Also this:
Code:
public static DataTable GetDataTableForUI(string sproc, List<SqlParameter> sps)
{
SqlConnection conn = new SqlConnection((string)ConfigurationSettings.AppSettings["DBConnectionString"]);
conn.Open();
SqlCommand comm = new SqlCommand(sproc, conn);
comm.CommandType = CommandType.StoredProcedure;
Leave a comment: