protected void Page_Load(object sender, EventArgs e)
{
// Kết nối CSDL
SqlConnection con =
new SqlConnection(ConfigurationManager.ConnectionStrings["QLBanSach2ConnectionString"].ConnectionString);
con.Open();
// Tạo dataset để chứa dữ liệu trên webserver
BanSach Entities = new BanSach();
Entities.EnforceConstraints = false;
// Viết câu lệnh truy vấn dữ liêu
string strSql = "Select CD.Mcd, CD.Ten_chu_de + " +
"' (' +ltrim(str(count(CD.Ten_chu_de))) + " +
"') ' as Ten_chu_de from Chu_de CD " +
"inner join Sach S on CD.Mcd=S.Mcd group by CD.Mcd, CD.Ten_chu_de";
// Response.Write(strSql);
// Tạo DataAdepter
SqlDataAdapter objAdapter = new SqlDataAdapter(strSql, con);
// Thực hiện truy vấn và đổ dữ liệu vào dataset
objAdapter.Fill(Entities.CHU_DE);
DataList1.DataSource = Entities.CHU_DE;
DataList1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
string s = Request.QueryString["Mcd"];
string ten = Request.QueryString["Tencd"];
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["QLBanSach2ConnectionString"].ConnectionString);
con.Open();
BanSach Entities = new BanSach();
Entities.EnforceConstraints = false;
string strSql = "Select Ms,Ten_sach,Don_gia,Hinh_minh_hoa from SACH where Mcd='" + s + "' order by Ngay_cap_nhat DESC";
SqlDataAdapter objAdapter = new SqlDataAdapter(strSql, con);
objAdapter.Fill(Entities.SACH);
DataList1.DataSource = Entities.SACH;
DataList1.DataBind();
lbldanhmucsach.Text = "Danh Mục Sách: " + ten;
}
protected void Page_Load(object sender, EventArgs e)
{
int Ms = Convert.ToInt32(Request.QueryString["MaSach"].Trim());
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["QLBanSach2ConnectionString"].ConnectionString);
con.Open();
BanSach Entities = new BanSach();
Entities.EnforceConstraints = false;
string strSql = string.Format("select * from SACH where MS={0}", Ms);
SqlDataAdapter objAdapter = new SqlDataAdapter(strSql, con);
objAdapter.Fill(Entities.SACH);
string img = Entities.SACH[0].Hinh_minh_hoa;
lblTen.Text = Entities.SACH[0].Ten_sach;
imgMH.ImageUrl = string.Format("~/images/upload/{0}.jpg", img);
lblChiTiet.Text = Entities.SACH[0].Mo_ta;
lblGia.Text = Convert.ToString(Entities.SACH[0].Don_gia);
// Response.Write(Entities.SACH[0].Mo_ta);
}
protected void Page_Load(object sender, EventArgs e)
{
SqlConnection con =
new SqlConnection(ConfigurationManager.ConnectionStrings["QLBanSach2ConnectionString"].ConnectionString);
con.Open();
// Tạo dataset để chứa dữ liệu trên webserver
BanSach Entities = new BanSach();
Entities.EnforceConstraints = false;
// Viết câu lệnh truy vấn dữ liêu
//string strSql = "Select CD.Mcd, CD.Ten_chu_de + " +
// "' (' +ltrim(str(count(CD.Ten_chu_de))) + " +
// "') ' as Ten_chu_de from Chu_de CD " +
// "inner join Sach S on CD.Mcd=S.Mcd group by CD.Mcd, CD.Ten_chu_de";
string strSql = "Select top 5 Ten_sach, Don_gia, Hinh_minh_hoa FROM SACH order by Ngay_cap_nhat DESC";
SqlDataAdapter objAdapter = new SqlDataAdapter(strSql, con);
objAdapter.Fill(Entities.SACH);
DataList1.DataSource = Entities.SACH;
DataList1.DataBind();
}
