C# : optimal dataretrieval.

[Airslash]

Hello,

I'm working on a database application to retrieve and manipulate data from the database. Currently I'm retrieving information about persons and dispay that in a combobox by using a custom class I wrote. Basicly it's just a container that has all the information about a person and a to string method to display it in the combobox.

Now I'm looking for a way that allows me to retrieve the information from a Person fast and clean so I can display it. I've been using custom written DAO objects, but they were slow.

I also need to mention, that the table Person contains links to Country, Status, Category and other related tables. So that information should be accessible as well, because I would like to display Country: England for example instead of Country : 3.

[dip_developer]

Hello,

I'm working on a database application to retrieve and manipulate data from the database. Currently I'm retrieving information about persons and dispay that in a combobox by using a custom class I wrote. Basicly it's just a container that has all the information about a person and a to string method to display it in the combobox.

Now I'm looking for a way that allows me to retrieve the information from a Person fast and clean so I can display it. I've been using custom written DAO objects, but they were slow.

I also need to mention, that the table Person contains links to Country, Status, Category and other related tables. So that information should be accessible as well, because I would like to display Country: England for example instead of Country : 3.

1.first make a sql query joining all your tables and retrieve the information you want.....
2.create a Dataset with those records....
3.now bind the Dataset with the combobox .....
4.set the DisplayMember property to the Person_Name column.....
5.now in the SelectedIndexChanged event of that combo you can have the full information of the selected person....you will have to Typecast the "SelectedItem row" of combo to DataRowView.........the code will look like

 
 
{ 
string person_name = ((DataRowView)myCombobox.SelectedItem).Row("Person_Name");
}