手动绑定数据到GridView并实现编辑_删除_取消···

GridView添加编辑删除using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Web.UI.HtmlControls;using OASys.BLL;using OASys.Models;using System.Collections.Generic;public partial class _Default : System.Web.UI.Page{public UserInfoManager info = new UserInfoManager();/// <summary>/// 窗体加载事件/// </summary>/// <param name="sender"></param>/// <param name="e"></param>protected void Page_Load(object sender, EventArgs e) {if (!IsPostBack){LoadInfo();}}/// <summary>/// 加载用户信息的方法/// </summary>private void LoadInfo(){List<UserInfo> users =new List<UserInfo>();foreach (UserInfo user in info.GetAllUserInfo()){if (user.Gender == 1){user.DepartId.sex = "男";}else{user.DepartId.sex = "女";}users.Add(user);}gdvUserInfo.DataSource =users;gdvUserInfo.DataBind();}/// <summary>/// 分页事件/// </summary>/// <param name="sender"></param>/// <param name="e"></param>protected void gdvUserInfo_PageIndexChanging(object sender, GridViewPageEventArgs e){gdvUserInfo.PageIndex = e.NewPageIndex;LoadInfo();}/// <summary>/// 删除信息事件/// </summary>/// <param name="sender"></param>/// <param name="e"></param>protected void gdvUserInfo_RowDeleting(object sender, GridViewDeleteEventArgs e){string id =gdvUserInfo.DataKeys[e.RowIndex].Value.ToString();if (info.DeleteUserInfoById(id) > 0){this.lblMessage.Text = "删除成功！";LoadInfo();}else{this.lblMessage.Text = "删除失败！";LoadInfo();}}/// <summary>/// 编辑事件/// </summary>/// <param name="sender"></param>/// <param name="e"></param>protected void gdvUserInfo_RowEditing(object sender, GridViewEditEventArgs e){gdvUserInfo.EditIndex = e.NewEditIndex;LoadInfo();}/// <summary>/// 取消编辑事件/// </summary>/// <param name="sender"></param>/// <param name="e"></param>protected void gdvUserInfo_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e){gdvUserInfo.EditIndex = -1;LoadInfo();}/// <summary>/// 更新事件/// </summary>/// <param name="sender"></param>/// <param name="e"></param>protected void gdvUserInfo_RowUpdating(object sender, GridViewUpdateEventArgs e){string userId = gdvUserInfo.DataKeys[e.RowIndex].Value.ToString();TextBox txtUserId =(TextBox)gdvUserInfo.Rows[e.RowIndex].Cells[0].FindControl("txtUserId");TextBox txtUserName =(TextBox)gdvUserInfo.Rows[e.RowIndex].Cells[0].FindControl("txtUserName" );TextBox txtPassWord =(TextBox)gdvUserInfo.Rows[e.RowIndex].Cells[0].FindControl("txtPassWord") ;if (txtUserName != null && txtPassWord != null){try{UserInfo user = info.GetUserInfoById(userId);erName = txtUserName.Text.ToString();user.Password = txtPassWord.Text.ToString();if (info.ModifyUserInfo(user) > 0){this.lblMessage.Text = "修改成功！";gdvUserInfo.EditIndex = -1;LoadInfo();}else{this.lblMessage.Text = "修改失败！";gdvUserInfo.EditIndex = -1;LoadInfo();}}catch (Exception){this.lblMessage.Text = "修改失败！";gdvUserInfo.EditIndex = -1;LoadInfo();}}}/// <summary>////// 光棒事件/// </summary>/// <param name="sender"></param>/// <param name="e"></param>protected void gdvUserInfo_RowDataBound(object sender, GridViewRowEventArgs e){for (int i = 0; i < gdvUserInfo.Rows.Count; i++){if (gdvUserInfo.Rows[i].RowType == DataControlRowType.DataRow){gdvUserInfo.Rows[i].Attributes.Add("onmouseover", "c=this.style.backgroundColor;this.style.backgroundColor='#9cf'");gdvUserInfo.Rows[i].Attributes.Add("onmouseout", "this.style.backgroundColor=c");}}}}。

GridView无代码分页排序GridView选中，编辑，取消，删除GridView正反双向排序GridView和下拉菜单DropDownList结合GridView和CheckBox结合鼠标移到GridView某一行时改变该行的背景色方法一鼠标移到GridView某一行时改变该行的背景色方法二GridView实现删除时弹出确认对话框GridView实现自动编号GridView实现自定义时间货币等字符串格式GridView实现用“...”代替超长字符串GridView一般换行与强制换行GridView显示隐藏某一列GridView弹出新页面/弹出新窗口GridView固定表头(不用javascript只用CSS，2行代码，很好用) GridView合并表头多重表头无错完美版（以合并3列3行举例）GridView突出显示某一单元格（例如金额低于多少，分数不及格等）GridView加入自动求和求平均值小计GridView数据导入Excel/Excel数据读入GridView在对GridView编辑的时候实现自动计算实现类似winform的点击行选中功能GridView在编辑的时候控制编辑框的列宽。

给Gridview加入Tooltip的功能1.GridView无代码分页排序：1.AllowSorting设为True，aspx代码中是AllowSorting="True"；2.默认1页10条，如果要修改每页条数，修改PageSize即可，在aspx代码中是PageSize="12"。

3.默认的是单向排序的，右击GridView弹出“属性”，选择AllowSorting为True即可。

2.GridView选中，编辑，取消，删除：效果图：后台代码：你可以使用sqlhelper,本文没用。

代码如下：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{//清清月儿/21aspnetSqlConnection sqlcon;SqlCommand sqlcom;string strCon = "Data Source=(local);Database=数据库名;Uid=帐号;Pwd=密码";protected void Page_Load(object sender, EventArgs e){if (!IsPostBack){bind();}}protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e) {GridView1.EditIndex = e.NewEditIndex;bind();}//删除protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) {string sqlstr = "delete from 表where id='" +GridView1.DataKeys[e.RowIndex].Value.ToString() + "'";sqlcon = new SqlConnection(strCon);sqlcom = new SqlCommand(sqlstr,sqlcon);sqlcon.Open();sqlcom.ExecuteNonQuery();sqlcon.Close();bind();}//更新protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e) {sqlcon = new SqlConnection(strCon);string sqlstr = "update 表set 字段1='"+((TextBox)(GridView1.Rows[e.RowIndex].Cells[1].Controls[0])).Text.ToString().Trim() + "',字段2='"+((TextBox)(GridView1.Rows[e.RowIndex].Cells[2].Controls[0])).Text.ToString().Trim() + "',字段3='"+((TextBox)(GridView1.Rows[e.RowIndex].Cells[3].Controls[0])).Text.ToString().Trim() + "' where id='"+ GridView1.DataKeys[e.RowIndex].Value.ToString() + "'";sqlcom=new SqlCommand(sqlstr,sqlcon);sqlcon.Open();sqlcom.ExecuteNonQuery();sqlcon.Close();GridView1.EditIndex = -1;bind();}//取消protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e){GridView1.EditIndex = -1;bind();}//绑定public void bind(){string sqlstr = "select * from 表";sqlcon = new SqlConnection(strCon);SqlDataAdapter myda = new SqlDataAdapter(sqlstr, sqlcon);DataSet myds = new DataSet();sqlcon.Open();myda.Fill(myds, "表");GridView1.DataSource = myds;GridView1.DataKeyNames = new string[] { "id" };//主键GridView1.DataBind();sqlcon.Close();}}前台主要代码：... ...<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" CellPadding="4"ForeColor="#333333" GridLines="None"OnRowDeleting="GridView1_RowDeleting" OnRowEditing="GridView1_RowEditing"OnRowUpdating="GridView1_RowUpdating"OnRowCancelingEdit="GridView1_RowCancelingEdit"><FooterStyle BackColor="#990000" Font-Bold="True" ForeColor="White" /><Columns><asp:BoundField DataField="身份证号码" HeaderText="用户ID" ReadOnly="True" /><asp:BoundField DataField="姓名" HeaderText="用户姓名" /><asp:BoundField DataField="员工性别" HeaderText="性别" /><asp:BoundField DataField="家庭住址" HeaderText="家庭住址" /><asp:CommandField HeaderText="选择" ShowSelectButton="True" /><asp:CommandField HeaderText="编辑" ShowEditButton="True" /><asp:CommandField HeaderText="删除" ShowDeleteButton="True" /> </Columns><RowStyle ForeColor="#000066" /><SelectedRowStyle BackColor="#669999" Font-Bold="True"ForeColor="White" /><PagerStyle BackColor="White" ForeColor="#000066"HorizontalAlign="Left" /><HeaderStyle BackColor="#006699" Font-Bold="True" ForeColor="White" /></asp:GridView>3.GridView正反双向排序：（用到数据库视图DATAVIEW及GRIDVIEW的VIEWSTAT 类）效果图：点姓名各2次的排序，点其他也一样可以。

<asp:ImageButton ID="ibOk" OnClientClick="return confirm('确定要删除?')" CommandName="ibOk" Visible="false" AlternateText="确定" OnClick="ibOk_Click" ImageUrl="../Images/StudentScore/page_go.png" runat="server"/>
<asp:TemplateField >
<ItemTemplate>
<asp:ImageButton ID="ibEdit" CommandName="ibEdit" AlternateText="编辑" OnClick="ibEdit_Click" ImageUrl="../Images/StudentScore/page_edit.png" runat="server"/>
view plaincopy to clipboardprint?
01.protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
02.
03. if (mandName == "ibEdit")
07. gv.EditIndex = drv.RowIndex;
08. isEdit =true;
09. TestCon();

数据控件DataGridView添加、删除和修改数据库中的内容作者：天涯来源：中国自学编程网发布日期：1214063638介绍一个数据控件DataGridView，它是 3.5中新增加的的重要控件。

它是一种网格形式的控件，能以表格的形式显示数据，它的优势是能多行显示数据，在数据库的操作中会经常用到。

（1）打开VS2008，在D:\C#\ch14目录下建立名为DataGridViewTest的Windows应用程序，打开工程，为当前窗体添加控件，如表14-2所示。

表14-2 添加控件列表控件名NameTextDataGridViewdataGridView1ButtonbtnRef更新设置ButtonbtnDelete删除（2）接下来需要设置DadaAdapter和DataSet，方法同上一节一样。

选中DataGridView的DataSource属性。

（3）单击“下一步”按钮，选择“数据连接”图标。

（4）最后一步需要选择数据库对象，本例是要操作StudentInf数据库中的表，所以选择“表”复选框。

（5）设置完毕后，整个程序界面就设置完了。

程序界面设计完毕后，接下来要做的工作就是通过修改dataGridView1中的数据来更新数据库中的内容。

它实现的原理很简单，通过studentInfDataSet把dataGridView1绑定到Class1表，studentInfDataSet处于中间位置，所以在dataGridView1中修改的数据必须要传递到studentInfDataSet后才能改变数据库中的内容。

（1）双击“更新设置”按钮，添加如下代码。

this.sqlDataAdapter1.Update(this.studentInfDataSet);该代码的功能是调用sqlDataAdapter1的Update()方法实现对studentInfDataSet的更新。

（2）按F5键，程序运行以后，对dataGridView1添加一行新的数据，然后单击“更新设置”按钮，完成后关闭程序再打开。