How I can Insert and Update datagrid row in using C#

Question

0.00/5 (No votes)

See more:

I am developing C# without using any framework.until now i successfully performed following task on Datagrid.
1.Displaying data in Data-grid by binding with database table
2.Getting the selected row data from Data-grid based on primary key
Here is my variable declaration :

CSS

SQLiteDataAdapter adap;
SQLiteCommandBuilder cmdbl;
DataSet ds;
String Query;
DataTable dt;

Here is code for displaying data in Data-grid :

C#

try
{
    Query = "Select * from Items";
    adap = new SQLiteDataAdapter(Query, GlobalVars.conn);
    ds = new DataSet();
    adap.Fill(ds, "Items");
    dt = ds.Tables[0];
    dtgitems.DataContext = ds.Tables[0].DefaultView;
    dtgitems.ItemsSource = dt.DefaultView;
    ds.Dispose();
    adap.Dispose();
    dt.Dispose();
}
catch (Exception ex)
{
    MessageBox.Show(ex.ToString());
}

It is working fine
and here is my code for updating that data-grid

C#

try
 {
     cmdbl = new SQLiteCommandBuilder(adap);
     adap.Update(ds, "Items");
    // ds.Tables[0].Clear();
 }
 catch (Exception ex)
 {

 }

it is not working .Does anyone knows how i can accomplish this update functionality in data-grid ? .Please help me to correct this code for update opreation .Thanks

Posted 27-Nov-13 20:18pm

Member 8840306

Updated 27-Nov-13 20:21pm

v2

Add a Solution

Comments

AnthonyMG 28-Nov-13 2:21am

Once you update your Grid , are you Refreshing the same .?

2 solutions

Add a Solution

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

Lauryx · Answer 1 · 2013-11-27T20:35:00

For inserting in a datagrid I'm using the following logic:

C#

yourDataGridView.Rows.Clear();

SqlCommand cmd = new SqlCommand(YourSqlQuery, dbConnection);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
     yourDataGridView.Rows.Add(dr[0].ToString(), (bool)dr[1], (int)dr[2]);
}
dr.Close();

If you're working with differen threads, collecting the data, you could add the data from the SqlDataReader into a DataTable and pass it to your UI Thread to fill the DataGrid.

For updating single values of your DataGrid you could use something like this:

C#

yourDataGridView.Rows[RowIndex].Cells[CellIndex].Value = yourNewValue;

Debopam Pal · Answer 2 · 2013-11-27T20:57:00

Solution 2

Hi! See this Article. It will help you.

Posted 27-Nov-13 20:57pm

Debopam Pal

How I can Insert and Update datagrid row in using C#

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

How I can Insert and Update datagrid row in using C#

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us