Import records from database to application variables

Question

0.00/5 (No votes)

See more:

Hello all,

Now this is either too simple to be asked by anyone, or its impossible, as ive been trawling google and can only find how to do it the other way around (i.e. send data TO a database)

I want to import each field in each row into a specific text box, but cannot for the life of me work it out. Suuuuurely this is fairly simple to do?

Sorry if it is a horrifically simple solution and im being a muppet, but thanks in advance for any help

Posted 12-Aug-11 0:57am

Member 8113010

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)

Wendelius · Accepted Answer · 2011-08-12T01:07:00

Solution 1

So if you do a query into a datatable, something like

SELECT * FROM MyTable

you will get basically a collection of rows with same amount of columns on each row. If you now loop through the Rows and Columns collections and add the values to an array of textbox's, wouldn't that work? Something like (pseudo):

Fill a datatable with a query
foreach datatable.row {
   foreach datatable.column {
      textboxlist.add(new textbox() {Text = Row.Column.Value })
   }
}
Place the textboxes to the form

Posted 12-Aug-11 1:07am

Wendelius

Updated 12-Aug-11 1:09am

v2

Comments

sk saini 12-Aug-11 7:27am

Accurate answer.

Wendelius 12-Aug-11 11:41am

Thanks :)

Member 8113010 16-Aug-11 3:19am

I have attempted to do this, but it seems not to work. Could anyone provide a sample code in c#? thanks for the solution, im sure it is exactly what i need i just cant work it out at the moment

Member 8113010 17-Aug-11 7:10am

nevermind, worked it out, and came up with a solution very similar to yours. thanks!

Wendelius 17-Aug-11 9:14am

Glad it got solved :)