GridView 不能更新数据 我用 sql server 2000,设好了 GridView 的数据源,并自动生成 insert,update,delete命令。没有加入任何代码。可是按更新按钮后不能保存,也没有提示。 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 下面是源码@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %><%@ Register Src="WebUserControl.ascx" TagName="WebUserControl" TagPrefix="uc1" %><!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>无标题页</title></head><body style="position: static"> <form id="form1" runat="server"> <br /> <br /> <asp:GridView ID="GridView1" runat="server" AllowSorting="True" AutoGenerateColumns="False" AutoGenerateDeleteButton="True" AutoGenerateEditButton="True" DataSourceID="SqlDataSource1" Width="386px"> <Columns> <asp:BoundField DataField="id" HeaderText="id" InsertVisible="False" ReadOnly="True" SortExpression="id" /> <asp:BoundField DataField="name" HeaderText="name" SortExpression="name" DataFormatString="{0:c}" /> <asp:BoundField DataField="path" HeaderText="path" SortExpression="path" ReadOnly="True" /> </Columns> </asp:GridView> <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:a1ConnectionString %>" DeleteCommand="DELETE FROM [TABLE1] WHERE [id] = @id" InsertCommand="INSERT INTO [TABLE1] ([name], [path]) VALUES (@name, @path)" SelectCommand="SELECT * FROM [TABLE1]" UpdateCommand="UPDATE [TABLE1] SET [name] = @name, [path] = @path WHERE [id] = @id" CancelSelectOnNullParameter="False" ProviderName="<%$ ConnectionStrings:a1ConnectionString.ProviderName %>"> <DeleteParameters> <asp:Parameter Name="id" Type="Int32" /> </DeleteParameters> <UpdateParameters> <asp:Parameter Name="name" Type="String" /> <asp:Parameter Name="path" Type="String" /> <asp:Parameter Name="id" Type="Int32" /> </UpdateParameters> <InsertParameters> <asp:Parameter Name="name" Type="String" /> <asp:Parameter Name="path" Type="String" /> </InsertParameters> </asp:SqlDataSource> </form></body></html> 下雪了,大雪分肥,10几年冒看到雪了!听说今年雪灾啊!不知道你是WINFORM 还是WEBFORM 递归问题,大家来看看为什么啊? 如何更改listview选中行行特定列的值 Bitmap 装换 byte[] 如何得到dataGridView网格内字符位置 帮忙推荐C#参考书 请教 winForm的DataGrid绑定DataTable,如何让DataGrid可以编辑行,但不能增加行 关于GUID,不能理解,谁来解释一下? 我想做一自动更新的程序,但如何让它一启动立即开始更新? 大家随便帮一下忙, C# 中如何写debug代码,如C++中 RichTextBox的拖放问题 C#菜单的问题 sqlserver 数据还原后还能不能恢复?
@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %><%@ Register Src="WebUserControl.ascx" TagName="WebUserControl" TagPrefix="uc1" %><!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>无标题页</title>
</head>
<body style="position: static">
<form id="form1" runat="server">
<br />
<br />
<asp:GridView ID="GridView1" runat="server" AllowSorting="True"
AutoGenerateColumns="False" AutoGenerateDeleteButton="True" AutoGenerateEditButton="True"
DataSourceID="SqlDataSource1" Width="386px">
<Columns>
<asp:BoundField DataField="id" HeaderText="id" InsertVisible="False" ReadOnly="True"
SortExpression="id" />
<asp:BoundField DataField="name" HeaderText="name" SortExpression="name" DataFormatString="{0:c}" />
<asp:BoundField DataField="path" HeaderText="path" SortExpression="path" ReadOnly="True" />
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:a1ConnectionString %>"
DeleteCommand="DELETE FROM [TABLE1] WHERE [id] = @id" InsertCommand="INSERT INTO [TABLE1] ([name], [path]) VALUES (@name, @path)"
SelectCommand="SELECT * FROM [TABLE1]" UpdateCommand="UPDATE [TABLE1] SET [name] = @name, [path] = @path WHERE [id] = @id" CancelSelectOnNullParameter="False" ProviderName="<%$ ConnectionStrings:a1ConnectionString.ProviderName %>">
<DeleteParameters>
<asp:Parameter Name="id" Type="Int32" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="name" Type="String" />
<asp:Parameter Name="path" Type="String" />
<asp:Parameter Name="id" Type="Int32" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="name" Type="String" />
<asp:Parameter Name="path" Type="String" />
</InsertParameters>
</asp:SqlDataSource>
</form>
</body>
</html>
不知道你是WINFORM 还是WEBFORM