public DataTable GetAllData(string tableName)
{
DataTable dt;
try
{
dt = new DataTable();
GetConnection.Open();
string query = $"select * from {tableName}";
new SqlDataAdapter(query, GetConnection.Conn).Fill(dt);
}
catch (Exception ex)
{
// ReSharper disable once PossibleIntendedRethrow
throw ex;
}
finally
{
GetConnection.Close();
}
return(dt);
}
public static DataTable FillCmb(string firstRow, string query)
{
DataTable dt;
try
{
dt = new DataTable();
GetConnection.Open();
new SqlDataAdapter(query, GetConnection.Conn).Fill(dt);
DataRow row1 = dt.NewRow();
row1[0] = 0;
row1[1] = firstRow;
dt.Rows.InsertAt(row1, 0);
}
catch (Exception ex)
{
throw ex;
}
finally
{
GetConnection.Close();
}
return(dt);
}