當(dāng)前位置：首頁 > 人文社科 > 生活经验 >内容正文

生活经验

GridView控件修改、删除示例（修改含有DropDownList控件）

發(fā)布時間：2023/11/27 生活经验 38 豆豆

生活随笔收集整理的這篇文章主要介紹了 GridView控件修改、删除示例（修改含有DropDownList控件）小編覺得挺不錯的,現(xiàn)在分享給大家,幫大家做個參考.

GridView控件修改、刪除例子，修改時含有DropDownList控件。
示例運行效果圖：

GridViewUp.aspx文件代碼：

<%@?Page?Language="C#"?AutoEventWireup="true"?CodeFile="GridViewUp.aspx.cs"?Inherits="gridview_GridViewUp"?%>

<!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>無標(biāo)題頁</title>
</head>
<body>
????<form?id="form1"?runat="server">
????????<div>
????????????<table?cellpadding="0"?cellspacing="0"?border="0"?width="80%"?style="font-size:?11px">
????????????????<tr>
????????????????????<td?align="center">
????????????????????????<asp:GridView?ID="GridView1"?runat="server"?Width="100%"?CellPadding="4"?ForeColor="#333333"
????????????????????????????AutoGenerateColumns="False"?AllowPaging="True"?PageSize="12"?OnRowCancelingEdit="GridView1_RowCancelingEdit"
????????????????????????????OnRowEditing="GridView1_RowEditing"?OnRowUpdating="GridView1_RowUpdating"?OnRowDeleting="GridView1_RowDeleting"
????????????????????????????DataKeyNames="id,name"?OnPageIndexChanging="GridView1_PageIndexChanging"?DataMember="card,price"?OnRowDataBound="GridView1_RowDataBound"?GridLines="None">
????????????????????????????<Columns>
????????????????????????????????<asp:BoundField?HeaderText="編號"?DataField="id"?ReadOnly="True"?/>
????????????????????????????????<asp:BoundField?DataField="name"?HeaderText="姓名"?ReadOnly="True"?/>
????????????????????????????????<asp:TemplateField?HeaderText="身份證號">
????????????????????????????????????<ItemTemplate>
????????????????????????????????????????<%#?Eval("card")?%>
????????????????????????????????????</ItemTemplate>
????????????????????????????????????<EditItemTemplate>
????????????????????????????????????????<asp:TextBox?ID="TBCard"?Text='<%#?Eval("card")?%>'?runat="server"?Width="140px"?/>
????????????????????????????????????</EditItemTemplate>
????????????????????????????????????<ItemStyle?Width="150px"?/>
????????????????????????????????</asp:TemplateField>
????????????????????????????????<asp:TemplateField?HeaderText="學(xué)歷">
????????????????????????????????????<ItemTemplate>
????????????????????????????????????????<%#?Eval("xueliText")%>
????????????????????????????????????</ItemTemplate>
????????????????????????????????????<EditItemTemplate>
????????????????????????????????????????<asp:HiddenField?ID="HDFXueli"?runat="server"?Value='<%#?Eval("xueli")?%>'?/>
????????????????????????????????????????<asp:DropDownList?ID="DDLXueli"?runat="server"?Width="90px"?/>
????????????????????????????????????</EditItemTemplate>
????????????????????????????????????<ItemStyle?Width="100px"?/>
????????????????????????????????</asp:TemplateField>
????????????????????????????????<asp:TemplateField?HeaderText="價格">
????????????????????????????????????<ItemTemplate>
????????????????????????????????????????<%#?Eval("price")?%>
????????????????????????????????????</ItemTemplate>
????????????????????????????????????<EditItemTemplate>
????????????????????????????????????????<asp:TextBox?ID="TBPrice"?Text='<%#?Eval("price")?%>'?runat="server"?Width="90px"?/>
????????????????????????????????????</EditItemTemplate>
????????????????????????????????????<ItemStyle?Width="100px"?/>
????????????????????????????????</asp:TemplateField>
????????????????????????????????<asp:BoundField?HeaderText="建立時間"?DataField="createdate"?ReadOnly="True"?/>
????????????????????????????????<asp:CommandField?ShowDeleteButton="True"?ShowEditButton="True"?HeaderText="操作"?/>
????????????????????????????</Columns>
????????????????????????????<PagerSettings?FirstPageText=""?LastPageText=""?NextPageText=""?PreviousPageText=""?/>
????????????????????????????<RowStyle?Height="20px"?BackColor="#F7F6F3"?ForeColor="#333333"?/>
????????????????????????????<FooterStyle?BackColor="#5D7B9D"?Font-Bold="True"?ForeColor="White"?/>
????????????????????????????<EditRowStyle?BackColor="#999999"?/>
????????????????????????????<SelectedRowStyle?BackColor="#E2DED6"?Font-Bold="True"?ForeColor="#333333"?/>
????????????????????????????<PagerStyle?BackColor="#284775"?ForeColor="White"?HorizontalAlign="Center"?/>
????????????????????????????<HeaderStyle?BackColor="#5D7B9D"?Font-Bold="True"?ForeColor="White"?/>
????????????????????????????<AlternatingRowStyle?BackColor="White"?ForeColor="#284775"?/>
????????????????????????</asp:GridView>
????????????????????</td>
????????????????</tr>
????????????</table>
????????</div>
????</form>
</body>
</html>

