Deepa
New member
- Joined
- May 9, 2006
- Messages
- 4
- Programming Experience
- Beginner
I have an table with a single colum in MSAccess.I have used the wazard to create dataset ..etc and connected it to my datagridview. this displays all the existing records
WHAT I DID:- i have used the foll code to add new records to the above table
WHAT HAPPENS in VB:- I can see the data ("AAA") being added to the datagrid..no eorror
WHAT HAPPENS IN Access:- it still has the same number of records.. the new additions ("AAA") is not added. hence when i close the vb form and run again..the datagrid shows only the records present before adding the "AAA" via code
Please help me to add-update to access - retiveit back in VB
I am sure that i might be missing smothing here..just cant put my finger to it
help me please
Thank you
WHAT I DID:- i have used the foll code to add new records to the above table
VB.NET:
Dim NEWrow As DataRow = MYTESTDataSet.Tables("MYTABLE").NewRow()
NEWrow(0) = "AAA"
MYTESTDataSet.Tables("MYTABLE").Rows.Add(NEWrow)
MYTESTDataSet.Tables("MYTABLE").AcceptChanges()
WHAT HAPPENS in VB:- I can see the data ("AAA") being added to the datagrid..no eorror
WHAT HAPPENS IN Access:- it still has the same number of records.. the new additions ("AAA") is not added. hence when i close the vb form and run again..the datagrid shows only the records present before adding the "AAA" via code
Please help me to add-update to access - retiveit back in VB
I am sure that i might be missing smothing here..just cant put my finger to it
help me please
Thank you