isNull in vb.net 2019

isNull di vb.net silahkan menggunakan

 IsDBNull()



list data pada sqLite

     Public Sub NilMahasiswa()

        Dim sqlite_conn As SQLiteConnection

        sqlite_conn = New SQLiteConnection("Data Source=D:\sqlite\jajal.db;Version=3;New=True;Compress=True;")


        ' open the connection:

        sqlite_conn.Open()

        Using cmd As New SQLiteCommand(sqlite_conn)

            cmd.CommandText = "SELECT npm,nama,uts,uas,total,nilai,prosen,tanggalEntryNilai FROM krs011 where npm='" & npm.Text & "' and kode_kul='" & downloadMATAKULIAH.kode_kul.Text & "' and kelas='" & downloadMATAKULIAH.kelas.Text & "';"

            Dim rdrMataKuliah As SQLiteDataReader = cmd.ExecuteReader()

            Using rdrMataKuliah

                While (rdrMataKuliah.Read())

                    npm.Text = rdrMataKuliah.GetString(0)

                    nama.Text = rdrMataKuliah.GetString(1)

                    presensi.Text = rdrMataKuliah.GetValue(6)

                    uts.Text = Replace(rdrMataKuliah.GetValue(2), ",", ".")

                    uas.Text = Replace(rdrMataKuliah.GetValue(3), ",", ".")

                    nilai.Text = rdrMataKuliah.GetString(5)

                    total.Text = Replace(rdrMataKuliah.GetValue(4), ",", ".")



                    If Trim(rdrMataKuliah.GetValue(7).ToString) = "" Then

                        terakhirDiUpdate.Text = "NULL"

                    Else

                        terakhirDiUpdate.Text = "Tanggal Update Terakhir : " & Replace(rdrMataKuliah.GetDateTime(7), ",", ".")

                    End If


                End While

            End Using

        End Using


    End Sub

memeriksa suatu record pada field yang bernilai KOSONG di VB.NET 2019

vNilaiField=Trim(rdrMataKuliah.GetValue(7).ToString) 

maka nilai dari variabel vNilaiField adalah kosong

auto shutdown Wifi routher HG8245H5

 berikut langkah auto shutdown Wifi routher HG8245H5, indihome :

1. Masuk ke url : http://192.168.100.1/

2. masukan user dan password : Support dan theworldinyourhand

3. klik advance

4. WLAN

5. Automatic WiFi Shutdown

6. centang Enable automatic WiFi shutdown

7. Masukan Start dan End, kemudian hari apa saja

8. Klik Apply

9. Selesai



user dan Password utk akses admik routher HG8245H5 indihome

buka browser

masukan url 192.168.100.1

masukan user : Support

masukan password : theworldinyourhand

klik log in


Postingan Lebih Baru Postingan Lama