slxdeveloper.com Community Forums

The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!

Architect Forums - Controls
Forum to discuss usage & tips for SalesLogix controls and other 3rd party ActiveX controls. View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to Controls | New Thread

View: Search:

Author

Thread: combo box column in data grid

Vamsi
Posts: 39

combo box column in data grid Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 02 Aug 07 8:36 AM

Dear all,

I am having a small issue in datagrid . I need to dynamically create combo column in datagrid in which i need to populate that combo box with some data fired by sql query can any body help in this issue

with regards
vamsi
icicle Technologies

[Reply][Quote]

Rodrigo Ginyaume
Posts: 20

Re: combo box column in data grid Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 09 Aug 07 1:30 PM

There is an example in the script "Insert Opportunity Common".

Here it is:

First you add the column:

Set col = grdProducts.Columns.Add(8)
col.FieldName = "PRICELEVEL" 'DNL
col.Caption = Application.Translator.Localize("Price Level")
col.Width = 130
col.Visible = True
'Set Drop Down to disable editing
col.DropDownListStyle = True

Then you add values:

Dim strSQL
Dim i

strSQL = "Select PROGRAM, 1 AS PRICE " _
& "From PRODUCTPROGRAM " _
& "Where PRODUCTID = '" & strPrdID & "'" 'DNL

Set objPrcLvlRS = objSLXDB.GetNewRecordset
With objPrcLvlRS
.Open strSQL, objSLXDB.Connection
If Not (.BOF And .EOF) Then
.MoveFirst
For i = 0 To .RecordCount - 1
If Not IsNull(.Fields.Item("PROGRAM").Value) Then 'DNL
grdProducts.Columns.Item("PRICELEVEL").Items.Add .Fields.Item("PROGRAM").Value 'DNL
End If
.MoveNext
Next
End If
End With

Hope this is what you were looking for, and hope it isn't too late to help you.

[Reply][Quote]

Vamsi
Posts: 39

Re: combo box column in data grid Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 12 Aug 07 5:16 AM

Thanks for your concern Mr. rodrigo

[Reply][Quote]

Page 1 of 1

You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2025 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 6/7/2025 1:09:05 PM