Please I need help with this error. I dont know what to do



SQL statement:

string reg;
         reg = "INSERT INTO Customer(Name, Surname,User, Pass, Address1, Email1)";
         reg += " VALUE('" +first.Text+ "','" +second.Text+ "','" +user.Text+ "','" +pass.Text+ "','" +address1.Text+ "','" +email.Text+ "');";









Exception Details: System.Data.OleDb.OleDbException: Syntax error in INSERT INTO statement.

Source Error:

Line 35:
Line 36: connection.Open();
Line 37: command.ExecuteNonQuery();
Line 38:
Line 39: Response.Redirect("product.aspx");


Source File: c:\Application development website\links\register.aspx Line: 37

Stack Trace:

[OleDbException (0x80040e14): Syntax error in INSERT INTO statement.]
   System.Data.OleDb.OleDbCommand.ExecuteCommandTextF orSingleResult(tagDBPARAMS dbParams, Object& executeResult) +177
   System.Data.OleDb.OleDbCommand.ExecuteCommandText( Object& executeResult) +194
   System.Data.OleDb.OleDbCommand.ExecuteCommand(Comm andBehavior behavior, Object& executeResult) +56
   System.Data.OleDb.OleDbCommand.ExecuteReaderIntern al(CommandBehavior behavior, String method) +105
   System.Data.OleDb.OleDbCommand.ExecuteNonQuery() +89
   ASP.register_aspx.register_click(Object sender, EventArgs e) in c:\Application development website\links\register.aspx:37
   System.Web.UI.WebControls.Button.OnClick(EventArgs e) +75
   System.Web.UI.WebControls.Button.RaisePostBackEven t(String eventArgument) +97
   System.Web.UI.WebControls.Button.System.Web.UI.IPo stBackEventHandler.RaisePostBackEvent(String eventArgument) +7
   System.Web.UI.Page.RaisePostBackEvent(IPostBackEve ntHandler sourceControl, String eventArgument) +11
   System.Web.UI.Page.RaisePostBackEvent(NameValueCol lection postData) +33
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +4919

hi there..

shouldn't be VALUES instead of VALUE????

HTH

Gonzalo

I have tried this again I am getting the same error. Other suggestion???

It has to be VALUES. There is some other error there. I wouldn't use the + . Use & instead. Debug and post your SQL statement here.

Thank you very much I finished it I completed. Do you want me to insert the complete code to see it??

Yes, I would appreciate know what the solution was.

Thank you.

Complete solution:


 public void register_click(object sender, EventArgs e)
     { //I have changed this part as defined in my report because there was no availability of using XML file in the Computer Suite

         OleDbConnection connection = new OleDbConnection();
         string dbconn;
         dbconn = "Provider=Microsoft.Jet.OLEDB.4.0;";
         dbconn += "Data Source= " + HttpContext.Current.Server.MapPath("accessMyWebsit e.mdb");
         connection.ConnectionString = dbconn;



         // insert data into registration table

         string reg;
         reg = "INSERT INTO Customer([Name], [Surname], [User], [Pass], [Address1], [Email1])";
         reg += " VALUES ('" +first.Text+ "','" +second.Text+ "','" +user.Text+ "','" +pass.Text+ "','" +address1.Text+ "','" +email.Text+ "');";

         //Define ADO.NET objects
         OleDbCommand command = new OleDbCommand();
         command.CommandText = reg;
         command.Connection = connection;

         connection.Open();

          command.ExecuteNonQuery();

         Response.Redirect("login.aspx");

         connection.Close();
     }

Thanks to all that contributed