>I have successfully added a combox to a DataGridView:
>
>

>DataGridViewComboBoxColumn colType = new DataGridViewComboBoxColumn();
>colType.HeaderText = "Total";
>colType.DropDownWidth = 90;
>colType.Width = 90;
>colType.MaxDropDownItems = 15;
>grdColumnInfo.Columns.Insert(0, colType);
>colType.Items.AddRange("", "Calc", "No Calc", "Pending");
>grdColumnInfo.Columns[7].DataPropertyName = "Total";
>

>
>In my SQL table is a column called Total. How do I set this combo to show the value from SQL?

Try setting the DataPropertyName directly on colType:

colType.DataPropertyName="Total"

Check this:http://msdn.microsoft.com/en-us/library/system.windows.forms.datagridviewcolumn.datapropertyname.aspx