bindingsource.addnew()

[p_nivalis]

I have a datagridview and a few textboxes bound to a dataset.

da.Fill(dsBox, "tblStuff")
bs.DataSource = dsBox
bs.DataMember = "tblStuff"
 
dgvBox.DataSource = bs
txtTitle.DataBindings.Add("Text", bs, "Dogs")
Controls.Add(txtTitle)

I have buttons on the form to remove, add, save, etc., but I am having troubles getting it to add. Deleting and saving records to the dataset works fine, but I can't get add to work.

I am using bs.addnew() to add a new record.

The following is hard to follow, but this is what happens:
When I click on the button for bs.addnew() it is supposed to clear out the textboxes that are bound but it does not. A new record is added at the end of the datagridview, but it does not select like it like it is supposed to. When I scroll down to the new record and select it, I see in the textboxes that it contains data from the first record in the table, but in the datagridview it shows all the columns as being empty. What is going on here?

 

[lingsn]

Well, that's strange, I had try to simulate whatever you had said in the above code (except Controls.Add(txtTitle)), and it works fine.

 

[JuggaloBrotha]

Private bs As BindingManagerBase = Me.BindingContext(dsBox, "tblStuff")

then use bs.AddNew() in a button