Adding a drop down to a grid


(system) #1
Add the bellow to the form load action. Just replace the GUID and your epicombo names
 

private static void
QuoteForm_Load(object sender, EventArgs args)

                {

                                //
Add Event Handler Code

                EpiUltraGrid
myGrid =
(EpiUltraGrid)csm.GetNativeControlReference(“73bddcdc-c164-4d92-804b-7309ce973d36”);

                myGrid.DisplayLayout.Bands[0].Columns[“Partnum”].ValueList
= epiComboC6;

               

                }



On Monday, November 4, 2013 6:25 PM, “joselortega@…” <joselortega@…> wrote:

 
<div id="ygrps-yiv-315487809yiv1808552570ygrp-text">
  
  
  <div>Hi everyone,</div>
 
I'm trying to add a description drop down to the SalesCatID field on the  order  entry  summary  grid. If I show SalesCatId in the grid, it can be modified but unless you know all the IDs it's not easy to change the sales category from the grid view.  I would like to show a drop down with salescat.description instead of the ID.
 
 I was able to add an ultracombo to the summary  sheet and that works but it still doesn't work in the grid.
Below is the code i'm using to set my ultracombo and also the code I have  to set the  salescatid  drop down properties in the grid.  If I add a manual  Value List  of items to the drop down it works but I need it  help in getting it bound to the SalesCat dataset like my ultracombo
 
 
Any help would be greatly appreciated.
 
te Sub SalesOrderForm_Load(ByVal sender As Object, ByVal args As EventArgs)
  Dim recSelected As Boolean
  Dim whereClause As String = String.empty
  Dim dsSales As DataSet = Epicor.Mfg.UI.FormFunctions.SearchFunctions.listLookup(oTrans,"SalesCatAdapter", recSelected, False,whereClause)
  Dim Fields As String() = New String(){"Description"}
  If (recSelected) Then
   ucbDescrip.ValueMember = "SalesCatID"
   ucbDescrip.DataSource = dsSales
   ucbDescrip.DisplayMember = "Description"
   ucbDescrip.SetColumnFilter(Fields)
 
 Dim grdSummaryOrderLines AS EpiUltragrid = Ctype(csm.GetNativeControlReference("bec51417-b286-4d61-a471-3912bc098905"),EpiUltraGrid)
 grdSummaryOrderLines.DisplayLayout.Bands(0).Columns("SalesCatID").Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList
 grdSummaryOrderLines.DisplayLayout.Override.AllowUpdate = Infragistics.Win .DefaultableBoolean .True
 
 
End if
End sub
 
 
</div>
 


<div style="height:0px;color:rgb(255, 255, 255);"></div></div>
#ygrps-yiv-315487809 #ygrps-yiv-315487809yiv1808552570 #ygrps-yiv-315487809yiv1808552570 -- #ygrps-yiv-315487809yiv1808552570ygrp-mkp { border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}

#ygrps-yiv-315487809 #ygrps-yiv-315487809yiv1808552570 #ygrps-yiv-315487809yiv1808552570ygrp-mkp hr {
border:1px solid #d8d8d8;}

#ygrps-yiv-315487809 #ygrps-yiv-315487809yiv1808552570 #ygrps-yiv-315487809yiv1808552570ygrp-mkp #ygrps-yiv-315487809yiv1808552570hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}

#ygrps-yiv-315487809 #ygrps-yiv-315487809yiv1808552570 #ygrps-yiv-315487809yiv1808552570ygrp-mkp #ygrps-yiv-315487809yiv1808552570ads {
margin-bottom:10px;}

#ygrps-yiv-315487809 #ygrps-yiv-315487809yiv1808552570 #ygrps-yiv-315487809yiv1808552570ygrp-mkp .ygrps-yiv-315487809yiv1808552570ad {
padding:0 0;}

#ygrps-yiv-315487809 #ygrps-yiv-315487809yiv1808552570 #ygrps-yiv-315487809yiv1808552570ygrp-mkp .ygrps-yiv-315487809yiv1808552570ad p {
margin:0;}

#ygrps-yiv-315487809 #ygrps-yiv-315487809yiv1808552570 #ygrps-yiv-315487809yiv1808552570ygrp-mkp .ygrps-yiv-315487809yiv1808552570ad a {
color:#0000ff;text-decoration:none;}
#ygrps-yiv-315487809 #ygrps-yiv-315487809yiv1808552570 #ygrps-yiv-315487809yiv1808552570ygrp-sponsor #ygrps-yiv-315487809yiv1808552570ygrp-lc {
font-family:Arial;}

