Databases
StackOverflow2013
Postsdbo
POHow to split a string in a datatable and add into new rows using Linq C#?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHow to split a string in a datatable and add into new rows using Linq C#?
    primarykey
    data
    text
    <p>I am new to linq. I am using linq to get vlaues from datalist control and creating a datatable with that values. The datatable contains three columns. In that, sometimes the 'Answer' column is having a data which is comma separated. <img src="https://i.stack.imgur.com/cOPi3.png" alt="You can see the image of datatable with comma separated column"></p> <pre><code> DataTable SaveAnswer = clsSource.SetData(); var df = from DataListItem dli in PollDataList.Items let z = ((HiddenField)dli.FindControl("IDReqHiddenField")) let y = ((RadioButtonList)dli.FindControl("rdblstPollOptions")) let v = ((CheckBoxList)dli.FindControl("CheckBoxListMultiplePollOptions")) select new { PollId=z.Value, Answered1 = y.SelectedValue, Answered2=v.Items.Cast&lt;ListItem&gt;().Where(r=&gt;r.Selected) }; var result = from p in df select SavePollAnswer.LoadDataRow( new object[] { p.PollId,p.Answered1+string.Join( ", ", p.Answered2 ),"" }, false); SavePollAnswer = result.CopyToDataTable(); </code></pre> <p>And here is my design</p> <pre><code>&lt;asp:DataList ID="PollDataList" runat="server" CssClass="poll-preview"&gt; &lt;ItemTemplate&gt; &lt;asp:HiddenField ID="PollIDReqHiddenField" Value='&lt;%# Eval("PollID") %&gt;' runat="server" Visible="false" /&gt; &lt;asp:Label ID="lblReqQuestionNumber" runat="server" Text='&lt;%# Eval("NoofPollQuestion") %&gt;' Font-Bold="true"&gt;&lt;/asp:Label&gt;&lt;br /&gt; &lt;asp:Label ID="lblRequiredPollQusetion" runat="server" Text='&lt;%# Eval("PollQuestions") %&gt;' Font-Bold="false"&gt;&lt;/asp:Label&gt; &lt;asp:Label ID="lblReqNotification" runat="server" ForeColor="Red" CssClass='&lt;%# Eval("PollReq") %&gt;' Text="*" Font-Bold="true"&gt;&lt;/asp:Label&gt; &lt;asp:RadioButtonList ID="rdblstPollOptions" DataSource='&lt;%# Eval("PollOptionsReq") %&gt;' runat="server"&gt;&lt;/asp:RadioButtonList&gt; &lt;asp:CheckBoxList ID="CheckBoxListMultiplePollOptions" DataSource='&lt;%# Eval("PollOptionsMul") %&gt;' runat="server" RepeatDirection="Vertical" RepeatColumns="1"&gt;&lt;/asp:CheckBoxList&gt; &lt;/ItemTemplate&gt; &lt;/asp:DataList&gt; </code></pre> <p>But we want the datatable output like this <img src="https://i.stack.imgur.com/SLVF3.png" alt="Expected Output"></p> <p>Thanks in advance!</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USSudha
    1. USSudha
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POHow to split a string in a datatable and add into new rows using Linq C#?
      1. This table or related slice is empty.
      1. VTUpMod
    1. COWould I be stating the obvious with [this](http://msdn.microsoft.com/en-us/library/5ycd1034(v=vs.80).aspx)? Split the ones with 2 values and add new 2 new rows.
      singulars
      1. POHow to split a string in a datatable and add into new rows using Linq C#?
      1. USChiefTwoPencils
    2. COI think I have to explain it more clearly...In the first image you can see the "PollAnswer" column having selected options(2,3) for the "PollID" (36). But the output I need should not be like this (36->2,3).It should be 36->2,36->3(you can see in second image).
      singulars
      1. POHow to split a string in a datatable and add into new rows using Linq C#?
      1. USSudha
    3. COYes, I see that. Where you build your `new object[]` you need to see if p.Answered2 is not empty/null. If not, meaning there is a comma separated value to view in separate rows, perform the first insert with a new object with p.Answered1, then again with another row and p.Answered2.
      singulars
      1. POHow to split a string in a datatable and add into new rows using Linq C#?
      1. USChiefTwoPencils
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload