Sign In| Join
Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Member
10 Points
8 Posts
Nov 05, 2011 07:55 AM|LINK
I change from ACCDB to MDB and I get Exactlly the same result
<asp:AccessDataSource ID="AccessDataSource2" runat="server" DataFile="~/App_Data/Form_ContinuousSimulated.mdb" DeleteCommand="DELETE FROM [T_Trains] WHERE [TrainID] = ?" InsertCommand="INSERT INTO [T_Trains] ([TrainID], [TrainCode], [ColorValue]) VALUES (?, ?, ?)" SelectCommand="SELECT * FROM [T_Trains]" UpdateCommand="UPDATE [T_Trains] SET [TrainCode] = ?, [ColorValue] = ? WHERE [TrainID] = ?"> <DeleteParameters> <asp:Parameter Name="TrainID" Type="Int32" /> </DeleteParameters> <InsertParameters> <asp:Parameter Name="TrainID" Type="Int32" /> <asp:Parameter Name="TrainCode" Type="String" /> <asp:Parameter Name="ColorValue" Type="Int32" /> </InsertParameters> <UpdateParameters> <asp:Parameter Name="TrainCode" Type="String" /> <asp:Parameter Name="ColorValue" Type="Int32" /> <asp:Parameter Name="TrainID" Type="Int32" /> </UpdateParameters> </asp:AccessDataSource> </p> <asp:FormView ID="FormView2" runat="server" DataKeyNames="TrainID" DataSourceID="AccessDataSource2"> <EditItemTemplate> TrainID: <asp:Label ID="TrainIDLabel1" runat="server" Text='<%# Eval("TrainID") %>' /> <br /> TrainCode: <asp:TextBox ID="TrainCodeTextBox" runat="server" Text='<%# Bind("TrainCode") %>' /> <br /> ColorValue: <asp:TextBox ID="ColorValueTextBox" runat="server" Text='<%# Bind("ColorValue") %>' /> <br /> <asp:LinkButton ID="UpdateButton" runat="server" CausesValidation="True" CommandName="Update" Text="Update" /> <asp:LinkButton ID="UpdateCancelButton" runat="server" CausesValidation="False" CommandName="Cancel" Text="Cancel" /> <asp:Button ID="Button2" runat="server" onclick="Button2_Click1" Text="Button" /> </EditItemTemplate> <InsertItemTemplate> TrainCode: <asp:TextBox ID="TrainCodeTextBox" runat="server" Text='<%# Bind("TrainCode") %>' /> <br /> ColorValue: <asp:TextBox ID="ColorValueTextBox" runat="server" Text='<%# Bind("ColorValue") %>' /> <br /> <asp:LinkButton ID="InsertButton" runat="server" CausesValidation="True" CommandName="Insert" Text="Insert" /> <asp:LinkButton ID="InsertCancelButton" runat="server" CausesValidation="False" CommandName="Cancel" Text="Cancel" /> </InsertItemTemplate> <ItemTemplate> TrainID: <asp:Label ID="TrainIDLabel" runat="server" Text='<%# Eval("TrainID") %>' /> <br /> TrainCode: <asp:Label ID="TrainCodeLabel" runat="server" Text='<%# Bind("TrainCode") %>' /> <br /> ColorValue: <asp:Label ID="ColorValueLabel" runat="server" Text='<%# Bind("ColorValue") %>' /> <br /> <asp:LinkButton ID="EditButton" runat="server" CausesValidation="False" CommandName="Edit" Text="Edit" /> <asp:LinkButton ID="DeleteButton" runat="server" CausesValidation="False" CommandName="Delete" Text="Delete" /> <asp:LinkButton ID="NewButton" runat="server" CausesValidation="False" CommandName="New" Text="New" /> </ItemTemplate> </asp:FormView>
VB
Protected Sub Button2_Click1(ByVal sender As Object, ByVal e As System.EventArgs)
AccessDataSource2.Update() FormView2.ChangeMode(FormViewMode.ReadOnly) End Sub
How can I update using VB by using accessdatasource . updateparamenter.add ..
ashrafedes
Member
10 Points
8 Posts
Re: accessdatasouce1.update using VB code in Asp.net
Nov 05, 2011 07:55 AM|LINK
I change from ACCDB to MDB and I get Exactlly the same result
<asp:AccessDataSource ID="AccessDataSource2" runat="server"
DataFile="~/App_Data/Form_ContinuousSimulated.mdb"
DeleteCommand="DELETE FROM [T_Trains] WHERE [TrainID] = ?"
InsertCommand="INSERT INTO [T_Trains] ([TrainID], [TrainCode], [ColorValue]) VALUES (?, ?, ?)"
SelectCommand="SELECT * FROM [T_Trains]"
UpdateCommand="UPDATE [T_Trains] SET [TrainCode] = ?, [ColorValue] = ? WHERE [TrainID] = ?">
<DeleteParameters>
<asp:Parameter Name="TrainID" Type="Int32" />
</DeleteParameters>
<InsertParameters>
<asp:Parameter Name="TrainID" Type="Int32" />
<asp:Parameter Name="TrainCode" Type="String" />
<asp:Parameter Name="ColorValue" Type="Int32" />
</InsertParameters>
<UpdateParameters>
<asp:Parameter Name="TrainCode" Type="String" />
<asp:Parameter Name="ColorValue" Type="Int32" />
<asp:Parameter Name="TrainID" Type="Int32" />
</UpdateParameters>
</asp:AccessDataSource>
</p>
<asp:FormView ID="FormView2" runat="server" DataKeyNames="TrainID"
DataSourceID="AccessDataSource2">
<EditItemTemplate>
TrainID:
<asp:Label ID="TrainIDLabel1" runat="server" Text='<%# Eval("TrainID") %>' />
<br />
TrainCode:
<asp:TextBox ID="TrainCodeTextBox" runat="server"
Text='<%# Bind("TrainCode") %>' />
<br />
ColorValue:
<asp:TextBox ID="ColorValueTextBox" runat="server"
Text='<%# Bind("ColorValue") %>' />
<br />
<asp:LinkButton ID="UpdateButton" runat="server" CausesValidation="True"
CommandName="Update" Text="Update" />
<asp:LinkButton ID="UpdateCancelButton" runat="server"
CausesValidation="False" CommandName="Cancel" Text="Cancel" />
<asp:Button ID="Button2" runat="server" onclick="Button2_Click1"
Text="Button" />
</EditItemTemplate>
<InsertItemTemplate>
TrainCode:
<asp:TextBox ID="TrainCodeTextBox" runat="server"
Text='<%# Bind("TrainCode") %>' />
<br />
ColorValue:
<asp:TextBox ID="ColorValueTextBox" runat="server"
Text='<%# Bind("ColorValue") %>' />
<br />
<asp:LinkButton ID="InsertButton" runat="server" CausesValidation="True"
CommandName="Insert" Text="Insert" />
<asp:LinkButton ID="InsertCancelButton" runat="server"
CausesValidation="False" CommandName="Cancel" Text="Cancel" />
</InsertItemTemplate>
<ItemTemplate>
TrainID:
<asp:Label ID="TrainIDLabel" runat="server" Text='<%# Eval("TrainID") %>' />
<br />
TrainCode:
<asp:Label ID="TrainCodeLabel" runat="server" Text='<%# Bind("TrainCode") %>' />
<br />
ColorValue:
<asp:Label ID="ColorValueLabel" runat="server"
Text='<%# Bind("ColorValue") %>' />
<br />
<asp:LinkButton ID="EditButton" runat="server" CausesValidation="False"
CommandName="Edit" Text="Edit" />
<asp:LinkButton ID="DeleteButton" runat="server" CausesValidation="False"
CommandName="Delete" Text="Delete" />
<asp:LinkButton ID="NewButton" runat="server" CausesValidation="False"
CommandName="New" Text="New" />
</ItemTemplate>
</asp:FormView>
VB
Protected Sub Button2_Click1(ByVal sender As Object, ByVal e As System.EventArgs)
AccessDataSource2.Update()
FormView2.ChangeMode(FormViewMode.ReadOnly)
End Sub
How can I update using VB by using accessdatasource . updateparamenter.add ..