SOFTWARE MANAGER   Posted by: BUNYAMIN on Wednesday, September 18, 2002

PERFECT CODE. THANK YOU VERY MUCH.

Exactly what I've been searching for! THANK YOU!   Posted by: JRF on Tuesday, February 11, 2003

Msdn should be ashamed for not incorporating localized MS Access database access for VB.Net sample source code. THANK YOU for providing a terrific example from which people can learn.

thanx a lot   Posted by: toko on Tuesday, April 15, 2003

have been reading a lot of stuff while searching for some helpful hints on the DataGrid control. What others didn't manage to make clear in hole articles you make understandable clear in maybe 2 lines of your comment. really cool!

Excellent!!! Very helpful indeed!!!   Posted by: Christos on Friday, May 16, 2003

First of all my congatulations!!! excellent example!!! Has been most helpfull :)

But...

I am refering to "Wizard Bound Controls"

Senario 1
It seems that (after ofcourse having clicked on "Use" button) and while i see a record (let's say "Smith Allen" ContactID 2) if I click Add and then Update I get an exact copy of the record with the new ContactID (so far everything is perfect)

Senario2
While I'm viewing the same record (ContactID 2) if I change the data (lets say the "Name" from "Smith Allen" to "John Doe" etc), and then click "Add" and "Update", the result is that I indeed get a new datarow (ContactID 5, Name John Doe) but the datarow with contactID 2 has also changed.

My question is:
How do I enter a new record without affecting any other records???
Do I have to un-bound all text boxes from the datasource and re-bound them after the procedure is completed??? (I believe there has to be an easier way, but...)

Any ideas???

thnx a lot, and... pls excuse any mistakes... My English R quite rusty :)

thanx you.. You save my life...   Posted by: ondierules on Monday, November 17, 2003

thanx!!!! i want to know, microsoft excel Automation!! God Bless...

ADO.NET - A BETTER EXAMPLE   Posted by: Jean Basquiat on Friday, November 28, 2003

Outstanding Example! I love you! I wish I found your example hours ago! Now I can go eat dinner!

What a beatuful code   Posted on Wednesday, January 07, 2004

realy beautyful your code
thx

Sweet   Posted on Thursday, January 22, 2004

Many, many thanks!

A good work   Posted on Monday, February 02, 2004

I've been searching a example like this for all the web and this is the one. Thank you very much.

Wicked Code   Posted by: PoTe on Thursday, May 20, 2004

Nice Code, I`m a student starting to learn VBDotNet. Got any more examples for me?
(ODBC)

GOOD. I get what I needed to know.   Posted on Monday, August 09, 2004

Thanks for posting this code. Now I know how to do somethings I was trying to do.

Very nice.   Posted by: Sharjeel on Sunday, September 26, 2004

But add a readme with explanation.

best code   Posted by: isaac sakala on Sunday, October 10, 2004

i think the code is really good and has helped me a lot

PERFECT AND CLEAR!   Posted by: Alex on Monday, March 21, 2005

This code is realy - short and clear representation of ADO.NET

Nice but Add Record Glitch   Posted by: John on Tuesday, June 21, 2005

I finally thought I'd found a decent example of accessing an MS Access database - well this is the best so far, but I am having the same 'add record' problems as Christos (Above). Anyone have any ideas on what the problem is, how to rectify it?

I haven't done any VB programming in about 4 years, and the jump from VB6 data access to ADO.NET is leaving me for dead at the moment :(

Helped me alot   Posted by: willow on Saturday, September 03, 2005

l was looking for a example, that showed how to bind text boxes to a dataset, this was the best one l found. thank-you

very goooood example   Posted by: Tarik on Tuesday, May 16, 2006

This is realy very good example and helpfull
please keep doing the good things
thank you very much

good code   Posted on Tuesday, June 13, 2006

suitable and easily understandable code

Still useful in 2006 !   Posted by: Andrew on Saturday, October 21, 2006

Thanks, this has helped a great deal!

Still useful in 2006 !   Posted by: Andrew on Saturday, October 21, 2006

Thanks, this has helped a great deal!

ADO.NET - A BETTER EXAMPLE   Posted by: Del Hundley on Saturday, November 11, 2006

This is excellent and I helped me tremendously. thanks to the author

Mr   Posted by: NickO on Wednesday, November 15, 2006

Come MSDN support and learn about the "smack on" answer: straight, to the point and when it is needed.
May be share the fees we are paying with the author.

Nicko

PS.
... and no hidden agenda either!

Comment   Posted by: mekala on Sunday, January 28, 2007

It's is very usefull to me .... but it need to be give in coding lines

This is very useful   Posted by: Chintan Hiremath on Saturday, February 03, 2007

This is very useful, plz keep this for a very long time, or plz do not remove this from the site!