storing the values of a database in an array

Question

0.00/5 (No votes)

See more:

I have a visual basic form linked to a database and want to save each row and column of the database in an 2 dimensional array(,). If someone can help me with that code. The database is already linked.

Posted 15-Apr-11 1:19am

Bovell

Add a Solution

Comments

Sandeep Mewara 15-Apr-11 8:44am

Before asking for code, you should share your effort made till now.

Chris Maunder 15-Apr-11 9:30am

If the poster has made no effort to help us answer his question then report the question and move on.

Sandeep Mewara 15-Apr-11 9:38am

I did report at times and move on.
Just to notify user, I put a comment too if it helps.

Bovell 15-Apr-11 13:58pm

Thank you for your comment. I am a first year VB student; not very versed on the appropriate language needed to explain myself. I am not so much looking for the detail code but trying to understand to logic so that I can figure out the code. So please be patient with me. I chose a two 2 dim array because I am more familiar with it. To answer your question as to what I have done so far, I have a search text box that searches through a specific column and once data is found shows all the fields in that row. I then set each row to equal to array and loop through to populate the array, but when I do if statement to check array, the array is empty. Thank you for any help in understanding what I am doing wrong

OriginalGriff 16-Apr-11 10:40am

Sandeep passed your comment on to me, I think we need to see a code fragment to work out what you are doing, and what may be wrong with it!

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)

OriginalGriff · Answer 1 · 2011-04-15T02:55:00

Solution 1

It's going to depend what you mean "The database is already linked". If it is connected to a control such as a DataGridView, then just iterate though the Rows collection, and copy it to the array.

Why are you trying to do this? Given that data from the database may be any datatype, you would almost certainly have to make this an array of object - which means it is difficult to use later. Instead, consider creating a class to hold the information, and use an array (or better a List<T>) of your class rather than a two dimensional array.

[edit]Typo: "or" instead of "of" - OriginalGriff[/edit]

Posted 15-Apr-11 2:55am

OriginalGriff

Updated 15-Apr-11 2:56am

v2

Comments

Sandeep Mewara 16-Apr-11 10:32am

Comment from OP to me, sharing with you in case it helps:
Thank you for your comment. I am a first year VB student; not very versed on the appropriate language needed to explain myself. I am not so much looking for the detail code but trying to understand to logic so that I can figure out the code. So please be patient with me. I chose a two 2 dim array because I am more familiar with it. To answer your question as to what I have done so far, I have a search text box that searches through a specific column and once data is found shows all the fields in that row. I then set each row to equal to array and loop through to populate the array, but when I do if statement to check array, the array is empty. Thank you for any help in understanding what I am doing wrong