#ygrps-yiv-315487809 #ygrps-yiv-315487809yiv1808552570 #ygrps-yiv-315487809yiv1808552570ygrp-sponsor #ygrps-yiv-315487809yiv1808552570ygrp-lc #ygrps-yiv-315487809yiv1808552570hd {
margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}

#ygrps-yiv-315487809 #ygrps-yiv-315487809yiv1808552570 #ygrps-yiv-315487809yiv1808552570ygrp-sponsor #ygrps-yiv-315487809yiv1808552570ygrp-lc .ygrps-yiv-315487809yiv1808552570ad {
margin-bottom:10px;padding:0 0;}

#ygrps-yiv-315487809 #ygrps-yiv-315487809yiv1808552570 #ygrps-yiv-315487809yiv1808552570actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#ygrps-yiv-315487809 #ygrps-yiv-315487809yiv1808552570 #ygrps-yiv-315487809yiv1808552570activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#ygrps-yiv-315487809 #ygrps-yiv-315487809yiv1808552570 #ygrps-yiv-315487809yiv1808552570activity span {
font-weight:700;}

#ygrps-yiv-315487809 #ygrps-yiv-315487809yiv1808552570 #ygrps-yiv-315487809yiv1808552570activity span:first-child {
text-transform:uppercase;}

#ygrps-yiv-315487809 #ygrps-yiv-315487809yiv1808552570 #ygrps-yiv-315487809yiv1808552570activity span a {
color:#5085b6;text-decoration:none;}

#ygrps-yiv-315487809 #ygrps-yiv-315487809yiv1808552570 #ygrps-yiv-315487809yiv1808552570activity span span {
color:#ff7900;}

#ygrps-yiv-315487809 #ygrps-yiv-315487809yiv1808552570 #ygrps-yiv-315487809yiv1808552570activity span .ygrps-yiv-315487809yiv1808552570underline {
text-decoration:underline;}

#ygrps-yiv-315487809 #ygrps-yiv-315487809yiv1808552570 .ygrps-yiv-315487809yiv1808552570attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}

#ygrps-yiv-315487809 #ygrps-yiv-315487809yiv1808552570 .ygrps-yiv-315487809yiv1808552570attach div a {
text-decoration:none;}

#ygrps-yiv-315487809 #ygrps-yiv-315487809yiv1808552570 .ygrps-yiv-315487809yiv1808552570attach img {
border:none;padding-right:5px;}

#ygrps-yiv-315487809 #ygrps-yiv-315487809yiv1808552570 .ygrps-yiv-315487809yiv1808552570attach label {
display:block;margin-bottom:5px;}

#ygrps-yiv-315487809 #ygrps-yiv-315487809yiv1808552570 .ygrps-yiv-315487809yiv1808552570attach label a {
text-decoration:none;}

#ygrps-yiv-315487809 #ygrps-yiv-315487809yiv1808552570 blockquote {
margin:0 0 0 4px;}

#ygrps-yiv-315487809 #ygrps-yiv-315487809yiv1808552570 .ygrps-yiv-315487809yiv1808552570bold {
font-family:Arial;font-size:13px;font-weight:700;}

#ygrps-yiv-315487809 #ygrps-yiv-315487809yiv1808552570 .ygrps-yiv-315487809yiv1808552570bold a {
text-decoration:none;}

#ygrps-yiv-315487809 #ygrps-yiv-315487809yiv1808552570 dd.ygrps-yiv-315487809yiv1808552570last p a {
font-family:Verdana;font-weight:700;}

#ygrps-yiv-315487809 #ygrps-yiv-315487809yiv1808552570 dd.ygrps-yiv-315487809yiv1808552570last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#ygrps-yiv-315487809 #ygrps-yiv-315487809yiv1808552570 dd.ygrps-yiv-315487809yiv1808552570last p span.ygrps-yiv-315487809yiv1808552570yshortcuts {
margin-right:0;}

#ygrps-yiv-315487809 #ygrps-yiv-315487809yiv1808552570 div.ygrps-yiv-315487809yiv1808552570attach-table div div a {
text-decoration:none;}

#ygrps-yiv-315487809 #ygrps-yiv-315487809yiv1808552570 div.ygrps-yiv-315487809yiv1808552570attach-table {
width:400px;}

