110,567
社区成员
发帖
与我相关
我的任务
分享
public DataTable ProcExcuteToDataTable(string procName, SqlParameter[] parameters)
{
SqlDataAdapter da = new SqlDataAdapter();
DataTable dt = new DataTable();
try
{
conn.Open();
comm.Parameters.Clear();
comm.CommandType = CommandType.StoredProcedure;
comm.CommandText = procName;
foreach (SqlParameter para in parameters)
{
SqlParameter p = (SqlParameter)para;
comm.Parameters.Add(p);
}
da.SelectCommand = comm;
da.Fill(dt);
}
catch (Exception e)
{
throw new Exception(e.Message);
}
finally
{
conn.Close();
}
return dt;
}
public void AddRange(SqlParameter[] values);
public DataTable ProcExcuteToDataTable(string procName, SqlParameter[] parameters,out SqlParameter[] returnParameters){
...
}