Last post Sep 20, 2013 06:07 AM by Happy Chen - MSFT
Member
18 Points
187 Posts
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.
Participant
960 Points
288 Posts
Sep 16, 2013 02:56 AM|galeny|LINK
hi mr41971,
you can use SQL statement below:
select a.* ,b.status from student a, status b where a.statusid =b.statusid
or
create a 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.
All-Star
15648 Points
2151 Posts
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 data // add rows newTable //.......... } return newTable; }
Please read the reference below for more information:
http://stackoverflow.com/questions/7161495/how-to-create-duplicate-rows-based-on-some-conditions
http://stackoverflow.com/questions/11735003/club-data-in-a-data-table-into-a-single-row-based-on-a-condition-in-c-sharp
If you need more assistance, please let me know.
Member
18 Points
187 Posts
I need to add a status field to a table and have that addition trickle down to the various webfor...
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.
Participant
960 Points
288 Posts
Re: I need to add a status field to a table and have that addition trickle down to the various we...
Sep 16, 2013 02:56 AM|galeny|LINK
hi mr41971,
you can use SQL statement below:
or
create a temporary table and insert data into it dynamic .
Participant
960 Points
288 Posts
Re: I need to add a status field to a table and have that addition trickle down to the various we...
Sep 16, 2013 02:56 AM|galeny|LINK
hi mr41971,
you can use SQL statement below:
or
create a temporary table and insert data into it dynamic .
Member
18 Points
187 Posts
Re: I need to add a status field to a table and have that addition trickle down to the various we...
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.
All-Star
15648 Points
2151 Posts
Re: I need to add a status field to a table and have that addition trickle down to the various we...
Sep 20, 2013 06:07 AM|Happy Chen - MSFT|LINK
hi mr41971,
According to your description, you want to add a status field to a table.
I would suggest you to try the following workaround:
Please read the reference below for more information:
http://stackoverflow.com/questions/7161495/how-to-create-duplicate-rows-based-on-some-conditions
http://stackoverflow.com/questions/11735003/club-data-in-a-data-table-into-a-single-row-based-on-a-condition-in-c-sharp
If you need more assistance, please let me know.