#ygrps-yiv-315487809 #ygrps-yiv-315487809yiv1808552570 div.ygrps-yiv-315487809yiv1808552570file-title a, #ygrps-yiv-315487809 #ygrps-yiv-315487809yiv1808552570 div.ygrps-yiv-315487809yiv1808552570file-title a:active, #ygrps-yiv-315487809 #ygrps-yiv-315487809yiv1808552570 div.ygrps-yiv-315487809yiv1808552570file-title a:hover, #ygrps-yiv-315487809 #ygrps-yiv-315487809yiv1808552570 div.ygrps-yiv-315487809yiv1808552570file-title a:visited {
text-decoration:none;}

#ygrps-yiv-315487809 #ygrps-yiv-315487809yiv1808552570 div.ygrps-yiv-315487809yiv1808552570photo-title a, #ygrps-yiv-315487809 #ygrps-yiv-315487809yiv1808552570 div.ygrps-yiv-315487809yiv1808552570photo-title a:active, #ygrps-yiv-315487809 #ygrps-yiv-315487809yiv1808552570 div.ygrps-yiv-315487809yiv1808552570photo-title a:hover, #ygrps-yiv-315487809 #ygrps-yiv-315487809yiv1808552570 div.ygrps-yiv-315487809yiv1808552570photo-title a:visited {
text-decoration:none;}

#ygrps-yiv-315487809 #ygrps-yiv-315487809yiv1808552570 div#ygrps-yiv-315487809yiv1808552570ygrp-mlmsg #ygrps-yiv-315487809yiv1808552570ygrp-msg p a span.ygrps-yiv-315487809yiv1808552570yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#ygrps-yiv-315487809 #ygrps-yiv-315487809yiv1808552570 .ygrps-yiv-315487809yiv1808552570green {
color:#628c2a;}

#ygrps-yiv-315487809 #ygrps-yiv-315487809yiv1808552570 .ygrps-yiv-315487809yiv1808552570MsoNormal {
margin:0 0 0 0;}

#ygrps-yiv-315487809 #ygrps-yiv-315487809yiv1808552570 o {
font-size:0;}

#ygrps-yiv-315487809 #ygrps-yiv-315487809yiv1808552570 #ygrps-yiv-315487809yiv1808552570photos div {
float:left;width:72px;}

#ygrps-yiv-315487809 #ygrps-yiv-315487809yiv1808552570 #ygrps-yiv-315487809yiv1808552570photos div div {
border:1px solid #666666;height:62px;overflow:hidden;width:62px;}

#ygrps-yiv-315487809 #ygrps-yiv-315487809yiv1808552570 #ygrps-yiv-315487809yiv1808552570photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}

#ygrps-yiv-315487809 #ygrps-yiv-315487809yiv1808552570 #ygrps-yiv-315487809yiv1808552570reco-category {
font-size:77%;}

#ygrps-yiv-315487809 #ygrps-yiv-315487809yiv1808552570 #ygrps-yiv-315487809yiv1808552570reco-desc {
font-size:77%;}

#ygrps-yiv-315487809 #ygrps-yiv-315487809yiv1808552570 .ygrps-yiv-315487809yiv1808552570replbq {
margin:4px;}

#ygrps-yiv-315487809 #ygrps-yiv-315487809yiv1808552570 #ygrps-yiv-315487809yiv1808552570ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}

#ygrps-yiv-315487809 #ygrps-yiv-315487809yiv1808552570 #ygrps-yiv-315487809yiv1808552570ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}

#ygrps-yiv-315487809 #ygrps-yiv-315487809yiv1808552570 #ygrps-yiv-315487809yiv1808552570ygrp-mlmsg table {
font-size:inherit;font:100%;}

#ygrps-yiv-315487809 #ygrps-yiv-315487809yiv1808552570 #ygrps-yiv-315487809yiv1808552570ygrp-mlmsg select, #ygrps-yiv-315487809 #ygrps-yiv-315487809yiv1808552570 input, #ygrps-yiv-315487809 #ygrps-yiv-315487809yiv1808552570 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#ygrps-yiv-315487809 #ygrps-yiv-315487809yiv1808552570 #ygrps-yiv-315487809yiv1808552570ygrp-mlmsg pre, #ygrps-yiv-315487809 #ygrps-yiv-315487809yiv1808552570 code {
font:115% monospace;}

#ygrps-yiv-315487809 #ygrps-yiv-315487809yiv1808552570 #ygrps-yiv-315487809yiv1808552570ygrp-mlmsg * {
line-height:1.22em;}

#ygrps-yiv-315487809 #ygrps-yiv-315487809yiv1808552570 #ygrps-yiv-315487809yiv1808552570ygrp-mlmsg #ygrps-yiv-315487809yiv1808552570logo {
padding-bottom:10px;}

