Bind data and auto show value in combobox

Question

Bind data and auto show value in dropdown combobox. I insert value in database and fetch value and show in datagrid view. It shows but datagridview combobox value not show.

Bikesh Srivastava · Answer

use debug and check data is coming or not if coming then check layout.

manoj kumar · Answer

dgvMaster.Rows(i).Cells(2).Value = dt2.Rows(i)(ITEM_DESC).ToString

Jitendra Yadav · Answer

Datagridview1.Rows[yourrowIndex].cells[  Your combobox column ]. value = // set the value member here

manoj kumar · Answer

any wrong code

manoj kumar · Answer

Private Sub dgvDetails_CellClick(ByVal sender As System.Object ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles dgvDetails.CellClick Dim q As String q = dgvDetails.CurrentRow.Index txtHregd.Text = dgvDetails.Rows(Convert.ToInt32(q)).Cells(0).Value.ToString txtSeriesNo.Text = dgvDetails.Rows(Convert.ToInt32(q)).Cells(1).Value.ToString dtpBillDate.Text = dgvDetails.Rows(Convert.ToInt32(q)).Cells(2).Value.ToString cbSeries.Text = dgvDetails.Rows(Convert.ToInt32(q)).Cells(3).Value.ToString txtTotal.Text = dgvDetails.Rows(Convert.ToInt32(q)).Cells(4).Value.ToString txtRmks.Text = dgvDetails.Rows(Convert.ToInt32(q)).Cells(5).Value.ToString dgvMaster.Rows.Clear() OraDap = New OracleDataAdapter(SELECT SL_NOFARMER_NAMEITEM_DESCWT_QNTYRATECUSTOMER_NAMEGATE_PASS_NO FROM EGMSDBA.H_REGISTER_DETAIL WHERE HSL_NO=' + txtHregd.Text + ' Oracon) dt2 = New DataTable OraDap.Fill(dt2) If dt2.Rows.Count > 0 Then 'dgvMaster.DataSource = dt2 ' Dim CBCell As DataGridViewComboBoxCell = DirectCast(dgvMaster.Rows(Convert.ToInt32(S)).Cells(2) DataGridViewComboBoxCell) 'Dim CBCell As New DataGridViewComboBoxCell If dt2.Rows.Count = 1 Then dgvMaster.Rows(0).Cells(0).Value = dt2.Rows(0)(SL_NO).ToString dgvMaster.Rows(0).Cells(1).Value = dt2.Rows(0)(FARMER_NAME).ToString dgvMaster.Rows(0).Cells(2).Value = dt2.Rows(0)(ITEM_DESC).ToString dgvMaster.Rows(0).Cells(3).Value = dt2.Rows(0)(WT_QNTY).ToString dgvMaster.Rows(0).Cells(4).Value = dt2.Rows(0)(RATE).ToString dgvMaster.Rows(0).Cells(5).Value = dt2.Rows(0)(CUSTOMER_NAME).ToString dgvMaster.Rows(0).Cells(6).Value = dt2.Rows(0)(GATE_PASS_NO).ToString Else dgvMaster.Rows.Add(dt2.Rows.Count - 1) For i As Integer = 0 To dt2.Rows.Count - 1 dgvMaster.Rows(i).Cells(0).Value = dt2.Rows(i)(SL_NO).ToString dgvMaster.Rows(i).Cells(1).Value = dt2.Rows(i)(FARMER_NAME).ToString dgvMaster.Rows(i).Cells(2).Value = dt2.Rows(i)(ITEM_DESC).ToString ' CType(dgvMaster.Rows(i).Cells(2) DataGridViewComboBoxCell).Value = CBCell.Value dgvMaster.Rows(i).Cells(3).Value = dt2.Rows(i)(WT_QNTY).ToString dgvMaster.Rows(i).Cells(4).Value = dt2.Rows(i)(RATE).ToString dgvMaster.Rows(i).Cells(5).Value = dt2.Rows(i)(CUSTOMER_NAME).ToString dgvMaster.Rows(i).Cells(6).Value = dt2.Rows(i)(GATE_PASS_NO).ToString Next End If End If End Sub

Ramesh Palanivel · Answer

Hi Manoj can you share the bind code for datagridview