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