Comments by bgcwaterman

bgcwaterman 26-Mar-21 12:29pm View

I added the following and it didn't work.

'clear the dataset before filling
Me.MubsDataSet.Clear() <--------added this line
'refill the table adapter from the dataset table
Me.TblReadingsTableAdapter.Fill(Me.MubsDataSet.tblReadings)
'clear out the datasource for the Grid view
Me.DataGridView1.DataSource = Nothing
'reset the datasource from the binding source
Me.DataGridView1.DataSource = Me.TblReadingsBindingSource
'should redraw with the new data
Me.DataGridView1.Update()
Me.DataGridView1.RefreshEdit()

bgcwaterman 26-Mar-21 12:24pm View

Deleted

I added the following and it didn't work.

Try
'clear the dataset before filling
Me.MubsDataSet.Clear()
'refill the table adapter from the dataset table
Me.TblReadingsTableAdapter.Fill(Me.MubsDataSet.tblReadings)
'clear out the datasource for the Grid view
Me.DataGridView1.DataSource = Nothing
'reset the datasource from the binding source
Me.DataGridView1.DataSource = Me.TblReadingsBindingSource
'should redraw with the new data
Me.DataGridView1.Update()
Me.DataGridView1.RefreshEdit()

bgcwaterman 23-Mar-20 20:23pm View

I am using the Leave event. I see I need to change it to a Validating event..

bgcwaterman 20-Feb-20 15:29pm View

That did it.
Thanks...

bgcwaterman 6-Feb-20 10:42am View

Got it to work. I just need to setup what I want to do with the handler... The strange thing is I have to go to each control to set the handler because if I select multiple controls the "TextChanged" event doesn't shop up.... thanks...

bgcwaterman 6-Feb-20 10:24am View

I found the "events" button... Sorry for my inexperience. Thanks.

bgcwaterman 6-Feb-20 10:21am View

I don't have a "Events" button in the properties window after I select the textboxes.

bgcwaterman 6-Feb-20 10:08am View

How would you do the IDE method? thanks

bgcwaterman 6-Feb-20 9:57am View

The textboxes are in group boxes. I will need to figure out how to do this for text boxes in group boxes.

bgcwaterman 30-Jan-20 9:40am View

Thank for all the help. I replaced the WHERE to ON. Still didn't work. I Read the article I noticed they were using INNER JOIN and not just JOIN. So I Replaced the JOIN and it got me past the Error. Now I will have to get it to the Datagrid.

bgcwaterman 5-May-19 8:34am View

Thanks to all that did the trick. I did some reading on the StringBuilder and it is what I need to use. I will put that in the code. Thanks again...

bgcwaterman 5-May-19 8:33am View

Deleted

Thanks Gerry that did the trick. I did some reading on the StringBuilder and it is what I need to use. I will put that in the code. Thanks again...

Comments by bgcwaterman (Top 12 by date)