default.aspx.cs

上海中商互联 六线主机空间

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;
/// <summary>
/// u六线空间让你网速无限：http://www.ebiz8.com  QQ:59716094
/// </summary>
public partial class _Default : System.Web.UI.Page 
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            bind();
        }
    }
    private void bind()
    {
        db sdb = new db();
        DataList1.DataSource = sdb.dt("select top 10 * from flash");
        DataList1.DataKeyField = "id";
        DataList1.DataBind();
    }

    protected void DataList1_CancelCommand(object source, DataListCommandEventArgs e)
    {
        DataList1.EditItemIndex = -1;
        bind();
    }
    protected void DataList1_DeleteCommand(object source, DataListCommandEventArgs e)
    {
        string id = DataList1.DataKeys[e.Item.ItemIndex].ToString();
        db sdb = new db();
        string query = "delete from flash where ID='"+id+"'";
        if (sdb.sql(query) > 0)
        {
            Response.Write("<script>return alert('删除成功')");
            DataList1.EditItemIndex = -1;
            bind();
        }
    }
    protected void DataList1_EditCommand(object source, DataListCommandEventArgs e)
    {
        DataList1.EditItemIndex = e.Item.ItemIndex;
    }
    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 flash set fenglei2='" + fname + "',mingfeng='" + city + "' where ID='" + id + "'";
        if (sdb.sql(query) > 0)
        {
            DataList1.EditItemIndex = -1;
            bind();
        }
        //如果是对SqlDataSource的话,就用下面方法即可
        //SqlDataSource1.UpdateCommand = "update authors set au_fname='" + fname + "',city='" + city + "' where au_id='" + id + "'";
        //SqlDataSource1.Update();
    }
}