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); }