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

public partial class _Default : System.Web.UI.Page 
{
    string myConnetionString = "server=XS;uid=sa;pwd=123456;database=Diamond;";
    SqlConnection myConnection = new SqlConnection();

    protected void Page_Load(object sender, EventArgs e)
    {
        GridViewBind();

    }
    private void GridViewBind()
    {
        myConnection.ConnectionString = myConnetionString;
        string cmdString = "select top 10 用户名, 城市, 地址,联系电话 from Customer";
        SqlDataAdapter myAdapter = new SqlDataAdapter(cmdString, myConnection);
        myConnection.Open();
        DataSet mySet = new DataSet();
        myAdapter.Fill(mySet);
        myGridView.DataSource = mySet;
        myGridView.DataBind();
        myConnection.Close();
    }
    protected void myGridView_RowEditing(object sender, GridViewEditEventArgs e)
    {
        myGridView.EditIndex = e.NewEditIndex;
        GridViewBind();
    }

    protected void myGridView_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
        myGridView.EditIndex = -1;
        GridViewBind();
    }
    protected void myGridView_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
    {
        myGridView.EditIndex = -1;
        GridViewBind();
    }
}