edituser.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_deluser : 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)
    //{

    //}

    //protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
    //{
    //    GridView1.EditIndex = e.NewEditIndex;
    //    this.GridView1.EditRowStyle.BackColor = Color.AliceBlue;
    //    bindtogridview();
    //}
    //protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
    //{
    //    GridView1.EditIndex = -1;
    //    bindtogridview();
    //}
    //protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
    //{
    //    string strID = this.GridView1.DataKeys[e.RowIndex].Value.ToString();
    //    string strClassName = ((TextBox)(GridView1.Rows[e.RowIndex].Cells[1].Controls[0])).Text.Trim().ToString();

    //    WebClass.ArticleList tmp = new WebClass.ArticleList();
    //    tmp.EditClass(strClassName, strID);

    //    GridView1.EditIndex = -1;
    //    bindtogridview();
    //}
    //protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
    //{
    //    string strID = this.GridView1.DataKeys[e.RowIndex].Value.ToString();

    //    WebClass.ArticleList tmp = new WebClass.ArticleList();
    //    tmp.DelClass(strID);

    //    GridView1.EditIndex = -1;
    //    bindtogridview();
    //}




     //bind
    private void bindtogridview()
    {
        SqlConnection con = DB.createConnection();
        SqlDataAdapter sda = new SqlDataAdapter();
        sda.SelectCommand = new SqlCommand("select * from login", con);
        DataSet ds = new DataSet();
        sda.Fill(ds, "login");
        this.GridView1.DataKeyNames = new string[] { "用户名" };
        this.GridView1.DataSource = ds.Tables["login"];
        this.GridView1.DataBind();
    }







    protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
    {

    }
}