ASP.NET VB on Dreamweaver for User Registration

bizjosh

Member
Joined
Mar 16, 2005
Messages
23
Programming Experience
Beginner
Hi

I'm having these errors when on the user registration form i created
and it gives these errors:

System.Data.OleDb.OleDbException: Operation must use an updateable query.
at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(Int32 hr)
at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
at System.Data.OleDb.OleDbCommand.ExecuteNonQuery()
at DreamweaverCtrls.DataSet.DoInit()



My Code is: (minus the other non relevant)
<%@ Page Language="VB" ContentType="text/html" %>
<%@ Register TagPrefix="MM" Namespace="DreamweaverCtrls" Assembly="DreamweaverCtrls,version=1.0.0.0,publicKeyToken=836f606ede05d46a,culture=neutral" %><MM:Insert
runat="server"
CommandText='<%# "INSERT INTO Customer_Details (customer_address, customer_city, customer_company, customer_country, customer_dob, customer_email, customer_fax, customer_firstname, customer_gender, customer_hometelephone, customer_lastname, customer_mobile, customer_officephone, customer_password, customer_security, customer_state, customer_zip) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)" %>'
ConnectionString='<%# System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_STRING_connSoftwares") %>'
DatabaseType='<%# System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_DATABASETYPE_connSoftwares") %>'
Expression='<%# Request.Form("MM_insert") = "UserRegistration" %>'
CreateDataSet="false"
SuccessURL='<%# "register_completed.aspx" %>'
Debug="true"
><Parameters>
<Parameter Name="@customer_address" Value='<%# IIf((Request.Form("customer_address") <> Nothing), Request.Form("customer_address"), "") %>' Type="WChar" />
<Parameter Name="@customer_city" Value='<%# IIf((Request.Form("customer_city") <> Nothing), Request.Form("customer_city"), "") %>' Type="WChar" />
<Parameter Name="@customer_company" Value='<%# IIf((Request.Form("customer_company") <> Nothing), Request.Form("customer_company"), "") %>' Type="WChar" />
<Parameter Name="@customer_country" Value='<%# IIf((Request.Form("customer_country") <> Nothing), Request.Form("customer_country"), "") %>' Type="WChar" />
<Parameter Name="@customer_dob" Value='<%# IIf((Request.Form("customer_dob") <> Nothing), Request.Form("customer_dob"), "") %>' Type="Date" />
<Parameter Name="@customer_email" Value='<%# IIf((Request.Form("customer_email") <> Nothing), Request.Form("customer_email"), "") %>' Type="WChar" />
<Parameter Name="@customer_fax" Value='<%# IIf((Request.Form("customer_fax") <> Nothing), Request.Form("customer_fax"), "") %>' Type="WChar" />
<Parameter Name="@customer_firstname" Value='<%# IIf((Request.Form("customer_firstname") <> Nothing), Request.Form("customer_firstname"), "") %>' Type="WChar" />
<Parameter Name="@customer_gender" Value='<%# IIf((Request.Form("customer_gender") <> Nothing), Request.Form("customer_gender"), "") %>' Type="WChar" />
<Parameter Name="@customer_hometelephone" Value='<%# IIf((Request.Form("customer_hometelephone") <> Nothing), Request.Form("customer_hometelephone"), "") %>' Type="WChar" />
<Parameter Name="@customer_lastname" Value='<%# IIf((Request.Form("customer_lastname") <> Nothing), Request.Form("customer_lastname"), "") %>' Type="WChar" />
<Parameter Name="@customer_mobile" Value='<%# IIf((Request.Form("customer_mobile") <> Nothing), Request.Form("customer_mobile"), "") %>' Type="WChar" />
<Parameter Name="@customer_officephone" Value='<%# IIf((Request.Form("customer_officephone") <> Nothing), Request.Form("customer_officephone"), "") %>' Type="WChar" />
<Parameter Name="@customer_password" Value='<%# IIf((Request.Form("customer_password") <> Nothing), Request.Form("customer_password"), "") %>' Type="WChar" />
<Parameter Name="@customer_security" Value='<%# IIf((Request.Form("customer_security") <> Nothing), Request.Form("customer_security"), "") %>' Type="Integer" />
<Parameter Name="@customer_state" Value='<%# IIf((Request.Form("customer_state") <> Nothing), Request.Form("customer_state"), "") %>' Type="WChar" />
<Parameter Name="@customer_zip" Value='<%# IIf((Request.Form("customer_zip") <> Nothing), Request.Form("customer_zip"), "") %>' Type="WChar" />
</Parameters>
</MM:Insert>
<MM:pageBind runat="server" PostBackBind="true" />



