i am getting an error in the following code

Question

0.00/5 (No votes)

See more:

C#

protected void activites()
    {
        string connection_string = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\HILProject\project4\App_Data\adminlog.mdb";
        using (OleDbConnection cn = new OleDbConnection(connection_string))
        {
            cn.Open();

            String Sql =" UPDATE Activites_tbl SET Read= ?,RdLang= ?,RdMthLang= ?,RdOthrLang= ?,Write= ?,WtMthLang= ?,WtOthrLang= ?,Speak= ?,SpLang= ?,SpMthLang= ?,SpOthrLang= ?,SportsAct= ?,CurriAct= ?,Hobby= ? WHERE UserName= ?";
            using (OleDbCommand cmd = new OleDbCommand(Sql, cn))
            {
                cmd.Parameters.Add(new OleDbParameter("Read", Atttxt1.Text.ToString()));
                cmd.Parameters.Add(new OleDbParameter("RdLang", readlangtxt.Text.ToString()));
                cmd.Parameters.Add(new OleDbParameter("RdMthLang", readmttxt.Text.ToString()));
                cmd.Parameters.Add(new OleDbParameter("RdOthrLang", readoltxt.Text.ToString()));
                cmd.Parameters.Add(new OleDbParameter("Write", Atttxt2.Text.ToString()));
                cmd.Parameters.Add(new OleDbParameter("WtLang", writelangtxt.Text.ToString()));
                cmd.Parameters.Add(new OleDbParameter("WtMthLang", writemttxt.Text.ToString()));
                cmd.Parameters.Add(new OleDbParameter("WtOthrLang", writeoltxt.Text.ToString()));
                cmd.Parameters.Add(new OleDbParameter("Speak", Atttxt3.Text.ToString()));
                cmd.Parameters.Add(new OleDbParameter("SpLang", speaklangtxt.Text.ToString()));
                cmd.Parameters.Add(new OleDbParameter("SpMthLang", speakmttxt.Text.ToString()));
                cmd.Parameters.Add(new OleDbParameter("SpOthrLang", speakoltxt.Text.ToString()));
                cmd.Parameters.Add(new OleDbParameter("SportsAct", sportstxt.Text.ToString()));
                cmd.Parameters.Add(new OleDbParameter("CurriAct",extraacttxt.Text.ToString()));
                cmd.Parameters.Add(new OleDbParameter("Hobby", hobbytxt.Text.ToString()));
                cmd.Parameters.Add(new OleDbParameter("UserName", usertxt.Text.ToString()));
               
                cmd.ExecuteNonQuery();
                   StatusLabel.Text = "Record inserted successfully";

            }
            cn.Close();

        }
}

getting error at cmd.ExecuteNonQuery();
my field name are correct, some syntax error is shown

Posted 3-Jun-14 3:48am

Ashwini Thakare

Updated 3-Jun-14 3:49am

Nirav Prabtani

v2

Add a Solution

Comments

Richard MacCutchan 3-Jun-14 10:00am

What error?
Also, you should not print the message "Record inserted successfully" when you have not checked whether it has been inserted or not.

Ashwini Thakare 3-Jun-14 10:08am

[OleDbException (0x80040e14): Syntax error in UPDATE statement.]
System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr) +1070856
System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) +247
System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) +194
System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) +58
System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) +167
System.Data.OleDb.OleDbCommand.ExecuteNonQuery() +113
FillForm.activites() in c:\HILProject\project4\FillForm111.aspx.cs:1170
FillForm.Submitbtn_Click(Object sender, EventArgs e) in c:\HILProject\project4\FillForm111.aspx.cs:848
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +118
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +112
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +36
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5563

[no name] 3-Jun-14 10:20am

You are missing WtLang in your query. Use AddWithValue. Why are you calling ToString on a string?

Ashwini Thakare 3-Jun-14 12:32pm

i used addwith value and also added wtlang but then also it is showing same error

Bernhard Hiller 5-Jun-14 2:38am

Are all those fields text fields, or are some of them numeric/boolean?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Mike Meinz · Answer 1 · 2014-06-04T02:40:00

The following parameter is created but there is no WtLang in the Update statement.

C#

cmd.Parameters.Add(new OleDbParameter("WtLang", writelangtxt.Text.ToString()));

Maybe the Update statement should look like this:

C#

String Sql =" UPDATE Activites_tbl SET Read= ?,RdLang= ?,RdMthLang= ?,RdOthrLang= ?,Write= ?,WtLang=?,WtMthLang= ?,WtOthrLang= ?,Speak= ?,SpLang= ?,SpMthLang= ?,SpOthrLang= ?,SportsAct= ?,CurriAct= ?,Hobby= ? WHERE UserName= ?";