Last post Sep 20, 2013 06:07 AM by Happy Chen - MSFT
Sep 14, 2013 06:57 AM|mr41971|LINK
What do I need to do to have the field show in the list.aspx? The field is a lookup field. For example: The student table will have a statusid field, which references a status table. Please be reminded this is a dynamic data project.
Sep 16, 2013 02:56 AM|galeny|LINK
you can use SQL statement below:
select a.* ,b.status
from student a, status b
where a.statusid =b.statusid
temporary table and insert data
into it dynamic .
Sep 16, 2013 05:30 AM|mr41971|LINK
Thank you for your kind effort. What I need to do is to have the addition of the status field trickle down to the list.aspx webform.
Sep 20, 2013 06:07 AM|Happy Chen - MSFT|LINK
According to your description, you want to add a status field to a table.
I would suggest you to try the following workaround:
private DataTable AlterDataTable(DataTable oldTable)
DataTable newTable = oldTable.Clone();
foreach (DataRow row in oldTable.Rows)
//add columns newTable
// add rows newTable
Please read the reference below for more information:
If you need more assistance, please let me know.