list data pada sqLite
Selasa, 08 Desember 2020 Sunarto 0
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
Jumat, 20 November 2020 Sunarto 0
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
Kamis, 19 November 2020 Sunarto 0
buka browser
masukan url 192.168.100.1
masukan user : Support
masukan password : theworldinyourhand
klik log in
didukung oleh
Calistung Kelas 4 SD
Statistik WEB
Sunarto,S.Kom
Web Site :
http://www.sunarto.web.id
sunarrto.sby@gmail.com
Soal-Soal SD
Populer
Archives
- ► 2016 (211)
- ► 2015 (236)
Kategori
- Kumpulan SOal (57)
- lain-lain (57)
- ASP Classic (24)
- PHP (15)
- Windows (12)
- Office (7)
- Ceramah (6)
- Visual Studio (6)
- Delphi (5)
- HTML (5)
- SQL (5)
- Freeware (3)
- Android (2)