You may have known using ValidationType.DropDownList/List/FreeList to create dropdownlist cells. The control support value/text pair in dropdownlist/list/freelist. You may use the Validation.ValueList.Add method to add new value/text pair into the list.
[C#]
// adds to a bindcolumn
GridWeb1.WebWorksheets[0].BindColumns["CategoryID"].Validation.ValueList.Add("1,1:test");
// adds to a validation cell
GridWeb1.WebWorksheets[1].Cells["A1"].Validation.ValueList.Add("1,1:test");
[VB]
' adds to a bindcolumn
GridWeb1.WebWorksheets(0).BindColumns("CategoryID").Validation.ValueList.Add("1,1:test")
' adds to a validation cell
GridWeb1.WebWorksheets(1).Cells("A1").Validation.ValueList.Add("1,1:test")
As you can see, the "1" is the value of the list item, and the "1:test" is the displayed text of the list item.
And you may use the LoadValueList method to load list items from a dataview object:
[C#]
GridWeb1.WebWorksheets[0].BindColumns["CategoryID"].Validation.LoadValueList(dataSet31.Categories.DefaultView, "CategoryID", "CategoryName", true);
[VB]
GridWeb1.WebWorksheets(0).BindColumns("CategoryID").Validation.LoadValueList(dataSet31.Categories.DefaultView, "CategoryID", "CategoryName", True)