public void laybangchogridview() { Ketnoi kn = new Ketnoi(); DataTable dt = new DataTable(); dt = kn.laybang("select * from Khach_Hang;"); GridView1.DataSource = dt; GridView1.DataBind(); }
public void laybangchogridview2() { Ketnoi kn = new Ketnoi(); DataTable dt = new DataTable(); dt = kn.laybang("select * from San_Pham;"); GridView2.DataSource = dt; GridView2.DataBind(); }
protected void GridView1_SelectedIndexChanged2(object sender, EventArgs e) { int dong = GridView1.SelectedIndex; Ketnoi kn = new Ketnoi(); DataTable dt = new DataTable(); dt = kn.laybang("select * from Khach_Hang"); txtMaKH.Text = dt.Rows[dong][0].ToString(); txtTenKH.Text = dt.Rows[dong][1].ToString(); txtDiaChi.Text = dt.Rows[dong][2].ToString(); txtEmail.Text = dt.Rows[dong][3].ToString(); txtSdt.Text = dt.Rows[dong][4].ToString(); }
protected void GridView2_SelectedIndexChanged(object sender, EventArgs e) { int dong = GridView2.SelectedIndex; Ketnoi kn = new Ketnoi(); DataTable dt = new DataTable(); dt = kn.laybang("select * from San_Pham"); txtMaSP.Text = dt.Rows[dong][0].ToString(); txtTenSP.Text = dt.Rows[dong][1].ToString(); txtDVT.Text = dt.Rows[dong][2].ToString(); txtDG.Text = dt.Rows[dong][3].ToString(); txtGC.Text = dt.Rows[dong][4].ToString(); }