Registration Form
<h4 class=fontblue>Registration Form (Users) </h4>
<form runat='server' action="" method='POST' name='UserRegistration' id="UserRegistration" onSubmit="return validate(this);">
<table width="550" align="center" class="formstyle">
<tr class="formheader">
<td height="20"></td>
</tr>
<tr>
<td> <table width="550" class="boxfield">
<tr>
<td width="80">First Name:</td>
<td width="140"><input name="customer_firstname" type="text" id="customer_firstname" size="20" maxlength="40"></td>
<td width="126">Last Name: </td>
<td width="150"><input name="customer_lastname" type="text" id="customer_lastname" size="20" maxlength="40"></td>
</tr>
<tr>
<td>Company:</td>
<td><input name="customer_company" type="text" id="customer_company" size="20" maxlength="40"></td>
<td>Gender:</td>
<td><input name="customer_gender" type="radio" value="M" checked>
Male
<input name="customer_gender" type="radio" value="F">
Female</td>
</tr>
<tr>
<td>Email Address: </td>
<td><input name="customer_email" type="text" id="customer_email" size="20" maxlength="40"></td>
<td>Date Of Birth: </td>
<td><input name="customer_dob" type="text" id="customer_dob" size="20" maxlength="40"></td>
</tr>
<tr>
<td>Address:</td>
<td colspan="2"><input name="customer_address" type="text" id="customer_address" size="40" maxlength="80"></td>
<td>(Same as billing address)</td>
<tr>
<td>City:</td>
<td><input name="customer_city" type="text" id="customer_city" size="20" maxlength="40"></td>
<td>State:</td>
<td><input name="customer_state" type="text" id="customer_state" size="10" maxlength="40"></td>
</tr>
<tr>
<td>Country:</td>
<td><input name="customer_country" type="text" id="customer_country" size="20" maxlength="40"></td>
<td>Zip Code: </td>
<td><input name="customer_zip" type="text" id="customer_zip" size="10" maxlength="40"></td>
</tr>
<tr>
<td>Home Phone: </td>
<td><input name="customer_hometelephone" type="text" id="customer_hometelephone" size="20" maxlength="40"></td>
<td>Mobile Phone </td>
<td><input name="customer_mobile" type="text" id="customer_mobile" size="20" maxlength="40"></td>
</tr>
<tr>
<td height="14">Office Phone: </td>
<td><input name="customer_officetelephone" type="text" id="customer_officetelephone" size="20" maxlength="40"></td>
<td>Fax (optional): </td>
<td><input name="customer_fax" type="text" id="customer_fax" size="20" maxlength="40"></td>
</tr>
<tr>
<td>Username:</td>
<td><input name="customer_username" type="text" id="customer_username" size="20" maxlength="40"></td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>Password:</td>
<td><input name="customer_password" type="password" id="customer_password" size="20" maxlength="40"></td>
<td> </td>
<td> </td>
</tr>
<tr>
<td><div align="center">
<input name="Agree" type="checkbox" id="Agree" value="Yes">
</div></td>
<td colspan="3">I have read the Terms & Conditions and agree to abide by them.
<input name="customer_security" type="hidden" id="customer_security" value="2"></td>
</tr>
<tr>
<td><input type="submit" name="Submit" value="Register Now"></td>
<td colspan="3"><div align="right">
<input type="reset" name="Reset" value="Reset">
</div></td>
</tr>
</table></td>
</tr>
</table>
<input type="hidden" name="MM_insert" value="UserRegistration">
</form>
 
Back
Top