DataList的用法.doc

1 数据绑定,绑定的方式为public partial class _Default : System.Web.UI.Page SqlConnection sqlcon; string strCon = Data Source=(local);Database=db_04;Uid=sa;Pwd=why20080104019; protected void Page_Load(object sender, EventArgs e) sqlcon = new SqlConnection(strCon); string sqlstr = select top 1* from tb_Member; SqlDataAdapter myda = new SqlDataAdapter(sqlstr, sqlcon); DataSet myds = new DataSet(); sqlcon.Open(); myda.Fill(myds, tb_Member); DataList1.DataSource = myds; DataList1.DataBind(); DataRowView mydrv = myds.Tablestb_Member.DefaultView0;/ds中缓存的表格“tb_Member” for (int i = 0; i = DataList1.Items.Count - 1; i+) Label lab = (Label)DataList1.Itemsi.FindControl(Label1); int money = Convert.ToInt32(mydrvmoney); lab.Text = money.ToString(￥#,#.00); sqlcon.Close(); 2.分页功能int curpage = Convert.ToInt32(this.Label2.Text.ToString().Trim(); PagedDataSource ps = new PagedDataSource(); sqlcon = new SqlConnection(strcon); SqlDataAdapter sda = new SqlDataAdapter(select * from tb_GoodsType, sqlcon); DataSet ds = new DataSet(); sda.Fill(ds, tb_GoodsType); ps.DataSource = ds.Tablestb_GoodsType.DefaultView; ps.AllowPaging = true; ps.PageSize = 2;/实现分页 LinkButton1.Enabled = true; LinkButton2.Enabled = true; LinkButton3.Enabled = true; LinkButton4.Enabled = true; ps.CurrentPageIndex = curpage-1; if (curpage = 1) this.LinkButton1.Enabled = false; this.LinkButton2.Enabled = false; if (curpage = ps.PageCount) this.LinkButton3.Enabled = false; this.LinkButton4.Enabled = false; this.Label3.Text = Convert.ToString(ps.PageCount); DataList1.DataSource = ps; this.DataList1.DataKeyField = GoodsTypeID; DataList1.DataBind();2.查找Datalist中的控件CheckBox cb=（CheckBox）Datalist.Item0.FindControl(“CheckBox1”)Datalist的属性是：   ID： asp:Label ID=Label1 runat=server Text=   姓名： asp:Label ID=Label2 runat=server Text=   性别： 男 女 学位： asp:Label ID=Label3 runat=server Text=   电话: asp:Label ID=Label4 runat=server Text=   地址： asp:Label ID=Label5 runat=server Text= 删除该项目 具体的代码是：protected void DataList1_DeleteCommand(object source, DataListCommandEventArgs e) SqlCon = new SqlConnection(strcon); for (int i = 0; i DataList1.Items.Count; i+) CheckBox cb = (CheckBox)DataList1.Itemsi.FindControl(cb1); if (cb.Checked) string strdel = delete from tb_mrEmp05 where ID= + DataList1.DataKeysi.ToString() + ; SqlCon.Open(); SqlCommand sqlcmd = new SqlCommand(strdel, SqlCon); sqlcmd.ExecuteNonQuery(); SqlCon.Close(); else Response.Write(请选择！); bind(); 3.Datalist实现自动编号功能protected void DataList1_ItemDataBound(object sender, DataListItemEventArgs e) int id = e.Item.ItemIndex+1; (Label)e.Item.FindControl(Label3).Text = id.ToString(); 4.Datalist实现删除功能在Datalist中的Button控件的Commandname必须设置为deleteprotected void DataList1_DeleteCommand(object source, DataListCommandEventArgs e) string strdel=delete from tb_Revert where RevertID=+DataList1.DataKeyse.Item.ItemIndex.ToString()+; sqlcon=new SqlConnection(strcon); sqlcon.Open(); SqlCommand sqlcmd=new SqlCommand(strdel,sqlcon); sqlcmd.ExecuteNonQuery(); sqlcon.Close(); bind(); 5.Datalist实现主细表Datalist的详细属性是： 员工ID：asp:Label ID=Label1 runat=server Text= asp:DataList ID=DataList2 runat=server DataSource= DataKeyField=UserID UserID: asp:Label ID=UserIDLabel runat=server Text= / UserLoginName: asp:Label ID=UserLoginNameLabel runat=server Text= / UserSex: asp:Label ID=UserSexLabel runat=server Text= / UserPwd: asp:Label ID=UserPwdLabel runat=server Text= / UserName: asp:Label ID=UserNameLabel runat=server Text= / UserQuePwd: asp:Label ID=UserQuePwdLabel runat=server Text= / UserAnsPwd: asp:Label ID=UserAnsPwdLabel runat=server Text= / UserTel: asp:Label ID=UserTelLabel runat=server Text= / UserEmail: asp:Label ID=UserEmailLabel runat=server Text= / UserAddress: asp:Label ID=UserAddressLabel runat=server Text= / UserPostCode: asp:Label ID=UserPostCodeLabel runat=server Text= / UserQQ: asp:Label ID=UserQQLabel runat=server Text= / UserDate: asp:Label ID=UserDateLabel runat=server Text= / 后台代码是：protected void Page_Load(object sender, EventArgs e) string strselect = select top 3* from tb_EmpID select top 3a.*,b.UserID from tb_Employee as a inner join tb_EmpID as b on a.UserID=b.UserID; SqlConnection sqlcon = new SqlConnection(Data Source=localhost;Initial Catalog=db_04;uid=sa;pwd=why20080104019); sqlcon.Open(); SqlDataAdapter sda = new SqlDataAdapter(strselect, sqlcon); DataSet ds = new DataSet(); sda.Fill(ds); ds.Tables0.TableName = tb_EmpID; ds.Tables1.TableName = tb_Employee; DataColumn Parent = ds.Tablestb_EmpID.ColumnsUserID; DataColumn Child = ds.Tablestb_Employee.ColumnsUserID; DataRelation tableRelation = new DataRelation(tableRelation, Parent, Child,false); ds.Relations.Add(tableRelation); DataList1.DataSource = ds.Tablestb_EmpID.DefaultView; DataList1.DataBind(); sqlcon.Close(); 6.Datalist实现编辑功能：.Datalist的属性为： 类型编号 asp:Label ID=Label2 runat=server Text= 类型名称 asp:TextBox ID=TextBox1 runat=server Text= 商店名称 asp:TextBox ID=TextBox2 runat=server Text= 姓名： asp:Label ID=Label1 runat=server Text= 后台代码是：protected void DataList1_EditCommand(object source, DataListCommandEventArgs e)/进入编辑状态 DataList1.EditItemIndex = e.Item.ItemIndex; bind(); protected void DataList1_CancelCommand(object source, DataListCommandEventArgs e)/取消编辑 DataList1.EditItemIndex = -1; bind(); protected void DataList1_UpdateCommand(object source, DataListCommandEventArgs e)/实现更新 string id = DataList1.DataKeyse.Item.ItemIndex.ToString(); string strname = (TextBox)e.Item.FindControl(TextBox1).Text; string strstore = (TextBox)e.Item.FindControl(TextBox2).Text; string strupdate = update tb_GoodsType set GoodsTypeName=+strname+,StoreID=+strstore+ where GoodsTypeID=+id+; sqlcon = new SqlConnection(strcon); SqlCommand sqlcmd = new SqlCommand(strupdate, sqlcon); sqlcon.Open(); sqlcmd.ExecuteNonQuery(); sqlcon.Close(); DataList1.EditItemIndex = -1; bind(); 7.DataList的查看详细信息功能:DataList的属性为：asp:DataList ID=DataList1 runat=server onitemcommand=DataList1_ItemCommand 商品编号： asp:LinkButton ID=LinkButton1 runat=server Text= CommandName=select 类型编号： asp:Label ID=Label1 runat=server Text=   类型名称： asp:Label ID=Label2 runat=server Text=       供应商： asp:Label ID=Label3 runat=server Text=   返回 后台代码是：public partial class Default6 : System.Web.UI.Page