PHP Indonesia - Facebook: agan2 maaf kalo keluar dari jalur, lagi urgent ban...

PHP Indonesia - Facebook PHP Indonesia is a community for everyone that loves PHP. Our focus is in the PHP world but our topics encompass the entire LAMP stack. Topics include PHP coding, to memcached handling, db optimizations, server stack, web server tuning, code deploying, hosting options and much much more. Youtube Channel : http://www.youtube.com/user/OurPHPIndonesia Twitter : @php_indonesia NOTE: Rules for Wall posting: https://www.facebook.com/groups/35688476100/doc/10151597056316101/ Daftar Keanggotaan : http://www.facebook.com/groups/35688476100/doc/10150671770741101/

Creating iOS Games: Beginner Course Marin Todorov teaches you how to create an iPhone game easily and simply using Cocos2d in this $99 online course. From our sponsors

agan2 maaf kalo keluar dari jalur, lagi urgent ban... Aug 21st 2013, 10:01, by Xiao Yen Xiao Yen 10:01am Aug 21 agan2 maaf kalo keluar dari jalur, lagi urgent banget soalnya u,u ada yg bisa visual studio 2005 ? kalo pas di running muncul errornya kayak gini, itu error dimananya ya ? makasih 黄天文 10:03am Aug 21 post querynya donk.. Ricky Wisnadri S. Kom 10:03am Aug 21 Itukan dah dikasih tahu errornya kenapa, coba liat querynya itu. Gunawan Mujur Wibisono 10:04am Aug 21 liat pada tanggalnya.. km pake model tgl yyyy-mm-dd ??? 黄天文 10:04am Aug 21 copy nilai CMD.CommandText sblm masuk ke ExecuteNonQuery itu.. Xiao Yen 10:04am Aug 21 query dimananya ya gan ? sorry masih newbie banget nih :( Nur Hidayat 10:05am Aug 21 waktu generate query, ketika mengubah tanggal di dotnet menjadi string, gunakan format "YYYY-MM-DD" Nur Hidayat 10:05am Aug 21 newbie? pertanyaan saya, itu coding yang bikin siapa? 黄天文 10:05am Aug 21 mngkn ikut tutorial buku'' menyesatkan 黄天文 10:05am Aug 21 awkwakkaw Xiao Yen 10:05am Aug 21 aku :3 aku baru belajar soalnya :3 Ricky Wisnadri S. Kom 10:06am Aug 21 Cari di variable AA, itu querynya sepertinya. Nur Hidayat 10:07am Aug 21 kita semua juga baru belajar koq, nah sekarang cara melakukkan dubugging-nya adalah teman2 disini perlu code yang lebih lengkap agar bisa cari errornya dimana Michael Lestario Halim 10:07am Aug 21 share codenya aj :D di pastebin.. biar lebih jelas ngelihat codeny :D 黄天文 10:07am Aug 21 sblm CMD.ExecuteNonQuery tambahkan ini Debug.WriteLine(AA).. udh tu execute seperti biasa.. ketika terjadi error, liat ke Output windows querynya kayak gmn.. Xiao Yen 10:08am Aug 21 ini codingnya : If Trim(Me.TextBox1.Text) = "" Then MsgBox("DATA HARUS DI ISI", MsgBoxStyle.Information, "Error") Exit Sub End If Call Buka_DB() If STATUS_input_data_baru = True Then Dim MM As String MM = "SELECT * FROM depart " & _ " WHERE kode_depart='" & Trim(Me.TextBox1.Text) & "'" CMD = New Odbc.OdbcCommand(MM, CONN) Dim DTReader_depart As Odbc.OdbcDataReader DTReader_depart = CMD.ExecuteReader() If DTReader_depart.HasRows Then MsgBox("KODE SUDAH ADA..", MsgBoxStyle.Information) DTReader_depart.Close() CMD.Dispose() Exit Sub End If DTReader_depart.Close() Dim AA As String AA = "INSERT INTO depart" & _ " (kode_depart, tgl, nama_karyawan, nama_departemen, jabatan) " & _ " VALUES " & _ " ('" & Trim(Me.TextBox1.Text) & "', " & _ " CONVERT(DATETIME,'" & Me.DateTimePicker1.Value & "',102), " & _ " '" & Me.TextBox2.Text & "'," & _ " '" & Me.TextBox3.Text & "'," & _ " '" & Me.TextBox4.Text & "')" CMD = New Odbc.OdbcCommand(AA, CONN) CMD.ExecuteNonQuery() CMD.Dispose() Else Dim ZZ As String ZZ = "UPDATE depart SET " & _ " kode_depart ='" & Trim(Me.TextBox1.Text) & "', " & _ " tgl ='" & Trim(Me.DateTimePicker1.Text) & "' " & _ " nama_karyawan ='" & Trim(Me.TextBox2.Text) & "' " & _ " nama_departemen ='" & Trim(Me.TextBox3.Text) & "' " & _ " jabatan ='" & Trim(Me.TextBox4.Text) & "' " & _ " WHERE kode_depart ='" & Trim(Me.TextBox1.Text) & "' " CMD = New Odbc.OdbcCommand(ZZ, CONN) CMD.ExecuteNonQuery() CMD.Dispose() End If Call TOMBOL_HIDUP() STATUS_input_data_baru = False Me.TextBox1.Enabled = False MsgBox("DATA TELAH DI SIMPAN..", MsgBoxStyle.Information, "Simpan") Call LISTVIEW_to_FORM() Askinas Kurniawan 10:12am Aug 21 ane ga ngerti visual studio 2005 tp bagian ini bener kah kaya gini CONVERT(DATETIME,'" & Me.DateTimePicker1.Value & "',102) bukan CONVERT(DATETIME, Me.DateTimePicker1.Value ,102) Michael Lestario Halim 10:15am Aug 21 ehm.. ane jg mw nanya donk.. yg convert itu mksdnya mau ngubah format datetimepicker ke format yang sesuai sama datetimenya database bukannya? soalnya dulu saya gak pake convert buat masukin ke dbnya :D Ricky Wisnadri S. Kom 10:15am Aug 21 Coba caritahu cara penggunaan function CONVERT di SQL Server nya, sudah betul belum penggunaannya, seperti nya masih ada salah penggunaannya. Reno Fizaldy 10:15am Aug 21 Besok2 kalau mau tanya pake FB cewek aaah :3 Ricky Wisnadri S. Kom 10:16am Aug 21 Reno Fizaldy, kwkwkwk... *ide bagus.... wkwkwkwkwk... Ricky Wisnadri S. Kom 10:18am Aug 21 Coba liat disini : http://www.sqlusa.com/bestpractices/datetimeconversion/ Xiao Yen 10:18am Aug 21 udah gan c: makasih ya ^^ Xiao Yen 10:31am Aug 21 yg tadi udah gan, cuman pas udh ke save, yg di listviewnya ngga muncul, itu gimana ya ?

You are receiving this email because you subscribed to this feed at blogtrottr.com. If you no longer wish to receive these emails, you can unsubscribe from this feed, or manage all your subscriptions