Code1
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="GridViewUp.aspx.cs" Inherits="gridview_GridViewUp" %>2
3
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">4
<html xmlns="http://www.w3.org/1999/xhtml">5
<head runat="server">6
<title>无标题页</title>7
</head>8
<body>9
<form id="form1" runat="server">10
<div>11
<table cellpadding="0" cellspacing="0" border="0" width="80%" style="font-size: 11px">12
<tr>13
<td align="center">14
<asp:GridView ID="GridView1" runat="server" Width="100%" CellPadding="4" ForeColor="#333333"15
AutoGenerateColumns="False" AllowPaging="True" PageSize="12" OnRowCancelingEdit="GridView1_RowCancelingEdit"16
OnRowEditing="GridView1_RowEditing" OnRowUpdating="GridView1_RowUpdating" OnRowDeleting="GridView1_RowDeleting"17
DataKeyNames="id,name" OnPageIndexChanging="GridView1_PageIndexChanging" DataMember="card,price" OnRowDataBound="GridView1_RowDataBound" GridLines="None">18
<Columns>19
<asp:BoundField HeaderText="身份证号" DataField="card" Visible=false />20
<asp:BoundField HeaderText="编号" DataField="id" ReadOnly="True" />21
<asp:BoundField DataField="name" HeaderText="姓名" ReadOnly="True" />22
<asp:TemplateField HeaderText="身份证号">23
<ItemTemplate>24
<%# Eval("card") %>25
</ItemTemplate>26
<EditItemTemplate>27
<asp:TextBox ID="TBCard" Text='<%# Eval("card") %>' runat="server" Width="140px" />28
</EditItemTemplate>29
<ItemStyle Width="150px" />30
</asp:TemplateField>31
<asp:TemplateField HeaderText="学历">32
<ItemTemplate>33
<%# Eval("description")%>34
</ItemTemplate>35
<EditItemTemplate>36
<asp:HiddenField ID="HDFXueli" runat="server" Value='<%# Eval("xueli") %>' />37
<asp:DropDownList ID="DDLXueli" runat="server" Width="90px" />38
</EditItemTemplate>39
<ItemStyle Width="100px" />40
</asp:TemplateField>41
<asp:TemplateField HeaderText="价格">42
<ItemTemplate>43
<%# Eval("price") %>44
</ItemTemplate>45
<EditItemTemplate>46
<asp:TextBox ID="TBPrice" Text='<%# Eval("price") %>' runat="server" Width="90px" />47
</EditItemTemplate>48
<ItemStyle Width="100px" />49
</asp:TemplateField>50
<asp:BoundField HeaderText="建立时间" DataField="createdate" ReadOnly="True" />51
<asp:CommandField ShowDeleteButton="True" ShowEditButton="True" HeaderText="操作" />52
</Columns>53
<PagerSettings FirstPageText="" LastPageText="" NextPageText="" PreviousPageText="" />54
<RowStyle Height="20px" BackColor="#F7F6F3" ForeColor="#333333" />55
<FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />56
<EditRowStyle BackColor="#999999" />57
<SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />58
<PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />59
<HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />60
<AlternatingRowStyle BackColor="White" ForeColor="#284775" />61
</asp:GridView>62
</td>63
</tr>64
</table>65
</div>66
</form>67
</body>68
</html>69
70
GridViewUp.aspx.cs文件代码：71
using System;72
using System.Data;73
using System.Configuration;74
using System.Collections;75
using System.Web;76
using System.Web.Security;77
using System.Web.UI;78
using System.Web.UI.WebControls;79
using System.Web.UI.WebControls.WebParts;80
using System.Web.UI.HtmlControls;81
using System.Data.SqlClient;82
83
public partial class gridview_GridViewUp : System.Web.UI.Page84
{85
protected void Page_Load(object sender, EventArgs e)86
{87
if (!IsPostBack)88
{89
GridViewBind();90
}91
}92
93
protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)94
{95
GridView1.PageIndex = e.NewPageIndex;96
GridViewBind();97
}98
99
private void GridViewBind()100
{101
string connStr = ConfigurationManager.ConnectionStrings["ConnString"].ConnectionString;102
string SqlStr = "Select a.*,b.description FROM test01 a,xueli b where a.xueli=b.code and a.id<1000 and a.id>200";103
DataSet ds = new DataSet();104
105
try106
{107
SqlConnection conn = new SqlConnection(connStr);108
if (conn.State.ToString() == "Closed") conn.Open();109
SqlDataAdapter da = new SqlDataAdapter(SqlStr, conn);110
da.Fill(ds, "test01");111
if (conn.State.ToString() == "Open") conn.Close();112
113
GridView1.DataSource = ds.Tables[0].DefaultView;114
GridView1.DataBind();115
}116
catch (Exception ex)117
{118
Response.Write("数据库错误，错误原因：" + ex.Message);119
Response.End();120
}121
}122
123
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)124
{125
if (((DropDownList)e.Row.FindControl("DDLXueli")) != null)126
{ 127
DropDownList ddlxueli = (DropDownList)e.Row.FindControl("DDLXueli");128
129
// 生成 DropDownList 的值，绑定数据130
string connStr = ConfigurationManager.ConnectionStrings["ConnString"].ConnectionString;131
string SqlStr = "Select * from xueli";132
DataSet ds = new DataSet();133
134
SqlConnection conn = new SqlConnection(connStr);135
if (conn.State.ToString() == "Closed") conn.Open();136
SqlDataAdapter da = new SqlDataAdapter(SqlStr, conn);137
da.Fill(ds, "xueli");138
if (conn.State.ToString() == "Open") conn.Close();139
140
ddlxueli.DataSource = ds.Tables[0].DefaultView;141
ddlxueli.DataTextField = "description";142
ddlxueli.DataValueField = "code";143
ddlxueli.DataBind();144
//145
146
// 选中 DropDownList147
ddlxueli.SelectedValue = ((HiddenField)e.Row.FindControl("HDFXueli")).Value;148
//149
}150
}151
152
protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)153
{154
GridView1.EditIndex = e.NewEditIndex;155
GridViewBind();156
}157
protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)158
{159
GridView1.EditIndex = -1;160
GridViewBind();161
}162
163
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)164
{165
string id = GridView1.DataKeys[e.RowIndex].Values[0].ToString();166
string card = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("TBCard")).Text;167
string xueli = ((DropDownList)GridView1.Rows[e.RowIndex].FindControl("DDLXueli")).SelectedValue;168
string price = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("TBPrice")).Text;169
170
string connStr = ConfigurationManager.ConnectionStrings["ConnString"].ConnectionString;171
string SqlStr = "update test01 set card='" + card + "',xueli='" + xueli + "',price='" + price + "' where id=" + id;172
173
try174
{175
SqlConnection conn = new SqlConnection(connStr);176
if (conn.State.ToString() == "Closed") conn.Open();177
SqlCommand comm = new SqlCommand(SqlStr, conn);178
comm.ExecuteNonQuery();179
comm.Dispose();180
if (conn.State.ToString() == "Open") conn.Close();181
182
GridView1.EditIndex = -1;183
GridViewBind();184
}185
catch (Exception ex)186
{187
Response.Write("数据库错误，错误原因：" + ex.Message);188
Response.End();189
}190
}191
192
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)193
{194
string id = GridView1.DataKeys[e.RowIndex].Values[0].ToString();195
string connStr = ConfigurationManager.ConnectionStrings["ConnString"].ConnectionString;196
string SqlStr = "delete from test01 where id=" + id;197
198
try199
{200
SqlConnection conn = new SqlConnection(connStr);201
if (conn.State.ToString() == "Closed") conn.Open();202
SqlCommand comm = new SqlCommand(SqlStr, conn);203
comm.ExecuteNonQuery();204
comm.Dispose();205
if (conn.State.ToString() == "Open") conn.Close();206
207
GridView1.EditIndex = -1;208
GridViewBind();209
}210
catch (Exception ex)211
{212
Response.Write("数据库错误，错误原因：" + ex.Message);213
Response.End();214
}215
}216
}217
218
sql server2000生成表代码：219
Create TABLE [dbo].[test01] (220
[id] [decimal](18, 0) IDENTITY (1, 1) NOT NULL ,221
[name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,222
[card] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,223
[xueli] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,224
[price] [decimal](18, 0) NULL ,225
[createdate] [datetime] NULL 226
) ON [PRIMARY]227
GO228
229
Alter TABLE [dbo].[test01] ADD 230
CONSTRAINT [DF_test01_createdate] DEFAULT (getdate()) FOR [createdate],231
CONSTRAINT [PK_test01] PRIMARY KEY CLUSTERED 232
(233
[id]234
) ON [PRIMARY] 235
GO236
237
238
Create TABLE [dbo].[xueli](239
[id] [int] IDENTITY(1,1) NOT NULL,240
[code] [int] NULL,241
[description] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,242
CONSTRAINT [PK_xueli] PRIMARY KEY CLUSTERED 243
(244
[id] ASC245
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]246
) ON [PRIMARY] 247
浙公网安备 33010602011771号