Filtering/Displaying records from Access in Visual Studio 2008

  • Thread starter Thread starter jazFunk
  • Start date Start date
  • Tags Tags
    Visual
AI Thread Summary
The discussion centers on the challenges faced by a novice-intermediate VB programmer who is transitioning from SQL Server to Microsoft Access for database programming. The user seeks guidance on using SQL statements to load specific records from an Access database based on a job number variable, without retrieving all fields. They need to transfer approximately 3,622 records into another table for further processing. Despite having experience with VB 2005, the user is struggling with object-oriented programming concepts and ADO.NET in Visual Studio 2008. They express confusion over the DataReader object and its compatibility with OleDb connections, highlighting a critical need for resources or advice to overcome these obstacles in their ongoing project.
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.
 

Thread 'Learning Assembly and computer architecture for x86'

Dear Peeps I have posted a few questions about programing on this sectio of the PF forum. I want to ask you veterans how you folks learn program in assembly and about computer architecture for the x86 family. In addition to finish learning C, I am also reading the book From bits to Gates to C and Beyond. In the book, it uses the mini LC3 assembly language. I also have books on assembly programming and computer architecture. The few famous ones i have are Computer Organization and...
View full post »

Thread 'Learning data structures and algorithms in different programming languages'

I have a quick questions. I am going through a book on C programming on my own. Afterwards, I plan to go through something call data structures and algorithms on my own also in C. I also need to learn C++, Matlab and for personal interest Haskell. For the two topic of data structures and algorithms, I understand there are standard ones across all programming languages. After learning it through C, what would be the biggest issue when trying to implement the same data...
View full post »

Similar threads

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

Hot Threads

Recent Insights

Back
Top