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