How to Call Access 2007 db records dynamically from Form1

Question

0.00/5 (No votes)

See more:

Dear Sir/Madam

I have created a C# Project with couple of Forms inside this project. In one particular form (lets say Form1) I have 10 Buttons. I also created a Access 2007 DataBase and inside this database I have a table with 10 records.

Now my question is:

Is there a possibility to call these 10 database records dynamically from Form1 (but not one-by-one).

What I mean is I dont want to create for every button event an opening db conn, exec query, and so on. So basically what I want is: the 10 buttons that I have in my form to create one sql query (lest say like an array query) so when I click button1 to get the rocord1 from db table and displayit in to my list view, same for button2, button3 and so on...

Basically what I want is, when Form1 Loads (where inside this form are 10 buttons) to create an SQL Query, get those 10 records from database, and each button I click I want that db record to match the corresponding button and display that record on my list view.

Kind Regards

Agron

Posted 10-Dec-10 1:45am

LAPEC

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

E.F. Nijboer · Answer 1 · 2010-12-10T01:52:00

Have you tried anything?

If you would simply select the records with an sql statement like select * from myTable order by button_id then you will get a recordset with all the records. You could simply get the row you want because all the rows are available in the recordset.

http://www.sqlselect.org/cs-sql-select-access.html[^]

Good luck!