Ejemplo n.º 1
0
        /// <summary>
        /// Hàm lấy dữ liệu . Trả về 1 data table
        /// </summary>
        /// <returns></returns>
        public DataTable GetData()
        {
            DataTable dt = new DataTable();

            cmd.CommandText = "select * from HoaDon";
            cmd.CommandType = CommandType.Text;
            cmd.Connection  = con.strConn;
            try
            {
                con.OpenConnect();
                SqlDataAdapter sda = new SqlDataAdapter(cmd);
                sda.Fill(dt);
                con.CloseConnection();
            }
            catch (Exception ex)
            {
                string mes = ex.Message;
                cmd.Dispose();
                con.CloseConnection();
            }
            return(dt);
        }
Ejemplo n.º 2
0
 public bool SeachKhachHang(KhachHangObj khobj)
 {
     cmd.CommandText = "select from KhachHang where TenKH LIKE " + khobj.TenKH + " ";
     cmd.CommandType = CommandType.Text;
     cmd.Connection  = con.strConn;
     try
     {
         con.OpenConnect();
         cmd.ExecuteNonQuery();
         con.CloseConnection();
         return(true);
     }
     catch (Exception ex)
     {
         string mes = ex.Message;
         cmd.Dispose();
         con.CloseConnection();
     }
     return(true);
 }
        private DataTable timKiem()
        {
            DataTable dt = new DataTable();

            cmd.CommandText = " select *  from KhachHang where TenKH LIKE '" + txtSeach.Text.ToString() + "' ";
            cmd.CommandType = CommandType.Text;
            cmd.Connection  = con.strConn;
            try
            {
                con.OpenConnect();
                cmd.ExecuteNonQuery();
                SqlDataAdapter sda = new SqlDataAdapter(cmd);
                sda.Fill(dt);
                con.CloseConnection();
                con.CloseConnection();
            }
            catch (Exception ex)
            {
                string mes = ex.Message;
                cmd.Dispose();
                con.CloseConnection();
            }
            return(dt);
        }