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?