Skip to main content

How To Check If Cell Value In Datagridview Is Null Or Empty

Here is this another thing that i try to solve in doing a project with VB.Net.
Scheme : i want my application to load data from datagridview to textbox or combobox but the trouble is datagridview cannot load data from an empty/null cell column.
 

Private Sub DgvSTAMP_CellContentClick(ByVal sender As System.Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles DgvSTAMP.CellContentClick
      
'Cek bila nilai pada cell di datagridview ada yang kosong
        For F As Integer = 0 To DgvSTAMP.RowCount - 1
            If IsDBNull(DgvSTAMP.CurrentRow.Cells(1).Value) Then
                TxtSTAMPNO.Text = ""
            Else
                TxtSTAMPNO.Text = DgvSTAMP.Item(1, DgvSTAMP.CurrentRow.Index).Value
            End If


            If IsDBNull(DgvSTAMP.CurrentRow.Cells(2).Value) Then
                TxtINSPECTORNAME.Text = ""
            Else
                TxtINSPECTORNAME.Text = DgvSTAMP.Item(2, DgvSTAMP.CurrentRow.Index).Value
            End If


            If IsDBNull(DgvSTAMP.CurrentRow.Cells(3).Value) Then
                TxtINSPECTORJOB.Text = ""
            Else
                TxtINSPECTORJOB.Text = DgvSTAMP.Item(3, DgvSTAMP.CurrentRow.Index).Value
            End If


            If IsDBNull(DgvSTAMP.CurrentRow.Cells(4).Value) Then
                CmbGROUP.Text = ""
            Else
                CmbGROUP.Text = DgvSTAMP.Item(4, DgvSTAMP.CurrentRow.Index).Value
            End If


            If IsDBNull(DgvSTAMP.CurrentRow.Cells(5).Value) Then
                CmbAREA.Text = ""
            Else
                CmbAREA.Text = DgvSTAMP.Item(5, DgvSTAMP.CurrentRow.Index).Value
            End If


            If IsDBNull(DgvSTAMP.CurrentRow.Cells(6).Value) Then
                CmbCUREGROUP.Text = ""
            Else
                CmbCUREGROUP.Text = DgvSTAMP.Item(6, DgvSTAMP.CurrentRow.Index).Value
            End If
        Next
    End Sub

Comments

Popular posts from this blog

CheckBox dalam DataGridView VB.Net

Pada saat membuat aplikasi (VB.Net) untuk materi skripsi, terbesit bagaimana cara baru untuk memberikan hak akses user secara dinamis pada sistem. setelah dicoba dengan tanya-tanya. akhirnya bisa mendapatkan cara itu... wah sesuatu banget dah.... inti dari posting ini hanya pada barisan kode berikut : Private Sub BtnSIMPAN_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BtnSIMPAN.Click         Dim Y As String = Mid(CmbUSER.Text, 1, 7)         Dim iROW As Integer         Dim AKSES As String         For iROW = 0 To DGVSample.Rows.Count - 1             'AksesBox = Nama CheckBox yang ada di DatagridView             If DGVSample.Rows(iROW).Cells("AksesBox").Value Then    ...

Create Comment As .xls In Farpoint Spread

  Private Sub TAGS_PARENTING()         Dim DTPopUp As New DataTable         With DTPopUp             .Columns.Add("SEQ", GetType(String))             .Columns.Add("QTY", GetType(String))             .Columns.Add("ETD", GetType(String))             .Columns.Add("ETA", GetType(String))             DTPopUp = MePostab_Control.Cari_TAG_PARENTING         End With         With FPPOSTAB             For GG As Integer = 0 To .ActiveSheet.RowCount - 1             ...