DataGrid中绑定控件实例

 

主要实现在DataGrid中绑定全选删除的CheckBox控件.和上传控件..以及取值关键代码

 

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

namespace  WebService1
... {
    public partial class DataGridTest : System.Web.UI.Page
    ...{
        protected void Page_Load(object sender, EventArgs e)
        ...{
            //if (Session["name"] == null)
            //{
            //    Response.Redirect("登陆页面.aspx");
            //}
            if (!Page.IsPostBack)
            ...{
                this.DataGridToBind();
            }

        }
        public void DataGridToBind()
        ...{

            SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["con"].ConnectionString);
            SqlDataAdapter sda = new SqlDataAdapter("select * from admin",con);
            DataSet ds = new DataSet();
            sda.Fill(ds, "admin");
            this.DataGrid1.DataKeyField = "userid";
            this.DataGrid1.DataSource = ds;
            this.DataGrid1.DataBind();
        }

        protected void DataGrid1_EditCommand(object source, DataGridCommandEventArgs e)
        ...{
            //编辑事件
            this.DataGrid1.EditItemIndex = e.Item.ItemIndex;
            this.DataGridToBind();

        }

        protected void DataGrid1_CancelCommand(object source, DataGridCommandEventArgs e)
        ...{
            //取消事件
            this.DataGrid1.EditItemIndex = -1;
            this.DataGridToBind();
        }

        protected void DataGrid1_UpdateCommand(object source, DataGridCommandEventArgs e)
        ...{
            //更新事件
            string id = this.DataGrid1.DataKeys[e.Item.ItemIndex].ToString();
            string name = ((TextBox)e.Item.Cells[3].Controls[0]).Text.Trim();
            string pswd = ((TextBox)e.Item.Cells[4].Controls[0]).Text.Trim();
            FileUpload fu = ((FileUpload)e.Item.Cells[1].FindControl("FileUpload1"));//获取FileUpload控件
            Response.Write(fu.PostedFile.FileName);//打印出文件地址来
            SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["con"].ConnectionString);
            con.Open();
            SqlCommand cmd = new SqlCommand("update admin set username='"+name+"',userpswd='"+pswd+"' where userid='"+id+"'",con);
            cmd.ExecuteNonQuery();
            this.DataGrid1.EditItemIndex = -1;
            this.DataGridToBind();
        }

        protected void DataGrid1_DeleteCommand(object source, DataGridCommandEventArgs e)
        ...{
            //删除事件
            string id = this.DataGrid1.DataKeys[e.Item.ItemIndex].ToString();
            SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["con"].ConnectionString);
            con.Open();
            SqlCommand cmd = new SqlCommand("delete admin  where userid='" + id + "'", con);
            cmd.ExecuteNonQuery();
            this.DataGrid1.EditItemIndex = -1;
            this.DataGridToBind();
        }

        protected void c1_CheckedChanged(object sender, EventArgs e)
        ...{
            //全选CheckBox
            foreach (DataGridItem gr in DataGrid1.Items)
            ...{
                CheckBox c1 = ((CheckBox)gr.FindControl("CheckBox1"));
                
                if (c1.Checked==false)
                ...{
                    c1.Checked = true;
                }
                else
                ...{
                    c1.Checked = false;
                }
            }
        }

        protected void btndelete_Click(object sender, EventArgs e)
        ...{
            //删除选中项 
            SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["con"].ConnectionString);
                    con.Open();
            for (int i = 0; i <= DataGrid1.Items.Count - 1; i++)
            ...{
                CheckBox c1 = (CheckBox)DataGrid1.Items[i].FindControl("CheckBox1");
                if (c1.Checked == true)
                ...{

                    SqlCommand cmd = new SqlCommand("delete from admin  where userid='" + this.DataGrid1.DataKeys[i] + "'", con);
                    cmd.ExecuteNonQuery();
                   
                }


            }
                    
                    this.DataGridToBind();
        }

    }
}

 

下面是前台代码

 

<% ... @ Page Language="C#" AutoEventWireup="true" CodeBehind="DataGridTest.aspx.cs" Inherits="WebService1.DataGridTest"  %>

<! DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd" >

< html  xmlns ="http://www.w3.org/1999/xhtml"   >
< head  runat ="server" >
     < title > 无标题页 </ title >
</ head >
< body >
     < form  id ="form1"  runat ="server" >
     < div >
         < asp:DataGrid  ID ="DataGrid1"  runat ="server"  AutoGenerateColumns ="False"  Style ="left: 19px;
            position: relative; top: 22px"  Width ="645px"  OnCancelCommand ="DataGrid1_CancelCommand"  OnDeleteCommand ="DataGrid1_DeleteCommand"  OnEditCommand ="DataGrid1_EditCommand"  OnUpdateCommand ="DataGrid1_UpdateCommand" >
             < Columns >
                 < asp:TemplateColumn >
                     < HeaderTemplate >
                         < asp:CheckBox  ID ="c1"  runat ="server"  Style ="position: relative"  Text ="全选"  AutoPostBack ="True"  OnCheckedChanged ="c1_CheckedChanged"   />
                     </ HeaderTemplate >
                     < ItemTemplate >
                         < asp:CheckBox  ID ="CheckBox1"  runat ="server"  Style ="position: relative"   />
                     </ ItemTemplate >
                 </ asp:TemplateColumn >
                 < asp:TemplateColumn  HeaderText ="上传文件" >
                     < ItemTemplate >
                         < asp:FileUpload  ID ="FileUpload1"  runat ="server"  Style ="position: relative"   />
                     </ ItemTemplate >
                 </ asp:TemplateColumn >
                 < asp:BoundColumn  DataField ="userid"  HeaderText ="编号"  ReadOnly ="True" ></ asp:BoundColumn >
                 < asp:BoundColumn  DataField ="userName"  HeaderText ="用户名" ></ asp:BoundColumn >
                 < asp:BoundColumn  DataField ="userpswd"  HeaderText ="密码" ></ asp:BoundColumn >
                 < asp:EditCommandColumn  CancelText ="取消"  EditText ="编辑"  HeaderText ="编辑"  UpdateText ="更新" >
                 </ asp:EditCommandColumn >
                 < asp:ButtonColumn  CommandName ="Delete"  HeaderText ="删除"  Text ="删除" ></ asp:ButtonColumn >
             </ Columns >
         </ asp:DataGrid > &nbsp; < asp:Button  ID ="btndelete"  runat ="server"  Height ="29px"  Style ="left: 11px;
            position: relative; top: 31px"  Text ="删除"  Width ="98px"  OnClick ="btndelete_Click"   /></ div >
     </ form >
</ body >
</ html >