通过带有存储过程的SqlDatasource在Gridview中更新数据的问题 [英] Problem in Update Data in Gridview via SqlDatasource with Store Procedure

查看：66
本文介绍了通过带有存储过程的SqlDatasource在Gridview中更新数据的问题的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

问题描述

我正在处理我的项目，并使用update / delte选项在网格视图上显示用户数据。删除操作工作正常，但是当我应用更新操作时，它会给出错误。存储过程过程或函数uspUpdateArticle指定的参数太多。



这是我的代码：

< pre lang =SQL> 创建 Proc uspUpdateArticle
@ArticleID int ， @ Title varchar （ 50 ）， @ Body varchar （ 1000 ），
@ Author varchar （ 50 ）， @ Categories varchar （ 30 ）， @ Updatedby int
作为
BEGIN
SET NOCOUNT ON ;
更新 TblArticles SET Title = @ Title ，Body = @ Body ，作者= @作者，Categories = @ Categories ，Updatedby = @ Updatedby WHERE ArticleID = @ ArticleID
END 





< asp：SqlDataSource ID =   SqlDataSource1 runat =   server ConnectionString =  <％$ ConnectionStrings：ECII（旧）ConnectionString％> SelectCommand =   uspGetArticles Dele teCommand =   uspDeleteArticle UpdateCommandType =   StoredProcedure UpdateCommand =   uspUpdateArticle SelectCommandType =   StoredProcedure DeleteCommandType =  < span class =code-string> StoredProcedure >  
< DeleteParameters> 
< asp：参数名称=   ArticleID Type =   Int32 /> 
 < /   DeleteParameters  >  
< SelectParameters> 
< asp：SessionParameter Name =   PublishedBy SessionField =   UserID Type =   Int32 /> 
< asp：SessionParameter Name =   SubcriptionId SessionField =   SubscripID Type =   Int32 /> 
 < /   SelectParameters  >  
< UpdateParameters> 
< asp：参数名称=  标题类型=   String /> 
< asp：参数名称=  正文类型=   String /> 
< asp：参数名称=  作者类型=   String /> 
< asp：参数名称=  类别类型=   String /> 
< asp：SessionParameter Name =  更新为 SessionField =   UserID Type =   Int32 /> 
< asp：参数名称=   ArticleID Type =   Int32 /> 
 < /   UpdateParameters  >  
 < /   asp：SqlDataSource   >  
< div style =   width：98％; height：500px; margin ：0 auto; margin-removed 10px; overflow：scroll; >  
 
< asp：GridView ID = < span class =code-string>  GridViewListallarticles runat =   server AutoGenerateColumns =   False BackColor =  白色 BorderColor =  ＃DEDFDE BorderStyle =  无 BorderWidth =   1px CellPadding =   4 DataKeyNames =   ArticleID DataSourceID =   SqlDataSource1 ForeColor =  黑色 GridLines =  垂直宽度=   200％ OnSelectedIndexChanged =   GridViewListallarticles_SelectedIndexChanged >  
< AlternatingRowStyle BackColor =  白色 /> 
< Columns> 
< asp：CommandField ShowDeleteButton =   True ShowEditButton =   True ButtonType =  按钮 /> 
< asp：BoundField DataField =   ArticleID HeaderText =   ArticleID InsertVisible =   False ReadOnly =   True SortExpression =   ArticleID /> 
 
