Advertisement
Advertisement
| 05.14.2008 at 11:04AM PDT, ID: 23402484 | Points: 500 |
|
[x]
Attachment Details
|
||
1: 2: 3: 4: 5: 6: 7: 8: 9: 10: 11: 12: 13: 14: 15: 16: 17: 18: 19: 20: 21: 22: 23: 24: 25: 26: |
<div style="height: 375px">
<asp:TextBox ID="TextBox1" runat="server" AutoPostBack="true"></asp:TextBox>
<asp:Button ID="Button1" runat="server" Text="Button" onclick="Button1_Click" />
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:ConnStrLiberty %>"
InsertCommand="INSERT INTO [test] ([test1]) VALUES (@test1)"
ConflictDetection="CompareAllValues"
DeleteCommand="DELETE FROM [test] WHERE [test1] = @original_test1"
OldValuesParameterFormatString="original_{0}"
SelectCommand="SELECT [test1] FROM [test] WHERE ([test1] = @test1)">
<SelectParameters>
<asp:ControlParameter ControlID="TextBox1" Name="test1" PropertyName="Text"
Type="String" />
</SelectParameters>
<DeleteParameters>
<asp:Parameter Name="original_test1" Type="String" />
</DeleteParameters>
<InsertParameters>
<asp:Parameter Name="test1" Type="String" />
</InsertParameters>
</asp:SqlDataSource>
</div>
|