Filtering/Displaying records from Access in Visual Studio 2008

  • Thread starter Thread starter jazFunk
  • Start date Start date
  • Tags Tags
    Visual
Click For Summary
SUMMARY

This discussion focuses on filtering and displaying records from an Access database using Visual Studio 2008 with VB.NET. The user seeks guidance on executing SQL statements to retrieve specific records based on a variable condition, specifically where [job #] equals a certain value. The goal is to transfer these records into another table for further processing. The user expresses difficulty in adapting from VB 2005 to the Object-Oriented Programming (OOP) and ADO.NET paradigms in Visual Studio 2008, particularly regarding the use of the DataReader object with OleDb connections.

PREREQUISITES
  • Understanding of Visual Basic .NET (VB.NET) programming
  • Familiarity with Microsoft Access database structure
  • Knowledge of ADO.NET for database connectivity
  • Basic SQL query construction for data retrieval
NEXT STEPS
  • Research how to use OleDbConnection and OleDbCommand in ADO.NET
  • Learn about executing SQL SELECT statements with parameters in Access
  • Explore the differences between DataReader and DataSet in ADO.NET
  • Investigate methods for transferring data between Access tables programmatically
USEFUL FOR

This discussion is beneficial for novice to intermediate VB.NET programmers, database developers working with Microsoft Access, and anyone transitioning from SQL Server to Access database management in Visual Studio 2008.

jazFunk
Messages
12
Reaction score
0
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.
 
Technology news on Phys.org
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.
 

Similar threads

Java Android Studio: Accessing SQLite Data In RecyclerView
  • · Replies 1 ·
Replies
1
Views
4K
I could really use some help picking my optional module [GameDev]
  • · Replies 2 ·
Replies
2
Views
3K
The Scientist as Hero - or not
  • · Replies 1 ·
Replies
1
Views
4K