asp Gridview控件实现增删改查（含数据库脚本）

【实例截图】

【核心代码】

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using government_web.db;
namespace government_web.user
{
    public partial class user : System.Web.UI.Page
    {
        public SqlServerDB sqlServerDB = null;
        protected void Page_Load(object sender, EventArgs e)
        {

          
           

        }
        /// <summary>
        /// 删除操作
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected void GridView_user_RowDeleting(object sender, GridViewDeleteEventArgs e)
        {
            int id = int.Parse(GridView_user.Rows[e.RowIndex].Cells[0].Text.ToString());
            SqlDataSource_user.DeleteCommand = "delete from [users] where uid="   id;
            SqlDataSource_user.Delete();
            bind();
        }
        /// <summary>
        /// 搜索
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected void user_search_Click(object sender, EventArgs e)
        {
            bind();
        }

        /// <summary>
        /// 点击分页
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected void GridView_user_PageIndexChanging(object sender, GridViewPageEventArgs e)
        {
            bind();
        }

        public void bind() {
            //查询字符串
            string sql = "select * from [users] where [username] like '%"   TextBox_username.Text   "%' "
                  " and [email] like '%"   TextBox_email.Text   "%' and [name] like '%"   TextBox_name.Text   "%'"
                  " and [phone] like '%"   TextBox_phone.Text   "%'";
            //设置SqlDataSource 执行sql语句
            SqlDataSource_user.SelectCommand = sql;
            //设置GridView中DataSourceID
            GridView_user.DataSourceID = SqlDataSource_user.ID;
            //绑定GridView数据
            GridView_user.DataBind();
        }

        protected void Button_user_search_Click(object sender, EventArgs e)
        {
            bind();
        }

        protected void GridView_user_SelectedIndexChanging(object sender, GridViewSelectEventArgs e)
        {
            int index = e.NewSelectedIndex;
            
        }
        /// <summary>
        /// 数据绑定
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected void GridView_user_RowDataBound(object sender, GridViewRowEventArgs e)
        {
            TextBox TextBox_row_username = (TextBox)e.Row.FindControl("TextBox_row_username") as TextBox;
            //e.Row.RowType 
            if (e.Row.RowType == DataControlRowType.DataRow )
            {
                //用户名
                if(TextBox_row_username!=null){
                    TextBox_row_username.Text = ((HiddenField)e.Row.FindControl("HiddenField_row_username")).Value;
                }
                //姓名
                TextBox TextBox_row_name = (TextBox)e.Row.FindControl("TextBox_row_name") as TextBox;
                if (TextBox_row_name != null)
                {
                    TextBox_row_name.Text = ((HiddenField)e.Row.FindControl("HiddenField_row_name")).Value;

                }
                //邮箱
                TextBox TextBox_row_email = (TextBox)e.Row.FindControl("TextBox_row_email") as TextBox;
                if (TextBox_row_email != null)
                {
                    TextBox_row_email.Text = ((HiddenField)e.Row.FindControl("HiddenField_row_email")).Value;

                }
                //电话
                TextBox TextBox_row_phone = (TextBox)e.Row.FindControl("TextBox_row_phone") as TextBox;
                if ( TextBox_row_phone != null)
                {
                    TextBox_row_phone.Text = ((HiddenField)e.Row.FindControl("HiddenField_row_phone")).Value;

                }
            }
            
            

            

            
            
          // TextBox_row_username.Text = "123";
        }

        protected void GridView_user_RowEditing(object sender, GridViewEditEventArgs e)
        {
            //Row.FindControl("TextBox_row_username");
            GridView_user.EditIndex = e.NewEditIndex;
        }

        protected void GridView_user_RowUpdating(object sender, GridViewUpdateEventArgs e)
        {
           
            //用户名
            TextBox TextBox_row_username= GridView_user.Rows[e.RowIndex].FindControl("TextBox_row_username") as TextBox;
            //姓名
            TextBox TextBox_row_name    = GridView_user.Rows[e.RowIndex].FindControl("TextBox_row_name") as TextBox;
            //邮箱
            TextBox TextBox_row_email   = GridView_user.Rows[e.RowIndex].FindControl("TextBox_row_email") as TextBox;
            //电话
            TextBox TextBox_row_phone   = GridView_user.Rows[e.RowIndex].FindControl("TextBox_row_phone") as TextBox;
            int id = int.Parse(GridView_user.Rows[e.RowIndex].Cells[0].Text);
            string sql = "";
            if (TextBox_row_username!=null && TextBox_row_username.Text!="")
            {
                sql  = " username='"   TextBox_row_username.Text   "',";
            }
            if (TextBox_row_name != null && TextBox_row_name.Text != "")
            {
                sql  = " name='"   TextBox_row_name.Text   "',";
            }
            if (TextBox_row_email != null && TextBox_row_email.Text != "")
            {
                sql  = " email='"   TextBox_row_email.Text   "',";
            }
            if (TextBox_row_phone != null && TextBox_row_username.Text != "")
            {
                sql  = " phone='"   TextBox_row_phone.Text   "',";
            }
            if(sql!=""){
                sql = sql.Remove(sql.LastIndexOf(","), 1);
                sql = "update users set "   sql " where uid=" id;
                SqlDataSource_user.UpdateCommand = sql;
                SqlDataSource_user.Update();
                bind();
            }
        }
    }
}