protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
int index = int.Parse(e.CommandArgument.ToString());
if (e.CommandName == "select")//Load d? li?u lên các control
{
var ac = new AccessData();
SqlDataReader reader = ac.ExecuteReader(@"Select tensach, dongia, donvitinh, mota, hinhminhhoa, ngaycapnhat, tentacgia from sach Where masach= " + int.Parse(GridView1.Rows[index].Cells[0].Text) + "");
while (reader.Read())
{
txttensach.Text = reader[0].ToString();
txtdongia.Text = reader[1].ToString();
txtdonvitinh.Text = reader[2].ToString();
txtmota.Text = reader[3].ToString();
txtpath.Text = reader[4].ToString();
txtngaycapnhat.Text = reader[5].ToString();
txttentacgia.Text = reader[6].ToString();
}
reader.Close();
ViewState["masach"] = int.Parse(GridView1.Rows[index].Cells[0].Text);
txtmasach.Text = GridView1.Rows[index].Cells[0].Text;
string sql1 = "select s.manxb, tennxb from nhaxuatban n, sach s where n.manxb = s.manxb and masach = " + int.Parse(GridView1.Rows[index].Cells[0].Text) + "";
ddtennxbht.DataTextField = "tennxb";
ddtennxbht.DataValueField = "manxb";
ddtennxbht.DataSource = ac.GetTable(sql1);
ddtennxbht.DataBind();
string sql2 = "select s.macd, tenchude from chude c, sach s where c.macd = s.macd and masach = " + int.Parse(GridView1.Rows[index].Cells[0].Text) + "";
ddtenchudeht.DataTextField = "tenchude";
ddtenchudeht.DataValueField = "macd";
ddtenchudeht.DataSource = ac.GetTable(sql2);
ddtenchudeht.DataBind();
}
else if (e.CommandName == "del")//Xóa tin
{
ns.masach = int.Parse(GridView1.Rows[index].Cells[0].Text);
ns.delete(ns);
Response.Redirect("~/Admin_SuaVaXoaSach.aspx");//?? hi?n th? l?i k?t qu? sau khi xóa
}
}
