public static DataTable GetTable(string strsql)
{
using (SqlConnection conn = new SqlConnection(strconn))
{
var dt = new DataTable();
SqlDataAdapter msda = new SqlDataAdapter(strsql, conn);
msda.Fill(dt);
return(dt);
}
}
public static DataTable GetTable_Proc(string pname, SqlParameter[] paras = null)
{
using (SqlConnection conn = new SqlConnection(strconn))
{
var dt = new DataTable();
SqlCommand comm = new SqlCommand(pname, conn);
comm.CommandType = CommandType.StoredProcedure;
if (paras != null)
{
comm.Parameters.AddRange(paras);
}
SqlDataAdapter msda = new SqlDataAdapter(comm);
msda.Fill(dt);
return(dt);
}
}
