Daven81

i don't think i use dataview. ok, it's like this, when i press the add button, my database will be updated. the coding runs fine. but the text boxes that i use to display data is not updated. i think it's because i call the values when i load the form. so after i add a new record the displayed data is still the same. so do i need to refresh the data or connection to the textbox?

yes i do. on another form i use the same coding and can add the data

guys i have a problem here.i am using vb.net and i have bind my textbox with data from my table and can display it, then i add a new record with the usual add command, but the record in the textbox didn't update( which the total record is still not added and i cannot find the record). however, in my database the record is added. When i close my vb and oepn it again, the data shows. should i close my connection and open it again? how? please help.

guys i encounter an error like this when i try to add a new record and i don't understand it. i am using vb.net with sqlserver "An explicit value for the identity column in table 'supplier' can only be specified when a column list is used and IDENTITY_INSERT is ON." please help