default.aspx.cs

实现asp.net技术以及它是如何使用的 实现asp.net技术以及它是如何使用的

using System;
using System.Data;
using System.Configuration;
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;

public partial class _Default : System.Web.UI.Page 
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            //db sdb = new db();
            //DataList1.DataSource = sdb.dt("select top 10 * from authors");
            //DataList1.DataKeyField = "au_id";
            //DataList1.DataBind();
            bind();
        }
    }
    private void bind()
    {
        db sdb = new db();
        DataList1.DataSource = sdb.dt("select top 10 * from authors");
        DataList1.DataKeyField = "au_id";
        DataList1.DataBind();
        //DataList1.DataSource = SqlDataSource1;
        //DataList1.DataKeyField = "au_id";
        //DataList1.DataBind();
    }
    protected void DataList1_DeleteCommand(object source, DataListCommandEventArgs e)
    {
        string id = DataList1.DataKeys[e.Item.ItemIndex].ToString();
        db sdb = new db();
        string query = "delete from authors where au_id='" + id + "'";
        if (sdb.sql(query) > 0)
        {
            Response.Write("<script>return alert('删除成功')");
            DataList1.EditItemIndex = -1;
            bind();
        }
    }
    protected void DataList1_ItemCommand(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.DataKeys[e.Item.ItemIndex].ToString();
        string fname = ((TextBox)e.Item.FindControl("TextBox1")).Text;
        string city = ((TextBox)e.Item.FindControl("TextBox2")).Text;
        db sdb = new db();
        string query="update authors set au_fname='"+fname+"',city='"+city+"' where au_id='"+id+"'";
        if(sdb.sql(query)>0)
        {
            DataList1.EditItemIndex=-1;
            bind();
            //SqlDataSource1.UpdateCommand = "update authors set au_fname='" + fname + "',city='" + city + "' where au_id='" + id + "'";
            //SqlDataSource1.Update();
        }
    }
}