How to update specific columns of access database using datagridview column name in C#

Question

I have a datagridview that it's columnNames are equal to my columns in access database

Now I want this: whene user click on savebtn all of datagridview columns values automatically updated to my database,
I've tried this code but it get me syntax error :

{"Syntax error (missing operator) in query expression '@1Where FeedID=@feedID'."}

where is the problem?

public void UpdatetFeeds(DataGridView dgv)
{
    string StrCon = System.Configuration.ConfigurationManager.ConnectionStrings
    ["FeedLibraryConnectionString"].ConnectionString;

    int FeedID = Convert.ToInt32(dgv.CurrentRow.Cells[0].Value);

    using (OleDbConnection Connection = new OleDbConnection(StrCon))
    {
        Connection.Open();

        using (OleDbCommand Cmd = new OleDbCommand())
        {
            Cmd.Connection = Connection;

            foreach (DataGridViewColumn column in dgv.Columns)
            {
                string columnName = dgv.Columns[column.Index].Name;
                object columnValue = dgv.CurrentRow.Cells[column.Index].Value;

                Cmd.CommandText = @"Update tFeeds Set " + columnName + " =@"
                    + columnValue + "Where FeedID=@feedID";

                Cmd.Parameters.Add("@feedID", OleDbType.Integer).Value = FeedID;


                Cmd.ExecuteNonQuery();
            }
        }
     }
 }

VadimB · Accepted Answer · 2016-12-29 16:48:12Z

1

Seems at least you lost space

" Where FeedID=@feedID";

Also, what kind of data you have here: " =@" + columnValue + ". Seems you need braskets here: " =@'" + columnValue + "'

answered Dec 29, 2016 at 16:48

VadimB

5,7213 gold badges39 silver badges49 bronze badges

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

3 Comments

SaraniO Over a year ago

yes I lost that space and after that code executed, But instead of updating cell bu column value, cell updated with FeedID parameters value

SaraniO Over a year ago

data type are string, int and double, it's okay that I use a object? or not?

VadimB Over a year ago

But you have only one parameter @feedId. If columnValue is string - you need bradkets. So brtter add one more parameter to avoid problems with data types. And use columnName = @feedValue. New param: Cmd.Parameters.Add("@feedValue", ...

Collectives™ on Stack Overflow

How to update specific columns of access database using datagridview column name in C#

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related