U
[UKLans]Khan
Guest
Y0
I'm am currently developing a system using ASP.Net and VB.Net. I have 2 tables in a database, a user table and a post table, when a user makes a post it adds to the post table.
I need a navigation screen that displays a Datagrid containing the username and the name of the last post they made. [So records from both tables].
I can do the datagrid so it is populated with the user variables e.g. name, e-mail etc but then I need a colomn that displays the last post they made [from the post table].
Do I have to do a SQL statement within the datagrid for each user [like old ASP do until loops] or is there a way to do the above using a snazy datagrid command?
Thanks,
Khan
I'm am currently developing a system using ASP.Net and VB.Net. I have 2 tables in a database, a user table and a post table, when a user makes a post it adds to the post table.
I need a navigation screen that displays a Datagrid containing the username and the name of the last post they made. [So records from both tables].
I can do the datagrid so it is populated with the user variables e.g. name, e-mail etc but then I need a colomn that displays the last post they made [from the post table].
Do I have to do a SQL statement within the datagrid for each user [like old ASP do until loops] or is there a way to do the above using a snazy datagrid command?
Thanks,
Khan