Last post Oct 23, 2012 08:44 AM by oned_gk
Member
5 Points
11 Posts
Oct 22, 2012 09:12 AM|Ryokox3|LINK
Hi all, can anyone tell me what I'm doing wrong here please. Edit: I'm getting an error with my sql syntax.
<LoggedInTemplate>
<asp:DetailsView ID="dvInsertUser" runat="server" Height="50px" Width="125px"
AutoGenerateInsertButton="True" AutoGenerateRows="False"
DataKeyNames="RecordID" DataSourceID="ads3" DefaultMode="Insert"
EnableModelValidation="True"
>
<Fields>
<asp:BoundField DataField="RecordID" HeaderText="RecordID"
InsertVisible="False" ReadOnly="True" SortExpression="RecordID" />
<asp:BoundField DataField="LastName" HeaderText="LastName"
SortExpression="LastName" />
<asp:BoundField DataField="FirstName" HeaderText="FirstName"
SortExpression="FirstName" />
<asp:BoundField DataField="Address" HeaderText="Address"
SortExpression="Address" />
<asp:BoundField DataField="City" HeaderText="City" SortExpression="City" />
<asp:BoundField DataField="State" HeaderText="State" SortExpression="State" />
<asp:BoundField DataField="Zip" HeaderText="Zip" SortExpression="Zip" />
<asp:BoundField DataField="Phone" HeaderText="Phone" SortExpression="Phone" />
<asp:BoundField DataField="DateOfBirth" HeaderText="DateOfBirth"
SortExpression="DateOfBirth" />
<asp:BoundField DataField="MemberType" HeaderText="MemberType"
SortExpression="MemberType" />
<asp:BoundField DataField="AMANumber" HeaderText="AMANumber"
SortExpression="AMANumber" />
<asp:BoundField DataField="Email" HeaderText="Email"
SortExpression="Email" />
<asp:BoundField DataField="Channels" HeaderText="Channels"
SortExpression="Channels" />
<asp:CheckBoxField DataField="ClubOfficer" HeaderText="ClubOfficer"
SortExpression="ClubOfficer" />
<asp:CheckBoxField DataField="ShowDetails" HeaderText="ShowDetails"
SortExpression="ShowDetails" />
<asp:CheckBoxField InsertVisible="false" DataField="inactive" HeaderText="inactive"
SortExpression="inactive" />
</Fields>
</asp:DetailsView>
<asp:AccessDataSource ID="ads3" runat="server" DataFile="~/App_Data/ourmemberfile.mdb"
SelectCommand="SELECT * FROM [Members]"
InsertCommand="Insert Members (LastName, FirstName, Address, City, State, Zip, Phone, DateOfBirth, MemberType, AMANumber, Email, Channels, ClubOfficer, ShowDetails, inactive)
Values (@LastName, @FirstName, @Address, @City, @State, @Zip, @Phone, @DateOfBirth, @MemberType, @AMANumber, @Email, @Channels, @ClubOfficer, @ShowDetails, False)"
</asp:AccessDataSource>
Thank you for the help all. This is my first time trying to insert with this control.
All-Star
25756 Points
7014 Posts
Oct 22, 2012 05:12 PM|hans_v|LINK
Ryokox3 Hi all, can anyone tell me what I'm doing wrong here please
You're missing the insertparameter collection
<asp:AccessDataSource ID="ads3" runat="server" DataFile="~/App_Data/ourmemberfile.mdb" SelectCommand="SELECT * FROM [Members]" InsertCommand="Insert Members (LastName, FirstName, Address, City, State, Zip, Phone, DateOfBirth, MemberType, AMANumber, Email, Channels, ClubOfficer, ShowDetails, inactive) Values (@LastName, @FirstName, @Address, @City, @State, @Zip, @Phone, @DateOfBirth, @MemberType, @AMANumber, @Email, @Channels, @ClubOfficer, @ShowDetails, False)"> <InsertParameters> <asp:parameter name="LastName" /> <asp:parameter name="FirstName" /> <asp:parameter name="Address" /> <asp:parameter name="City" /> <asp:parameter name="State" /> <asp:parameter name="Zip" /> <asp:parameter name="Phone" /> <asp:parameter name="DateOfBirth" /> <asp:parameter name="MemberType" /> <asp:parameter name="AMANumber" /> <asp:parameter name="Email" /> <asp:parameter name="Channels" /> <asp:parameter name="ClubOfficer" /> <asp:parameter name="ShowDetails" /> </InsertParameters> </asp:AccessDataSource>
52803 Points
15764 Posts
Oct 22, 2012 09:07 PM|oned_gk|LINK
Set default value for inactive=false in access file, then dont include it in insert command. And use ? to pass parameter
InsertCommand="Insert Members (LastName, FirstName, Address, City, State, Zip, Phone, DateOfBirth, MemberType, AMANumber, Email, Channels, ClubOfficer, ShowDetails) Values (?,?,?,?,?,?,?,?,?,?,?,?,?,?)"
and add insertparamater from LastName to Showdetails
<InsertParameters> <asp:parameter name="LastName" /> <asp:parameter name="FirstName" /> <asp:parameter name="Address" /> <asp:parameter name="City" /> <asp:parameter name="State" /> <asp:parameter name="Zip" /> <asp:parameter name="Phone" /> <asp:parameter name="DateOfBirth" /> <asp:parameter name="MemberType" /> <asp:parameter name="AMANumber" /> <asp:parameter name="Email" /> <asp:parameter name="Channels" /> <asp:parameter name="ClubOfficer" /> <asp:parameter name="ShowDetails" /> </InsertParameters>
Oct 22, 2012 09:50 PM|Ryokox3|LINK
Thanks guys, really appreciate the help.
Oct 23, 2012 06:00 AM|hans_v|LINK
oned_gk Set default value for inactive=false in access file, then dont include it in insert command
That is just another option, but doesn't solve the problem
oned_gk And use ? to pass parameter
Named parameters will work also
oned_gk and add insertparamater from LastName to Showdetails
That is indeed causing the problem, as I already said!
Oct 23, 2012 08:44 AM|oned_gk|LINK
I just giving sugestion what i know, sorry pasting the parameters.
I always use accessdatasource and sqldatasource in my app (not like code behind)
I am very new here, appologize me.
Member
5 Points
11 Posts
Having trouble inserting a record with detailview
Oct 22, 2012 09:12 AM|Ryokox3|LINK
Hi all, can anyone tell me what I'm doing wrong here please. Edit: I'm getting an error with my sql syntax.
<LoggedInTemplate>
<asp:DetailsView ID="dvInsertUser" runat="server" Height="50px" Width="125px"
AutoGenerateInsertButton="True" AutoGenerateRows="False"
DataKeyNames="RecordID" DataSourceID="ads3" DefaultMode="Insert"
EnableModelValidation="True"
>
<Fields>
<asp:BoundField DataField="RecordID" HeaderText="RecordID"
InsertVisible="False" ReadOnly="True" SortExpression="RecordID" />
<asp:BoundField DataField="LastName" HeaderText="LastName"
SortExpression="LastName" />
<asp:BoundField DataField="FirstName" HeaderText="FirstName"
SortExpression="FirstName" />
<asp:BoundField DataField="Address" HeaderText="Address"
SortExpression="Address" />
<asp:BoundField DataField="City" HeaderText="City" SortExpression="City" />
<asp:BoundField DataField="State" HeaderText="State" SortExpression="State" />
<asp:BoundField DataField="Zip" HeaderText="Zip" SortExpression="Zip" />
<asp:BoundField DataField="Phone" HeaderText="Phone" SortExpression="Phone" />
<asp:BoundField DataField="DateOfBirth" HeaderText="DateOfBirth"
SortExpression="DateOfBirth" />
<asp:BoundField DataField="MemberType" HeaderText="MemberType"
SortExpression="MemberType" />
<asp:BoundField DataField="AMANumber" HeaderText="AMANumber"
SortExpression="AMANumber" />
<asp:BoundField DataField="Email" HeaderText="Email"
SortExpression="Email" />
<asp:BoundField DataField="Channels" HeaderText="Channels"
SortExpression="Channels" />
<asp:CheckBoxField DataField="ClubOfficer" HeaderText="ClubOfficer"
SortExpression="ClubOfficer" />
<asp:CheckBoxField DataField="ShowDetails" HeaderText="ShowDetails"
SortExpression="ShowDetails" />
<asp:CheckBoxField InsertVisible="false" DataField="inactive" HeaderText="inactive"
SortExpression="inactive" />
</Fields>
</asp:DetailsView>
<asp:AccessDataSource ID="ads3" runat="server" DataFile="~/App_Data/ourmemberfile.mdb"
SelectCommand="SELECT * FROM [Members]"
InsertCommand="Insert Members (LastName, FirstName, Address, City, State, Zip, Phone, DateOfBirth, MemberType, AMANumber, Email, Channels, ClubOfficer, ShowDetails, inactive)
Values (@LastName, @FirstName, @Address, @City, @State, @Zip, @Phone, @DateOfBirth, @MemberType, @AMANumber, @Email, @Channels, @ClubOfficer, @ShowDetails, False)"
>
</asp:AccessDataSource>
Thank you for the help all. This is my first time trying to insert with this control.
All-Star
25756 Points
7014 Posts
Re: Having trouble inserting a record with detailview
Oct 22, 2012 05:12 PM|hans_v|LINK
You're missing the insertparameter collection
All-Star
52803 Points
15764 Posts
Re: Having trouble inserting a record with detailview
Oct 22, 2012 09:07 PM|oned_gk|LINK
Set default value for inactive=false in access file, then dont include it in insert command. And use ? to pass parameter
and add insertparamater from LastName to Showdetails
Suwandi - Non Graduate Programmer
Member
5 Points
11 Posts
Re: Having trouble inserting a record with detailview
Oct 22, 2012 09:50 PM|Ryokox3|LINK
Thanks guys, really appreciate the help.
All-Star
25756 Points
7014 Posts
Re: Having trouble inserting a record with detailview
Oct 23, 2012 06:00 AM|hans_v|LINK
That is just another option, but doesn't solve the problem
Named parameters will work also
That is indeed causing the problem, as I already said!
All-Star
52803 Points
15764 Posts
Re: Having trouble inserting a record with detailview
Oct 23, 2012 08:44 AM|oned_gk|LINK
I just giving sugestion what i know, sorry pasting the parameters.
I always use accessdatasource and sqldatasource in my app (not like code behind)
I am very new here, appologize me.
Suwandi - Non Graduate Programmer