hi,
u might wanna check out some books out there wrt to ADO.Net. Even some simple .Net and ASP.Net books from the national library should be able to answer most of your queries you've posted, should be beneficial to learn from there as it will give u proper foundation.
just my 2 cents.
Code Complete 2E, Steve McConnell:The difference between the "convenience" philosophy and the "intellectual manageability" philosophy boils down to a difference between writing programs and reading them. Maximizing scope might indeed make a program easy to write, but a program in which any routine can use any variable at any time is harder to understand than a program that uses well-factored routines. In such a program, you can't just understand only one routine; you have to understand all the other routines which that routine shares global data. Such programs are hard to read, hard to debug, and hard to modify
The melody of logic will always play out the truth. ~ Narumi Ayumu, Spiral
don't get me wrong that i'm trying to be an unkind soul, rather i'd prefer to see u learning the right way having foundation, instead of asking for quick solutions to ur problems, whereby may lead to more difficult problems maintaining ur code in the future.
there are obviously kind souls around whom already have helped u...Cheers.
eddykuan:books make me feel sleepy...i know i can find alotof resources through books, but i might say some people do not like to read books cos when they read it, they will fall asleep and im that kind of person. and also, books make searching certain question difficult.