listbook.aspx.cs

完成一个网上书店系统

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;

public partial class listbook : System.Web.UI.Page
{
 
        protected void Page_Load(object sender, EventArgs e)
        {
            int catid = Convert.ToInt32(Request.Params["CatID"]);
            //catid = 1;
            string settings = Convert.ToString(ConfigurationManager.ConnectionStrings["BookShopConnectionString"]);
            SqlConnection myconn = new SqlConnection(settings);
            myconn.Open();

            SqlCommand mycmd = new SqlCommand("BookByCategory", myconn);
            mycmd.CommandType = CommandType.StoredProcedure;

            //给存储过程添加参数
            SqlParameter parametercatid=new SqlParameter ("@CatID",SqlDbType.Int,4);
            parametercatid.Value=catid;
            mycmd.Parameters.Add(parametercatid);

            
            SqlDataReader result = mycmd.ExecuteReader(CommandBehavior.CloseConnection);
            DataList2.DataSource = result;
            DataList2.DataBind();
        }


        protected void Button2_Click(object sender, EventArgs e)
        {
          /*  string bookname = ((HyperLink)DataList2.FindControl("HyperLink2")).Text;
            if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
            {

                LinkButton LBfk = ((LinkButton)(e.Item.FindControl("LBfankui")));
            }
            /*if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
       ｛
                      取值代码例如：
                          LinkButton LBfk = ((LinkButton)(e.Item.FindControl("LBfankui")));

         ｝如果是想获取所有的遍历items就可以然后再通过datalist.items [?].findcontrol("控件id")就可以取道每个控件 
*/
        }
        protected void DataList2_ItemCommand(object source, DataListCommandEventArgs e)
        {
            if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
            {
                string ss =(String) DataList2.DataKeys[e.Item.ItemIndex];//MyDataList.DataKeys[MyDataList.SelectedItem.ItemIndex]
            }
        }
}