Blog

Bind DataGridView Combobox cell with DataSource

Posted by Ankur Gupta in Blogs | Active Directory in VB.NET on Jun 04, 2010

How can we bind DataGridView Combobox cell with DataSource

Tweet
6579
0

Here is the code to Bind DataGridView combobox cell with DataSource
First insert all items in a List of Strings and then Bind this string with DataGridView combobox cell
'grdBilling is a DataGridView

Dim List As New List(Of String)

strsql = "Select BatchNo from Purchase where Code = '" & grdBilling.Rows(e.RowIndex).Cells(0).Value & "'"
Dim objDataAdapter As New SqlClient.SqlDataAdapter(strsql, Conn)
objDataAdapter.Fill(ds)
If ds.Tables(0).Rows.Count > 0 Then
For item As Integer = 0 To ds.Tables(0).Rows.Count - 1
myList.Add(ds.Tables(0).Rows(item)(0).ToString())
Next
Else
End If
If ds.Tables(0).Rows.Count > 0 Then
'Cast DataGridView cell with DataGridView combobox cell and strDataSource

CType(grdBilling.Rows(e.RowIndex).Cells(2), DataGridViewComboBoxCell).DataSource = myList
End If

post comment