ADO.NET in VB.2005 101, Applied Version Please (i.e. I can make NorthWind, Microsoft's famous Export Traders Database)

I am a programmer in VB6 and Access STILL unforntunally.  I was wondering if anyone had any Good examples of Data-Binding; from one Table, many Tables,  heirachtical data, like Order and LineItems in Order.  Using Data Objects and Code ways of ADO.NET)

Will be later seperated into more questions.

Thank You

PC_tech22Asked:
Who is Participating?
 
newyuppieCommented:
you can download and examine several samples from microsoft specifically for ADO.NET
http://msdn.microsoft.com/data/prev/downloads/samples/
0
 
PC_tech22Author Commented:
I will get a chance to look at these.  Is there one good example of each that you can directly point me to.  Like Binding a Form tblInventory or something
0
Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

 
PC_tech22Author Commented:
I used the way of draging textboxes from the Data Source Viewer. Now how do I query the recordset that is Generated.
0
 
newyuppieCommented:
when you use that Drag and Drop way it automatically creates a few objects in the form which can be seen at the bottom of the form in the visual designer view. typically they will be a Dataset, a BindingSource and a BindingNavigator. you will need to get familiarized with the newer terms, as Dataset replaces your notion of Recordset. i would recommend you buy any ADO.NET book for beginners in any case, or read maybe
http://www.developer.com/net/vb/article.php/10926_1540311_1
for a brief introduction to new terminology.

what exactly do you want to do, what do you mean you want to query the recordset. what type of query, etc. in the drag and drop case there is an automatic binding of the textboxes to the data source so if you compile and run the project as is, it will work. if you need any more different questions you should probably have to be more specific about a problem, and post them separately.

hope this helps
NY
0
 
PC_tech22Author Commented:
Hi newyuppie,


This question explains more about the querying
http://www.experts-exchange.com/Programming/Programming_Languages/Dot_Net/VB_DOT_NET/Q_22051300.html


I will need to look at this and break it up futher into more questions and award points, but above is one question.
0
 
PC_tech22Author Commented:
Also if you guys have any ideas how to break off more questions.
0
 
newyuppieCommented:
theres no way to break a question in 2 automatically. you would need to post a new question and if you decide to delete any previous questions you need to ask support to do that
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.