public static DataTable GetDataTable(SqlConnection connection, string sql)
{
DuLieu dl = new DuLieu();
try
{
SqlDataAdapter DataA = new SqlDataAdapter(sql, connection);
dl.OpenConnection(connection);
DataTable DataT = new DataTable();
DataA.Fill(DataT);
return(DataT);
}
catch (Exception)
{
throw;
}
finally
{
dl.CloseConnection(connection);
}
}