Calling access 2007 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). For instance I know how to call a db record when clicking (lets say Button1) e.g.

C#

Button1_Click(object sender, EventArgs e)
{
    //to do database stuff.....
}

but this is not the case I want.

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 9-Dec-10 13:56pm

LAPEC

Updated 9-Dec-10 14:57pm

Henry Minute

v3

Add a Solution

Comments

Henry Minute 10-Dec-10 7:01am

If you follow the link on 'parameterized query' you will see a code example.

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)

Henry Minute · Accepted Answer · 2010-12-09T15:10:00

One way is to load the data into a DataTable/DataSet (you say you know how to do this) in the Form.Load event.

Then, still in Form.Load, get the value you want to use, ID say or Name, from each record and use that value as the Text of each button. Then dispose of the DataTable/DataSet.

Then when a button is clicked use a parameterized query[^] (scroll down till you hit the Select section.)

The main difference in your situation is that you would use

C#

cmd.Parameters.AddWithValue("ID", Button.Text);

Hope this helps. :)