Getting database records into an array

Question

Hi there,

I'm new here, so this is my first post ;)

I've got a problem to get my database content into an array, in fact I don't have a clue how to do it :-s. It's the plan to process all the records and to put the content of those recors in the array. Can someone tell me how to do it? Thanks in advance!

This is the code that I have, for the moment I have hardcoded the array, but it's the purpose to fill the array with the database content.

string MainSQL =
"select id, firstname, surname, gender, email, telephone, city +
"from persoon";

string[,] persons= new string[2, 7];

persons[0, 0] = "1"; (id)
persons[0, 1] = "Jef"; (firstname)
persons[0, 2] = "Maes"; (surname)
persons[0, 3] = "male"; (gender)
persons[0, 4] = "jef@jef.be"; (email)
persons[0, 5] = "123/456789"; (telephone)
persons[0, 6] = "Testegem"; (city)

persons[1, 0] = "2";
persons[1, 1] = "Koen";
persons[1, 2] = "Mertens";
persons[1, 3] = "male";
personen[1, 4] = "koen@koen.be";
persons[1, 5] = "123/456789";
persons[1, 6] = "Testegem";

P.S. Excuse me for my bad english.

Len La Sala · Answer

I assume that you want to dynamically fill the array with field data from a table without knowing its structure :-) To put data from a table into an array you need to know a few things in order to properly deal with the type of data you are putting into the array cell. //the struct to hold data and field info. public struct databaseRecord{ public int ordinal; //position of field in table public string fName; //the field name public int dataType; //the data type for casting public object fData; //the data from field in table } //the array databaseRecord[] dbArray ; //resize array Array.Resize(ref DBRecord, DBRecord.Length +1); //assign values While(Reader.Read()) { Array.Resize(ref DBRecord, DBRecord.Length +1); DBRecord[DBRecord.Length -1].ordinal = //get from table DBRecord[DBRecord.Length -1].fName = //get from table DBRecord[DBRecord.Length -1].dataType = //get from table DBRecord[DBRecord.Length -1].fData = //get from table } fData declared as object, this allows you to cast the obeject to whatever you want eg. TextBox1.Text = DBRecord[index].fData.ToString(); //this is simple stuff but you might want to make life a bit easy and let a function do most of the work for you. TextBox1.Text = getFielData(DBRecord, index); //the function public string getFieldData(databaseRecord r, int index) { switch r[index].datatype { case int: //check for valid data types return(r[index].fData.ToString()); break } } There is a fair bit of work to do to establish the fundamental frame work but will be worth it, I know this works because I use similar, but more complex methodes in my controls, see www.c-sharplizards.com Hope this helps.

Getting database records into an array

Answers (1)