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 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 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 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 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();
}
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;
}
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 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 = "";
}
}
//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();
}
//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();
}
