My first thought was to put a condition on the column property but I couldn't figure out how to do that. I hope someone will enlighten us on this one...
So...leaving that aside...
I've got the DataGrid showing the fields I want and formating a couple of them...Elsewhere I've got Comboboxes working...
What's the next step in getting the ComboBox into the DataGrid?
Rick
-----------
>Rich,
>
>I'm not sure what would be the best way to do this. My first thought is to generate the column in the SQL query but I would need to test this approach. Maybe someone else can help with that question.
>
>Regards,
>
>Terry Carroll
>
>
>
>>Terry,
>>I thought I was ready to go on, but I discovered I have a "side" question first... On the DataGridBoolColumn...
>>
>>How would I do that if I wanted to tie it to the Northwind.Orders.ShipCountry field...
>>display a checkbox Checked if Northwind.Orders.ShipCountry is not "USA"
>>and unchecked if it is "USA"
>>
>>Thanks for being patient with me,
>>Rick
>>------------------------------
>>>Rick,
>>>
>>>I too am a VFP developer climbing the learning curve of .Net. As a matter of fact I have only been working with it full time for 9 weeks so I’m by no means an authority but I am willing to help when I can. There are so many people on the forums that have helped me, and will help me in the future, so I want to give back.
>>>
>>>I have included a few lines of code that illustrates how to add a table style to a grid. The code should be added to a method in your form and then called after the forms call to InitializeComponent().
>>>
>>>In addition to defining the table style, you should know how to setup a combo box. Once you can worked with these two techniques it’s a snap to add the combobox with the Syncfusion class and I will be happy to assist you at that point.
>>>
>>>Happy .Net Programming
>>>
>>>Terry Carroll
>>>
>>>
>>>
>>>
>>> Public Sub SetGridTableStyles()
>>>
>>> ' This is a sample that will display 3 columns in a grid with the defined properties
>>> ' set.
>>>
>>> ' Int Table Style object
>>> Dim tsTableStyle As New DataGridTableStyle
>>> ' Set the name of the table to map to the style.
>>> tsTableStyle.MappingName = "Mail"
>>>
>>>
>>> ' For Each Column you want to display in the grid Init and
>>> ' set properties for a GridColumnStyle object.
>>>
>>> ' Note there are other properties you can set
>>> Dim Col1 As New DataGridTextBoxColumn
>>> Col1.MappingName = "M_From" ' Name of column to display
>>> Col1.HeaderText = "From" ' Header
>>> Col1.Width = 50
>>> ' Add this column to the table style object tsTableStyle
>>> tsTableStyle.GridColumnStyles.Add(Col1)
>>>
>>> Dim col2 As New DataGridTextBoxColumn
>>> col2.MappingName = "m_CoName" ' Name of column to display
>>> col2.HeaderText = "Name Addressed To" ' header
>>> col2.Width = 145
>>> tsTableStyle.GridColumnStyles.Add(col2)
>>>
>>> ' Note there is a .Net framework style class for a check box. Only textbox and check box
>>> ' are natively supported in .Net for now anyway.
>>> 'Example for checkbox
>>> Dim Col3 As New DataGridBoolColumn
>>>
>>> Col3.MappingName = "m_nocharg"
>>> Col3.HeaderText = "NC"
>>> Col3.Width = 20
>>> Col3.AllowNull = False
>>> tsTableStyle.GridColumnStyles.Add(Col3)
>>>
>>>
>>> ' Add the table style to the Grid
>>> Me.grdNameOfGrid.TableStyles.Clear()
>>> Me.grdNameOfGrid.TableStyles.Add(tsTableStyle)
>>>
>>>