DXPerience之ASPxGridView使用体会(一) 自定义数据后台处理

using System;
using System.Collections.Generic;
using System.Data;
using DevExpress.Web.ASPxGridView;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
public partial class Main : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    { GetData(ASPxGridView1); }
    protected void GetData(ASPxGridView grid)
    {
        List<Category> categories = new List<Category>(); DataSet ds = msSql.SqlExecuteDataSet("select * from categories");
        foreach (DataTable table in ds.Tables)
        {
            foreach (DataRow row in table.Rows)
            {
                categories.Add(
                    new Category(Convert.ToInt16(row[0]), Convert.ToString(row[1]), Convert.ToString(row[2])));
            }
        } grid.DataSource = categories; grid.DataBind();
    }
    protected void UpdateData(object CategoryID, object CategoryName, object Description)
    {
        string s = String.Format("Update categories set CategoryName='{0}',Description='{1}' where CategoryID={2}",
            CategoryName, Description, CategoryID); msSql.SqlExecuteNonQuery(s);
    }
    protected void InsertData(object CategoryID, object CategoryName, object Description)
    {
        string s = String.Format("insert into categories (CategoryID,CategoryName,Description) values ({0},'{1}','{2}')",
          CategoryID, CategoryName, Description); msSql.SqlExecuteNonQuery(s);
    }
    protected void DeleteData(object CategoryID)
    {
        string s = String.Format("delete from categories where CategoryID={0}", CategoryID); msSql.SqlExecuteNonQuery(s);
    }
    protected void ASPxGridView1_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e)
    {
        UpdateData(e.OldValues["CategoryID"], e.NewValues[" CategoryName"], e.NewValues["Description"]);
        e.Cancel = true;
        (sender as ASPxGridView).CancelEdit(); GetData((sender as ASPxGridView));
    }
    protected void ASPxGridView1_RowDeleting( object sender, DevExpress.Web.Data.ASPxDataDeletingEventArgs e)
    {
        DeleteData(e.Keys[0]); e.Cancel = true; GetData((sender as ASPxGridView));
    }
    protected void ASPxGridView1_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e)
    {
        InsertData(e.NewValues["CategoryID"], e.NewValues["CategoryName"], e.NewValues["Description"]);
        e.Cancel = true;
        (sender as ASPxGridView).CancelEdit();
        GetData((sender as ASPxGridView));
    }
}
public class Category
{
    private int _CategoryID;
    public int CategoryID
    {
        get { return _CategoryID; }
        set
        { _CategoryID = value; }
    }
    public string CategoryName { get; set; }
    public string Description { get; set; }
    public Category(int categoryid, string categoryname, string description)
    { CategoryID = categoryid; CategoryName = categoryname; Description = description; }
}

来自：http://www.heiqu.com/show-6545-1.html