手动绑定数据到GridView并实现编辑，删除，取消···
生活随笔
收集整理的這篇文章主要介紹了
手动绑定数据到GridView并实现编辑，删除，取消···
小編覺得挺不錯的,現在分享給大家,幫大家做個參考.
效果圖：
前臺代碼：
<!DOCTYPE?html?PUBLIC?"-//W3C//DTD?XHTML?1.0?Transitional//EN"?"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html?xmlns="http://www.w3.org/1999/xhtml">
<head?runat="server">
????<title>無標題頁</title>
</head>
<body>
????<form?id="form1"?runat="server">
????<div?align="center">
????
????????<asp:GridView?ID="GridView1"?runat="server"?AutoGenerateColumns="False"?
????????????CellPadding="4"?ForeColor="#333333"?GridLines="None"?Height="285px"?
????????????onrowcancelingedit="GridView1_RowCancelingEdit"?
????????????onrowdeleting="GridView1_RowDeleting"?onrowediting="GridView1_RowEditing"?
????????????onrowupdating="GridView1_RowUpdating"?Width="771px">
????????????<FooterStyle?BackColor="#5D7B9D"?Font-Bold="True"?ForeColor="White"?/>
????????????<RowStyle?BackColor="#F7F6F3"?ForeColor="#333333"?/>
????????????<Columns>
????????????????<asp:BoundField?DataField="id"?HeaderText="學號"?/>
????????????????<asp:BoundField?DataField="name"?HeaderText="姓名"?/>
????????????????<asp:BoundField?DataField="sex"?HeaderText="性別"?/>
????????????????<asp:BoundField?DataField="age"?HeaderText="年齡"?/>
????????????????<asp:BoundField?DataField="department"?HeaderText="專業"?/>
????????????????<asp:BoundField?DataField="grade"?HeaderText="班級"?/>
????????????????<asp:CommandField?HeaderText="編輯?"?ShowEditButton="True"?/>
????????????????<asp:CommandField?HeaderText="選擇"?ShowSelectButton="True"?/>
????????????????<asp:TemplateField?HeaderText="刪除?"?ShowHeader="False">
????????????????????<ItemTemplate>
????????????????????????<asp:LinkButton?ID="LinkButton1"?runat="server"?CausesValidation="False"?
????????????????????????????CommandName="Delete"?Text="刪除"?OnClientClick="return?confirm('你確定要刪除嗎？')"></asp:LinkButton>
????????????????????</ItemTemplate>
????????????????</asp:TemplateField>
????????????</Columns>
????????????<PagerStyle?BackColor="#284775"?ForeColor="White"?HorizontalAlign="Center"?/>
????????????<SelectedRowStyle?BackColor="#E2DED6"?Font-Bold="True"?ForeColor="#333333"?/>
????????????<HeaderStyle?BackColor="#5D7B9D"?Font-Bold="True"?ForeColor="White"?/>
????????????<EditRowStyle?BackColor="#999999"?/>
????????????<AlternatingRowStyle?BackColor="White"?ForeColor="#284775"?/>
????????</asp:GridView>
????
????</div>
????</form>
</body>
</html>
后臺代碼：
using ?System;
using ?System.Collections;
using ?System.Configuration;
using ?System.Data;
using ?System.Web;
using ?System.Web.Security;
using ?System.Web.UI;
using ?System.Web.UI.HtmlControls;
using ?System.Web.UI.WebControls;
using ?System.Web.UI.WebControls.WebParts;
using ?System.Data.SqlClient;
public ? partial ? class ?Default5?:?System.Web.UI.Page
{
????protected?void?Page_Load(object?sender,?EventArgs?e)
????{
????????if?(!IsPostBack)
????????{
????????????Bind();
????????}
????}
????private?void?Bind()
????{
????????SqlConnection?conn?=?new?SqlConnection(ConfigurationManager.ConnectionStrings["Personal"].ConnectionString);
????????SqlDataAdapter?adq?=?new?SqlDataAdapter("select?*?from?information",?conn);
????????DataSet?dataset=new?DataSet();
????????adq.Fill(dataset,"information");
????????GridView1.DataSource=dataset;
????????GridView1.DataKeyNames=new?String[]{"id"};
????????GridView1.DataBind();
????}
????protected?void?GridView1_RowEditing(object?sender,?GridViewEditEventArgs?e)
????{
????????GridView1.EditIndex?=?e.NewEditIndex;
????????Bind();
????}
????protected?void?GridView1_RowDeleting(object?sender,?GridViewDeleteEventArgs?e)
????{
????????SqlConnection?conn?=?new?SqlConnection(ConfigurationManager.ConnectionStrings["Personal"].ConnectionString);
????????SqlCommand?comm?=?new?SqlCommand("delete?from?information?where?id='"?+?GridView1.DataKeys[e.RowIndex].Value.ToString()?+?"'",conn);
????????conn.Open();
????????try
????????{
????????????int?i?=?Convert.ToInt32(comm.ExecuteNonQuery());
????????????if?(i?>?0)
????????????{
????????????????Response.Write("<script?language=javascript>alert('刪除成功！')</script>");
????????????}
????????????else
????????????{
????????????????Response.Write("<script?language=javascript>alert('刪除失敗！')</script>");
????????????}
????????????Bind();
????????}
????????catch?(Exception?erro)
????????{
????????????Response.Write("錯誤信息:"+erro.Message);
????????}
????????finally
????????{
????????????conn.Close();
????????}
????}
????protected?void?GridView1_RowUpdating(object?sender,?GridViewUpdateEventArgs?e)
????{
????????string?id?=?((TextBox)GridView1.Rows[e.RowIndex].Cells[0].Controls[0]).Text.ToString().Trim();
????????string?name?=?((TextBox)GridView1.Rows[e.RowIndex].Cells[1].Controls[0]).Text.ToString().Trim();
????????string?sex?=?((TextBox)GridView1.Rows[e.RowIndex].Cells[2].Controls[0]).Text.ToString().Trim();
????????string?age=?((TextBox)GridView1.Rows[e.RowIndex].Cells[3].Controls[0]).Text.ToString().Trim();
????????string?department?=?((TextBox)GridView1.Rows[e.RowIndex].Cells[4].Controls[0]).Text.ToString().Trim();
????????string?grade?=?((TextBox)GridView1.Rows[e.RowIndex].Cells[5].Controls[0]).Text.ToString().Trim();
????????SqlConnection?conn?=?new?SqlConnection(ConfigurationManager.ConnectionStrings["Personal"].ConnectionString);
????????SqlCommand?comm?=?new?SqlCommand("update?information?set?id='"+id+"',?name='"+name+"'?,?sex='"+sex+"'?,?age='"+age+"'?,?department='"+department+"'?,?grade='"+grade+"'?where?id='"+GridView1.DataKeys[e.RowIndex].Value.ToString()+"'",?conn);
????????conn.Open();
????????try
????????{
????????????int?i?=?Convert.ToInt32(comm.ExecuteNonQuery());
????????????if?(i?>?0)
????????????{
????????????????Response.Write("<script?language=javascript>alert('保存成功！')</script>");
????????????}
????????????else
????????????{
????????????????Response.Write("<script?language=javascript>alert('保存失敗！')</script>");
????????????}
????????????GridView1.EditIndex?=?-1;
????????????Bind();
????????}
????????catch?(Exception?erro)
????????{
????????????Response.Write("錯誤信息:"?+?erro.Message);
????????}
????????finally
????????{
????????????conn.Close();
????????}
????}
????protected?void?GridView1_RowCancelingEdit(object?sender,?GridViewCancelEditEventArgs?e)
????{
????????GridView1.EditIndex?=?-1;
????????Bind();
????}
}
總結
以上是生活随笔為你收集整理的手动绑定数据到GridView并实现编辑，删除，取消···的全部內容，希望文章能夠幫你解決所遇到的問題。
- 上一篇： 数据绑定控件之ListView
- 下一篇： 手动绑定数据到DatList并实现编辑，