程序过程调用 - 黑马程序员技术交流社区

在oledbhelpdao.cs函数中有一个子函数
/// <summary>
/// 测试调用存储过程
/// </summary>
/// <param name="connectionString"></param>
/// <param name="cmdType"></param>
/// <param name="cmdText"></param>
/// <param name="tableName"></param>
/// <param name="commandParameters"></param>
/// <returns></returns>
public static DataSet ExecuteDataSet(string connectionString, CommandType cmdType, string cmdText, string tableName,params OleDbParameter[] commandParameters)
{
DataSet ds = new DataSet();
using (OleDbConnection conn = new OleDbConnection(connectionString))
{
conn.Open();
OleDbCommand cmd = new OleDbCommand( );
using (OleDbDataAdapter da = new OleDbDataAdapter())
{
PrepareCommand(cmd, conn, null, cmdType, cmdText, commandParameters);
da.SelectCommand = cmd;
da.Fill(ds, tableName);
cmd.Parameters.Clear();
}
}
return ds ;

复制代码