随笔分类 -  ADO.NET

摘要:exec sp_executesql N'SELECT LA001, LA014, LA005, LA011, LA013, LA021 FROM cgjterp..INVLA INVLAWHERE LA001=@P1 AND LA009=@P2 ORDER BY LA001, LA009 ', N'@P1 varchar(20),@P2 varchar(10)', '301110101001', '01'这是执行动态sql的exec sp_executesql N'SELECT LA001, LA014, LA005, 阅读全文
posted @ 2014-03-04 21:09 xjt360 阅读(247) 评论(0) 推荐(0)
摘要:View Code 1 using (SqlConnection conn = new SqlConnection(connStr)) 2 { 3 string sql = "[PRinserTcheck]";//存储过程名 4 using (SqlCommand cmd = new SqlCommand(sql, conn)) 5 { 6 //执行存储过程 7 ... 阅读全文
posted @ 2013-05-01 19:48 xjt360 阅读(147) 评论(0) 推荐(0)