How to add row in DataGridView programmatically

Question

Here I've tried this code. But, my problem now is that, it doesn't display any data.

Here is my code

try
{
    DataTable dt = new DataTable();
    con.Open();

    dt.Load(new MySqlCommand("SELECT variant_name FROM tblVariant_Product WHERE product_name='" + cboProduct.Text + "'", con).ExecuteReader());

    DataColumn col = dt.Columns.Add(new DataColumn("Quantity", typeof(Int32));
    col.AllowDBNull = false;

    DataRow row = dt.NewRow();
    row["variant_name"] = "TOTAL";
    row["quantity"] = 0;
    dt.Rows.Add(row);

    dataGridView2.DataSource = dt;
    con.Close();
}
catch (Exception)
{
}

@DevProve after typing the datagridview2 and the period the databind does not show in the intellisense instead it shows DataBindings and DataBindingComplete. — Harvey
– Harvey, Commented May 15, 2013 at 3:56

NeverHopeless · Accepted Answer · 2013-05-28 06:37:36Z

3

Write:

dt.AcceptChanges();

after:

dt.Rows.Add(row);

edited May 28, 2013 at 6:37

NeverHopeless

11.2k4 gold badges37 silver badges56 bronze badges

answered May 15, 2013 at 5:58

Abhishek B Patel

94510 silver badges14 bronze badges

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

11 Comments

Harvey Over a year ago

The same, and I double check in my database table tblVariant_Product that it has data but when I run the program it doesn't display that data. Why is that?

Abhishek B Patel Over a year ago

Please check dt in QuickWatch at this dt.Load(new MySqlCommand("SELECT variant_name FROM tblVariant_Product WHERE product_name='" + cboProduct.Text + "'", con).ExecuteReader()); at debug time is datatable(dt) contains data at this point?

Harvey Over a year ago

Sorry I'm a beginner in using visual studio, so how would I know that dt contains data?

Abhishek B Patel Over a year ago

add debug point using F9 key at this line and run the application

Harvey Over a year ago

Okay I'm already running the application and the line is highlighted with the cursor blinking and after that?

|

NeverHopeless · Accepted Answer · 2013-05-28 06:37:48Z

0

To add column:

dt.Columns.Add(new DataColumn("ColumnName",Type.GetType("System.String")));

and its better to remove the it first:

dataGridView2.DataSource = dt;

edited May 28, 2013 at 6:37

NeverHopeless

11.2k4 gold badges37 silver badges56 bronze badges

answered May 15, 2013 at 4:16

DevProve

1921 silver badge16 bronze badges

6 Comments

Harvey Over a year ago

No it has two columns variant_name and Quantity, whereas the Quantity is the one that I've added in datagridview2 property.

Harvey Over a year ago

Okay I get it...I think I know the error. So now I have a question if you don't mind, what is the syntax for adding a column in datatable?

Harvey Over a year ago

It doesn't display any data, anyway I updated my question already.

DevProve Over a year ago

Check your cboProduct.Text it maybe null

Harvey Over a year ago

I don't think so because it's functioning previously.

|

Abhishek · Accepted Answer · 2015-09-16 11:46:56Z

0

try{
    DataTable dt = new DataTable();
    con.Open();

    dt.Load(new MySqlCommand("SELECT variant_name FROM tblVariant_Product WHERE product_name='" + cboProduct.Text + "'", con).ExecuteReader());

    dt.Columns.Add(new DataColumn("Quantity", typeof(Int32));

    DataRow row = dt.NewRow();
    row["variant_name"] = "TOTAL";
    row["quantity"] = 0;
    dt.Rows.Add(row);

    dataGridView2.DataSource = dt;
    con.Close();
 }
 catch (Exception)
 {
 }

edited Sep 16, 2015 at 11:46

Abhishek

2,9354 gold badges38 silver badges62 bronze badges

answered May 15, 2013 at 7:22

Harvey

3794 gold badges15 silver badges35 bronze badges

Collectives™ on Stack Overflow

How to add row in DataGridView programmatically

3 Answers 3

11 Comments

6 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

11 Comments

6 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related