tag:blogger.com,1999:blog-1434875882980174321.post5280095054464611854..comments2023-10-03T17:41:49.877+07:00Comments on .Net Tutorial & Solution: VB 9 - Stored Procedures in MS AccessJunindar, MVPhttp://www.blogger.com/profile/03221343212883759254noreply@blogger.comBlogger14125tag:blogger.com,1999:blog-1434875882980174321.post-29243601608335675702010-10-19T23:10:24.704+07:002010-10-19T23:10:24.704+07:00Kang Junindar, saya kemarin Nginstall hasil progra...Kang Junindar, saya kemarin Nginstall hasil program VB6 yang saya buat di laptop.. Namun ketika program .exe tersebut dijalankan mengakibatkan CPU Usage 100%.. pdahal ketika program yang saya buat tersebut di install ke CPU biasa. CPU Usage hanya 5%... Tolong Pendapatnya Kang tentang masalah ini?Verynandushttp://verynandushutabaliansblog.blogspot.com/noreply@blogger.comtag:blogger.com,1999:blog-1434875882980174321.post-86918423807299512332010-09-29T14:03:08.021+07:002010-09-29T14:03:08.021+07:00ini email saya junindar@gmail.comini email saya junindar@gmail.comJunindar, MVPhttps://www.blogger.com/profile/03221343212883759254noreply@blogger.comtag:blogger.com,1999:blog-1434875882980174321.post-60564420597240053912010-09-29T08:43:01.994+07:002010-09-29T08:43:01.994+07:00pak saya mau kirim lewat email aja ya pak tapi say...pak saya mau kirim lewat email aja ya pak tapi saya ngak tau email bapak email saya nextlagi16@yahoo.co.idsource vb and sqlhttps://www.blogger.com/profile/08618805459530170286noreply@blogger.comtag:blogger.com,1999:blog-1434875882980174321.post-10455658907733274012010-09-27T08:35:24.466+07:002010-09-27T08:35:24.466+07:00coba kirim kan projectnya ke saya, include DB
than...coba kirim kan projectnya ke saya, include DB<br />thanksJunindar, MVPhttps://www.blogger.com/profile/03221343212883759254noreply@blogger.comtag:blogger.com,1999:blog-1434875882980174321.post-56715630947634345402010-09-25T10:22:12.912+07:002010-09-25T10:22:12.912+07:00TETAPA AJA ERRORNYA
Failed to convert parameter v...TETAPA AJA ERRORNYA <br />Failed to convert parameter value from a DateFormat to a DateTime.source vb and sqlhttps://www.blogger.com/profile/08618805459530170286noreply@blogger.comtag:blogger.com,1999:blog-1434875882980174321.post-59042274020978355722010-09-25T10:20:37.162+07:002010-09-25T10:20:37.162+07:00UDAH PAK TETAP NGAK MAU JUGA PAKUDAH PAK TETAP NGAK MAU JUGA PAKsource vb and sqlhttps://www.blogger.com/profile/08618805459530170286noreply@blogger.comtag:blogger.com,1999:blog-1434875882980174321.post-48460485066006148352010-09-24T11:36:55.890+07:002010-09-24T11:36:55.890+07:00Dim paramtanggal As SqlParameter = New SqlParamete...Dim paramtanggal As SqlParameter = New SqlParameter("@tanggallahir ", SqlDbType.SmallDateTime)<br /><br />coba untuk paramtanggal buat seperti diatas...Junindar, MVPhttps://www.blogger.com/profile/03221343212883759254noreply@blogger.comtag:blogger.com,1999:blog-1434875882980174321.post-63576645367112805922010-09-24T09:03:54.323+07:002010-09-24T09:03:54.323+07:00dia menunjuk kesalahan padaini pak
Dim result As ...dia menunjuk kesalahan padaini pak<br /> Dim result As SqlDataReader = myCommand.ExecuteReader(CommandBehavior.CloseConnection)source vb and sqlhttps://www.blogger.com/profile/08618805459530170286noreply@blogger.comtag:blogger.com,1999:blog-1434875882980174321.post-42412400333787459952010-09-24T08:26:05.296+07:002010-09-24T08:26:05.296+07:00ini errornya
Failed to convert parameter value fro...ini errornya<br />Failed to convert parameter value from a DateFormat to a DateTime.<br />ini store procedurenya<br />CREATE PROCEDURE [dbo].[spinsertusers ]<br />@NAMA CHAR(10),<br />@tanggallahir smalldatetime<br /><br /> AS<br /> INSERT INTO [TB_NAMA]<br />( [Nama],[tanggallahir])<br />VALUES<br />( @Nama,@tanggallahir)<br />GOsource vb and sqlhttps://www.blogger.com/profile/08618805459530170286noreply@blogger.comtag:blogger.com,1999:blog-1434875882980174321.post-47582806664674350182010-09-23T16:12:45.869+07:002010-09-23T16:12:45.869+07:00Detail error nya apa??
coba copy kasih liat stored...Detail error nya apa??<br />coba copy kasih liat stored procedure yang kamu buat..Junindar, MVPhttps://www.blogger.com/profile/03221343212883759254noreply@blogger.comtag:blogger.com,1999:blog-1434875882980174321.post-62643005980840606442010-09-23T14:10:39.143+07:002010-09-23T14:10:39.143+07:00ini di classaccesdata
Public Function insertusert(...ini di classaccesdata<br />Public Function insertusert(ByVal nama As String, ByVal tanggallahir As datettime) As SqlDataReader<br /> Dim mycon As accesdata.koneksi = New accesdata.koneksi<br /> Dim cmd As SqlCommand = New SqlCommand("SpInsertusers", mycon.open)<br /> cmd.CommandType = CommandType.StoredProcedure<br /> Dim paramnama As SqlParameter = New SqlParameter("@nama", SqlDbType.Char, 20)<br /> paramuser.Value = nama<br /> Dim paramtanggal As SqlParameter = New SqlParameter("@tanggallahir ", datetime,4)<br /> parampassword.Value = tanggallahir<br /> With cmd.Parameters<br /> .Add(paramnama)<br /> .Add(paramtanggal)<br /><br /> End With<br /> Dim result As SqlDataReader = cmd.ExecuteReader(CommandBehavior.CloseConnection)<br /> Return result<br /><br /> End Function<br /><br /><br />ini program button nyapak<br />sub btnsimpan()<br />accesdata.insertuser(txtnama.text,txttanggal.text)<br />ngak bisa diinput dia pak <br />maupun select pak ngak mau juga bagaimana solusinya pak <br />mulai dari bikin clasnya samapai aplikasi buttonyan pak<br />terima kasih pak atas tanggapanyasource vb and sqlhttps://www.blogger.com/profile/08618805459530170286noreply@blogger.comtag:blogger.com,1999:blog-1434875882980174321.post-78063062446746944232010-09-23T14:08:25.978+07:002010-09-23T14:08:25.978+07:00This comment has been removed by the author.source vb and sqlhttps://www.blogger.com/profile/08618805459530170286noreply@blogger.comtag:blogger.com,1999:blog-1434875882980174321.post-63713127675576111212010-09-23T11:06:58.947+07:002010-09-23T11:06:58.947+07:00bisa ksih contoh codenya..
trus detail yang kamu i...bisa ksih contoh codenya..<br />trus detail yang kamu inginkan seperti apa?? jika ada error bisa di share error message nya..Junindar, MVPhttps://www.blogger.com/profile/03221343212883759254noreply@blogger.comtag:blogger.com,1999:blog-1434875882980174321.post-15814825429073259152010-09-23T09:39:05.963+07:002010-09-23T09:39:05.963+07:00pak mau nannya nih pak saya terkendala memangil st...pak mau nannya nih pak saya terkendala memangil store procedure di vb 2005 dimana format tanggal tidak bisa di input atau di select,pak tolong pencerahanya gimana cara menggil store procedure di vb paksource vb and sqlhttps://www.blogger.com/profile/08618805459530170286noreply@blogger.com