在ASP.NET 2.0 下如何实现DataList的编辑功能

前台:

 

     < form id = " form1 "  runat = " server " >
     < div >
         < asp:DataList ID = " dlEditItem "  runat = " server "  DataKeyField = " EmployeeID "  OnCancelCommand = " dlEditItem_CancelCommand "  OnEditCommand = " dlEditItem_EditCommand "  OnUpdateCommand = " dlEditItem_UpdateCommand " >
         < HeaderTemplate > 人员信息 </ HeaderTemplate >
         < ItemTemplate >
         < asp:Button ID = " edit "  runat = " server "  Text = " Edit "  CommandName = " Edit " /><% # Eval( " LastName " ) %><% # Eval( " FirstName " ) %>
         </ ItemTemplate >
         < EditItemTemplate >
         < asp:Label ID = " lastname "  runat = " server " ><% # Eval( " LastName " ) %></ asp:Label >
         < asp:Label ID = " firstname "  runat = " server " ><% #Eval( " FirstName " )  %></ asp:Label >
         < asp:TextBox ID = " title "  runat = " server "  Text = ' <%#Eval("Title") %> ' ></ asp:TextBox >
         < asp:Button ID = " update "  CommandName = " update "  runat = " server "  Text = " Update " />
         < asp:Button ID = " cancel "  runat = " server "  CommandName = " cancel "  Text = " Cancel " />
         </ EditItemTemplate >
         < FooterTemplate >< hr ></ FooterTemplate >
         </ asp:DataList ></ div >
     </ form >

 后台:

 

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;

public   partial   class  DataListEditItem : System.Web.UI.Page
... {
    protected void Page_Load(object sender, EventArgs e)
    ...{
        if (!IsPostBack)
            DataListDataBind();
    }

    private void DataListDataBind()
    ...{
        string connStr = ConfigurationManager.ConnectionStrings["northwind"].ConnectionString;
        SqlConnection conn = new SqlConnection(connStr);
        SqlDataAdapter Adapter = new SqlDataAdapter("select employeeid,lastname, firstname, title from employees", conn);
        conn.Open();
        DataSet ds = new DataSet();
        try
        ...{
            Adapter.Fill(ds, "testTable");
            dlEditItem.DataSource = ds.Tables["testTable"].DefaultView;
            dlEditItem.DataBind();
        }
        catch (Exception error)
        ...{
            Response.Write(error.ToString());
        }
        finally
        ...{
            conn.Close();
        }
    }
    protected void dlEditItem_CancelCommand(object source, DataListCommandEventArgs e)
    ...{
        dlEditItem.EditItemIndex = -1;
        DataListDataBind();
    }
    protected void dlEditItem_EditCommand(object source, DataListCommandEventArgs e)
    ...{
        dlEditItem.EditItemIndex = e.Item.ItemIndex;
        DataListDataBind();
    }
    protected void dlEditItem_UpdateCommand(object source, DataListCommandEventArgs e)
    ...{
        int empID = (int)dlEditItem.DataKeys[e.Item.ItemIndex];
        TextBox newTitle = (TextBox)e.Item.FindControl("title");
        string strUpt = "update employees set title ='" + newTitle.Text + "' where employeeid=" + empID.ToString();
        string connStr = ConfigurationManager.ConnectionStrings["northwind"].ConnectionString;
        SqlConnection conn = new SqlConnection(connStr);
        SqlCommand cmd = new SqlCommand(strUpt, conn);
        conn.Open();
        try
        ...{
            cmd.ExecuteNonQuery();
            dlEditItem.EditItemIndex = -1;
            DataListDataBind();
        }
        catch(Exception error)
        ...{
            Response.Write(error.ToString());
        }
        finally
        ...{
            conn.Close();
        }
    }
}