datalist的控件数据绑定以及修改删除

using System;
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;
using System.IO;
public partial class _Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!this.IsPostBack)
        {
            datalist();
        }
    }
    private void datalist()
    {
       
        SqlDataAdapter sda = new SqlDataAdapter();
        sda.SelectCommand = new SqlCommand("select * from admin", DB.conn);
        DataSet ds = new DataSet();
        sda.Fill(ds, "admin");
        this.DataList1.DataKeyField = "id";
        this.DataList1.DataSource = ds.Tables["admin"].DefaultView;
        this.DataList1.DataBind();
        DB.conn.Close();      
    }

    protected void Button1_Click1(object sender, EventArgs e)
    {
        Response.Write(Application["count"].ToString());
        Response.Write("<br>");
        Response.Write(Server.MachineName);
        Response.Write("<h1>Title</h1>");
        Response.Write(Server.UrlEncode("<a href=www.baidu.com>www.baidu.com</a>"));
    
    }

    protected void DataList1_ItemCommand(object source, DataListCommandEventArgs e)
    {
        if (e.CommandName == "select")
        {
            this.DataList1.SelectedIndex = e.Item.ItemIndex;
            this.datalist();
        }
    
    }
    protected void DataList1_EditCommand(object source, DataListCommandEventArgs e)
    {
        if (e.CommandName == "edit")
        {
            this.DataList1.EditItemIndex = e.Item.ItemIndex;
            this.datalist();
           
        }
    }
    protected void DataList1_CancelCommand(object source, DataListCommandEventArgs e)
    {
      

            this.DataList1.EditItemIndex = -1;
            this.datalist();
   
    }
    protected void DataList1_UpdateCommand(object source, DataListCommandEventArgs e)
    {
        string id = this.DataList1.DataKeys[e.Item.ItemIndex].ToString();
        string name = ((TextBox)e.Item.FindControl("txtname")).Text;

        try
        {
            SqlCommand cmd = new SqlCommand("update admin set name='" + name + "'where id='" + id + "'", DB.conn);
            DB.conn.Open();
            cmd.ExecuteNonQuery();
        }
        catch (Exception ex)
        {
            Response.Write(ex.Message);
        }
        finally
        {
            DB.conn.Close();
        }
    }
    protected void DataList1_DeleteCommand(object source, DataListCommandEventArgs e)
    {
        string id = this.DataList1.DataKeys[e.Item.ItemIndex].ToString();
        try
        {
            DB.conn.Open();
            SqlCommand cmd = new SqlCommand("delete from admin where id='" + id + "'", DB.conn);
            cmd.ExecuteNonQuery();
        }
        catch (Exception ex)
        {
            Response.Write(ex.Message);
        }
        finally
        {
            DB.conn.Close();
        }
    }

 

简单实现。