public DataTable GetDataByStoredProcedure(CommandSender cmdSnd)
{
using (SqlDataAdapter sda = new SqlDataAdapter(cmdSnd.GetCommand()))
{
DataTable dt = new DataTable();
sda.Fill(dt);
SQLConfiguration.Close();
return(dt);
}
}
private DataTable GetDataTable(string query)
{
SqlDataAdapter adapter = new SqlDataAdapter(query, SQLConfiguration.GetDbString());
DataTable dataTable = new DataTable();
adapter.Fill(dataTable);
SQLConfiguration.Close();
return(dataTable);
}