GridViewUp.aspx.cs文件代碼：

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?gridview_GridViewUp?:?System.Web.UI.Page
{
????protected?void?Page_Load(object?sender,?EventArgs?e)
????{
????????if?(!IsPostBack)
????????{
????????????GridViewBind();
????????}
????}

????protected?void?GridView1_PageIndexChanging(object?sender,?GridViewPageEventArgs?e)
????{
????????GridView1.PageIndex?=?e.NewPageIndex;
????????GridViewBind();
????}

????private?void?GridViewBind()
????{
????????string?connStr?=?ConfigurationManager.ConnectionStrings["ConnString"].ConnectionString;
????????string?SqlStr?=?"SELECT?*,case?xueli?when?'1'?then?'博士'?when?'2'?then?'碩士'?when?'3'?then?'學(xué)士'?else?''?end?as?xueliText?FROM?test01?where?id<1000?and?id>200";
????????DataSet?ds?=?new?DataSet();

????????try
????????{
????????????SqlConnection?conn?=?new?SqlConnection(connStr);
????????????if?(conn.State.ToString()?==?"Closed")?conn.Open();
????????????SqlDataAdapter?da?=?new?SqlDataAdapter(SqlStr,?conn);
????????????da.Fill(ds,?"test01");
????????????if?(conn.State.ToString()?==?"Open")?conn.Close();

????????????GridView1.DataSource?=?ds.Tables[0].DefaultView;
????????????GridView1.DataBind();
????????}
????????catch?(Exception?ex)
????????{
????????????Response.Write("數(shù)據(jù)庫錯誤，錯誤原因："?+?ex.Message);
????????????Response.End();
????????}
????}

????protected?void?GridView1_RowDataBound(object?sender,?GridViewRowEventArgs?e)
????{
????????if?(((DropDownList)e.Row.FindControl("DDLXueli"))?!=?null)
????????{????????
????????????DropDownList?ddlxueli?=?(DropDownList)e.Row.FindControl("DDLXueli");

????????????//??生成?DropDownList?的值，也可以取得數(shù)據(jù)庫中的數(shù)據(jù)綁定
????????????ddlxueli.Items.Clear();
????????????ddlxueli.Items.Add(new?ListItem("博士",?"1"));
????????????ddlxueli.Items.Add(new?ListItem("碩士",?"2"));
????????????ddlxueli.Items.Add(new?ListItem("學(xué)士",?"3"));
????????????//

????????????//??選中?DropDownList
????????????ddlxueli.SelectedValue?=?((HiddenField)e.Row.FindControl("HDFXueli")).Value;
????????????//
????????}
????}

????protected?void?GridView1_RowEditing(object?sender,?GridViewEditEventArgs?e)
????{
????????GridView1.EditIndex?=?e.NewEditIndex;
????????GridViewBind();
????}
????protected?void?GridView1_RowCancelingEdit(object?sender,?GridViewCancelEditEventArgs?e)
????{
????????GridView1.EditIndex?=?-1;
????????GridViewBind();
????}

????protected?void?GridView1_RowUpdating(object?sender,?GridViewUpdateEventArgs?e)
????{
????????string?id?=?GridView1.DataKeys[e.RowIndex].Values[0].ToString();
????????string?card?=?((TextBox)GridView1.Rows[e.RowIndex].FindControl("TBCard")).Text;
????????string?xueli?=?((DropDownList)GridView1.Rows[e.RowIndex].FindControl("DDLXueli")).SelectedValue;
????????string?price?=?((TextBox)GridView1.Rows[e.RowIndex].FindControl("TBPrice")).Text;

????????string?connStr?=?ConfigurationManager.ConnectionStrings["ConnString"].ConnectionString;
????????string?SqlStr?=?"update?test01?set?card='"?+?card?+?"',xueli='"?+?xueli?+?"',price='"?+?price?+?"'?where?id="?+?id;

????????try
????????{
????????????SqlConnection?conn?=?new?SqlConnection(connStr);
????????????if?(conn.State.ToString()?==?"Closed")?conn.Open();
????????????SqlCommand?comm?=?new?SqlCommand(SqlStr,?conn);
????????????comm.ExecuteNonQuery();
????????????comm.Dispose();
????????????if?(conn.State.ToString()?==?"Open")?conn.Close();

????????????GridView1.EditIndex?=?-1;
????????????GridViewBind();
????????}
????????catch?(Exception?ex)
????????{
????????????Response.Write("數(shù)據(jù)庫錯誤，錯誤原因："?+?ex.Message);
????????????Response.End();
????????}
????}

????protected?void?GridView1_RowDeleting(object?sender,?GridViewDeleteEventArgs?e)
????{
????????string?id?=?GridView1.DataKeys[e.RowIndex].Values[0].ToString();
????????string?connStr?=?ConfigurationManager.ConnectionStrings["ConnString"].ConnectionString;
????????string?SqlStr?=?"delete?from?test01?where?id="?+?id;

????????try
????????{
????????????SqlConnection?conn?=?new?SqlConnection(connStr);
????????????if?(conn.State.ToString()?==?"Closed")?conn.Open();
????????????SqlCommand?comm?=?new?SqlCommand(SqlStr,?conn);
????????????comm.ExecuteNonQuery();
????????????comm.Dispose();
????????????if?(conn.State.ToString()?==?"Open")?conn.Close();

????????????GridView1.EditIndex?=?-1;
????????????GridViewBind();
????????}
????????catch?(Exception?ex)
????????{
????????????Response.Write("數(shù)據(jù)庫錯誤，錯誤原因："?+?ex.Message);
????????????Response.End();
????????}
????}
}

sql server2000生成表代碼：

CREATE?TABLE?[dbo].[test01]?(
????[id]?[decimal](18,?0)?IDENTITY?(1,?1)?NOT?NULL?,
????[name]?[varchar]?(50)?COLLATE?Chinese_PRC_CI_AS?NULL?,
????[card]?[varchar]?(50)?COLLATE?Chinese_PRC_CI_AS?NULL?,
????[xueli]?[varchar]?(50)?COLLATE?Chinese_PRC_CI_AS?NULL?,
????[price]?[decimal](18,?0)?NULL?,
????[createdate]?[datetime]?NULL?
)?ON?[PRIMARY]
GO

ALTER?TABLE?[dbo].[test01]?ADD?
????CONSTRAINT?[DF_test01_createdate]?DEFAULT?(getdate())?FOR?[createdate],
????CONSTRAINT?[PK_test01]?PRIMARY?KEY??CLUSTERED?
????(
????????[id]
????)??ON?[PRIMARY]?
GO

?

總結(jié)

以上是生活随笔為你收集整理的GridView控件修改、删除示例（修改含有DropDownList控件）的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯，歡迎將生活随笔推薦給好友。

上一篇： GridView自定义分页导航
下一篇： Gridview][UpdateComm