C#通过存储过程返回数据集的方法
1 /// <summary>
2 /// 返回数据集合（DataSet）
3 /// </summary>
4 /// <param name="procedureName">存储过程名称</param>
5 /// <param name="parameters">需要的参数集合</param>
6 /// <returns>查找到的数据集合</returns>
7 public static DataSet RunProcedure(string procedureName, SqlParameter[] parameters)
8 {
9 SqlConnection thisconnection = new SqlConnection(SqlHelper.ConnectionString);
10
11 SqlCommand cmd = new SqlCommand();
12 cmd.CommandText = procedureName;
13 cmd.CommandType = CommandType.StoredProcedure;//存储过程
14 cmd.Connection = thisconnection;//数据库连接
15 if (parameters != null)
16 foreach (SqlParameter param in parameters)
17 cmd.Parameters.Add(param);
18
19 SqlDataAdapter adapter = new SqlDataAdapter(cmd);
20 DataSet ds = new DataSet();
21 thisconnection.Open();
22 //执行操作
23 adapter.Fill(ds);
24 thisconnection.Close();
25 return ds;
26 }
13146413981
393992480
yibing98@hotmail.com