export data from database to form

OK, your SELECT query will need to be something like this to pull in all 3 columns at once:

SELECT table1.projectid AS projectid, table2.name AS name, table3.time AS time from table1, table2, table3 WHERE table1.projectid = table2.projectid AND table1.projectid = table3.projectid

You should then be able to bind the ListBox to the projectid column as before.

When the SelectedIndex of the ListBox changes, you can then assign the name and time columns in the same row of the DataTable as the projectid to your TextBoxes.

Hi Vulpes,

Thanks!!

Give me some more idea to do. For you convenience i am giving u an example.

I have a table like this

1st table:

projectid

1

2

3

4

5

 

2nd table:

name    projectid

xyz         1

abc         2

def         3

 

3rd table:

time  projectid

1              1

2              2

1              3

 

I retrieved the Projectid data from Database and stored into listbox.

 

Whenever I select the an item in listbox (for example I selected projecteId 2)

On my windows form shows as follows:

Name abc

Time 2

 

Hi Vulpes,

Thanks for ur reply.

No, 

based on the selected value in the listbox, i wanted to retrieve the data from other tables (not from the same table which i got listbox values).

Darma

Do you mean that you've retrieved just a single column of data from the database and bound it to a listbox  but you now want to retrieve all the other columns from the database corresponding to the selected column in the listbox and place them in textboxes?

If you do, then I'd retrieve the whole row and not just a single column from the database in the first place.

The index of the selected column in the listbox should then correspond with the index of the row in the DataTable.Rows collection from which that column has been derived.