System.Data.SqlClient.SqlConnection cnn = new System.Data.SqlClient.SqlConnection("...."); System.Data.SqlClient.SqlCommand cm = new System.Data.SqlClient.SqlCommand(); cm.Connection = cnn; cm.CommandType = System.Data.CommandType.StoredProcedure; cm.CommandText = "存储过程名"; System.Data.SqlClient.SqlDataAdapter da = new System.Data.SqlClient.SqlDataAdapter(cm); DataSet ds = new DataSet(); da.Fill(ds);
我想用它执行存储过程的原因是想把结果放在DataSet里面,而用SqlDataCommand,就要用循环读的方法来取结果
http://blog.csdn.net/knight94/archive/2006/03/23/635885.aspx
System.Data.SqlClient.SqlCommand cm = new System.Data.SqlClient.SqlCommand();
cm.Connection = cnn;
cm.CommandType = System.Data.CommandType.StoredProcedure;
cm.CommandText = "存储过程名";
System.Data.SqlClient.SqlDataAdapter da = new System.Data.SqlClient.SqlDataAdapter(cm);
DataSet ds = new DataSet();
da.Fill(ds);
的是正解,SqlDataAdapter 内部封装的是SqlCommand