ASP.Net Error in inserting Data To OleDb

Question

I keep getting this error. I read that OleDb doesn't support named parameters so I changed them to (?, ?).

But is keep getting the same error

System.Data.OleDb.OleDbException: Syntax error in INSERT INTO statement. at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult 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 Registration.ImageButton1_Click(Object sender, ImageClickEventArgs e) in c:\Users\Nirre\Desktop\Cti Project\Book Club TRY 2\Registration.aspx.cs:line 51

Here is the code in the .cs class

 protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
    if (IsPostBack)
    {
        OleDbConnection conn = new OleDbConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
        conn.Open();
        string insCmd = @"INSERT COUNT(*) INTO Registration(UserName, [Password], EmailAddress, FullName, Country, PasswordRecovery)
                     VALUES (?, ?, ?, ?, ?, ?)";
        OleDbCommand insertUser = new OleDbCommand(insCmd, conn);
        insertUser.Parameters.AddWithValue("@UserName", txtUserName.Text);
        insertUser.Parameters.AddWithValue("@Password", txtPassoword.Text);
        insertUser.Parameters.AddWithValue("@EmailAddress", txtEmail.Text);
        insertUser.Parameters.AddWithValue("@FullName", txtFullName);
        insertUser.Parameters.AddWithValue("@Country", DdlCountry.SelectedItem.ToString());
        insertUser.Parameters.AddWithValue("@PasswordRecovery", txtAnswer.Text);

        try
        {
            insertUser.ExecuteNonQuery();
            conn.Close();
            Response.Redirect("Login.aspx");
        }
        catch (Exception er)
        {
            Response.Write(er);
            lblError.Visible = true;
            lblError.Text = "An error has ocured pleas try again...!";
        }
        finally
        {
            // Code
        }
    }
}

Plain-text passwords make me sad :( Also... why was this ancient question at the top of the list again? — Joel Coehoorn
– Joel Coehoorn, Commented Jul 11, 2018 at 14:23

Steve · Accepted Answer · 2012-06-18 14:03:52Z

1

INSERT COUNT(*) is not a valid SQL statement, simply remove COUNT(*) and the rest of your code seems correct.

See here for refs

answered Jun 18, 2012 at 14:03

Steve

217k22 gold badges242 silver badges296 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Steve Over a year ago

This is a little strange: Do you mean txtFullName.Text instead of txtFullName?

Nirre Over a year ago

Thanx Steve, lol it was missing the .Text over looked it think i have been working to long now need a break and some sleep

Dimitri · Accepted Answer · 2012-06-18 14:28:05Z

1

string insCmd = @"INSERT COUNT(*) INTO Registration(UserName, [Password], EmailAddress, FullName, Country, PasswordRecovery)
                     VALUES (?, ?, ?, ?, ?, ?)";

Should be

string insCmd = @"INSERT INTO Registration(UserName, [Password], EmailAddress, FullName, Country, PasswordRecovery)
                     VALUES (@UserName, @Password, @EmailAddress, @FullName, @Country, @PasswordRecovery)";

I don't understand what did you want to do with COUNT. If you want to then return number of affected rows, just add return parameter and assign @@ROWCOUNT to it

Edit: I've never used question marks as parameter placeholders outside Reporting Services so try replacing them with named parameters as shown above.

edited Jun 18, 2012 at 14:28

answered Jun 18, 2012 at 14:04

Dimitri

7,0534 gold badges38 silver badges50 bronze badges

2 Comments

Nirre Over a year ago

Yeah soz my bad over looked it "Whoops" but still get the same error

Joel Coehoorn Over a year ago

You need ? rather than named placeholders for the OleDb provider.

Collectives™ on Stack Overflow

ASP.Net Error in inserting Data To OleDb

2 Answers 2

2 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related