trouble adding a databound combobox to a datagrid
I have a datagrid that has columns like "tasks", "date completed" and "rating". I am retrieving data and binding the grid like this:
<code>
DataSet dsProgramTasks = data.GetStandardProgramTasks(); // ADO.Net access method
</code>
I would like the "rating" column to be databound a combo-box. I have an access method for this as well:
<code>
DataSet dsratings = data.GetRatingss(); // ADO.Net access method
</code>
Now, how do I add a combo box to the datagrid? I know that I have to alter the datagrid tablestyle somehow but I'm at a loss exactly what to do....I think I have to do something like this (but I can't get it to work!)
<code>
DataGridTableStyle myGridStyle = new DataGridTableStyle();
myGridStyle.MappingName = "Tasks";
DataGridTextBoxColumn nameColumnStyle = new DataGridTextBoxColumn();
nameColumnStyle.MappingName = "Rating";
nameColumnStyle.HeaderText = "Rating";
myGridStyle.GridColumnStyles.Add(nameColumnStyle);
dgProgramTasks.TableStyles.Add(myGridStyle);
</code>
