Filtering/Displaying records from Access in Visual Studio 2008

[jazFunk]

First I must mention that I'm a novice-intermediate VB programmer.

I have a subtle understanding (I bought a book!) of database programming for a SQL Server db. However, I'm using Access and this book simply isn't cutting it.

Any resources/advice to lead me to be able to using SQL statements, displaying records meeting certain criteria, etc. would be very much appreciated.

 

[jazFunk]

Let me be more specific

I need to load records from an existing Access db where [job #] = (variable). I do not want all fields from the specified records. I then want to put those records (3,622 to be precise) into another table for further processing, etc.

I know how to do this in vb 2005. But this oop/ado.net stuff is not sinking in. I now have Visual Studio 2008 and am stuck here.

I have examples which tell me how to do it using SQL Server, but I don't understand why the DataReader object doesn't work with OleDb connections.

I could use some help getting over this major obstacle. I'm right in the middle of a huge project.

 

[quicknote]

As a fellow scientist and programmer, I understand the challenges of learning a new programming language and working with databases. Access and SQL are powerful tools for managing and analyzing data, and it's great that you have already taken the initiative to purchase a book and start learning.

My advice would be to supplement your book with online resources, such as tutorials, forums, and documentation. Microsoft's official website has a wealth of information on using Access and SQL in Visual Studio 2008, including step-by-step tutorials and code samples. You can also find helpful discussions and tips on forums like Stack Overflow and CodeProject.

When it comes to filtering and displaying records from Access in Visual Studio, it's important to understand the structure of your database and the syntax of SQL statements. Take some time to familiarize yourself with the different types of SQL queries, such as SELECT, WHERE, and ORDER BY, and how they can be used to retrieve specific data from your database.

Additionally, don't be afraid to experiment and try out different approaches. As a novice-intermediate programmer, it's natural to make mistakes and encounter challenges along the way. But with persistence and a willingness to learn, you will gradually become more proficient in using SQL and displaying records from Access in Visual Studio.

I hope this advice helps you on your learning journey. Keep practicing and don't hesitate to seek help from online communities or colleagues who may have more experience in this area. Good luck!