< asp：TemplateField HeaderText =  标题 SortExpression =  标题 >  
< ; EditItemTemplate>< asp：TextBox ID =   tbtitle runat =   server Text = ' <％＃Bind（Title）％>' >  < /   asp：TextBox  >  
< asp：RequiredFieldValidator ID =   RequiredFieldValidatortitle Display =  无 runat =   se rver ControlToValidate =   tbtitle Text =   * ErrorMessage =  请输入文章标题 ForeColor =  红色字体名称=   Calibri >  < /   asp：RequiredFieldValidator  >  
< asp： RegularExpressionValidator ID =   RegularExpressionValidatortitle显示=  无 runat =   server ControlToValidate =   tbtitle ValidationExpression =   ^ [a-zA-Z' '-'\s] {20,50} $ ErrorMessage =  文章标题名称必须包含只有20-50个字符 Text =   *字体名称=   Calibri字体大小=  小 ForeColor =  红色 >  < /   asp：RegularExpressionValidator< / EditItemTemplate  < span class =code-keyword>>  
< ItemTemplate> 
< asp：标签ID =   Label1 runat =   server Text = ' <％＃Bind（Title）％>' >  < /   asp：标签 >  < /   ItemTemplate  >  
 < /   asp：TemplateField  >  
 
 
 < asp：TemplateField HeaderText =   Body SortExpression =    Body>< EditItemTemplate> 
< asp：TextBox ID =   tbbody runat =   server Text = ' <％＃Bind（Body）％>' >  < /   asp：TextBox  >  
< asp：RequiredFieldValidator ID =   RequiredFieldValidatorbody显示=  无 runat =   server ControlToValidate =   tbbody Text =   * ErrorMessage =  请输入Artic le Title ForeColor =   Red Font-Names =   Calibri >  < /   asp：RequiredFieldValidator  >  
< asp：RegularExpressionValidator ID =   RegularExpressionValidatorbody显示=  无 runat =   server ControlToValidate =   tbbody ValidationExpression =  < span class =code-string> ^。{50,500} $ ErrorMessage =  文章正文名称必须只包含50-500个字符 Text =   *字体名称=   Calibri字体大小=  小 ForeColor =  红色 >  < /   asp：RegularExpressionValidator  >  < /   EditItemTemplate  >  
< ItemTemplate>< asp：Label ID =   Label2 runat =   server Text = ' <％＃Bind（Body）％>' >  < /   asp：标签 >  
 < /   ItemTemplate  >  < /   asp：TemplateField  >  
 
< asp：TemplateField HeaderText =  作者 SortExpression =  作者 >  
< EditItemTemplate> 
< asp：TextBox ID =   tbauthor runat =   server Text = ' <％＃Bind（作者）％>' >  < /   asp：TextBox  >  
< asp：RequiredFieldValidator ID =   RequiredFieldValidatorauthor显示=  无 runat =   server ControlToValidate =   tbauthor Text =   * ErrorMessage =  请Inp ut作者名称 ForeColor =  红色字体名称=   Calibri >  < /   asp：RequiredFieldValidator  >  
< asp： RegularExpressionValidator ID =   RegularExpressionValidatorauthor Display =  无 runat =   server ControlToValidate =   tbauthor ValidationExpression =   ^ [a-zA-Z'' - '\ s] {10,50} $ ErrorMessage =  作者姓名必须仅包含1-50字符 Text =   *字体名称=   Calibri字体大小=  小 ForeColor =  红色 >  < /   asp：RegularExpressionValidator  >  < /   EditItemTemplate   >  
< ItemTemplate> < asp：Label ID =   Label3 runat =    server Text = ' < ％＃Bind（作者）％>' >  < /  < span class =code-leadattribute> asp：Label  >  < /  < span class =code-leadattribute> ItemTemplate  >  < /   asp：TemplateField  >  
 
< asp：TemplateField HeaderText =   Categories SortExpression =  类别 >  
< EditItemTemplate> 
< asp：TextBox ID =   tbcategory runat =   server Text = ' <％＃Bind（Categories）％>' >  < /   asp：TextBox  >  
< asp：RequiredFieldValidator ID =   RequiredFieldValidatorcategory显示=  无 runat =   server ControlToValidate =   tbcategory Text =   * ErrorMessage =  请输入文章类别 ForeColor =  红色字体名称=   Calibri >  < /   asp：RequiredFieldValidator  >  < /   EditItemTemplate  >  
< ItemTemplate>< ; asp：标签ID =   Label4 runat =    server Text = ' <％ #Bind（Categories）％>' >  < /   asp：Label< / ItemTemplate  >  < /   asp：TemplateField  >  
 
< asp：BoundField DataField =   PublishedOn HeaderText =   PublishedOn SortExpression =   PublishedOn /> 
< asp：BoundField DataField =   PublishedBy HeaderText =   PublishedBy SortExpression =  已发布 /> 
< asp：BoundField DataField =   UpdatedOn HeaderText =   UpdatedOn SortExpression =   UpdatedOn /> 
< asp：BoundField DataField =  更新 HeaderText =  更新 SortExpression =  更新 /> 
< asp：BoundField DataField =   countlikes HeaderText =   countlikes SortExpression =   countlikes /> 
< asp：BoundField DataField =   SubcriptionId HeaderText =   SubcriptionId SortExpression =   SubcriptionId /> 
 < /  列 >  
< FooterStyle BackColor =  ＃CCCC99 /> 
< HeaderStyle BackColor =  ＃6B696B Font-Bold =   True ForeColor =  白色 /> 
< PagerStyle BackColor =  ＃F7F7DE ForeColor =  黑色 Horizo​​ntalAlign =  右 /> 
< RowStyle BackColor =  ＃F7F7DE /> 
< SelectedRowStyle BackColor =  ＃CE5D5A Font-Bold =   True ForeColor =  白色 /> 
< SortedAscendingCellStyle BackColor =  ＃FBFBF2 /> 
< SortedAscendingHeaderStyle BackColor =  ＃848384 /> 
< SortedDescendingCellStyle BackColor =  ＃EAEAD3 /> 
< SortedDescendingHeaderStyle BackColor =  ＃575357 /> 
 < /   asp：GridView  >  < /   div  >  
< asp：ValidationSummary ID =   ValidationSummary1 runat =   server Font-Names =   Calibri字体大小=  小 HeaderText = < span class =code-string> 无效输入 ShowMessageBox =   True ShowSummary =   False />

解决方案

ConnectionStrings：ECII（旧）ConnectionStri ng％> SelectCommand = uspGetArticles DeleteCommand = uspDeleteArticle UpdateCommandType = StoredProcedure UpdateCommand = uspUpdateArticle SelectCommandType = StoredProcedure DeleteCommandType = StoredProcedure >
< DeleteParameters>
< asp：参数名称= ArticleID Type = Int32 />
< / DeleteParameters >
< SelectParameters>
< asp：SessionParameter Name = PublishedBy SessionField = UserID Type = Int32 />
< asp：SessionParameter Name = SubcriptionId SessionField = SubscripID Type = Int32 />
< / SelectParameters >
< UpdateParameters>
< asp：参数名称= 标题类型= String />
< asp：参数名称= 正文类型= String />
< asp：参数名称= 作者类型= String />
< asp：参数名称= 类别类型= String />
< asp：SessionParameter Name = 更新为 SessionField = UserID Type = Int32 />
< asp：参数名称= ArticleID Type = Int32 />
< / UpdateParameters >
< / asp：SqlDataSource >
< div style = width：98％; height：500px; margin ：0 auto; margin-removed 10px; overflow：scroll; >

< asp：GridView ID = < span class =code-string> GridViewListallarticles runat = server AutoGenerateColumns = False BackColor = 白色 BorderColor = ＃DEDFDE BorderStyle = 无 BorderWidth = 1px CellPadding = 4 DataKeyNames = ArticleID DataSourceID = SqlDataSource1 ForeColor = 黑色 GridLines = \"Vertical\" Width=\"200%\" OnSelectedIndexChanged=\"GridViewListallarticles_SelectedIndexChanged\">
<AlternatingRowStyle BackColor=\"White\" />
< Columns>
<asp:CommandField ShowDeleteButton=\"True\" ShowEditButton=\"True\" ButtonType=\"Button\" />
<asp:BoundField DataField=\"ArticleID\" HeaderText=\"ArticleID\" InsertVisible=\"False\" ReadOnly=\"True\" SortExpression=\"ArticleID\" />

<asp:TemplateField HeaderText=\"Title\" SortExpression=\"Title\">
<EditItemTemplate><asp:TextBox ID=\"tbtitle\" runat=\"server\" Text='<%# Bind(\"Title\") %>'></asp:TextBox>
<asp:RequiredFieldValidator ID=\"RequiredFieldValidatortitle\" Display=\"None\" runat=\"se rver\" ControlToValidate=\"tbtitle\" Text=\"*\" ErrorMessage=\"Please Input Article Title\" ForeColor=\"Red\" Font-Names=\"Calibri\"></asp:RequiredFieldValidator>
<asp:RegularExpressionValidator ID=\"RegularExpressionValidatortitle\" Display=\"None\" runat=\"server\" ControlToValidate=\"tbtitle\" ValidationExpression=\"^[a-zA-Z''-'\s]{20,50}


\" ErrorMessage=\"Article Title Name Must Contain Only 20-50 Characters\" Text=\"*\" Font-Names=\"Calibri\" Font-Size=\"Small\" ForeColor=\"Red\"></asp:RegularExpressionValidator</EditItemTemplate>
<ItemTemplate>
<asp:Label ID=\"Label1\" runat=\"server\" Text='<%# Bind(\"Title\") %>'></asp:Label></ItemTemplate>
</asp:TemplateField>


<asp:TemplateField HeaderText=\"Body\" SortExpression=\"Body\"><EditItemTemplate>
<asp:TextBox ID=\"tbbody\" runat=\"server\" Text='<%# Bind(\"Body\") %>'></asp:TextBox>
<asp:RequiredFieldValidator ID=\"RequiredFieldValidatorbody\" Display=\"None\" runat=\"server\" ControlToValidate=\"tbbody\" Text=\"*\" ErrorMessage=\"Please Input Artic le Title\" ForeColor=\"Red\" Font-Names=\"Calibri\"></asp:RequiredFieldValidator>
<asp:RegularExpressionValidator ID=\"RegularExpressionValidatorbody\" Display=\"None\" runat=\"server\" ControlToValidate=\"tbbody\" ValidationExpression=\"^.{50,500}


\" ErrorMessage=\"Article Body Name Must Contain On ly 50-500 Characters\" Text=\"*\" Font-Names=\"Calibri\" Font-Size=\"Small\" ForeColor=\"Red\"></asp:RegularExpressionValidator></EditItemTemplate>
<ItemTemplate><asp:Label ID=\"Label2\" runat=\"server\" Text='<%# Bind(\"Body\") %>'&g t;</asp:Label>
</ItemTemplate></asp:TemplateField>

<asp:TemplateField HeaderText=\"Author\" SortExpression=\"Author\">
<EditItemTemplate>
<asp:TextBox ID=\"tbauthor\" runat=\"server\" Text='<%# Bind(\"Author\") %>'></asp:TextBox>
<asp:RequiredFieldValidator ID=\"RequiredFieldValidatorauthor\" Display=\"None\" runat=\"server\" ControlToValidate=\"tbauthor\" Text=\"*\" ErrorMessage=\"Please Inp ut Author Name\" ForeColor=\"Red\" Font-Names=\"Calibri\"></asp:RequiredFieldValidator>
<asp:RegularExpressionValidator ID=\"RegularExpressionValidatorauthor\" Display=\"None\" runat=\"server\" ControlToValidate=\"tbauthor\" ValidationExpression=\"^[a-zA-Z''-'\s]{10,50}


I have working on my project and shows user data on grid view with update/delte option. the delete operation work fine, but when i apply update operation it gives error. that store procedure Procedure or function uspUpdateArticle has too many arguments specified.

Here is my Code:

Create Proc uspUpdateArticle
@ArticleID int, @Title varchar(50), @Body varchar(1000),
@Author varchar(50), @Categories varchar(30), @Updatedby int
As
BEGIN
SET NOCOUNT ON;
UPDATE TblArticles SET Title = @Title, Body = @Body, Author = @Author, Categories = @Categories, Updatedby = @Updatedby WHERE ArticleID = @ArticleID
END



  <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ECII(Old)ConnectionString %>" SelectCommand="uspGetArticles" DeleteCommand="uspDeleteArticle"  UpdateCommandType="StoredProcedure" UpdateCommand="uspUpdateArticle" SelectCommandType="StoredProcedure" DeleteCommandType="StoredProcedure">
            <DeleteParameters>
                <asp:Parameter Name="ArticleID" Type="Int32" />
            </DeleteParameters>
            <SelectParameters>
                <asp:SessionParameter Name="PublishedBy" SessionField="UserID" Type="Int32" />
                <asp:SessionParameter Name="SubcriptionId" SessionField="SubscripID" Type="Int32" />
            </SelectParameters>
            <UpdateParameters>
                <asp:Parameter Name="Title" Type="String" />
                <asp:Parameter Name="Body" Type="String" />
                <asp:Parameter Name="Author" Type="String" />
                <asp:Parameter Name="Categories" Type="String" />
                <asp:SessionParameter Name="Updatedby" SessionField="UserID" Type="Int32" />
                <asp:Parameter Name="ArticleID" Type="Int32" />
            </UpdateParameters>
        </asp:SqlDataSource>
        <div style="width: 98%; height: 500px; margin: 0 auto; margin-removed 10px; overflow: scroll;">

<asp:GridView ID="GridViewListallarticles" runat="server" AutoGenerateColumns="False" BackColor="White" BorderColor="#DEDFDE" BorderStyle="None" BorderWidth="1px" CellPadding="4" DataKeyNames="ArticleID" DataSourceID="SqlDataSource1" ForeColor="Black" GridLines="Vertical" Width="200%" OnSelectedIndexChanged="GridViewListallarticles_SelectedIndexChanged">
                <AlternatingRowStyle BackColor="White" />
                <Columns>
<asp:CommandField ShowDeleteButton="True" ShowEditButton="True" ButtonType="Button" />
<asp:BoundField DataField="ArticleID" HeaderText="ArticleID" InsertVisible="False" ReadOnly="True" SortExpression="ArticleID" />

<asp:TemplateField HeaderText="Title" SortExpression="Title">
<EditItemTemplate><asp:TextBox ID="tbtitle" runat="server" Text='<%# Bind("Title") %>'></asp:TextBox>
<asp:RequiredFieldValidator ID="RequiredFieldValidatortitle" Display="None" runat="server" ControlToValidate="tbtitle" Text="*" ErrorMessage="Please Input Article Title" ForeColor="Red" Font-Names="Calibri"></asp:RequiredFieldValidator>
<asp:RegularExpressionValidator ID="RegularExpressionValidatortitle" Display="None" runat="server" ControlToValidate="tbtitle" ValidationExpression="^[a-zA-Z''-'\s]{20,50}$" ErrorMessage="Article Title Name Must Contain Only 20-50 Characters" Text="*" Font-Names="Calibri" Font-Size="Small" ForeColor="Red"></asp:RegularExpressionValidator</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="Label1" runat="server" Text='<%# Bind("Title") %>'></asp:Label></ItemTemplate>
</asp:TemplateField>


<asp:TemplateField HeaderText="Body" SortExpression="Body"><EditItemTemplate>
<asp:TextBox ID="tbbody" runat="server" Text='<%# Bind("Body") %>'></asp:TextBox>
<asp:RequiredFieldValidator ID="RequiredFieldValidatorbody" Display="None" runat="server" ControlToValidate="tbbody" Text="*" ErrorMessage="Please Input Article Title" ForeColor="Red" Font-Names="Calibri"></asp:RequiredFieldValidator>
<asp:RegularExpressionValidator ID="RegularExpressionValidatorbody" Display="None" runat="server" ControlToValidate="tbbody" ValidationExpression="^.{50,500}$" ErrorMessage="Article Body Name Must Contain Only 50-500 Characters" Text="*" Font-Names="Calibri" Font-Size="Small" ForeColor="Red"></asp:RegularExpressionValidator></EditItemTemplate>
<ItemTemplate><asp:Label ID="Label2" runat="server" Text='<%# Bind("Body") %>'></asp:Label>
</ItemTemplate></asp:TemplateField>

<asp:TemplateField HeaderText="Author" SortExpression="Author">
<EditItemTemplate>
<asp:TextBox ID="tbauthor" runat="server" Text='<%# Bind("Author") %>'></asp:TextBox>
<asp:RequiredFieldValidator ID="RequiredFieldValidatorauthor" Display="None" runat="server" ControlToValidate="tbauthor" Text="*" ErrorMessage="Please Input Author Name" ForeColor="Red" Font-Names="Calibri"></asp:RequiredFieldValidator>
<asp:RegularExpressionValidator ID="RegularExpressionValidatorauthor" Display="None" runat="server" ControlToValidate="tbauthor" ValidationExpression="^[a-zA-Z''-'\s]{10,50}$" ErrorMessage="Author Name Must Contain Only 1-50 Characters" Text="*" Font-Names="Calibri" Font-Size="Small" ForeColor="Red"></asp:RegularExpressionValidator></EditItemTemplate>
<ItemTemplate> <asp:Label ID="Label3" runat="server" Text='<%# Bind("Author") %>'></asp:Label></ItemTemplate></asp:TemplateField>

<asp:TemplateField HeaderText="Categories" SortExpression="Categories">
<EditItemTemplate>
<asp:TextBox ID="tbcategory" runat="server" Text='<%# Bind("Categories") %>'></asp:TextBox>
<asp:RequiredFieldValidator ID="RequiredFieldValidatorcategory" Display="None" runat="server" ControlToValidate="tbcategory" Text="*" ErrorMessage="Please Input Article Category" ForeColor="Red" Font-Names="Calibri"></asp:RequiredFieldValidator></EditItemTemplate>
<ItemTemplate><asp:Label ID="Label4" runat="server" Text='<%# Bind("Categories") %>'></asp:Label</ItemTemplate></asp:TemplateField>

<asp:BoundField DataField="PublishedOn" HeaderText="PublishedOn" SortExpression="PublishedOn" />
<asp:BoundField DataField="PublishedBy" HeaderText="PublishedBy" SortExpression="PublishedBy" />
<asp:BoundField DataField="UpdatedOn" HeaderText="UpdatedOn" SortExpression="UpdatedOn" />
<asp:BoundField DataField="Updatedby" HeaderText="Updatedby" SortExpression="Updatedby" />
<asp:BoundField DataField="countlikes" HeaderText="countlikes" SortExpression="countlikes" />
<asp:BoundField DataField="SubcriptionId" HeaderText="SubcriptionId" SortExpression="SubcriptionId" />
</Columns>
<FooterStyle BackColor="#CCCC99" />
<HeaderStyle BackColor="#6B696B" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="#F7F7DE" ForeColor="Black" HorizontalAlign="Right" />
<RowStyle BackColor="#F7F7DE" />
<SelectedRowStyle BackColor="#CE5D5A" Font-Bold="True" ForeColor="White" />
<SortedAscendingCellStyle BackColor="#FBFBF2" />
<SortedAscendingHeaderStyle BackColor="#848384" />
<SortedDescendingCellStyle BackColor="#EAEAD3" />
<SortedDescendingHeaderStyle BackColor="#575357" />
</asp:GridView></div>
<asp:ValidationSummary ID="ValidationSummary1" runat="server" Font-Names="Calibri" Font-Size="Small" HeaderText="Invalid Input" ShowMessageBox="True" ShowSummary="False" />

解决方案

ConnectionStrings:ECII(Old)ConnectionString %>" SelectCommand="uspGetArticles" DeleteCommand="uspDeleteArticle" UpdateCommandType="StoredProcedure" UpdateCommand="uspUpdateArticle" SelectCommandType="StoredProcedure" DeleteCommandType="StoredProcedure"> <DeleteParameters> <asp:Parameter Name="ArticleID" Type="Int32" /> </DeleteParameters> <SelectParameters> <asp:SessionParameter Name="PublishedBy" SessionField="UserID" Type="Int32" /> <asp:SessionParameter Name="SubcriptionId" SessionField="SubscripID" Type="Int32" /> </SelectParameters> <UpdateParameters> <asp:Parameter Name="Title" Type="String" /> <asp:Parameter Name="Body" Type="String" /> <asp:Parameter Name="Author" Type="String" /> <asp:Parameter Name="Categories" Type="String" /> <asp:SessionParameter Name="Updatedby" SessionField="UserID" Type="Int32" /> <asp:Parameter Name="ArticleID" Type="Int32" /> </UpdateParameters> </asp:SqlDataSource> <div style="width: 98%; height: 500px; margin: 0 auto; margin-removed 10px; overflow: scroll;"> <asp:GridView ID="GridViewListallarticles" runat="server" AutoGenerateColumns="False" BackColor="White" BorderColor="#DEDFDE" BorderStyle="None" BorderWidth="1px" CellPadding="4" DataKeyNames="ArticleID" DataSourceID="SqlDataSource1" ForeColor="Black" GridLines="Vertical" Width="200%" OnSelectedIndexChanged="GridViewListallarticles_SelectedIndexChanged"> <AlternatingRowStyle BackColor="White" /> <Columns> <asp:CommandField ShowDeleteButton="True" ShowEditButton="True" ButtonType="Button" /> <asp:BoundField DataField="ArticleID" HeaderText="ArticleID" InsertVisible="False" ReadOnly="True" SortExpression="ArticleID" /> <asp:TemplateField HeaderText="Title" SortExpression="Title"> <EditItemTemplate><asp:TextBox ID="tbtitle" runat="server" Text='<%# Bind("Title") %>'></asp:TextBox> <asp:RequiredFieldValidator ID="RequiredFieldValidatortitle" Display="None" runat="server" ControlToValidate="tbtitle" Text="*" ErrorMessage="Please Input Article Title" ForeColor="Red" Font-Names="Calibri"></asp:RequiredFieldValidator> <asp:RegularExpressionValidator ID="RegularExpressionValidatortitle" Display="None" runat="server" ControlToValidate="tbtitle" ValidationExpression="^[a-zA-Z''-'\s]{20,50}


" ErrorMessage="Article Title Name Must Contain Only 20-50 Characters" Text="*" Font-Names="Calibri" Font-Size="Small" ForeColor="Red"></asp:RegularExpressionValidator</EditItemTemplate> <ItemTemplate> <asp:Label ID="Label1" runat="server" Text='<%# Bind("Title") %>'></asp:Label></ItemTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="Body" SortExpression="Body"><EditItemTemplate> <asp:TextBox ID="tbbody" runat="server" Text='<%# Bind("Body") %>'></asp:TextBox> <asp:RequiredFieldValidator ID="RequiredFieldValidatorbody" Display="None" runat="server" ControlToValidate="tbbody" Text="*" ErrorMessage="Please Input Article Title" ForeColor="Red" Font-Names="Calibri"></asp:RequiredFieldValidator> <asp:RegularExpressionValidator ID="RegularExpressionValidatorbody" Display="None" runat="server" ControlToValidate="tbbody" ValidationExpression="^.{50,500}


" ErrorMessage="Article Body Name Must Contain Only 50-500 Characters" Text="*" Font-Names="Calibri" Font-Size="Small" ForeColor="Red"></asp:RegularExpressionValidator></EditItemTemplate> <ItemTemplate><asp:Label ID="Label2" runat="server" Text='<%# Bind("Body") %>'></asp:Label> </ItemTemplate></asp:TemplateField> <asp:TemplateField HeaderText="Author" SortExpression="Author"> <EditItemTemplate> <asp:TextBox ID="tbauthor" runat="server" Text='<%# Bind("Author") %>'></asp:TextBox> <asp:RequiredFieldValidator ID="RequiredFieldValidatorauthor" Display="None" runat="server" ControlToValidate="tbauthor" Text="*" ErrorMessage="Please Input Author Name" ForeColor="Red" Font-Names="Calibri"></asp:RequiredFieldValidator> <asp:RegularExpressionValidator ID="RegularExpressionValidatorauthor" Display="None" runat="server" ControlToValidate="tbauthor" ValidationExpression="^[a-zA-Z''-'\s]{10,50}


这篇关于通过带有存储过程的SqlDatasource在Gridview中更新数据的问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！

查看全文
相关文章
其他开发语言最新文章
热门教程
热门工具
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