I need to add a status field to a table and have that addition trickle down to the various webforms like list.aspx. [Answered]RSS

• • Reply
  mr41971

  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.

• • Reply
  galeny

  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:

  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 .

  If you think one reply solves your problem, please mark it as An Answer.
• • Reply
  galeny

  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:

  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 .

  If you think one reply solves your problem, please mark it as An Answer.
• • Reply
  mr41971

  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.

• • Reply
  Happy Chen -...

  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: 

  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.

  We are trying to better understand customer views on social support experience. Click HERE to participate the survey. Thanks!