public DataTable GetData() { DataTable dt = new DataTable(); cmd.CommandText = "select *from tb_CTHD"; cmd.CommandType = CommandType.Text; cmd.Connection = con.Connection; try { con.OpenConn(); SqlDataAdapter sda = new SqlDataAdapter(cmd); sda.Fill(dt); con.CloseConn(); } catch (Exception ex) { string mex = ex.Message; cmd.Dispose(); con.CloseConn(); } return(dt); }