bind data from database to datagridview combobox
-
Hello Experts!! I am using following code to bind data from db to datagridview column having type combobox. but i dont know how to show data into combobox.
Dim o As New designpant
Dim i As Integer
rssearch = New ADODB.Recordset
rssearch.Open("select srno from designpant", con, ADODB.CursorTypeEnum.adOpenDynamic, ADODB.LockTypeEnum.adLockPessimistic)
While Not rssearch.EOF
o = New designpant
o.dsrno = rssearch.Fields("srno").ValueDim row1() As String = {o.dsrno} Dim rows() As Object = {row1} Dim rowArray As String() For Each rowArray In rows Dim no As Integer = rowArray(0) 'ComboBox1.Items.Add(no) dgvsherwanibottom.Columns **//like combobox1 i want to show rowArray contents into gridview combobox ** Next rowArray
-
Hello Experts!! I am using following code to bind data from db to datagridview column having type combobox. but i dont know how to show data into combobox.
Dim o As New designpant
Dim i As Integer
rssearch = New ADODB.Recordset
rssearch.Open("select srno from designpant", con, ADODB.CursorTypeEnum.adOpenDynamic, ADODB.LockTypeEnum.adLockPessimistic)
While Not rssearch.EOF
o = New designpant
o.dsrno = rssearch.Fields("srno").ValueDim row1() As String = {o.dsrno} Dim rows() As Object = {row1} Dim rowArray As String() For Each rowArray In rows Dim no As Integer = rowArray(0) 'ComboBox1.Items.Add(no) dgvsherwanibottom.Columns **//like combobox1 i want to show rowArray contents into gridview combobox ** Next rowArray
-
1.
DataGridViewComboBoxColumn
2.DataGridViewComboBoxColumn.DataSource
3.DataGridViewComboBoxColumn.DisplayMember
4.DataGridViewComboBoxColumn.ValueMember