I've got some coding (or maybe database connection settings) issues that I cannot figure out in a VB.net program.

I want to connect a DBgridview with an access database where I can edit information in the grid and then click a button and have it save the grid information into a database (modifying records, not adding them)

I know how to write the SQL, it's just the VB.net stuff that confuses me

Can someone knowledgeable with VB.net PM me if they think they can help?

7/12/2010 10:33:04 PM

did you have trouble with the form designer

7/12/2010 10:38:14 PM

Are you using a joined query (getting data from multiple tables) or are you selecting all columns from a single table? If its the former then you have to manually create the update/insert/delete portions of the TableAdapter. If it is the latter, then it should be done automatically when you drag the DataSource to the form designer and it creates the databound DataGridView.

Beth Massey has some great video tutorials for learning basics of ado.net/data stuff (and lucky for you she did all the videos in VB).
http://msdn.microsoft.com/en-us/vbasic/bb466226.aspx#formsoverdata_08

[Edited on July 13, 2010 at 12:26 AM. Reason : .]

7/13/2010 12:20:43 AM

if you think it's a connection string issue, take a look at http://connectionstrings.com/access-2007 or http://connectionstrings.com/access to see if you got it right

other than that, the form designer should take care of most of it for you

[Edited on July 13, 2010 at 12:50 AM. Reason : boo access. boo vb. boo forms designer]

7/13/2010 12:49:15 AM

i can help

7/13/2010 2:06:20 AM

These threads may help some:

http://www.eggheadcafe.com/community/aspnet/14/10088392/update-gridview-problem.aspx
http://www.eggheadcafe.com/community/aspnet/14/10088603/gridview-update-.aspx
http://social.msdn.microsoft.com/Forums/en-US/Vsexpressvb/thread/75a3f123-09c9-4fec-9f2b-2d0883b53bdd


Also if you haven't visited http://stackoverflow.com it's a great place to post programming questions

7/13/2010 3:16:01 PM