databinding to combo

[carlblanchard]

how do you get a combo box to show a selected index compared to the value store in the database via databinding.....

my binding code

Me.cboIndexPeriod.DataBindings.Add(New System.Windows.Forms.Binding("Text", MyDataSource, "Table.SpiderPeriod"))

contain int value i have a combo displaying values from table a

0, Weekly
1, monthly

i wana display the text value depending on the value in my dataset. this int value is the fk to the table that displays in the combo


hope this makes sense