代码如下:
<asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True"
AutoGenerateColumns="False" CssClass="table001" DataKeyNames="sortsid" DataSourceID="SqlDataSource1"
PageSize="20">
<Columns>
<asp:BoundField DataField="sortsid" HeaderText="序号" InsertVisible="False" ReadOnly="True"
SortExpression="sortsid" />
<asp:BoundField DataField="categoryid" HeaderText="类别" SortExpression="categoryid" />
<asp:BoundField DataField="webname" HeaderText="网站名称" SortExpression="webname" />
<asp:BoundField DataField="linkaddress" HeaderText="链接URL" SortExpression="linkaddress" />
<asp:BoundField DataField="linklogo" HeaderText="图片链接" SortExpression="linklogo" />
<asp:CheckBoxField DataField="sh" HeaderText="审核" SortExpression="sh" />
<asp:TemplateField HeaderText="排序号">
<EditItemTemplate>
<asp:TextBox ID="TextBox1" runat="server" Text='<%# Eval("sortsorder") %>'></asp:TextBox>
<asp:RegularExpressionValidator ID="RegularExpressionValidator1" runat="server" ControlToValidate="TextBox1"
Display="Dynamic" ErrorMessage="请使用数字" ValidationExpression="^[0-9]{1,}$"></asp:RegularExpressionValidator>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="Label1" runat="server" Text='<%# Eval("sortsorder") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:CommandField ShowDeleteButton="True" ShowEditButton="True" />
</Columns>
<RowStyle CssClass="table002" Height="20px" HorizontalAlign="Center" />
<HeaderStyle CssClass="table002" Height="20px" HorizontalAlign="Center" />
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:527ConnectionString %>"
DeleteCommand="DELETE FROM [sortslink] WHERE [sortsid] = @sortsid" InsertCommand="INSERT INTO [sortslink] ([categoryid], [webname], [linkaddress], [linklogo], [sortsintroduce], [sortsorder], [linktype], [sh], [addtime], [linkalt]) VALUES (@categoryid, @webname, @linkaddress, @linklogo, @sortsintroduce, @sortsorder, @linktype, @sh, @addtime, @linkalt)"
SelectCommand="SELECT * FROM [sortslink] ORDER BY [sortsorder] DESC" UpdateCommand="UPDATE [sortslink] SET [categoryid] = @categoryid, [webname] = @webname, [linkaddress] = @linkaddress, [linklogo] = @linklogo, [sortsintroduce] = @sortsintroduce, [sortsorder] =sortsorder, [sh] = @sh, [addtime] = @addtime, [linkalt] = @linkalt WHERE [sortsid] = @sortsid">
<DeleteParameters>
<asp:Parameter Name="sortsid" Type="Int32" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="categoryid" Type="Int32" />
<asp:Parameter Name="webname" Type="String" />
<asp:Parameter Name="linkaddress" Type="String" />
<asp:Parameter Name="linklogo" Type="String" />
<asp:Parameter Name="sortsintroduce" Type="String" />
<asp:Parameter Name="sortsorder" Type="Int32" Direction="Input"/>
<asp:Parameter Name="linktype" Type="Boolean" />
<asp:Parameter Name="sh" Type="Boolean" />
<asp:Parameter Name="addtime" Type="DateTime" />
<asp:Parameter Name="linkalt" Type="String" />
<asp:Parameter Name="sortsid" Type="Int32" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="categoryid" Type="Int32" />
<asp:Parameter Name="webname" Type="String" />
<asp:Parameter Name="linkaddress" Type="String" />
<asp:Parameter Name="linklogo" Type="String" />
<asp:Parameter Name="sortsintroduce" Type="String" />
<asp:Parameter Name="sortsorder" Type="Int32" />
<asp:Parameter Name="linktype" Type="Boolean" />
<asp:Parameter Name="sh" Type="Boolean" />
<asp:Parameter Name="addtime" Type="DateTime" />
<asp:Parameter Name="linkalt" Type="String" />
</InsertParameters>
</asp:SqlDataSource>这里我知道搞:
<asp:TemplateField HeaderText="排序号">
<EditItemTemplate>
<asp:TextBox ID="TextBox1" runat="server" Text='<%# Eval("sortsorder") %>'></asp:TextBox>
可是更新的时候值为空了.传不过去,怎么搞好呢?
<asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True"
AutoGenerateColumns="False" CssClass="table001" DataKeyNames="sortsid" DataSourceID="SqlDataSource1"
PageSize="20">
<Columns>
<asp:BoundField DataField="sortsid" HeaderText="序号" InsertVisible="False" ReadOnly="True"
SortExpression="sortsid" />
<asp:BoundField DataField="categoryid" HeaderText="类别" SortExpression="categoryid" />
<asp:BoundField DataField="webname" HeaderText="网站名称" SortExpression="webname" />
<asp:BoundField DataField="linkaddress" HeaderText="链接URL" SortExpression="linkaddress" />
<asp:BoundField DataField="linklogo" HeaderText="图片链接" SortExpression="linklogo" />
<asp:CheckBoxField DataField="sh" HeaderText="审核" SortExpression="sh" />
<asp:TemplateField HeaderText="排序号">
<EditItemTemplate>
<asp:TextBox ID="TextBox1" runat="server" Text='<%# Eval("sortsorder") %>'></asp:TextBox>
<asp:RegularExpressionValidator ID="RegularExpressionValidator1" runat="server" ControlToValidate="TextBox1"
Display="Dynamic" ErrorMessage="请使用数字" ValidationExpression="^[0-9]{1,}$"></asp:RegularExpressionValidator>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="Label1" runat="server" Text='<%# Eval("sortsorder") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:CommandField ShowDeleteButton="True" ShowEditButton="True" />
</Columns>
<RowStyle CssClass="table002" Height="20px" HorizontalAlign="Center" />
<HeaderStyle CssClass="table002" Height="20px" HorizontalAlign="Center" />
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:527ConnectionString %>"
DeleteCommand="DELETE FROM [sortslink] WHERE [sortsid] = @sortsid" InsertCommand="INSERT INTO [sortslink] ([categoryid], [webname], [linkaddress], [linklogo], [sortsintroduce], [sortsorder], [linktype], [sh], [addtime], [linkalt]) VALUES (@categoryid, @webname, @linkaddress, @linklogo, @sortsintroduce, @sortsorder, @linktype, @sh, @addtime, @linkalt)"
SelectCommand="SELECT * FROM [sortslink] ORDER BY [sortsorder] DESC" UpdateCommand="UPDATE [sortslink] SET [categoryid] = @categoryid, [webname] = @webname, [linkaddress] = @linkaddress, [linklogo] = @linklogo, [sortsintroduce] = @sortsintroduce, [sortsorder] =sortsorder, [sh] = @sh, [addtime] = @addtime, [linkalt] = @linkalt WHERE [sortsid] = @sortsid">
<DeleteParameters>
<asp:Parameter Name="sortsid" Type="Int32" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="categoryid" Type="Int32" />
<asp:Parameter Name="webname" Type="String" />
<asp:Parameter Name="linkaddress" Type="String" />
<asp:Parameter Name="linklogo" Type="String" />
<asp:Parameter Name="sortsintroduce" Type="String" />
<asp:Parameter Name="sortsorder" Type="Int32" Direction="Input"/>
<asp:Parameter Name="linktype" Type="Boolean" />
<asp:Parameter Name="sh" Type="Boolean" />
<asp:Parameter Name="addtime" Type="DateTime" />
<asp:Parameter Name="linkalt" Type="String" />
<asp:Parameter Name="sortsid" Type="Int32" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="categoryid" Type="Int32" />
<asp:Parameter Name="webname" Type="String" />
<asp:Parameter Name="linkaddress" Type="String" />
<asp:Parameter Name="linklogo" Type="String" />
<asp:Parameter Name="sortsintroduce" Type="String" />
<asp:Parameter Name="sortsorder" Type="Int32" />
<asp:Parameter Name="linktype" Type="Boolean" />
<asp:Parameter Name="sh" Type="Boolean" />
<asp:Parameter Name="addtime" Type="DateTime" />
<asp:Parameter Name="linkalt" Type="String" />
</InsertParameters>
</asp:SqlDataSource>这里我知道搞:
<asp:TemplateField HeaderText="排序号">
<EditItemTemplate>
<asp:TextBox ID="TextBox1" runat="server" Text='<%# Eval("sortsorder") %>'></asp:TextBox>
可是更新的时候值为空了.传不过去,怎么搞好呢?
这个应是:.<asp:Parameter Name="sortsorder" Type="Int32"/>
[sortsorder] =sortsorder这个就是:[sortsorder] =@sortsorder
这个写错了.不好意思.帮帮忙呀