how to get data directly from database as a table on asp

[DivyaJaiKumar]

Hello,
I have a doubt, that is I have to bring the data's present in the database (*.mdb) in which we have two tables as a single table for which I have used a query using where statement for the common id but I want all the data to be displayed in the form of a table in the asp form, could anyone help me in this.
If we have the several rows of datas under name, add, sirname in one table say studentdetails and email, messengerid in another table say stu then I want the table as name, add, sirname, email, messengerid in a single table which I am getting but I want all the datas to be displayed in the table form, if you could help me in this with codings.
Thanks in advance,

[Sahir]

You need to use a join

[DivyaJaiKumar]

I have done it using the query as select * from sutdentdetails st , stu s where st.id=s.id;

All those works but I I am getting the data from the table and i want to display all the datas in the database on the screen.
Please if you could help me with this problem as writting query is not the problem the display is the probelm.

[aquafin]

I

All those works but I I am getting the data from the table and i want to display all the datas in the database on the screen.
Please if you could help me with this problem as writting query is not the problem the display is the probelm.

DO you want to display the retrieved data in a table form ?


If so use the join query and bind the data to a datagrid.

[DivyaJaiKumar]

Yes, but I am using javascript in the programming and so can't use datagrid in this to view and also the join statement . If yes could u help me with the coding. It would be of much help for me.
Thanks in advance,

[aquafin]

I think this could be of some help to you


http://www.kuro5hin.org/story/2005/7/14/13942/7643