Update the sqlite from datagrid using c#

Question

I am able to open the data grid connection , Now in data grid after opening i want to update particuar value through text box. But how should I update using grid.

Below is the code

    private void button3_Click(object sender, EventArgs e)
    {
        SQLiteConnection connection4 = new SQLiteConnection(@"Data Source = C:\foo.sqlite;Version =3");
        connection4.Open();
        string sql2 = "Update Table set language1= '" + textBoxUpdate1.Text + "' where language1 = '" + textBox_Search.Text + "'";
        SQLiteDataAdapter connect4 = new SQLiteDataAdapter(sql2, connection4);
        DataSet ds4 = new DataSet();
        connect4.Fill(ds4);
        dataGridView.DataSource = ds4.Tables[0];
    }

Data grid view

From the image i want to say that i want to update the language 2 , so i will type in the second text box where in the update statement i will set but "where" i want to choose where the user highlights in the data grid , below is the update table where datagrid selection is there , at that place i want data grid selected

like

    string sql2 = "Update Table set language1= '" + textBoxUpdate1.Text + "' where language1 = '" + DATAGrid Selection + "'";

Is this possible?

Don't forget to dispose of your SQLiteConnection. Suggest wrapping this code in Using — Ian Quigley
– Ian Quigley, Commented Nov 21, 2012 at 11:17

tcshao · Accepted Answer · 2012-11-20 16:58:08Z

1

The DataGridView exposes properties you can examine to pull out what is selected. You can find more information in this MSDN Link

answered Nov 20, 2012 at 16:58

tcshao

1462 bronze badges

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

Comments

Sohail · Accepted Answer · 2012-11-21 13:35:37Z

0

Run the below code to edit particular thing from the grid. Just edit at the grid and press the update button. Form the below code you can edit the particular row by editing on it and press the update button

  private void button3_Click(object sender, EventArgs e)
    {
        DataTable dt = dataGridView.DataSource as DataTable;
        for (int i = 0; i < dt.Rows.Count; i++)
        {
            if (dt.Rows[i].RowState == DataRowState.Modified)
            {
                MessageBox.Show(dt.Rows[i][3].ToString());
            }
        }

answered Nov 21, 2012 at 13:35

Sohail

7903 gold badges14 silver badges28 bronze badges

Collectives™ on Stack Overflow

Update the sqlite from datagrid using c#

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