Hello experts,
I'm a newbee to ASP.NET. And I have been struggling solving
this problem. But I can't do it. Can you please help me get
over this wall? Below is the code and error message:
<%@ Page Language="vb" AutoEventWireup ="true"
Codebehind="Reg isterForm.aspx. vb"
Inherits="WebAp plication1.Regi sterForm"%>
<%@ import Namespace="Syst em.data.oledb" %>
<%@ import Namespace="Syst em.data" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<title>Register Form</title>
<script language="vb" runat="server">
Sub SubmitBtn_Click (Source As Object, ByVal E as EventArgs)
dim listError as string
dim connectionStrin g as string
connectionStrin g = "Provider=Micro soft.Jet.OLEDB. 4.0;Data
Source=C:\myPro ject\WebApplica tion1\UserDB1.m db;"
dim objConn = New OleDbConnection ( connectionStrin g )
dim objCommand
try
objConn.Open()
dim InsertSQL as string
Response.Write( "Connection established! <br />")
dim fname as string
dim lname as string
dim sname as string
dim eml as string
dim pwd as string
dim sex as string
fname=FN.text
lname=LN.text
sname=ScreenNam e.text
eml=Email.text
sex=Request.For m("Sex")
pwd=Password.te xt
'Create Insert statement
InsertSQL ="insert into Users (Email, FirstName, LastName,
ScreenName, Sex, Password) "
InsertSQL = InsertSQL & "values('" & eml &"', '" & fname
&"', '" & lname &"', '" & sname &"','" & sex & "', '" & pwd
&"');"
' Create OleDbCommand object
dim cmdInsert as New OleDbCommand(In sertSQL, objConn)
cmdInsert.Execu teNonQuery()
Response.Write( "Data Recorded")
catch Err as Exception
listError = Err.ToString()
Response.Write( listError)
end try
End Sub
</script>
ERROR:
System.Data.Ole Db.OleDbExcepti on: Syntax error in INSERT
INTO statement. at
System.Data.Ole Db.OleDbCommand .ExecuteCommand TextErrorHandli ng(Int32
hr) at
System.Data.Ole Db.OleDbCommand .ExecuteCommand TextForSingleRe sult(tagDBPARAM S
dbParams, Object& executeResult) at
System.Data.Ole Db.OleDbCommand .ExecuteCommand Text(Object&
executeResult) at
System.Data.Ole Db.OleDbCommand .ExecuteCommand (CommandBehavio r
behavior, Object& executeResult) at
System.Data.Ole Db.OleDbCommand .ExecuteReaderI nternal(Command Behavior
behavior, String method) at
System.Data.Ole Db.OleDbCommand .ExecuteNonQuer y() at
ASP.RegisterFor m_aspx.SubmitBt n_Click(Object Source,
EventArgs E) in
C:\myProject\We bApplication1\R egisterForm.asp x:line 39
Line 30 contains: cmdInsert.Execu teNonQuery()
Thank you for your time,
