I have the following insercommand in my asp page.
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="
<%$ ConnectionStrings:eventsConnectionString %>"
SelectCommand="SELECT registration.* FROM registration"
InsertCommand="INSERT INTO registration(eventName,
firstName, lastName,instName,faculty, jobTitle,email,
phoneNumber,degreeName, yearOfStudy,interestOthers,eventSource,
eventOthersDetail, resCountry) VALUES
(@eventName,@first,@lastName,@instName,@faculty,@j obTitle,@email,@phoneNumb*er,@degreeName,@yearOfSt udy,@interestOthers,@eventSource,@eventOthersDetai l*,@resCountry)"
ProviderName="<%$ ConnectionStrings:eventsConnectionString.ProviderN ame
%>">
<insertparameters>
<asp:formparameter name="eventName" formfield="eventName" />
<asp:formparameter name="firstName" formfield="firstName" />
<asp:formparameter name="lastName" formfield="lastName" />
<asp:formparameter name="instName" formfield="instName" />
<asp:formparameter name="faculty" formfield="faculty" />
<asp:formparameter name="jobTitle" formfield="jobTitle" />
<asp:formparameter name="email" formfield="email" />
<asp:formparameter name="phoneNumber" formfield="phoneNumber" />
<asp:formparameter name="degreeName" formfield="degreeName" />
<asp:formparameter name="yearOfStudy" formfield="yearOfStudy" />
<asp:formparameter name="interestOthers" formfield="interestOthers" />
<asp:formparameter name="eventSource" formfield="eventSource" />
<asp:formparameter name="eventOthersDetail"
formfield="eventOthersDetail" />
<asp:formparameter name="resCountry" formfield="resCountry" />
</insertparameters>
</asp:SqlDataSource>
The problem is none of the values return anything. Is my formparameter
wrongly defined?
Thanks in advance.