Why adding data to datagridview with bindingsource from dataset is blank?

Question

What i try here is, i want to Add 4 textbox to datagridview from dataset. Here is what i do,

i create a dataset and set some column with it, and then i bind the "dataset" to BindingSource which is i named them

dataset = ds1 BindingSource = bs1

then i select the datasource in datagridview with "bs1", then the column showed up, then i change the column header name. Here come my problem, i try bind 4 textbox entry to datagridview like this

    public void AddRow()
    {
        try
        {
            DataRow dr1 = dt1.NewRow();

            dr1["cnNo"] = dgv_details.Rows.Count + 1;
            dr1["cnProductID"] = txt_ProductID.Text;
            dr1["cnProductName"] = txt_ProductName.Text;
            dr1["cnQty"] = txt_Qty.Text;
            dr1["cnPrice"] = txt_Price.Text;

            dt1.Rows.Add();

            MessageBox.Show("Executed");

        }
        catch (Exception)
        {
            MessageBox.Show("Duplicate entry");
        }
    }

i should work, the row is added new, but all of the row is blank, no entry is added to datagridview, what i got is new row with blank row, what i missed here?

*cnNo here mean "cn" is column name, this is how i named them in dataset column

LarsTech · Accepted Answer · 2013-12-19 00:31:21Z

2

You need to add the row:

dt1.Rows.Add(dr1);

answered Dec 19, 2013 at 0:31

LarsTech

81.9k14 gold badges161 silver badges237 bronze badges

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

Collectives™ on Stack Overflow

Why adding data to datagridview with bindingsource from dataset is blank?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related