#ygrps-yiv-315487809 #ygrps-yiv-315487809yiv1808552570 #ygrps-yiv-315487809yiv1808552570ygrp-msg p a {
font-family:Verdana;}

#ygrps-yiv-315487809 #ygrps-yiv-315487809yiv1808552570 #ygrps-yiv-315487809yiv1808552570ygrp-msg p#ygrps-yiv-315487809yiv1808552570attach-count span {
color:#1E66AE;font-weight:700;}

#ygrps-yiv-315487809 #ygrps-yiv-315487809yiv1808552570 #ygrps-yiv-315487809yiv1808552570ygrp-reco #ygrps-yiv-315487809yiv1808552570reco-head {
color:#ff7900;font-weight:700;}

#ygrps-yiv-315487809 #ygrps-yiv-315487809yiv1808552570 #ygrps-yiv-315487809yiv1808552570ygrp-reco {
margin-bottom:20px;padding:0px;}

#ygrps-yiv-315487809 #ygrps-yiv-315487809yiv1808552570 #ygrps-yiv-315487809yiv1808552570ygrp-sponsor #ygrps-yiv-315487809yiv1808552570ov li a {
font-size:130%;text-decoration:none;}

#ygrps-yiv-315487809 #ygrps-yiv-315487809yiv1808552570 #ygrps-yiv-315487809yiv1808552570ygrp-sponsor #ygrps-yiv-315487809yiv1808552570ov li {
font-size:77%;list-style-type:square;padding:6px 0;}

#ygrps-yiv-315487809 #ygrps-yiv-315487809yiv1808552570 #ygrps-yiv-315487809yiv1808552570ygrp-sponsor #ygrps-yiv-315487809yiv1808552570ov ul {
margin:0;padding:0 0 0 8px;}

#ygrps-yiv-315487809 #ygrps-yiv-315487809yiv1808552570 #ygrps-yiv-315487809yiv1808552570ygrp-text {
font-family:Georgia;}

#ygrps-yiv-315487809 #ygrps-yiv-315487809yiv1808552570 #ygrps-yiv-315487809yiv1808552570ygrp-text p {
margin:0 0 1em 0;}

#ygrps-yiv-315487809 #ygrps-yiv-315487809yiv1808552570 #ygrps-yiv-315487809yiv1808552570ygrp-text tt {
font-size:120%;}

#ygrps-yiv-315487809 #ygrps-yiv-315487809yiv1808552570 #ygrps-yiv-315487809yiv1808552570ygrp-vital ul li:last-child {
border-right:none !important;}
#ygrps-yiv-315487809




(system) #2

Hi everyone,

 

I'm trying to add a description drop down to the SalesCatID field on the  order  entry  summary  grid. If I show SalesCatId in the grid, it can be modified but unless you know all the IDs it's not easy to change the sales category from the grid view.  I would like to show a drop down with salescat.description instead of the ID.

 

 I was able to add an ultracombo to the summary  sheet and that works but it still doesn't work in the grid.

Below is the code i'm using to set my ultracombo and also the code I have  to set the  salescatid  drop down properties in the grid.  If I add a manual  Value List  of items to the drop down it works but I need it  help in getting it bound to the SalesCat dataset like my ultracombo

 

 

Any help would be greatly appreciated.

 

te Sub SalesOrderForm_Load(ByVal sender As Object, ByVal args As EventArgs)

  Dim recSelected As Boolean
  Dim whereClause As String = String.empty
  Dim dsSales As DataSet = Epicor.Mfg.UI.FormFunctions.SearchFunctions.listLookup(oTrans,"SalesCatAdapter", recSelected, False,whereClause)
  Dim Fields As String() = New String(){"Description"}
  If (recSelected) Then
   ucbDescrip.ValueMember = "SalesCatID"
   ucbDescrip.DataSource = dsSales
   ucbDescrip.DisplayMember = "Description"
   ucbDescrip.SetColumnFilter(Fields)

 
 Dim grdSummaryOrderLines AS EpiUltragrid = Ctype(csm.GetNativeControlReference("bec51417-b286-4d61-a471-3912bc098905"),EpiUltraGrid)
 grdSummaryOrderLines.DisplayLayout.Bands(0).Columns("SalesCatID").Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList
 grdSummaryOrderLines.DisplayLayout.Override.AllowUpdate = Infragistics.Win .DefaultableBoolean .True
 

 

End if
End sub