editclient.ascx.cs

用vs2005和sql2000实现的小型超市管理系统

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 control_alterclient : System.Web.UI.UserControl
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            this.bindtogridview();
        }

    }
    protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
    {

    }

    private void bindtogridview()
    {
        SqlConnection con = DB.createConnection();
        SqlDataAdapter sda = new SqlDataAdapter();
        sda.SelectCommand = new SqlCommand("select * from client", con);
        DataSet ds = new DataSet();
        sda.Fill(ds, "client");
        this.GridView1.DataKeyNames = new string[] { "客户编号" };
        this.GridView1.DataSource = ds.Tables["client"];
        this.GridView1.DataBind();
    }
    //protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
    //{
    //    this.GridView1.EditIndex = e.NewEditIndex;
    //    bindtogridview();
    //}
    //protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
    //{
    //    this.GridView1.EditIndex = -1;
    //    bindtogridview();
    //}
    //protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
    //{
    //    DepartmentInfo dept = new DepartmentInfo();
    //    dept.DepartmentID = Convert.ToInt32(this.GridView1.DataKeys[e.RowIndex].Value);
    //    dept.DepartmentName = ((TextBox)this.GridView1.Rows[e.RowIndex].Cells[0].Controls[0]).Text;
    //    dept.DepartmentBrief = ((TextBox)this.GridView1.Rows[e.RowIndex].Cells[1].Controls[0]).Text;
    //    //department.DepartmentName =  e.NewValues[0].ToString();  //此两句不能成功，原因未知。
    //    //department.DepartmentBrief = e.NewValues[1].ToString();
    //    if (dept.DepartmentID == 0)
    //    {
    //        new Department().insert(dept);
    //    }
    //    else
    //    {
    //        new Department().update(dept);
    //    }
    //    this.GridView1.EditIndex = -1;
    //    BindDepts();
    //}



    protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        this.GridView1.PageIndex = e.NewPageIndex;
        this.bindtogridview();
    }

}