<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConflictDetection="CompareAllValues"
ConnectionString="<%$ ConnectionStrings:ConnectionString %>" DeleteCommand="DELETE FROM [Customer] WHERE [id] = @original_id AND [Date] = @original_Date AND [CustomerName] = @original_CustomerName AND [CustomerID] = @original_CustomerID AND [RName] = @original_RName AND [Love] = @original_Love AND [Birthday] = @original_Birthday AND [ZRname] = @original_ZRname AND [CustomerType] = @original_CustomerType AND [Dname] = @original_Dname AND [fengxian] = @original_fengxian AND [jiaoyi] = @original_jiaoyi AND [caozuo] = @original_caozuo AND [touzi] = @original_touzi AND [xiwang] = @original_xiwang AND [lianxi] = @original_lianxi AND [Time] = @original_Time AND [yuji] = @original_yuji AND [yijian] = @original_yijian"
InsertCommand="INSERT INTO [Customer] ([Date], [CustomerName], [CustomerID], [RName], [Love], [Birthday], [ZRname], [CustomerType], [Dname], [fengxian], [jiaoyi], [caozuo], [touzi], [xiwang], [lianxi], [Time], [yuji], [yijian]) VALUES (@Date, @CustomerName, @CustomerID, @RName, @Love, @Birthday, @ZRname, @CustomerType, @Dname, @fengxian, @jiaoyi, @caozuo, @touzi, @xiwang, @lianxi, @Time, @yuji, @yijian)"
OldValuesParameterFormatString="original_{0}" SelectCommand="SELECT * FROM [Customer] WHERE ([CustomerID] = @CustomerID) ORDER BY [Date] DESC, [id] DESC"
UpdateCommand="UPDATE [Customer] SET [Date] = @Date, [CustomerName] = @CustomerName, [CustomerID] = @CustomerID, [RName] = @RName, [Love] = @Love, [Birthday] = @Birthday, [ZRname] = @ZRname, [CustomerType] = @CustomerType, [Dname] = @Dname, [fengxian] = @fengxian, [jiaoyi] = @jiaoyi, [caozuo] = @caozuo, [touzi] = @touzi, [xiwang] = @xiwang, [lianxi] = @lianxi, [Time] = @Time, [yuji] = @yuji, [yijian] = @yijian WHERE [id] = @original_id AND [Date] = @original_Date AND [CustomerName] = @original_CustomerName AND [CustomerID] = @original_CustomerID AND [RName] = @original_RName AND [Love] = @original_Love AND [Birthday] = @original_Birthday AND [ZRname] = @original_ZRname AND [CustomerType] = @original_CustomerType AND [Dname] = @original_Dname AND [fengxian] = @original_fengxian AND [jiaoyi] = @original_jiaoyi AND [caozuo] = @original_caozuo AND [touzi] = @original_touzi AND [xiwang] = @original_xiwang AND [lianxi] = @original_lianxi AND [Time] = @original_Time AND [yuji] = @original_yuji AND [yijian] = @original_yijian">
<DeleteParameters>
<asp:Parameter Name="original_id" Type="Int32" />
<asp:Parameter Name="original_Date" Type="DateTime" />
<asp:Parameter Name="original_CustomerName" Type="String" />
<asp:Parameter Name="original_CustomerID" Type="String" />
<asp:Parameter Name="original_RName" Type="String" />
<asp:Parameter Name="original_Love" Type="String" />
<asp:Parameter Name="original_Birthday" Type="String" />
<asp:Parameter Name="original_ZRname" Type="String" />
<asp:Parameter Name="original_CustomerType" Type="String" />
<asp:Parameter Name="original_Dname" Type="String" />
<asp:Parameter Name="original_fengxian" Type="String" />
<asp:Parameter Name="original_jiaoyi" Type="String" />
<asp:Parameter Name="original_caozuo" Type="String" />
<asp:Parameter Name="original_touzi" Type="String" />
<asp:Parameter Name="original_xiwang" Type="String" />
<asp:Parameter Name="original_lianxi" Type="String" />
<asp:Parameter Name="original_Time" Type="String" />
<asp:Parameter Name="original_yuji" Type="String" />
<asp:Parameter Name="original_yijian" Type="String" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="Date" Type="DateTime" />
<asp:Parameter Name="CustomerName" Type="String" />
<asp:Parameter Name="CustomerID" Type="String" />
<asp:Parameter Name="RName" Type="String" />
<asp:Parameter Name="Love" Type="String" />
<asp:Parameter Name="Birthday" Type="String" />
<asp:Parameter Name="ZRname" Type="String" />
<asp:Parameter Name="CustomerType" Type="String" />
<asp:Parameter Name="Dname" Type="String" />
<asp:Parameter Name="fengxian" Type="String" />
<asp:Parameter Name="jiaoyi" Type="String" />
<asp:Parameter Name="caozuo" Type="String" />
<asp:Parameter Name="touzi" Type="String" />
<asp:Parameter Name="xiwang" Type="String" />
<asp:Parameter Name="lianxi" Type="String" />
<asp:Parameter Name="Time" Type="String" />
<asp:Parameter Name="yuji" Type="String" />
<asp:Parameter Name="yijian" Type="String" />
<asp:Parameter Name="original_id" Type="Int32" />
<asp:Parameter Name="original_Date" Type="DateTime" />
<asp:Parameter Name="original_CustomerName" Type="String" />
<asp:Parameter Name="original_CustomerID" Type="String" />
<asp:Parameter Name="original_RName" Type="String" />
<asp:Parameter Name="original_Love" Type="String" />
<asp:Parameter Name="original_Birthday" Type="String" />
<asp:Parameter Name="original_ZRname" Type="String" />
<asp:Parameter Name="original_CustomerType" Type="String" />
<asp:Parameter Name="original_Dname" Type="String" />
<asp:Parameter Name="original_fengxian" Type="String" />
<asp:Parameter Name="original_jiaoyi" Type="String" />
<asp:Parameter Name="original_caozuo" Type="String" />
<asp:Parameter Name="original_touzi" Type="String" />
<asp:Parameter Name="original_xiwang" Type="String" />
<asp:Parameter Name="original_lianxi" Type="String" />
<asp:Parameter Name="original_Time" Type="String" />
<asp:Parameter Name="original_yuji" Type="String" />
<asp:Parameter Name="original_yijian" Type="String" />
</UpdateParameters>
<SelectParameters>
<asp:ControlParameter ControlID="TextBox11" Name="CustomerID" PropertyName="Text"
Type="String" />
</SelectParameters>
<InsertParameters>
<asp:Parameter Name="Date" Type="DateTime" />
<asp:Parameter Name="CustomerName" Type="String" />
<asp:Parameter Name="CustomerID" Type="String" />
<asp:Parameter Name="RName" Type="String" />
<asp:Parameter Name="Love" Type="String" />
<asp:Parameter Name="Birthday" Type="String" />
<asp:Parameter Name="ZRname" Type="String" />
<asp:Parameter Name="CustomerType" Type="String" />
<asp:Parameter Name="Dname" Type="String" />
<asp:Parameter Name="fengxian" Type="String" />
<asp:Parameter Name="jiaoyi" Type="String" />
<asp:Parameter Name="caozuo" Type="String" />
<asp:Parameter Name="touzi" Type="String" />
<asp:Parameter Name="xiwang" Type="String" />
<asp:Parameter Name="lianxi" Type="String" />
<asp:Parameter Name="Time" Type="String" />
<asp:Parameter Name="yuji" Type="String" />
<asp:Parameter Name="yijian" Type="String" />
</InsertParameters>
</asp:SqlDataSource>
ConnectionString="<%$ ConnectionStrings:ConnectionString %>" DeleteCommand="DELETE FROM [Customer] WHERE [id] = @original_id AND [Date] = @original_Date AND [CustomerName] = @original_CustomerName AND [CustomerID] = @original_CustomerID AND [RName] = @original_RName AND [Love] = @original_Love AND [Birthday] = @original_Birthday AND [ZRname] = @original_ZRname AND [CustomerType] = @original_CustomerType AND [Dname] = @original_Dname AND [fengxian] = @original_fengxian AND [jiaoyi] = @original_jiaoyi AND [caozuo] = @original_caozuo AND [touzi] = @original_touzi AND [xiwang] = @original_xiwang AND [lianxi] = @original_lianxi AND [Time] = @original_Time AND [yuji] = @original_yuji AND [yijian] = @original_yijian"
InsertCommand="INSERT INTO [Customer] ([Date], [CustomerName], [CustomerID], [RName], [Love], [Birthday], [ZRname], [CustomerType], [Dname], [fengxian], [jiaoyi], [caozuo], [touzi], [xiwang], [lianxi], [Time], [yuji], [yijian]) VALUES (@Date, @CustomerName, @CustomerID, @RName, @Love, @Birthday, @ZRname, @CustomerType, @Dname, @fengxian, @jiaoyi, @caozuo, @touzi, @xiwang, @lianxi, @Time, @yuji, @yijian)"
OldValuesParameterFormatString="original_{0}" SelectCommand="SELECT * FROM [Customer] WHERE ([CustomerID] = @CustomerID) ORDER BY [Date] DESC, [id] DESC"
UpdateCommand="UPDATE [Customer] SET [Date] = @Date, [CustomerName] = @CustomerName, [CustomerID] = @CustomerID, [RName] = @RName, [Love] = @Love, [Birthday] = @Birthday, [ZRname] = @ZRname, [CustomerType] = @CustomerType, [Dname] = @Dname, [fengxian] = @fengxian, [jiaoyi] = @jiaoyi, [caozuo] = @caozuo, [touzi] = @touzi, [xiwang] = @xiwang, [lianxi] = @lianxi, [Time] = @Time, [yuji] = @yuji, [yijian] = @yijian WHERE [id] = @original_id AND [Date] = @original_Date AND [CustomerName] = @original_CustomerName AND [CustomerID] = @original_CustomerID AND [RName] = @original_RName AND [Love] = @original_Love AND [Birthday] = @original_Birthday AND [ZRname] = @original_ZRname AND [CustomerType] = @original_CustomerType AND [Dname] = @original_Dname AND [fengxian] = @original_fengxian AND [jiaoyi] = @original_jiaoyi AND [caozuo] = @original_caozuo AND [touzi] = @original_touzi AND [xiwang] = @original_xiwang AND [lianxi] = @original_lianxi AND [Time] = @original_Time AND [yuji] = @original_yuji AND [yijian] = @original_yijian">
<DeleteParameters>
<asp:Parameter Name="original_id" Type="Int32" />
<asp:Parameter Name="original_Date" Type="DateTime" />
<asp:Parameter Name="original_CustomerName" Type="String" />
<asp:Parameter Name="original_CustomerID" Type="String" />
<asp:Parameter Name="original_RName" Type="String" />
<asp:Parameter Name="original_Love" Type="String" />
<asp:Parameter Name="original_Birthday" Type="String" />
<asp:Parameter Name="original_ZRname" Type="String" />
<asp:Parameter Name="original_CustomerType" Type="String" />
<asp:Parameter Name="original_Dname" Type="String" />
<asp:Parameter Name="original_fengxian" Type="String" />
<asp:Parameter Name="original_jiaoyi" Type="String" />
<asp:Parameter Name="original_caozuo" Type="String" />
<asp:Parameter Name="original_touzi" Type="String" />
<asp:Parameter Name="original_xiwang" Type="String" />
<asp:Parameter Name="original_lianxi" Type="String" />
<asp:Parameter Name="original_Time" Type="String" />
<asp:Parameter Name="original_yuji" Type="String" />
<asp:Parameter Name="original_yijian" Type="String" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="Date" Type="DateTime" />
<asp:Parameter Name="CustomerName" Type="String" />
<asp:Parameter Name="CustomerID" Type="String" />
<asp:Parameter Name="RName" Type="String" />
<asp:Parameter Name="Love" Type="String" />
<asp:Parameter Name="Birthday" Type="String" />
<asp:Parameter Name="ZRname" Type="String" />
<asp:Parameter Name="CustomerType" Type="String" />
<asp:Parameter Name="Dname" Type="String" />
<asp:Parameter Name="fengxian" Type="String" />
<asp:Parameter Name="jiaoyi" Type="String" />
<asp:Parameter Name="caozuo" Type="String" />
<asp:Parameter Name="touzi" Type="String" />
<asp:Parameter Name="xiwang" Type="String" />
<asp:Parameter Name="lianxi" Type="String" />
<asp:Parameter Name="Time" Type="String" />
<asp:Parameter Name="yuji" Type="String" />
<asp:Parameter Name="yijian" Type="String" />
<asp:Parameter Name="original_id" Type="Int32" />
<asp:Parameter Name="original_Date" Type="DateTime" />
<asp:Parameter Name="original_CustomerName" Type="String" />
<asp:Parameter Name="original_CustomerID" Type="String" />
<asp:Parameter Name="original_RName" Type="String" />
<asp:Parameter Name="original_Love" Type="String" />
<asp:Parameter Name="original_Birthday" Type="String" />
<asp:Parameter Name="original_ZRname" Type="String" />
<asp:Parameter Name="original_CustomerType" Type="String" />
<asp:Parameter Name="original_Dname" Type="String" />
<asp:Parameter Name="original_fengxian" Type="String" />
<asp:Parameter Name="original_jiaoyi" Type="String" />
<asp:Parameter Name="original_caozuo" Type="String" />
<asp:Parameter Name="original_touzi" Type="String" />
<asp:Parameter Name="original_xiwang" Type="String" />
<asp:Parameter Name="original_lianxi" Type="String" />
<asp:Parameter Name="original_Time" Type="String" />
<asp:Parameter Name="original_yuji" Type="String" />
<asp:Parameter Name="original_yijian" Type="String" />
</UpdateParameters>
<SelectParameters>
<asp:ControlParameter ControlID="TextBox11" Name="CustomerID" PropertyName="Text"
Type="String" />
</SelectParameters>
<InsertParameters>
<asp:Parameter Name="Date" Type="DateTime" />
<asp:Parameter Name="CustomerName" Type="String" />
<asp:Parameter Name="CustomerID" Type="String" />
<asp:Parameter Name="RName" Type="String" />
<asp:Parameter Name="Love" Type="String" />
<asp:Parameter Name="Birthday" Type="String" />
<asp:Parameter Name="ZRname" Type="String" />
<asp:Parameter Name="CustomerType" Type="String" />
<asp:Parameter Name="Dname" Type="String" />
<asp:Parameter Name="fengxian" Type="String" />
<asp:Parameter Name="jiaoyi" Type="String" />
<asp:Parameter Name="caozuo" Type="String" />
<asp:Parameter Name="touzi" Type="String" />
<asp:Parameter Name="xiwang" Type="String" />
<asp:Parameter Name="lianxi" Type="String" />
<asp:Parameter Name="Time" Type="String" />
<asp:Parameter Name="yuji" Type="String" />
<asp:Parameter Name="yijian" Type="String" />
</InsertParameters>
</asp:SqlDataSource>
解决方案 »
- SQL TREE
- 求助 Asp.net 未将对象引用设置到对象的实例
- 高手问题(asp.net+ word)
- .net服务器端控件编译后出现为何生成表格,请问该如何取消!(有样品)
- asp.net把WORD中的内容读出来显示在网页上,怎么实现?
- 求成为高级.net软件工程师的具体推荐课本?
- 获取datalist中的值
- 值得想想:如何在网页中用链接去触发一个事件?
- xml知识 求解答 求解答 求解答
- 在网上下载的控件怎么在本地使用??
- DataGrid控件中如何修改列名和,字体的大小啊?是哪个属性,麻烦知道的说下! 着急啊!(再线等)
- 求助:怎样用asp.net(c#)做弹出登陆框?多谢各位帮忙.急急急急
<asp:DetailsView ID="DetailsView1" runat="server" AllowPaging="True" AutoGenerateRows="False"
DataKeyNames="id" DataSourceID="SqlDataSource1" Height="50px" Width="125px">
然后建一个TextBox和一个Button,在textbox里面输入用户id,按回车或者按button数据就会显示在detailsview里面。然后detailsview设置分页和编辑功能。运行的时候detailsview里面的数据和分页都正常,但是点击编辑按钮进入detailsview的编辑模板,更改数据之后点击更新,但是之后数据还是没有变,也没有提示出错。
其次在vs2003里面(我知道你是2005)执行完更新sql后会重新绑定数据库,而connection的关闭对数据更新的显示有影响)
<html>
<head runat="server">
<title>Updating Data Using GridView</title>
</head>
<body>
<form id="form1" runat="server">
<asp:GridView ID="GridView1" AllowSorting="true" AllowPaging="true" Runat="server"
DataSourceID="SqlDataSource1" AutoGenerateEditButton="true" DataKeyNames="au_id"
AutoGenerateColumns="False">
<Columns>
<asp:BoundField ReadOnly="true" HeaderText="ID" DataField="au_id" SortExpression="au_id" />
<asp:BoundField HeaderText="Last Name" DataField="au_lname" SortExpression="au_lname" />
<asp:BoundField HeaderText="First Name" DataField="au_fname" SortExpression="au_fname" />
<asp:BoundField HeaderText="Phone" DataField="phone" SortExpression="phone" />
<asp:BoundField HeaderText="Address" DataField="address" SortExpression="address" />
<asp:BoundField HeaderText="City" DataField="city" SortExpression="city" />
<asp:BoundField HeaderText="State" DataField="state" SortExpression="state" />
<asp:BoundField HeaderText="Zip Code" DataField="zip" SortExpression="zip" />
<asp:CheckBoxField HeaderText="Contract" SortExpression="contract" DataField="contract" />
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" Runat="server" SelectCommand="SELECT [au_id], [au_lname], [au_fname], [phone], [address], [city], [state], [zip], [contract] FROM [authors]"
UpdateCommand="UPDATE [authors] SET [au_lname] = @au_lname, [au_fname] = @au_fname, [phone] = @phone, [address] = @address, [city] = @city, [state] = @state, [zip] = @zip, [contract] = @contract WHERE [au_id] = @au_id"
ConnectionString="<%$ ConnectionStrings:Pubs %>" />
</form>
</body>
</html>这个是微软给出的示例代码,他里面有个selectcommand但是你没有不知道有关系没有
t43 1。86g 1g内存vs2003和ps加上dreamweaver可以勉强用,2005就完全不行了