验证GridView控件在编辑状态下输入的数据是否合法（不合法，不允许更新，同时弹出提示框）
ReadOnly="true"，表示该列不能被编辑
页面设计：
<table style="border:solid 1px green;width:40%">
<tr>
<td style="background-color:Green"><strong><span style="font-size: 14pt; color: #ffffff">验证GridView控件中编辑列的值</span></strong>
</td>
</tr>
<tr>
<td>
<asp:GridView Width="100%" ID="GridView1" runat="server" AutoGenerateColumns="False" CellPadding="4" ForeColor="#333333" GridLines="None" OnRowCancelingEdit="GridView1_RowCancelingEdit" OnRowDataBound="GridView1_RowDataBound" OnRowEditing="GridView1_RowEditing" OnRowUpdating="GridView1_RowUpdating" DataKeyNames="ProductID">
<Columns>
<asp:BoundField DataField="ProductName" ReadOnly="True" HeaderText="商品名称"/>
<asp:TemplateField>
<HeaderTemplate>
<table width="100%">
<tr>
<td align="left" width="60%" >数量</td>
</tr>
</table>
</HeaderTemplate>
<ItemTemplate>
<table width="100%">
<tr>
<td width="20%"><%# Eval("UnitsInStock")%></td>
</tr>
</table>
</ItemTemplate>
<EditItemTemplate>
<table>
<tr>
<td width="20%"><asp:TextBox runat="Server" ID="t1" Text='<%# Eval("UnitsInStock")%>' Width="90%"></asp:TextBox></td>
</tr>
</table>
</EditItemTemplate>
</asp:TemplateField>
<asp:CommandField ShowEditButton="True" HeaderText="操作" />
</Columns>
<FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
<RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
<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" />
</asp:GridView>
</td>
</tr>
</table>
后台代码：
“编辑”事件处理代码：
protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
{
this.GridView1.EditIndex = -1; // 获取编辑行的索引值
band(); // 会绑数据
}
当用户进入编辑状态，在文本框中输入内容后，“更新”，会触发 RowDataBound事件进行校验用户输入的数据，代码如下：
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if ((e.Row.RowState & DataControlRowState.Edit)==DataControlRowState.Edit)
{
RequiredFieldValidator re = new RequiredFieldValidator(); // 创建一个非空验证控件
re.ControlToValidate = "t1";
re.ErrorMessage = "销售量不能为空";
re.Display = ValidatorDisplay.Dynamic;
re.Text = "*";
e.Row.Cells[1].Controls.Add(re); // 将该空间添加到GridView控件中
RangeValidator ra = new RangeValidator();
ra.ControlToValidate = "t1";
ra.Type = ValidationDataType.Integer;
ra.Display = ValidatorDisplay.Dynamic;
ra.MaximumValue = "200";
ra.MinimumValue = "10";
ra.Text = "*";
ra.ErrorMessage = "销售量的范围为10-200";
e.Row.Cells[1].Controls.Add(ra);
ValidationSummary va = new ValidationSummary(); // 创建一个范围验证控件
va.ShowSummary = false;
va.ShowMessageBox = true;
e.Row.Cells[1].Controls.Add(va); // 添加到GridView中
}
}
验证无误后，触发 RowUpdating 事件，代码如下：
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["val"].ConnectionString);
con.Open();
string aa = this.GridView1.DataKeys[e.RowIndex].Value.ToString();
string bb = ((TextBox)this.GridView1.Rows[e.RowIndex].Cells[0].FindControl("t1")).Text.ToString();
string cc = "update products set UnitsInStock='" + bb + "' where ProductID='" + aa +"'";
SqlCommand cmd = new SqlCommand(cc, con);
cmd.ExecuteNonQuery();
con.Close();
this.GridView1.EditIndex = -1;
band();
Response.Write("<script>alert('更新成功！')</script>");
}
