Why I get Syntax error in INSERT INTO statement?

Question

protected void btnUpload_Click(object sender, EventArgs e)
{
    if (FileUpload1.PostedFile != null)
    {
        string FileName = Path.GetFileName(FileUpload1.PostedFile.FileName);
        //Save files to disk
        FileUpload1.SaveAs(Server.MapPath("" + FileName));

        //Add Entry to DataBase
        String strConnString = System.Configuration.ConfigurationManager.ConnectionStrings["conString"].ConnectionString;

        OleDbConnection con = new OleDbConnection(strConnString);

        string strQuery = "INSERT INTO image([FileName],[FilePath],[AlbumName]) Values(@FN, @FP, @AN)";

        OleDbCommand cmd = new OleDbCommand(strQuery);

        cmd.Parameters.AddWithValue("@FN", FileName);
        cmd.Parameters.AddWithValue("@FP", "images/" + FileName);
        cmd.Parameters.AddWithValue("@AN", txtAlbumname.Text.ToString());

        cmd.CommandType = CommandType.Text;
        cmd.Connection = con;
        try
        {
            con.Open();
            cmd.ExecuteNonQuery();
        }

        catch (Exception ex)
        {
            Response.Write(ex.Message);
        }

        finally
        {
            con.Close();
            con.Dispose();
        }
    }
}
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
    string var = DropDownList1.SelectedItem.ToString();
    txtAlbumname.Text = var.ToString();
}
}

I Have tried almost everything , but this error keeps on coming. I have put on the brackets aswell incase of reserved words but still this error is showing

try it INSERT INTO image(FileName,FilePath,AlbumName) Values(@FN, @FP, @AN)"; — Khurram Ali
– Khurram Ali, Commented Sep 29, 2014 at 9:53
@ByteBlast I Have Already Included The Error That Syntax Error In Inser INto Statement — Zeeshan Rizvi
– Zeeshan Rizvi, Commented Sep 29, 2014 at 9:57
Could you try to replace the parameter names in the query by question marks (VALUES (?, ?, ?))? Could be OleDbQueries have a problem replacing named parameters. Please make sure that your AddWithValue lines are in the required order for this to work. — Thorsten Dittmar
– Thorsten Dittmar, Commented Sep 29, 2014 at 10:01

Shekhar Pankaj · Accepted Answer · 2014-09-29 10:26:02Z

1

The OLE DB .NET Provider does not support named parameters for passing parameters to an SQL statement or a stored procedure called by an OleDbCommand when CommandType is set to Text. In this case, the question mark (?) placeholder must be used. For example:

SELECT * FROM Customers WHERE CustomerID = ?

Therefore, the order in which OleDbParameter objects are added to the OleDbParameterCollection must directly correspond to the position of the question mark placeholder for the parameter in the command text.

For Example

OleDbCommand command = new OleDbCommand(queryString, connection);
command.CommandText = 
    "SELECT CustomerID, CompanyName FROM Customers WHERE Country = ? AND City = ?";
command.Parameters.Add(parameters);

for (int j=0; j<parameters.Length; j++)
{
    command.Parameters.Add(parameters[j]) ;
}

for reference .. MSDN

answered Sep 29, 2014 at 10:26

Shekhar Pankaj

9,1453 gold badges31 silver badges49 bronze badges

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

Comments

Gord Thompson · Accepted Answer · 2014-09-29 10:57:52Z

0

IMAGE is a reserved word in Access SQL so to use it as a table name you must also enclose it in square brackets:

string strQuery = "INSERT INTO [image] ([FileName], ...

answered Sep 29, 2014 at 10:57

Gord Thompson

125k38 gold badges251 silver badges458 bronze badges

Collectives™ on Stack Overflow

Why I get Syntax error in INSERT INTO statement?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related