public void ReadData() { int id = int.Parse(comboBoxDT.SelectedValue.ToString()); ConsumerWinform.WSSDT.WSSDT dtct = new ConsumerWinform.WSSDT.WSSDT(); //IDataReader reader = new IDataReader(); dts = new DataSet(); table = new DataTable(); // table dien thoai string dt = ""; dt = "SELECT BaiViet FROM ThongTinChiTiet WHERE idDT ='" + id + "'"; dts = dtct.SelectQuery(dt); //MessageBox.Show(dt); table = dts.Tables[0]; if (table.Rows.Count > 0) { txtBaiViet.Text = table.Rows[0][0].ToString(); } else { rsl = MessageBox.Show(this, "Điện thoại này chưa có bài viết. Nhấn Ok để viết bài..!", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Question); txtBaiViet.Text = ""; } }
public void edit() { dtct = new ConsumerWinform.WSSDT.WSSDT(); int rs; ten = txtTenDT.Text; gia = int.Parse(txtGia.Text); img = txtHinhAnh.Text; mota = txtMoTa.Text; phukien = txtPhuKien.Text; baohanh = int.Parse(txtBaoHanh.Text); khuyenmai = txtKhuyenMai.Text; date = txtNgayCapNhat.Text; ah = int.Parse(txtDTAnHien.Text); dt = "update dienthoai set TenDT='" + ten + "', Gia='" + gia + "', HinhAnh='" + img + "',MoTa=N'" + mota + "', PhuKien=N'" + phukien + "',BaoHanh='" + baohanh + "', KhuyenMai=N'" + khuyenmai + "', NgayCapNhat='" + date + "', AnHien='" + ah + "' where idDT='" + id + "'"; // MessageBox.Show(sql); idDT = int.Parse(comboBoxDT.SelectedValue.ToString()); mang2g = txtMang2G.Text; mang3g = txtMang3G.Text; sim = txtSim.Text; khac = txtKhac.Text; loangoai = txtLoaNgoai.Text; thenho = txtTheNho.Text; bluetooth = txtBlueTooth.Text; camerachinh = txtCameraChinh.Text; tinnhan = txtTinNhan.Text; hedieuhanh = txtHDH.Text; java = txtJava.Text; thoigiancho = txtThoiGianCho.Text; kichthuoc = txtKichThuoc.Text; trongluong = txtTrongLuong.Text; mausac = txtMauSac.Text; loaimanhinh = txtLoaiManHinh.Text; bonhotrong = txtBoNhoTrong.Text; gprs = txtGPRS.Text; usb = txtUSB.Text; jack35 = txtJack.Text; cameraphu = txtCameraPhu.Text; trinhduyet = txtTrinhDuyet.Text; gpu = txtGPU.Text; trochoi = txtTroChoi.Text; thoigianhoatdong = txtThoiGianHoatDong.Text; kichthuocmanhinh = txtKTManHinh.Text; audio = txtAudio.Text; video = txtVideo.Text; radio = txtRadio.Text; kieuchuong = txtKieuChuong.Text; wlan = txtWLan.Text; hspda = txtHSPDA.Text; gps = txtGPS.Text; chucnang = txtChucNang.Text; quayphim = txtQuayPhim.Text; cpu = txtCPU.Text; chipset = txtChipSet.Text; loaipin = txtLoaiPin.Text; tndt = "UPDATE TinhNangDienThoai SET Mang2G='" + mang2g + "', Mang3G='" + mang3g + "', Sim='" + sim + "', KichThuoc='" + kichthuoc + "', TrongLuong='" + trongluong + "', MauSac='" + mausac + "', LoaiManHinh='" + loaimanhinh + "', KichThuocManHinh='" + kichthuocmanhinh + "', Audio='" + audio + "', Video='" + video + "', Radio='" + radio + "', KieuChuong='" + kieuchuong + "', LoaNgoai='" + loangoai + "', BoNhoTrong='" + bonhotrong + "', TheNho='" + thenho + "', Wlan='" + wlan + "', GPRS='" + gprs + "', HSPDA='" + hspda + "', Bluetooth='" + bluetooth + "', USB='" + usb + "', GPS='" + gps + "', Jack35='" + jack35 + "', CameraChinh='" + camerachinh + "', ChucNang='" + chucnang + "', CameraPhu='" + cameraphu + "', QuayPhim='" + quayphim + "', TinNhan='" + tinnhan + "', TrinhDuyet='" + trinhduyet + "', HeDieuHanh='" + hedieuhanh + "', CPU='" + cpu + "', Chipset='" + chipset + "', GPU='" + gpu + "', JAVA='" + java + "', TroChoi='" + trochoi + "', LoaiPin='" + loaipin + "', ThoiGianCho='" + thoigiancho + "', ThoiGianHoatDong='" + thoigianhoatdong + "', Khac='" + khac + "' where idDT='" + id + "'"; //MessageBox.Show(tndt); rs = dtct.InsertDeleteQuery(tndt); }
public void edit() { id = int.Parse(comboBoxDT.SelectedValue.ToString()); noidung = txtBaiViet.Text; int rs; ConsumerWinform.WSSDT.WSSDT dtct = new ConsumerWinform.WSSDT.WSSDT(); string sql = ""; sql = "UPDATE THONGTINCHITIET SET BAIVIET='"+noidung+"' WHERE IDDT='" + id + "'"; rs = dtct.InsertDeleteQuery(sql); }
public void add() { id =int.Parse( comboBoxDT.SelectedValue.ToString()); noidung = txtBaiViet.Text; int rs; ConsumerWinform.WSSDT.WSSDT dtct = new ConsumerWinform.WSSDT.WSSDT(); string sql = ""; sql = "INSERT INTO ThongTinChiTiet (idDT, BaiViet) VALUES ('"+id+"', '" + noidung + "')"; //MessageBox.Show(sql); rs = dtct.InsertDeleteQuery(sql); }
public void edit() { id = int.Parse(comboBoxDT.SelectedValue.ToString()); noidung = txtBaiViet.Text; int rs; ConsumerWinform.WSSDT.WSSDT dtct = new ConsumerWinform.WSSDT.WSSDT(); string sql = ""; sql = "UPDATE THONGTINCHITIET SET BAIVIET='" + noidung + "' WHERE IDDT='" + id + "'"; rs = dtct.InsertDeleteQuery(sql); }
public void add() { id = int.Parse(comboBoxDT.SelectedValue.ToString()); noidung = txtBaiViet.Text; int rs; ConsumerWinform.WSSDT.WSSDT dtct = new ConsumerWinform.WSSDT.WSSDT(); string sql = ""; sql = "INSERT INTO ThongTinChiTiet (idDT, BaiViet) VALUES ('" + id + "', '" + noidung + "')"; //MessageBox.Show(sql); rs = dtct.InsertDeleteQuery(sql); }
public void Sua() { ten = txtTenHSX.Text; tt = int.Parse(txtThuTu.Text); id = int.Parse(txtIDHSX.Text); ah = int.Parse(txtAnHien.Text); int rs; ConsumerWinform.WSSDT.WSSDT dtct = new ConsumerWinform.WSSDT.WSSDT(); string sql = ""; sql = "UPDATE HANGSANXUAT SET TenHSX=N'" + ten + "',ThuTu='" + tt + "',AnHien='" + ah + "' WHERE idHSX='" + id + "'"; //MessageBox.Show(sql); rs = dtct.InsertDeleteQuery(sql); }
public void Frmload() { ConsumerWinform.WSSDT.WSSDT dtct = new ConsumerWinform.WSSDT.WSSDT(); DataSet dts = new DataSet(); DataTable table = new DataTable(); string sql = ""; sql = "SELECT idHSX, TenHSX, ThuTu, AnHien FROM HANGSANXUAT";// WHERE idHSX =" +"'"+txtIDHSX+"'"; dts = dtct.SelectQuery(sql); table = dts.Tables[0]; //ds = dtct.SelectQuery(sql); dataGridView1.AutoGenerateColumns = false; dataGridView1.DataSource = table; }
public void Them() { //id = int.Parse(txtIDHSX.Text); ten = (string)txtTenHSX.Text; tt = int.Parse(txtThuTu.Text); ah = int.Parse(txtAnHien.Text); int rs; ConsumerWinform.WSSDT.WSSDT dtct = new ConsumerWinform.WSSDT.WSSDT(); string sql = ""; sql = "INSERT INTO HANGSANXUAT (TenHSX, ThuTu, AnHien) VALUES ('" + ten + "','" + tt + "','" + ah + "')"; //MessageBox.Show(sql); rs = dtct.InsertDeleteQuery(sql); }
public void Frmload() { dtct = new ConsumerWinform.WSSDT.WSSDT(); dts = new DataSet(); table = new DataTable(); string sql = ""; sql = "SELECT idDT, TenDT FROM DIENTHOAI";// WHERE idHSX =" +"'"+txtIDHSX+"'"; dts = dtct.SelectQuery(sql); table = dts.Tables[0]; //ds = dtct.SelectQuery(sql); comboBoxDT.DisplayMember = "TenDT"; comboBoxDT.ValueMember = "idDT"; comboBoxDT.DataSource = table; }
public void ReadData() { id = int.Parse(txtIDHSX.Text); ConsumerWinform.WSSDT.WSSDT dtct = new ConsumerWinform.WSSDT.WSSDT(); //IDataReader reader = new IDataReader(); DataSet dts = new DataSet(); DataTable table = new DataTable(); string sql = ""; sql = "SELECT TenHSX, ThuTu, AnHien FROM HANGSANXUAT WHERE idHSX ='"+id+"'"; dts = dtct.SelectQuery(sql); table = dts.Tables[0]; //txtIDHSX.Text = table.Rows[0][0].ToString(); txtTenHSX.Text = table.Rows[0][0].ToString(); txtThuTu.Text = table.Rows[0][1].ToString(); txtAnHien.Text = table.Rows[0][2].ToString(); }
public void ReadData() { id = int.Parse(txtIDHSX.Text); ConsumerWinform.WSSDT.WSSDT dtct = new ConsumerWinform.WSSDT.WSSDT(); //IDataReader reader = new IDataReader(); DataSet dts = new DataSet(); DataTable table = new DataTable(); string sql = ""; sql = "SELECT TenHSX, ThuTu, AnHien FROM HANGSANXUAT WHERE idHSX ='" + id + "'"; dts = dtct.SelectQuery(sql); table = dts.Tables[0]; //txtIDHSX.Text = table.Rows[0][0].ToString(); txtTenHSX.Text = table.Rows[0][0].ToString(); txtThuTu.Text = table.Rows[0][1].ToString(); txtAnHien.Text = table.Rows[0][2].ToString(); }
//================================= public void add() { dtct = new ConsumerWinform.WSSDT.WSSDT(); int rs; id = int.Parse(txtidHSX.Text); ten = txtTenDT.Text; gia = int.Parse(txtGia.Text); img = txtHinhAnh.Text; mota = txtMoTa.Text; phukien = txtPhuKien.Text; baohanh = int.Parse(txtBaoHanh.Text); khuyenmai = txtKhuyenMai.Text; date = txtNgayCapNhat.Text; ah = int.Parse(txtDTAnHien.Text); sql = "INSERT INTO dienthoai (idHSX, TenDT, Gia, HinhAnh, mota, phukien, baohanh, khuyenmai, ngaycapnhat, anhien) VALUES ('" + id + "','" + ten + "','" + gia + "','" + img + "','" + mota + "','" + phukien + "','" + baohanh + "', '" + khuyenmai + "','" + date + "', '" + ah + "')"; MessageBox.Show(sql); rs = dtct.InsertDeleteQuery(sql); }
private void buttonLoad_Click(object sender, EventArgs e) { //WSSDT dtct = new WSSDT(); //ComsumerWinform.WSSDT.WSSDTSoapClient dtct = new ComsumerWinform.WSSDT.WSSDTSoapClient(); ConsumerWinform.WSSDT.WSSDT dtct = new ConsumerWinform.WSSDT.WSSDT(); DataSet dts = new DataSet(); DataTable table = new DataTable(); string sql = ""; sql = "SELECT TenHSX, TenDT, Gia, MoTa, PhuKien, BaoHanh, KhuyenMai, NgayCapNhat "; sql += "FROM DIENTHOAI DT, HANGSANXUAT HSX "; sql += "WHERE DT.idHSX = HSX.idHSX "; dts = dtct.SelectQuery(sql); table = dts.Tables[0]; //ds = dtct.SelectQuery(sql); dataGridView1.AutoGenerateColumns = false; dataGridView1.DataSource = table; }
public void Xoa() { id = int.Parse(txtIDHSX.Text); int rs; ConsumerWinform.WSSDT.WSSDT dtct = new ConsumerWinform.WSSDT.WSSDT(); string sql = ""; sql = "DELETE FROM HANGSANXUAT WHERE idHSX='" + id + "'"; //MessageBox.Show(sql); rsl = MessageBox.Show(this, "Bạn Có Muốn Xóa Không...?", "Thông Báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (rsl == DialogResult.Yes) { rs = dtct.InsertDeleteQuery(sql); } else { txtIDHSX.Text = ""; } txtIDHSX.Text = ""; }
public void Xoa() { id = int.Parse(comboBoxDT.SelectedValue.ToString()); int rs; ConsumerWinform.WSSDT.WSSDT dtct = new ConsumerWinform.WSSDT.WSSDT(); string sql = ""; sql = "DELETE FROM THONGTINCHITIET WHERE IDDT='" + id + "'"; //MessageBox.Show(sql); rsl = MessageBox.Show(this, "Bạn Có Muốn Xóa Không...?", "Thông Báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (rsl == DialogResult.Yes) { rs = dtct.InsertDeleteQuery(sql); } else { Frmload(); } }
// them data public void add() { idDT = int.Parse(comboBoxDT.SelectedValue.ToString()); mang2g = txtMang2G.Text; mang3g = txtMang3G.Text; sim = txtSim.Text; khac = txtKhac.Text; loangoai = txtLoaNgoai.Text; thenho = txtTheNho.Text; bluetooth = txtBlueTooth.Text; camerachinh = txtCameraChinh.Text; tinnhan = txtTinNhan.Text; hedieuhanh = txtHDH.Text; java = txtJava.Text; thoigiancho = txtThoiGianCho.Text; kichthuoc = txtKichThuoc.Text; trongluong = txtTrongLuong.Text; mausac = txtMauSac.Text; loaimanhinh = txtLoaiManHinh.Text; bonhotrong = txtBoNhoTrong.Text; gprs = txtGPRS.Text; usb = txtUSB.Text; jack35 = txtJack.Text; cameraphu = txtCameraPhu.Text; trinhduyet = txtTrinhDuyet.Text; gpu = txtGPU.Text; trochoi = txtTroChoi.Text; thoigianhoatdong = txtThoiGianHoatDong.Text; kichthuocmanhinh = txtKTManHinh.Text; audio = txtAudio.Text; video = txtVideo.Text; radio = txtRadio.Text; kieuchuong = txtKieuChuong.Text; wlan = txtWLan.Text; hspda = txtHSPDA.Text; gps = txtGPS.Text; chucnang = txtChucNang.Text; quayphim = txtQuayPhim.Text; cpu = txtCPU.Text; chipset = txtChipSet.Text; loaipin = txtLoaiPin.Text; dtct = new ConsumerWinform.WSSDT.WSSDT(); int rs; //sql = "INSERT INTO TinhNangDienThoai ( idDT, Mang2G, Mang3G, Sim, KichThuoc, TrongLuong, MauSac, LoaiManHinh, KichThuocManHinh, Audio, Video, Radio, KieuChuong, LoaNgoai, BoNhoTrong, TheNho, Wlan, GPRS, HSPDA, Bluetooth, USB, GPS, Jack35, CameraChinh, ChucNang, CameraPhu, QuayPhim, TinNhan, TrinhDuyet, HeDieuHanh, CPU, Chipset, GPU, JAVA, TroChoi, LoaiPin, ThoiGianCho, ThoiGianHoatDong, Khac) VALUES ('"+idDT+"', '"+mang2g+"', '"+mang3g+ "','"+sim+"', '"+kichthuoc+"', '"+trongluong+"', '"+mausac+"', '"+loaimanhinh+"', '"+kichthuocmanhinh+"','"+audio+"', '" + video+"', '"+radio+"', '"+kieuchuong+"', '"+loangoai+"', '"+bonhotrong+"', '"+thenho+"', '"+wlan+"', '"+gprs+"', '"+hspda+"', '"+bluetooth+"', '"+usb+"', '"+gps+"', '"+jack35+"', '"+camerachinh+"', '"+chucnang+"', '"+cameraphu+"', '"+quayphim+"', '"+tinnhan+"', '"+trinhduyet+"', '"+hedieuhanh+"', '"+cpu+"', '"+chipset+"', '"+gpu+ "', '"+java+ "', '"+trochoi+"', '"+loaipin+"', '"+thoigiancho+"', '"+thoigianhoatdong+"', '"+khac+"')"; sql = "INSERT INTO TinhNangDienThoai ( idDT, Mang2G, Mang3G, Sim, KichThuoc, TrongLuong, MauSac, LoaiManHinh, KichThuocManHinh, Audio, Video, Radio, KieuChuong, LoaNgoai, BoNhoTrong, TheNho, Wlan, GPRS, HSPDA, Bluetooth, USB, GPS, Jack35, CameraChinh, ChucNang, CameraPhu, QuayPhim, TinNhan, TrinhDuyet, HeDieuHanh, CPU, Chipset, GPU, JAVA, TroChoi, LoaiPin, ThoiGianCho, ThoiGianHoatDong, Khac) VALUES ('" + idDT + "','" + mang2g + "', '" + mang3g + "', '" + sim + "', '" + kichthuoc + "','" + trongluong + "', '" + mausac + "',' " + loaimanhinh + "', '" + kichthuocmanhinh + "', '" + audio + "', '" + video + "', '" + radio + "', '" + kieuchuong + "', '" + loangoai + "', '" + bonhotrong + "', '" + thenho + "', '" + wlan + "', '" + gprs + "', '" + hspda + "', '" + bluetooth + "', '" + usb + "', '" + gps + "', '" + jack35 + "', '" + camerachinh + "', '" + chucnang + "', '" + cameraphu + "', '" + quayphim + "', '" + tinnhan + "', '" + trinhduyet + "', '" + hedieuhanh + "', '" + cpu + "', '" + chipset + "', '" + gpu + "', '" + java + "', '" + trochoi + "',' " + loaipin + "', '" + thoigiancho + "', '" + thoigianhoatdong + "', '" + khac + "')"; MessageBox.Show(sql); rs = dtct.InsertDeleteQuery(sql); }
// them data public void add() { idDT = int.Parse(comboBoxDT.SelectedValue.ToString()); mang2g = txtMang2G.Text; mang3g = txtMang3G.Text; sim = txtSim.Text; khac = txtKhac.Text; loangoai = txtLoaNgoai.Text; thenho = txtTheNho.Text; bluetooth = txtBlueTooth.Text; camerachinh = txtCameraChinh.Text; tinnhan = txtTinNhan.Text; hedieuhanh = txtHDH.Text; java = txtJava.Text; thoigiancho = txtThoiGianCho.Text; kichthuoc = txtKichThuoc.Text; trongluong = txtTrongLuong.Text; mausac = txtMauSac.Text; loaimanhinh = txtLoaiManHinh.Text; bonhotrong = txtBoNhoTrong.Text; gprs = txtGPRS.Text; usb = txtUSB.Text; jack35 = txtJack.Text; cameraphu = txtCameraPhu.Text; trinhduyet = txtTrinhDuyet.Text; gpu = txtGPU.Text; trochoi = txtTroChoi.Text; thoigianhoatdong = txtThoiGianHoatDong.Text; kichthuocmanhinh = txtKTManHinh.Text; audio = txtAudio.Text; video = txtVideo.Text; radio = txtRadio.Text; kieuchuong = txtKieuChuong.Text; wlan = txtWLan.Text; hspda = txtHSPDA.Text; gps = txtGPS.Text; chucnang = txtChucNang.Text; quayphim = txtQuayPhim.Text; cpu = txtCPU.Text; chipset = txtChipSet.Text; loaipin = txtLoaiPin.Text; dtct = new ConsumerWinform.WSSDT.WSSDT(); int rs; //sql = "INSERT INTO TinhNangDienThoai ( idDT, Mang2G, Mang3G, Sim, KichThuoc, TrongLuong, MauSac, LoaiManHinh, KichThuocManHinh, Audio, Video, Radio, KieuChuong, LoaNgoai, BoNhoTrong, TheNho, Wlan, GPRS, HSPDA, Bluetooth, USB, GPS, Jack35, CameraChinh, ChucNang, CameraPhu, QuayPhim, TinNhan, TrinhDuyet, HeDieuHanh, CPU, Chipset, GPU, JAVA, TroChoi, LoaiPin, ThoiGianCho, ThoiGianHoatDong, Khac) VALUES ('"+idDT+"', '"+mang2g+"', '"+mang3g+ "','"+sim+"', '"+kichthuoc+"', '"+trongluong+"', '"+mausac+"', '"+loaimanhinh+"', '"+kichthuocmanhinh+"','"+audio+"', '" + video+"', '"+radio+"', '"+kieuchuong+"', '"+loangoai+"', '"+bonhotrong+"', '"+thenho+"', '"+wlan+"', '"+gprs+"', '"+hspda+"', '"+bluetooth+"', '"+usb+"', '"+gps+"', '"+jack35+"', '"+camerachinh+"', '"+chucnang+"', '"+cameraphu+"', '"+quayphim+"', '"+tinnhan+"', '"+trinhduyet+"', '"+hedieuhanh+"', '"+cpu+"', '"+chipset+"', '"+gpu+ "', '"+java+ "', '"+trochoi+"', '"+loaipin+"', '"+thoigiancho+"', '"+thoigianhoatdong+"', '"+khac+"')"; sql = "INSERT INTO TinhNangDienThoai ( idDT, Mang2G, Mang3G, Sim, KichThuoc, TrongLuong, MauSac, LoaiManHinh, KichThuocManHinh, Audio, Video, Radio, KieuChuong, LoaNgoai, BoNhoTrong, TheNho, Wlan, GPRS, HSPDA, Bluetooth, USB, GPS, Jack35, CameraChinh, ChucNang, CameraPhu, QuayPhim, TinNhan, TrinhDuyet, HeDieuHanh, CPU, Chipset, GPU, JAVA, TroChoi, LoaiPin, ThoiGianCho, ThoiGianHoatDong, Khac) VALUES ('"+idDT+"','"+mang2g+"', '"+mang3g+"', '"+sim+"', '"+kichthuoc+"','"+trongluong+"', '"+mausac+"',' "+loaimanhinh+"', '"+kichthuocmanhinh+"', '"+audio+"', '"+video+"', '"+radio+"', '"+kieuchuong+"', '"+loangoai+"', '"+bonhotrong+"', '"+thenho+"', '"+wlan+"', '"+gprs+"', '"+hspda+"', '"+bluetooth+"', '"+usb+"', '"+gps+"', '"+jack35+"', '"+camerachinh+"', '"+chucnang+"', '"+cameraphu+"', '"+quayphim+"', '"+tinnhan+"', '"+trinhduyet+"', '"+hedieuhanh+"', '"+cpu+"', '"+chipset+"', '"+gpu+"', '"+java+"', '"+trochoi+"',' "+loaipin+"', '"+thoigiancho+"', '"+thoigianhoatdong+"', '"+khac+"')"; MessageBox.Show(sql); rs = dtct.InsertDeleteQuery(sql); }
public void Xoa() { id = int.Parse(comboBoxDT.SelectedValue.ToString()); int rs; ConsumerWinform.WSSDT.WSSDT dtct = new ConsumerWinform.WSSDT.WSSDT(); ttct = "DELETE FROM THONGTINCHITIET WHERE idDT='" + id + "'"; dt = "DELETE FROM DIENTHOAI WHERE idDT='" + id + "'"; tndt = "DELETE FROM TINHNANGDIENTHOAI WHERE idDT='" + id + "'"; //MessageBox.Show(sql); rsl = MessageBox.Show(this, "Bạn Có Muốn Xóa Không...?", "Thông Báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (rsl == DialogResult.Yes) { rs = dtct.InsertDeleteQuery(ttct); rs = dtct.InsertDeleteQuery(dt); rs = dtct.InsertDeleteQuery(tndt); } else { } }
//doc du lieu public void ReadData() { id = int.Parse(comboBoxDT.SelectedValue.ToString()); ConsumerWinform.WSSDT.WSSDT dtct = new ConsumerWinform.WSSDT.WSSDT(); //IDataReader reader = new IDataReader(); dts = new DataSet(); table = new DataTable(); // table dien thoai string dt = ""; dt = "SELECT TenDT, Gia, HinhAnh, MoTa, PhuKien, BaoHanh, KhuyenMai, NgayCapNhat, AnHien, idHSX FROM DIENTHOAI WHERE idDT ='" + id + "'"; dts = dtct.SelectQuery(dt); table = dts.Tables[0]; txtidHSX.Text = table.Rows[0][9].ToString(); txtTenDT.Text = table.Rows[0][0].ToString(); txtGia.Text = table.Rows[0][1].ToString(); txtHinhAnh.Text = table.Rows[0][2].ToString(); txtMoTa.Text = table.Rows[0][3].ToString(); txtPhuKien.Text = table.Rows[0][4].ToString(); txtBaoHanh.Text = table.Rows[0][5].ToString(); txtKhuyenMai.Text = table.Rows[0][6].ToString(); txtNgayCapNhat.Text = table.Rows[0][7].ToString(); txtDTAnHien.Text = table.Rows[0][8].ToString(); // table tinh nang dien thoai string tn; tn = "Select Mang2g, Mang3G , Sim, KichThuoc, TrongLuong, MauSac, LoaiManHinh, KichThuocManHinh, Audio, Video, Radio, KieuChuong, LoaNgoai, BoNhoTrong, TheNho, Wlan, GPRS, HSPDA, Bluetooth, USB, GPS, Jack35, CameraChinh, ChucNang, CameraPhu, QuayPhim, TinNhan, TrinhDuyet, HeDieuHanh, CPU, ChipSet, GPU, JAVA, TroChoi, LoaiPin, ThoiGianCho, ThoiGianHoatDong, Khac From TinhNangDienThoai where idDT='" + id + "'"; ds = new DataSet(); table2 = new DataTable(); ds = dtct.SelectQuery(tn); table2 = ds.Tables[0]; txtMang2G.Text = table2.Rows[0][0].ToString(); txtMang3G.Text = table2.Rows[0][1].ToString(); txtSim.Text = table2.Rows[0][2].ToString(); txtKichThuoc.Text = table2.Rows[0][3].ToString(); txtTrongLuong.Text = table2.Rows[0][4].ToString(); txtMauSac.Text = table2.Rows[0][5].ToString(); txtLoaiManHinh.Text = table2.Rows[0][6].ToString(); txtKTManHinh.Text=table2.Rows[0][7].ToString(); txtAudio.Text = table2.Rows[0][8].ToString(); txtVideo.Text = table2.Rows[0][9].ToString(); txtRadio.Text = table2.Rows[0][10].ToString(); txtKieuChuong.Text = table2.Rows[0][11].ToString(); txtLoaNgoai.Text = table2.Rows[0][12].ToString(); txtBoNhoTrong.Text = table2.Rows[0][13].ToString(); txtTheNho.Text = table2.Rows[0][14].ToString(); txtWLan.Text = table2.Rows[0][15].ToString(); txtGPRS.Text = table2.Rows[0][16].ToString(); txtHSPDA.Text = table2.Rows[0][17].ToString(); txtBlueTooth.Text = table2.Rows[0][18].ToString(); txtUSB.Text = table2.Rows[0][19].ToString(); txtGPS.Text = table2.Rows[0][20].ToString(); txtJack.Text = table2.Rows[0][21].ToString(); txtCameraChinh.Text = table2.Rows[0][21].ToString(); txtChucNang.Text = table2.Rows[0][23].ToString(); txtCameraPhu.Text = table2.Rows[0][24].ToString(); txtQuayPhim.Text = table2.Rows[0][25].ToString(); txtTinNhan.Text = table2.Rows[0][26].ToString(); txtTrinhDuyet.Text = table2.Rows[0][27].ToString(); txtHDH.Text = table2.Rows[0][28].ToString(); txtCPU.Text = table2.Rows[0][29].ToString(); txtChipSet.Text = table2.Rows[0][30].ToString(); txtGPU.Text = table2.Rows[0][31].ToString(); txtJava.Text = table2.Rows[0][32].ToString(); txtTroChoi.Text = table2.Rows[0][33].ToString(); txtLoaiPin.Text = table2.Rows[0][34].ToString(); txtThoiGianCho.Text = table2.Rows[0][35].ToString(); txtThoiGianHoatDong.Text = table2.Rows[0][36].ToString(); txtKhac.Text = table2.Rows[0][37].ToString(); }
public void Xoa() { id = int.Parse(txtIDHSX.Text); int rs; ConsumerWinform.WSSDT.WSSDT dtct = new ConsumerWinform.WSSDT.WSSDT(); string sql = ""; sql = "DELETE FROM HANGSANXUAT WHERE idHSX='"+id+"'"; //MessageBox.Show(sql); rsl = MessageBox.Show(this, "Bạn Có Muốn Xóa Không...?","Thông Báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (rsl == DialogResult.Yes) { rs = dtct.InsertDeleteQuery(sql); } else { txtIDHSX.Text = ""; } txtIDHSX.Text = ""; }
public void Them() { //id = int.Parse(txtIDHSX.Text); ten =(string) txtTenHSX.Text; tt = int.Parse(txtThuTu.Text); ah = int.Parse(txtAnHien.Text); int rs; ConsumerWinform.WSSDT.WSSDT dtct = new ConsumerWinform.WSSDT.WSSDT(); string sql = ""; sql = "INSERT INTO HANGSANXUAT (TenHSX, ThuTu, AnHien) VALUES ('" + ten + "','" + tt + "','" + ah + "')"; //MessageBox.Show(sql); rs = dtct.InsertDeleteQuery(sql); }
//doc du lieu public void ReadData() { id = int.Parse(comboBoxDT.SelectedValue.ToString()); ConsumerWinform.WSSDT.WSSDT dtct = new ConsumerWinform.WSSDT.WSSDT(); //IDataReader reader = new IDataReader(); dts = new DataSet(); table = new DataTable(); // table dien thoai string dt = ""; dt = "SELECT TenDT, Gia, HinhAnh, MoTa, PhuKien, BaoHanh, KhuyenMai, NgayCapNhat, AnHien, idHSX FROM DIENTHOAI WHERE idDT ='" + id + "'"; dts = dtct.SelectQuery(dt); table = dts.Tables[0]; txtidHSX.Text = table.Rows[0][9].ToString(); txtTenDT.Text = table.Rows[0][0].ToString(); txtGia.Text = table.Rows[0][1].ToString(); txtHinhAnh.Text = table.Rows[0][2].ToString(); txtMoTa.Text = table.Rows[0][3].ToString(); txtPhuKien.Text = table.Rows[0][4].ToString(); txtBaoHanh.Text = table.Rows[0][5].ToString(); txtKhuyenMai.Text = table.Rows[0][6].ToString(); txtNgayCapNhat.Text = table.Rows[0][7].ToString(); txtDTAnHien.Text = table.Rows[0][8].ToString(); // table tinh nang dien thoai string tn; tn = "Select Mang2g, Mang3G , Sim, KichThuoc, TrongLuong, MauSac, LoaiManHinh, KichThuocManHinh, Audio, Video, Radio, KieuChuong, LoaNgoai, BoNhoTrong, TheNho, Wlan, GPRS, HSPDA, Bluetooth, USB, GPS, Jack35, CameraChinh, ChucNang, CameraPhu, QuayPhim, TinNhan, TrinhDuyet, HeDieuHanh, CPU, ChipSet, GPU, JAVA, TroChoi, LoaiPin, ThoiGianCho, ThoiGianHoatDong, Khac From TinhNangDienThoai where idDT='" + id + "'"; ds = new DataSet(); table2 = new DataTable(); ds = dtct.SelectQuery(tn); table2 = ds.Tables[0]; txtMang2G.Text = table2.Rows[0][0].ToString(); txtMang3G.Text = table2.Rows[0][1].ToString(); txtSim.Text = table2.Rows[0][2].ToString(); txtKichThuoc.Text = table2.Rows[0][3].ToString(); txtTrongLuong.Text = table2.Rows[0][4].ToString(); txtMauSac.Text = table2.Rows[0][5].ToString(); txtLoaiManHinh.Text = table2.Rows[0][6].ToString(); txtKTManHinh.Text = table2.Rows[0][7].ToString(); txtAudio.Text = table2.Rows[0][8].ToString(); txtVideo.Text = table2.Rows[0][9].ToString(); txtRadio.Text = table2.Rows[0][10].ToString(); txtKieuChuong.Text = table2.Rows[0][11].ToString(); txtLoaNgoai.Text = table2.Rows[0][12].ToString(); txtBoNhoTrong.Text = table2.Rows[0][13].ToString(); txtTheNho.Text = table2.Rows[0][14].ToString(); txtWLan.Text = table2.Rows[0][15].ToString(); txtGPRS.Text = table2.Rows[0][16].ToString(); txtHSPDA.Text = table2.Rows[0][17].ToString(); txtBlueTooth.Text = table2.Rows[0][18].ToString(); txtUSB.Text = table2.Rows[0][19].ToString(); txtGPS.Text = table2.Rows[0][20].ToString(); txtJack.Text = table2.Rows[0][21].ToString(); txtCameraChinh.Text = table2.Rows[0][21].ToString(); txtChucNang.Text = table2.Rows[0][23].ToString(); txtCameraPhu.Text = table2.Rows[0][24].ToString(); txtQuayPhim.Text = table2.Rows[0][25].ToString(); txtTinNhan.Text = table2.Rows[0][26].ToString(); txtTrinhDuyet.Text = table2.Rows[0][27].ToString(); txtHDH.Text = table2.Rows[0][28].ToString(); txtCPU.Text = table2.Rows[0][29].ToString(); txtChipSet.Text = table2.Rows[0][30].ToString(); txtGPU.Text = table2.Rows[0][31].ToString(); txtJava.Text = table2.Rows[0][32].ToString(); txtTroChoi.Text = table2.Rows[0][33].ToString(); txtLoaiPin.Text = table2.Rows[0][34].ToString(); txtThoiGianCho.Text = table2.Rows[0][35].ToString(); txtThoiGianHoatDong.Text = table2.Rows[0][36].ToString(); txtKhac.Text = table2.Rows[0][37].ToString(); }