From DropDown to MultiSelecthttp://forums.asp.net/t/1792485.aspx/1?From+DropDown+to+MultiSelectMon, 16 Apr 2012 03:48:37 -040017924854930665http://forums.asp.net/p/1792485/4930665.aspx/1?From+DropDown+to+MultiSelectFrom DropDown to MultiSelect <p>Dear All,</p> <p>When i am using combo box, my skeleton code work fine as this:-</p> <p>Boolean <span size="2" style="font-size:small">filterByProductFamily = </span> <span color="#0000ff" size="2" style="color:#0000ff; font-size:small"><span color="#0000ff" size="2" style="color:#0000ff; font-size:small">false</span></span><span size="2" style="font-size:small">;</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</p> <p><span color="#2b91af" size="2" style="color:#2b91af; font-size:small"><span color="#2b91af" size="2" style="color:#2b91af; font-size:small">Guid</span></span><span size="2" style="font-size:small"> productFamily = </span><span color="#2b91af" size="2" style="color:#2b91af; font-size:small"><span color="#2b91af" size="2" style="color:#2b91af; font-size:small">Guid</span></span><span size="2" style="font-size:small">.Empty;</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</p> <p><span color="#0000ff" size="2" style="color:#0000ff; font-size:small"><span color="#0000ff" size="2" style="color:#0000ff; font-size:small">if</span></span><span size="2" style="font-size:small"> (tscboProductFamily.ComboBox.SelectedValue != </span><span color="#0000ff" size="2" style="color:#0000ff; font-size:small"><span color="#0000ff" size="2" style="color:#0000ff; font-size:small">null</span></span><span size="2" style="font-size:small">)</span>&nbsp; {</p> <p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; productFamily = (<span color="#2b91af" size="2" style="color:#2b91af; font-size:small"><span color="#2b91af" size="2" style="color:#2b91af; font-size:small">Guid</span></span><span size="2" style="font-size:small">)tscboProductFamily.ComboBox.SelectedValue; </span></p> <p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; filterByProductFamily = (productFamily !=<span color="#0000ff" size="2" style="color:#0000ff; font-size:small"><span color="#0000ff" size="2" style="color:#0000ff; font-size:small">null</span></span><span size="2" style="font-size:small"> &amp;&amp; productFamily != </span><span color="#2b91af" size="2" style="color:#2b91af; font-size:small"><span color="#2b91af" size="2" style="color:#2b91af; font-size:small">Guid</span></span><span size="2" style="font-size:small">.Empty) ? </span><span color="#0000ff" size="2" style="color:#0000ff; font-size:small"><span color="#0000ff" size="2" style="color:#0000ff; font-size:small">true</span></span><span size="2" style="font-size:small"> : </span><span color="#0000ff" size="2" style="color:#0000ff; font-size:small"><span color="#0000ff" size="2" style="color:#0000ff; font-size:small">false</span></span><span size="2" style="font-size:small">;</span>&nbsp;<br> }</p> <p>productFamily&nbsp; will stored the Guid</p> <p>&nbsp;</p> <p>But when i try to change to multiselect as below, i having problem on Guid, Please advise. My skeleton code not completed as below:-</p> <p>foreach <span size="2" style="font-size:small">(</span><span color="#2b91af" size="2" style="color:#2b91af; font-size:small"><span color="#2b91af" size="2" style="color:#2b91af; font-size:small">ToolStripMenuItem</span></span><span size="2" style="font-size:small"> item </span><span color="#0000ff" size="2" style="color:#0000ff; font-size:small"><span color="#0000ff" size="2" style="color:#0000ff; font-size:small">in</span></span><span size="2" style="font-size:small"> tsddbSegment.DropDown.Items)</span>&nbsp;{&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</p> <p><span color="#0000ff" size="2" style="color:#0000ff; font-size:small"><span color="#0000ff" size="2" style="color:#0000ff; font-size:small">if</span></span><span size="2" style="font-size:small"> (item.Checked == </span><span color="#0000ff" size="2" style="color:#0000ff; font-size:small"><span color="#0000ff" size="2" style="color:#0000ff; font-size:small">true</span></span><span size="2" style="font-size:small">)<br> </span>{<br> &nbsp;&nbsp;<strong>&nbsp; <span style="text-decoration:line-through">productFamily = (<span color="#2b91af" size="2" style="color:#2b91af; font-size:small; text-decoration:line-through"><span color="#2b91af" size="2" style="color:#2b91af; font-size:small; text-decoration:line-through">Guid</span></span></span></strong><span size="2" style="font-size:small"><strong><span style="text-decoration:line-through">)item.Text;&nbsp;</span>&nbsp; //I stuck on this portion. How can i get Guid instead of value string. It maybe can call from Find segment method&nbsp;&nbsp;at helpers.cs file. But i dono how to call it &amp; return into Guid.</strong><br> &nbsp;&nbsp;&nbsp; </span>filterByProductFamily = (productFamily !=<span color="#0000ff" size="2" style="color:#0000ff; font-size:small"><span color="#0000ff" size="2" style="color:#0000ff; font-size:small">null</span></span><span size="2" style="font-size:small"> &amp;&amp; productFamily != </span><span color="#2b91af" size="2" style="color:#2b91af; font-size:small"><span color="#2b91af" size="2" style="color:#2b91af; font-size:small">Guid</span></span><span size="2" style="font-size:small">.Empty) ? </span><span color="#0000ff" size="2" style="color:#0000ff; font-size:small"><span color="#0000ff" size="2" style="color:#0000ff; font-size:small">true</span></span><span size="2" style="font-size:small"> : </span><span color="#0000ff" size="2" style="color:#0000ff; font-size:small"><span color="#0000ff" size="2" style="color:#0000ff; font-size:small">false</span></span><span size="2" style="font-size:small">;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span>}<br> }</p> <p>&nbsp;&nbsp;&nbsp;&nbsp;</p> <p><span style="text-decoration:underline">Helpers.cs</span></p> <p>&nbsp;//&nbsp; Return dataset of options&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</p> <p><span color="#0000ff" size="2" style="color:#0000ff; font-size:small"><span color="#0000ff" size="2" style="color:#0000ff; font-size:small">public</span></span><span size="2" style="font-size:small"> </span><span color="#0000ff" size="2" style="color:#0000ff; font-size:small"><span color="#0000ff" size="2" style="color:#0000ff; font-size:small">static</span></span><span size="2" style="font-size:small"> </span><span color="#2b91af" size="2" style="color:#2b91af; font-size:small"><span color="#2b91af" size="2" style="color:#2b91af; font-size:small">List</span></span><span size="2" style="font-size:small">&lt;</span><span color="#2b91af" size="2" style="color:#2b91af; font-size:small"><span color="#2b91af" size="2" style="color:#2b91af; font-size:small">SegmentItem</span></span><span size="2" style="font-size:small">&gt; GetChoices()</span></p> <p>{&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</p> <p><span color="#008000" size="2" style="color:#008000; font-size:small"><span color="#008000" size="2" style="color:#008000; font-size:small">//&nbsp; Establish reference to dataset</span></span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</p> <p><span color="#2b91af" size="2" style="color:#2b91af; font-size:small"><span color="#2b91af" size="2" style="color:#2b91af; font-size:small">frmMain</span></span><span size="2" style="font-size:small"> mainForm = (</span><span color="#2b91af" size="2" style="color:#2b91af; font-size:small"><span color="#2b91af" size="2" style="color:#2b91af; font-size:small">frmMain</span></span><span size="2" style="font-size:small">)</span><span color="#2b91af" size="2" style="color:#2b91af; font-size:small"><span color="#2b91af" size="2" style="color:#2b91af; font-size:small">Application</span></span><span size="2" style="font-size:small">.OpenForms[</span><span color="#a31515" size="2" style="color:#a31515; font-size:small"><span color="#a31515" size="2" style="color:#a31515; font-size:small">&quot;frmMain&quot;</span></span><span size="2" style="font-size:small">];</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</p> <p><span color="#2b91af" size="2" style="color:#2b91af; font-size:small"><span color="#2b91af" size="2" style="color:#2b91af; font-size:small">DataSet1</span></span><span size="2" style="font-size:small"> dataset = mainForm.GetDataSet();</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</p> <p><span color="#008000" size="2" style="color:#008000; font-size:small"><span color="#008000" size="2" style="color:#008000; font-size:small">//&nbsp; Clear down existing list</span></span></p> <p>possibleChoices.Clear();&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</p> <p><span color="#008000" size="2" style="color:#008000; font-size:small"><span color="#008000" size="2" style="color:#008000; font-size:small">//&nbsp; Add option 'All'</span></span></p> <p>possibleChoices.Add(<span color="#0000ff" size="2" style="color:#0000ff; font-size:small"><span color="#0000ff" size="2" style="color:#0000ff; font-size:small">new</span></span><span size="2" style="font-size:small"> </span><span color="#2b91af" size="2" style="color:#2b91af; font-size:small"><span color="#2b91af" size="2" style="color:#2b91af; font-size:small">SegmentItem</span></span><span size="2" style="font-size:small">(</span><span color="#a31515" size="2" style="color:#a31515; font-size:small"><span color="#a31515" size="2" style="color:#a31515; font-size:small">&quot;(All)&quot;</span></span><span size="2" style="font-size:small">));</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</p> <p><span color="#008000" size="2" style="color:#008000; font-size:small"><span color="#008000" size="2" style="color:#008000; font-size:small">//&nbsp; Get distinct set of account managers refrenced in opportunity dataset</span></span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</p> <p><span color="#2b91af" size="2" style="color:#2b91af; font-size:small"><span color="#2b91af" size="2" style="color:#2b91af; font-size:small">DataView</span></span><span size="2" style="font-size:small"> tempView = </span><span color="#0000ff" size="2" style="color:#0000ff; font-size:small"><span color="#0000ff" size="2" style="color:#0000ff; font-size:small">new</span></span><span size="2" style="font-size:small"> </span><span color="#2b91af" size="2" style="color:#2b91af; font-size:small"><span color="#2b91af" size="2" style="color:#2b91af; font-size:small">DataView</span></span><span size="2" style="font-size:small">(dataset.OpportunityElement, </span><span color="#0000ff" size="2" style="color:#0000ff; font-size:small"><span color="#0000ff" size="2" style="color:#0000ff; font-size:small">null</span></span><span size="2" style="font-size:small">, </span><span color="#a31515" size="2" style="color:#a31515; font-size:small"><span color="#a31515" size="2" style="color:#a31515; font-size:small">&quot;productfamilyname&quot;</span></span><span size="2" style="font-size:small">, </span><span color="#2b91af" size="2" style="color:#2b91af; font-size:small"><span color="#2b91af" size="2" style="color:#2b91af; font-size:small">DataViewRowState</span></span><span size="2" style="font-size:small">.CurrentRows);</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</p> <p><span color="#2b91af" size="2" style="color:#2b91af; font-size:small"><span color="#2b91af" size="2" style="color:#2b91af; font-size:small">DataTable</span></span><span size="2" style="font-size:small"> distinctSegments = tempView.ToTable(</span><span color="#0000ff" size="2" style="color:#0000ff; font-size:small"><span color="#0000ff" size="2" style="color:#0000ff; font-size:small">true</span></span><span size="2" style="font-size:small">, </span><span color="#0000ff" size="2" style="color:#0000ff; font-size:small"><span color="#0000ff" size="2" style="color:#0000ff; font-size:small">new</span></span><span size="2" style="font-size:small"> </span><span color="#0000ff" size="2" style="color:#0000ff; font-size:small"><span color="#0000ff" size="2" style="color:#0000ff; font-size:small">string</span></span><span size="2" style="font-size:small">[] { </span><span color="#a31515" size="2" style="color:#a31515; font-size:small"><span color="#a31515" size="2" style="color:#a31515; font-size:small">&quot;productfamilyname&quot;</span></span><span size="2" style="font-size:small"> });</span></p> <p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</p> <p><span color="#008000" size="2" style="color:#008000; font-size:small"><span color="#008000" size="2" style="color:#008000; font-size:small">//&nbsp; Quit now if no account managers</span></span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</p> <p><span color="#0000ff" size="2" style="color:#0000ff; font-size:small"><span color="#0000ff" size="2" style="color:#0000ff; font-size:small">if</span></span><span size="2" style="font-size:small"> (distinctSegments.Rows.Count == 0)</span></p> <p>&nbsp;{&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</p> <p><span color="#0000ff" size="2" style="color:#0000ff; font-size:small"><span color="#0000ff" size="2" style="color:#0000ff; font-size:small">&nbsp;&nbsp;&nbsp; return</span></span><span size="2" style="font-size:small"> possibleChoices;</span></p> <p>}</p> <p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</p> <p><span color="#008000" size="2" style="color:#008000; font-size:small"><span color="#008000" size="2" style="color:#008000; font-size:small">//&nbsp; Create list of account manager options</span></span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</p> <p><span color="#0000ff" size="2" style="color:#0000ff; font-size:small"><span color="#0000ff" size="2" style="color:#0000ff; font-size:small">foreach</span></span><span size="2" style="font-size:small"> (</span><span color="#2b91af" size="2" style="color:#2b91af; font-size:small"><span color="#2b91af" size="2" style="color:#2b91af; font-size:small">DataRow</span></span><span size="2" style="font-size:small"> segmentRow </span><span color="#0000ff" size="2" style="color:#0000ff; font-size:small"><span color="#0000ff" size="2" style="color:#0000ff; font-size:small">in</span></span><span size="2" style="font-size:small"> distinctSegments.Rows)</span></p> <p>{&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</p> <p><span color="#2b91af" size="2" style="color:#2b91af; font-size:small"><span color="#2b91af" size="2" style="color:#2b91af; font-size:small">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SegmentItem</span></span><span size="2" style="font-size:small"> segmentItem =</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span color="#0000ff" size="2" style="color:#0000ff; font-size:small"><span color="#0000ff" size="2" style="color:#0000ff; font-size:small">new</span></span><span size="2" style="font-size:small"> </span><span color="#2b91af" size="2" style="color:#2b91af; font-size:small"><span color="#2b91af" size="2" style="color:#2b91af; font-size:small">SegmentItem</span></span><span size="2" style="font-size:small">((</span><span color="#0000ff" size="2" style="color:#0000ff; font-size:small"><span color="#0000ff" size="2" style="color:#0000ff; font-size:small">string</span></span><span size="2" style="font-size:small">)segmentRow[</span><span color="#a31515" size="2" style="color:#a31515; font-size:small"><span color="#a31515" size="2" style="color:#a31515; font-size:small">&quot;productfamilyname&quot;</span></span><span size="2" style="font-size:small">]);</span></p> <p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; possibleChoices.Add(segmentItem);</p> <p>}&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</p> <p><span color="#0000ff" size="2" style="color:#0000ff; font-size:small"><span color="#0000ff" size="2" style="color:#0000ff; font-size:small">return</span></span><span size="2" style="font-size:small"> possibleChoices;</span></p> <p>&nbsp;}&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</p> <p><span color="#008000" size="2" style="color:#008000; font-size:small"><span color="#008000" size="2" style="color:#008000; font-size:small">//&nbsp; Find segment method</span></span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</p> <p><span color="#0000ff" size="2" style="color:#0000ff; font-size:small"><span color="#0000ff" size="2" style="color:#0000ff; font-size:small">public</span></span><span size="2" style="font-size:small"> </span><span color="#0000ff" size="2" style="color:#0000ff; font-size:small"><span color="#0000ff" size="2" style="color:#0000ff; font-size:small">static</span></span><span size="2" style="font-size:small"> </span><span color="#2b91af" size="2" style="color:#2b91af; font-size:small"><span color="#2b91af" size="2" style="color:#2b91af; font-size:small">SegmentItem</span></span><span size="2" style="font-size:small"> Find(</span><span color="#2b91af" size="2" style="color:#2b91af; font-size:small"><span color="#2b91af" size="2" style="color:#2b91af; font-size:small">String</span></span><span size="2" style="font-size:small"> optionName)</span></p> <p>&nbsp;{&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</p> <p><span color="#0000ff" size="2" style="color:#0000ff; font-size:small"><span color="#0000ff" size="2" style="color:#0000ff; font-size:small">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; return</span></span><span size="2" style="font-size:small"> possibleChoices.Find(</span><span color="#0000ff" size="2" style="color:#0000ff; font-size:small"><span color="#0000ff" size="2" style="color:#0000ff; font-size:small">delegate</span></span><span size="2" style="font-size:small">(</span><span color="#2b91af" size="2" style="color:#2b91af; font-size:small"><span color="#2b91af" size="2" style="color:#2b91af; font-size:small">SegmentItem</span></span><span size="2" style="font-size:small"> option) { </span><span color="#0000ff" size="2" style="color:#0000ff; font-size:small"><span color="#0000ff" size="2" style="color:#0000ff; font-size:small">return</span></span><span size="2" style="font-size:small"> option.Name == optionName; });</span></p> <p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }</p> <p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }</p> <p>&nbsp;</p> <p>&nbsp;</p> <p>&nbsp;</p> <p>Please Advise.</p> <p>&nbsp;</p> <p>Thank you.</p> <p>&nbsp;</p> <p>Regards,</p> <p>Micheale&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</p> 2012-04-13T08:49:48-04:004933509http://forums.asp.net/p/1792485/4933509.aspx/1?Re+From+DropDown+to+MultiSelectRe: From DropDown to MultiSelect <p>http://stackoverflow.com/questions/774587/multi-select-dropdown-list-in-asp-net</p> <p>http://www.dotnetfunda.com/articles/article1591-multiselect-dropdown-in-aspnet-40-using-csharp.aspx</p> 2012-04-15T21:28:17-04:004933634http://forums.asp.net/p/1792485/4933634.aspx/1?Re+From+DropDown+to+MultiSelectRe: From DropDown to MultiSelect <p>I solved with solution by creating an function pass in a parameter and return the Guid.</p> <p><span style="text-decoration:underline">Example function</span></p> <p>public <span size="2" color="#0000ff" style="color:#0000ff; font-size:small"><span size="2" color="#0000ff" style="color:#0000ff; font-size:small">static</span></span><span size="2" style="font-size:small"> </span><span size="2" color="#2b91af" style="color:#2b91af; font-size:small"><span size="2" color="#2b91af" style="color:#2b91af; font-size:small">Guid</span></span><span size="2" style="font-size:small"> getProduct(</span><span size="2" color="#0000ff" style="color:#0000ff; font-size:small"><span size="2" color="#0000ff" style="color:#0000ff; font-size:small">string</span></span><span size="2" style="font-size:small"> name)<br> </span>{</p> <p><span size="2" color="#2b91af" style="color:#2b91af; font-size:small"><span size="2" color="#2b91af" style="color:#2b91af; font-size:small">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; frmMain</span></span><span size="2" style="font-size:small"> mainForm = (</span><span size="2" color="#2b91af" style="color:#2b91af; font-size:small"><span size="2" color="#2b91af" style="color:#2b91af; font-size:small">frmMain</span></span><span size="2" style="font-size:small">)</span><span size="2" color="#2b91af" style="color:#2b91af; font-size:small"><span size="2" color="#2b91af" style="color:#2b91af; font-size:small">Application</span></span><span size="2" style="font-size:small">.OpenForms[</span><span size="2" color="#a31515" style="color:#a31515; font-size:small"><span size="2" color="#a31515" style="color:#a31515; font-size:small">&quot;frmMain&quot;</span></span><span size="2" style="font-size:small">];</span></p> <p><span size="2" color="#2b91af" style="color:#2b91af; font-size:small"><span size="2" color="#2b91af" style="color:#2b91af; font-size:small">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DataSet1</span></span><span size="2" style="font-size:small"> dataset = mainForm.GetDataSet();</span></p> <p><span size="2" color="#008000" style="color:#008000; font-size:small"><span size="2" color="#008000" style="color:#008000; font-size:small">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; //&nbsp; Get distinct set of Families referenced in opportunity dataset</span></span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</p> <p><span size="2" color="#2b91af" style="color:#2b91af; font-size:small"><span size="2" color="#2b91af" style="color:#2b91af; font-size:small">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DataView</span></span><span size="2" style="font-size:small"> tempView = </span><span size="2" color="#0000ff" style="color:#0000ff; font-size:small"><span size="2" color="#0000ff" style="color:#0000ff; font-size:small">new</span></span><span size="2" style="font-size:small"> </span><span size="2" color="#2b91af" style="color:#2b91af; font-size:small"><span size="2" color="#2b91af" style="color:#2b91af; font-size:small">DataView</span></span><span size="2" style="font-size:small">(dataset.OpportunityElement, </span><span size="2" color="#0000ff" style="color:#0000ff; font-size:small"><span size="2" color="#0000ff" style="color:#0000ff; font-size:small">null</span></span><span size="2" style="font-size:small">, </span><span size="2" color="#a31515" style="color:#a31515; font-size:small"><span size="2" color="#a31515" style="color:#a31515; font-size:small">&quot;productfamilyname&quot;</span></span><span size="2" style="font-size:small">, </span><span size="2" color="#2b91af" style="color:#2b91af; font-size:small"><span size="2" color="#2b91af" style="color:#2b91af; font-size:small">DataViewRowState</span></span><span size="2" style="font-size:small">.CurrentRows);</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</p> <p><span size="2" color="#2b91af" style="color:#2b91af; font-size:small"><span size="2" color="#2b91af" style="color:#2b91af; font-size:small">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;DataTable</span></span><span size="2" style="font-size:small"> distinctAProductFamily = tempView.ToTable(</span><span size="2" color="#0000ff" style="color:#0000ff; font-size:small"><span size="2" color="#0000ff" style="color:#0000ff; font-size:small">true</span></span><span size="2" style="font-size:small">, </span><span size="2" color="#0000ff" style="color:#0000ff; font-size:small"><span size="2" color="#0000ff" style="color:#0000ff; font-size:small">new</span></span><span size="2" style="font-size:small"> </span><span size="2" color="#0000ff" style="color:#0000ff; font-size:small"><span size="2" color="#0000ff" style="color:#0000ff; font-size:small">string</span></span><span size="2" style="font-size:small">[] { </span><span size="2" color="#a31515" style="color:#a31515; font-size:small"><span size="2" color="#a31515" style="color:#a31515; font-size:small">&quot;productfamilyname&quot;</span></span><span size="2" style="font-size:small">, </span><span size="2" color="#a31515" style="color:#a31515; font-size:small"><span size="2" color="#a31515" style="color:#a31515; font-size:small">&quot;productfamily&quot;</span></span><span size="2" style="font-size:small"> });</span></p> <p><span size="2" color="#2b91af" style="color:#2b91af; font-size:small"><span size="2" color="#2b91af" style="color:#2b91af; font-size:small">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Guid</span></span><span size="2" style="font-size:small"> aPro = </span><span size="2" color="#2b91af" style="color:#2b91af; font-size:small"><span size="2" color="#2b91af" style="color:#2b91af; font-size:small">Guid</span></span><span size="2" style="font-size:small">.Empty;</span></p> <p><span size="2" color="#008000" style="color:#008000; font-size:small"><span size="2" color="#008000" style="color:#008000; font-size:small">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; //&nbsp; Create list of region options</span></span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</p> <p><span size="2" color="#0000ff" style="color:#0000ff; font-size:small"><span size="2" color="#0000ff" style="color:#0000ff; font-size:small">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; foreach</span></span><span size="2" style="font-size:small"> (</span><span size="2" color="#2b91af" style="color:#2b91af; font-size:small"><span size="2" color="#2b91af" style="color:#2b91af; font-size:small">DataRow</span></span><span size="2" style="font-size:small"> aPFRow </span><span size="2" color="#0000ff" style="color:#0000ff; font-size:small"><span size="2" color="#0000ff" style="color:#0000ff; font-size:small">in</span></span><span size="2" style="font-size:small"> distinctAProductFamily.Rows)</span></p> <p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; {&nbsp;&nbsp;<br> <span size="2" color="#0000ff" style="color:#0000ff; font-size:small"><span size="2" color="#0000ff" style="color:#0000ff; font-size:small">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if</span></span><span size="2" style="font-size:small"> ((</span><span size="2" color="#0000ff" style="color:#0000ff; font-size:small"><span size="2" color="#0000ff" style="color:#0000ff; font-size:small">string</span></span><span size="2" style="font-size:small">)aPFRow[</span><span size="2" color="#a31515" style="color:#a31515; font-size:small"><span size="2" color="#a31515" style="color:#a31515; font-size:small">&quot;productfamilyname&quot;</span></span><span size="2" style="font-size:small">] == name)</span></p> <p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; {<br> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; aPro=(<span size="2" color="#2b91af" style="color:#2b91af; font-size:small"><span size="2" color="#2b91af" style="color:#2b91af; font-size:small">Guid</span></span><span size="2" style="font-size:small">)aPFRow[</span><span size="2" color="#a31515" style="color:#a31515; font-size:small"><span size="2" color="#a31515" style="color:#a31515; font-size:small">&quot;productfamily&quot;</span></span><span size="2" style="font-size:small">];<br> </span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }<br> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</p> <p><span size="2" color="#0000ff" style="color:#0000ff; font-size:small"><span size="2" color="#0000ff" style="color:#0000ff; font-size:small">return</span></span><span size="2" style="font-size:small"> (aPro);</span></p> <p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }</p> <p>&nbsp;</p> <p>Thank you.</p> <p>&nbsp;</p> <p>Regards,<br> Micheale</p> 2012-04-16T03:48:37-04:00