Attach Database SQL Server

Malam semua kali ini saya akan memposting tentang Cara Attach Database SQL Server<br /> <br /> Oke langsung saja yang perlu di persiapkan adalah<br /> 1. File .mdf  dan .ldf<br /> 2. SQL Server jika menggunakan SQL Server Express harap instal SQL Management Studio terlebih dahulu<br /> <br /> Langkah pertama adalah<br /> 1. Buka SQL Server Management Studio<br /> 2. Pilh Server, masukan username dan password lalu klik connect <br /> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgSfJfuRprSkyDxasZn7I_8ZCcAsC8lRkaH18COIT7y7HSw1ro8wYPkgVriEzIr1JfxP3zljy1FIQZrwQx7qUCF10PoMwNkUBJMuAiSPtG57EhILWJALywi0uqIDEKeaz8ltUxQictzQdNz/s1600/Sql_server_1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Cara Attach Database SQL Server" border="0" height="179" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgSfJfuRprSkyDxasZn7I_8ZCcAsC8lRkaH18COIT7y7HSw1ro8wYPkgVriEzIr1JfxP3zljy1FIQZrwQx7qUCF10PoMwNkUBJMuAiSPtG57EhILWJALywi0uqIDEKeaz8ltUxQictzQdNz/s320/Sql_server_1.png" title="Cara Attach Database SQL Server" width="320" /></a></div> 3. Klik kanan database yang ada di sebelahkanan<br /> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiIeVlJ8aZo2GlIKzauLxwD_dZb6xD8sx-iKGtMLVv898Ql9RD-AbX00r5ArGUsg0BXcwXm7sC_Y8boIYo1pSmaJ6WwRZ1q7dGJjeH8jpdSKPY-GuORiTc1RJ3uKqqK4M-S01AMEoLNC8D0/s1600/sql_server2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Cara Attach Database SQL Server" border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiIeVlJ8aZo2GlIKzauLxwD_dZb6xD8sx-iKGtMLVv898Ql9RD-AbX00r5ArGUsg0BXcwXm7sC_Y8boIYo1pSmaJ6WwRZ1q7dGJjeH8jpdSKPY-GuORiTc1RJ3uKqqK4M-S01AMEoLNC8D0/s1600/sql_server2.png" title="Cara Attach Database SQL Server" /></a></div> <br />  4. Maka akan muncul tampilan seperti di bawah ini, lalu klik add dan cari file .mdf yang kamu punya lalu klik OK<br /> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg1Kn2EzpzTEPfxCZhD1fjQQwA_l1StX1wzxvfCGzL32S2GEWv9y1jWx-R9S3FDyOJF6Bp_FFTkUBbstwPHcrOufNyD0dlH1wJHzjHBVaVGGWKKFFV4RUXRNNeuQ4Bx6C0xV3JvNQ3VbjYN/s1600/Sql_server3.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Cara Attach Database SQL Server" border="0" height="288" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg1Kn2EzpzTEPfxCZhD1fjQQwA_l1StX1wzxvfCGzL32S2GEWv9y1jWx-R9S3FDyOJF6Bp_FFTkUBbstwPHcrOufNyD0dlH1wJHzjHBVaVGGWKKFFV4RUXRNNeuQ4Bx6C0xV3JvNQ3VbjYN/s320/Sql_server3.png" title="Cara Attach Database SQL Server" width="320" /></a></div> 5. Dan langkah terakhir anda tinggal klik ok, lalu tunggu lah sejenak sampai proses selesai<br /> <br /> <br /> Semoga berhasil<br /> Sekian dulu dari saya<br /> semoga artikel ini bermanfaat untuk anda, terima kasih sudah mengunjungi blog saya :)

Attach Database SQL Server

Malam semua kali ini saya akan memposting tentang Cara Attach Database SQL Server Oke langsung saja yang perlu di persiapkan adalah 1. Fi...

Read more »

10 Cara Meningkatkan SEO Blog

<div style="text-align: center;"> <img height="319" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhRUuxKo9c83sbQpdUTj8T6OCsnf8_EuNHslXmEZD9JiAZBK7kTVmW_aS5HXgPMfm9TgoGzWr9fHDP0sk0hK0VbJo-we7cTWeezkRstBfJMQjdt4VGImyEdPMVgV_Z-7IjhWACur6nVkg4q/s320/teknik+seo.jpg" width="320" /> </div> <span style="background-color: white; font-family: inherit;"><b style="line-height: 19px; text-align: left;"><br /></b></span><br /> <span style="background-color: white; font-family: inherit;"><b style="line-height: 19px; text-align: left;">1. Update Artikel Setiap Hari</b><br style="line-height: 19px; text-align: left;" /><span style="line-height: 19px; text-align: left;">Selalu meng-update artikel adalah pekerjaan wajib sebagai blogger misalnya, dan tentunya artikel tersebut adalah artikel yang sangat memiliki nilai pikat yang tinggi. Tak usah terlalu banyak menulis artikel akan tetap cukup satu atau dua saja kalian update, asal itu adalah artikel yang fresh dan memang sedang dicari-cari orang (</span><i style="line-height: 19px; text-align: left;">masih hangat dibicarakan oleh media</i><span style="line-height: 19px; text-align: left;">). Tujuannya adalah agar situs kalian ini tetap terlihat hidup.</span></span><br /> <blockquote class="tr_bq"> <span style="background-color: white; font-family: inherit;"><b style="line-height: 19px; text-align: left;">2. Submit Artikel ke Sosial Bookmark</b></span> </blockquote> <blockquote class="tr_bq"> <span style="background-color: white; font-family: inherit;"><span style="line-height: 19px; text-align: left;">Alat promosi yang memang sangat ampuh adalah submit artikel ke berbagai sosial bookmark. Banyak sosial bookmark yang tersedia di internet, misalnya<b> <a href="http://www.lintas.me/" target="_blank">Lintas.me</a></b>,<a href="http://www.infogue.com/" target="_blank"><b>Infogue.com</b></a>,<a href="http://www.antarblog.com/" target="_blank"><b>Antarblog.com</b></a></span><span style="line-height: 19px; text-align: left;"> dan masih banyak lagi yang lainnya.</span></span><span style="background-color: white; font-family: inherit;"><span style="line-height: 19px; text-align: left;">Saran saya untuk para blogger pemula, submitlah artikel / konten blog kalian ke sosial bookmark, jika kalian beruntung dan masuk dalam jajaran 10 Top Hits, maka kalian akan cepat kebanjiran banyak pengunjung.</span></span></blockquote> <span style="background-color: white; font-family: inherit;"><br style="line-height: 19px; text-align: left;" /><b style="line-height: 19px; text-align: left;">3. Pasang Artikel Terkait di Blog / website</b><br style="line-height: 19px; text-align: left;" /><span style="line-height: 19px; text-align: left;">Salah satu cara jitu ini juga sangat banyak digunakan bagi kalangan webmaster maupun blogger profesional SEO sekalipun. Mengapa ini juga tergolong trik yang bisa membuat pengunjung mebeludak, karena cara ini pun cara yang sangat friendly sebab memberi kemudahan untuk para pengunjung untuk dengan cepat mengetahui berita-berita atau konten-konten yang terkait.</span></span><br /> <blockquote class="tr_bq"> <span style="background-color: white; font-family: inherit;"><b style="line-height: 19px; text-align: left;">4. Buatlah Navigari Situs yang Baik dan Terarah</b></span> </blockquote> <blockquote class="tr_bq"> <span style="background-color: white; font-family: inherit;"><span style="line-height: 19px; text-align: left;">Ciptakan sebuah kenyamanan bagi para pengunjung dengan menyediakan layanan navigasi yang baik. Navigasi ini juga sebagai langkah ampuh untuk membuat situs kalian dibanjiri para pengunjung. Pembuatan menu misalnya adalah salah satu pemegang peran penting karena dengan menyediakan menu-menu pada situs, ini adalah sebuah gambaran kecil tentang sitemap situs kalian sendiri.</span></span></blockquote> <span style="background-color: white; font-family: inherit;"><br style="line-height: 19px; text-align: left;" /><b style="line-height: 19px; text-align: left;">5. Pasang Arsip Blog</b><br style="line-height: 19px; text-align: left;" /><span style="line-height: 19px; text-align: left;">Jika anda malas memasang artikel berkaitan, hal yang mungkin anda lakukan adalah memasang blog arsip merupakan pilihan yang wajib untuk di lakukan. banyak blog-blog bermuatan besar seperti terselubung.blogspot.com yang menjadikan blog arsip nya sebagai ladang pageview dan ini memang terbukti ampuh. Cara memasangnya sendiri cukup mudah karena sudah disediakan oleh blogspot di <b>tambah gadget >>> Arsip blog</b></span></span><br /> <blockquote class="tr_bq"> <span style="background-color: white; font-family: inherit;"><b style="line-height: 19px; text-align: left;">6. Pasang Artikel Penting di Sidebar</b></span> </blockquote> <blockquote class="tr_bq"> <span style="background-color: white; font-family: inherit;"><span style="line-height: 19px; text-align: left;">Manfaatkanlah fasilitas sidebar anda untuk memberi kemudahan bagi para pengunjung sebuah situs adalah untuk menemukan artikel yang sangat bermanfaat, navigasikan sidebar anda dengan </span><i style="line-height: 19px; text-align: left;">blogroll</i><span style="line-height: 19px; text-align: left;"> atau link artikel andalan, jangan lupa untuk menuliskan judul yang menarik dan tampilan elegan ini akan sangat membantu jumlah pageview anda dimasa yang akan datang.</span></span></blockquote> <span style="background-color: white; font-family: inherit;"><br style="line-height: 19px; text-align: left;" /><b style="line-height: 19px; text-align: left;">7. Buatlah Blog Menjadi Secepat Mungkin</b><br style="line-height: 19px; text-align: left;" /><span style="line-height: 19px; text-align: left;">Hal ini bisa kalian lakukan dengan cara menghapus beberapa widget yang dirasa kurang terlalu penting namun justru ini akan memberatkan sebuah speed situs kalian untuk di load oleh web browser para pengunjung. Semakin lama halaman situs kalian terbuka maka secara otomatis akan melangsingkan jumlah visitor kalian.Sobat bisa mengecek kecepatan blog sobat di <a href="http://iwebtool.com/" target="_blank"><b>Iwebtool.com</b></a></span></span><br /> <blockquote class="tr_bq"> <span style="background-color: white; font-family: inherit;"><b style="line-height: 19px; text-align: left;">8. Gunakan Jejaring Sosial</b></span> </blockquote> <blockquote class="tr_bq"> <span style="background-color: white; font-family: inherit;"><span style="line-height: 19px; text-align: left;">Manfaatkan jejaring-jejaring sosial yang tersedia seperti </span><b style="line-height: 19px; text-align: left;"><a href="https://facebook.com/mylaboratorium" target="_blank">Facebook</a></b><span style="line-height: 19px; text-align: left;"> dan </span><b style="line-height: 19px; text-align: left;"><a href="https://twitter.com/#%21/My_Laboratorium" target="_blank">Twitter</a></b><span style="line-height: 19px; text-align: left;">. Hal ini bisa kalian lakukan dengan berpromosi konten-konten yang menarik dan tentunya yang sedang hot news atau yang paling banyak dicari oleh orang-orang.</span></span></blockquote> <span style="background-color: white; font-family: inherit;"><br style="line-height: 19px; text-align: left;" /><b style="line-height: 19px; text-align: left;">9. Lakukan Backlink</b><br style="line-height: 19px; text-align: left;" /><span style="line-height: 19px; text-align: left;">Cara promosi yang sangat familiar sekali untuk kalangan blogger adalah backlink.Saling bertukar link (Link Exchange) adalah hal yang perlu dilakukan. Sebagai kiat cemerlang untuk berpromosi, ini juga bisa sebagai cara untuk ajang kekerabatan antar blogger.</span></span><br /> <blockquote class="tr_bq"> <span style="background-color: white; font-family: inherit;"><b style="line-height: 19px; text-align: left;">10. Daftarkan Blog ke Mesin Pencari</b></span> </blockquote> <blockquote class="tr_bq"> <span style="background-color: white; font-family: inherit;"><span style="line-height: 19px; text-align: left;">Ini adalah hal yang palin penting bagi para blogger yang mempunyai blog pastinya karena dengan cara ini, secara langsung kalian akan mempermudah peng-indeks-an URL kalian di mesin pencari secara mudah. Artinya jika kalian mendaftarkan URL kalian sendiri, ini akan mempermudah mesin pencari mengindeks URL tanpa ia harus mencarinya sendiri yang tentunya akan memakan waktu yang lumayan lama.Sobat bisa mendaftarkan blog sobat di <a href="http://mylaboratorium.blogspot.com/2011/01/free-web-submission.html" target="_blank"><b>Submit Your Blog</b></a></span></span></blockquote> <div style="background-color: white; border: medium none; color: black; overflow: hidden; text-align: left; text-decoration: none;"> Source : http://mylaboratorium.blogspot.com/2012/05/10-cara-meningkatkan-seo-blog.html</div>

10 Cara Meningkatkan SEO Blog

1. Update Artikel Setiap Hari Selalu meng-update artikel adalah pekerjaan wajib sebagai blogger misalnya, dan tentunya artikel terseb...

Read more »

Statement Case Di VB.NET

Pagi semua kali setelah kemarin saya memposting tentang <a href="http://dwirandyherdinanto.blogspot.com/2013/12/statement-if-di-vbnet.html" target="_blank">Statement IF Di VB.NET</a><br /> kali ini saya akan melanjutkan postingan saya yaitu <a href="http://dwirandyherdinanto.blogspot.com/2013/12/statement-case-di-vbnet.html" target="_blank">Statement Select Case Di VB.NET</a><br /> Select Case mempunyai fungsi yang sama dengan switch case pada php dan pada bahasa pemrograman<br /> lainnya.<br /> <br /> Fungsi dari Select Case hampir sama dengan Fungsi IF. Select Case berfungsi sebagai kontrol statement<br /> pemilihan dimana nilanya sudah pasti atau dengan kata lain kondisinya sudah tetap. Dalam Select Case<br /> terdapat beberapa case atau beberapa kondisi<br /> <br /> Bentuk dasar dari Select Case adalah<br /> <br /> Select Case namavariable<br />            Case 1<br /> <br />            Case 2<br /> <br />            Case 3<br /> End Select<br /> <br /> Contoh sederhana penggunaan Select Case adalah sebagai berikut<br /> <br /> Dim Nilai As Integer = 4<br /> Select Case Nilai<br />            Case 1 :<br />            MsgBox("Isi dari variable Nilai adalah Satu")<br />            Case 2 :<br />            MsgBox("Isi dari variable Nilai adalah Dua")<br />            Case 3 :<br />            MsgBox("Isi dari variable Nilai adalah Tiga")<br />            Case 4 :<br />            MsgBox("Isi dari variable Nilai adalah Empat")<br />            Case Else<br />            MsgBox("isi dari variable Nilai tidak sesuai ketentuan")<br /> End Select<br /> <br /> Logikanya begini jika variable Nilai berisi 1 maka akan muncul pesan "Isi dari variable Nilai adalah Satu")<br /> Jika variable Nilai berisi 2 maka akan muncul pesan "Isi dari variable Nilai adalah Dua") <br /> Jika variable Nilai berisi 3 maka akan muncul pesan "Isi dari variable Nilai adalah Tiga")<br /> Jika variable Nilai berisi 4 maka akan muncul pesan "Isi dari variable Nilai adalah Empat")  <br /> Jika variable Nilai tidak berisi 1, 2, 3, atau 4  maka akan muncul pesan "Isi dari variable Nilai tidak sesuai ketentuan")<br /> <br /> <br /> Sekian dulu dari saya<br /> semoga artikel ini bermanfaat untuk anda, terima kasih sudah mengunjungi blog saya :) <br /> <br /> <br />

Statement Case Di VB.NET

Pagi semua kali setelah kemarin saya memposting tentang Statement IF Di VB.NET kali ini saya akan melanjutkan postingan saya yaitu Statemen...

Read more »

Statement IF di VB.NET

Sore semua sudah lama tidak posting :D<br /> kali ini saya akan memposting tentang <a href="http://dwirandyherdinanto.blogspot.com/2013/12/statement-if-di-vbnet.html" target="_blank">Statment IF di VB.NET</a><br /> IF merupakan salah satu struktur kendali dalam bahasa pemrograman dan di dalam program yang dibuat<br /> pasti banyak menggunakan statment IF, oleh karna itu IF sangat lah berguna dalam membuat program<br /> <br /> Ada beberapa penggunaan IF diantaranya adalah<br /> IF Tunggal, IF Ganda, IF Jamak, IF Bersarang<br /> <br /> Contoh penggunaan IF Tunggal<br />       Dim nilai as integer =75<br />       IF nilai > 70 Then<br />            Messagebox("Anda lulus")<br />       End IF<br /> <br /> Contoh penggunaan IF Ganda<br />       Dim nilai as integer = 75<br />       IF nilai > 70 Then<br />            MessageBox("Anda lulus")<br />       Else<br />            MessageBox("Anda belum lulus")<br />       End IF<br /> <br /> Contoh penggunaan IF Jamak<br />       Dim nilai as integer = 75<br />       IF nilai > 90 Then<br />           MessageBox("Anda mendapatkan nilai A")<br />       Else IF nilai > 80 Then<br />            MessageBox("Anda mendapatkan nilai B")<br />       Else<br />            MessageBox("Anda mendapatkan Nilai C")<br />       End IF<br /> <br /> Contoh penggunaan IF Tersarang<br />       Dim nilai as integer =60<br />       Dim absensi as integer = 70<br />       IF nilai > 55 Then<br />            MessageBox("Anda Lulus")<br />       Else<br />            IF absensi > 69 Then<br />                 MessageBox("Anda Lulus")<br />            Else<br />                 MessageBox("Anda tidak lulus")<br />            End IF<br />       End IF

Statement IF di VB.NET

Sore semua sudah lama tidak posting :D kali ini saya akan memposting tentang Statment IF di VB.NET IF merupakan salah satu struktur kendal...

Read more »

CRUD Dengan VB.NET Bagian 2

<div class="MsoNormalCxSpFirst"> Malam semua, kali ini saya akan melanjutkan postingan sebelumnya yaitu <a href="http://dwirandyherdinanto.blogspot.com/2013/10/crud-dengan-vbnet-bagian-1.html" rel="nofollow" target="_blank">Crud Dengan VB.Net Bagian 1</a></div> <div class="MsoNormalCxSpMiddle"> Jika kemarin kita sudah mempelajari bagaimana cara menyimpan dan mencari data, kali ini saya akan menambahkan cara memperbarui/mengupdate dan menghapus/delete data</div> <div class="MsoNormalCxSpMiddle"> Oke langsung saja </div> <div class="MsoNormalCxSpMiddle"> <br /></div> <br /> <div class="MsoNormalCxSpMiddle"> Pertama – tama buka project yang kita buat sebelumnya dengan cara File – Open Project – Nama_project_yang_telah_kita_buat</div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhW6b0zNxwXNFiGeqHlHmnueXClLsn6CY7YefbCyvcgicSnIx8bdmHz8CZ5OqcL8ntkfbDOPx-wW8OMxheUYtWttr6WzgvbWSiAhnBkurhTaZgxyNDd7xaCzYQqvjM5x-2Ddgwcojha09U8/s1600/Crud_dengan_VB.Net_dan_SQL_Server_1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="175" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhW6b0zNxwXNFiGeqHlHmnueXClLsn6CY7YefbCyvcgicSnIx8bdmHz8CZ5OqcL8ntkfbDOPx-wW8OMxheUYtWttr6WzgvbWSiAhnBkurhTaZgxyNDd7xaCzYQqvjM5x-2Ddgwcojha09U8/s320/Crud_dengan_VB.Net_dan_SQL_Server_1.png" width="320" /></a></div> <div class="separator" style="clear: both; text-align: center;"> <br /></div> <div class="MsoNormalCxSpFirst"> 2.  tambahkan 2 button lagi untuk tombol update dan hapus</div> <table border="1" cellpadding="0" cellspacing="0" class="MsoTableGrid" style="border-collapse: collapse; border: none; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-padding-alt: 0cm 5.4pt 0cm 5.4pt; mso-yfti-tbllook: 1184;"> <tbody> <tr> <td style="border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 159.6pt;" valign="top" width="213"><div class="MsoNormalCxSpMiddle" style="margin-bottom: 0.0001pt;"> Object</div> </td> <td style="border-left: none; border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-themecolor: text1; mso-border-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 159.6pt;" valign="top" width="213"><div class="MsoNormalCxSpMiddle" style="margin-bottom: 0.0001pt;"> Property</div> </td> <td style="border-left: none; border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-themecolor: text1; mso-border-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 159.6pt;" valign="top" width="213"><div class="MsoNormalCxSpMiddle" style="margin-bottom: 0.0001pt;"> Value</div> </td> </tr> <tr> <td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 159.6pt;" valign="top" width="213"><div class="MsoNormalCxSpMiddle" style="margin-bottom: 0.0001pt;"> Button1</div> </td> <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 159.6pt;" valign="top" width="213"><div class="MsoNormalCxSpMiddle" style="margin-bottom: 0.0001pt;"> Name</div> </td> <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 159.6pt;" valign="top" width="213"><div class="MsoNormalCxSpMiddle" style="margin-bottom: 0.0001pt;"> Btn_update</div> </td> </tr> <tr> <td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 159.6pt;" valign="top" width="213"><div class="MsoNormalCxSpMiddle" style="margin-bottom: 0.0001pt;"> <br /></div> </td> <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 159.6pt;" valign="top" width="213"><div class="MsoNormalCxSpMiddle" style="margin-bottom: 0.0001pt;"> Text</div> </td> <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 159.6pt;" valign="top" width="213"><div class="MsoNormalCxSpMiddle" style="margin-bottom: 0.0001pt;"> Update</div> </td> </tr> <tr> <td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 159.6pt;" valign="top" width="213"><div class="MsoNormalCxSpMiddle" style="margin-bottom: 0.0001pt;"> Button2</div> </td> <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 159.6pt;" valign="top" width="213"><div class="MsoNormalCxSpMiddle" style="margin-bottom: 0.0001pt;"> Name</div> </td> <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 159.6pt;" valign="top" width="213"><div class="MsoNormalCxSpMiddle" style="margin-bottom: 0.0001pt;"> Btn_hapus</div> </td> </tr> <tr> <td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 159.6pt;" valign="top" width="213"><div class="MsoNormalCxSpMiddle" style="margin-bottom: 0.0001pt;"> <br /></div> </td> <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 159.6pt;" valign="top" width="213"><div class="MsoNormalCxSpMiddle" style="margin-bottom: 0.0001pt;"> Text</div> </td> <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 159.6pt;" valign="top" width="213"><div class="MsoNormalCxSpMiddle" style="margin-bottom: 0.0001pt;"> Hapus</div> </td> </tr> </tbody></table> <div class="MsoNormalCxSpMiddle"> </div> <div class="MsoNormalCxSpMiddle"> Sehingga tampilan form seperti dibawah ini</div> <div class="separator" style="clear: both; text-align: center;"> </div> <br /> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh8ta30WnrsO4CRiZxs0GCOQNI-u7DTmnTI-nNYmYbw0mFL3JrGLQl9awC1HC938LbsT5x8CsmwIhyphenhyphens5iUiPzRKFMtddYadKsQuVZLUzfyte2JERAKCdlxoDDv2NSKhgF-f38Ljlpvk6-PD/s1600/Crud_dengan_VB.Net_dan_SQL_Server_5.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="175" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh8ta30WnrsO4CRiZxs0GCOQNI-u7DTmnTI-nNYmYbw0mFL3JrGLQl9awC1HC938LbsT5x8CsmwIhyphenhyphens5iUiPzRKFMtddYadKsQuVZLUzfyte2JERAKCdlxoDDv2NSKhgF-f38Ljlpvk6-PD/s320/Crud_dengan_VB.Net_dan_SQL_Server_5.png" width="320" /></a></div> <div class="separator" style="clear: both; text-align: center;"> <br /></div> <div class="MsoNormalCxSpFirst"> 3. Tambahkan script dibawah ini pada sub awal</div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <span style="font-family: Consolas; font-size: 9.5pt;">        btn_update.Enabled = False<o:p></o:p></span></div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <span style="font-family: Consolas; font-size: 9.5pt;">        btn_hapus.Enabled = False<o:p></o:p></span></div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <span style="font-family: Consolas; font-size: 9.5pt;">  Sehingga menjadi seperti dibawah ini<o:p></o:p></span></div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <span style="font-family: Consolas; font-size: 9.5pt;">  Sub awal()<o:p></o:p></span></div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <span style="font-family: Consolas; font-size: 9.5pt;">        Txt_nis.Text = ""<o:p></o:p></span></div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <span style="font-family: Consolas; font-size: 9.5pt;">        Txt_nama.Text = ""<o:p></o:p></span></div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <span style="font-family: Consolas; font-size: 9.5pt;">        Txt_alamat.Text = ""<o:p></o:p></span></div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <span style="font-family: Consolas; font-size: 9.5pt;">        Cbo_kelamin.Text = ""<o:p></o:p></span></div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <span style="font-family: Consolas; font-size: 9.5pt;">        Cbo_kelamin.Items.Clear()<o:p></o:p></span></div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <span style="font-family: Consolas; font-size: 9.5pt;">        Cbo_kelamin.Items.Add("Laki - Laki")<o:p></o:p></span></div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <span style="font-family: Consolas; font-size: 9.5pt;">        Cbo_kelamin.Items.Add("Perempuan")<o:p></o:p></span></div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <span style="font-family: Consolas; font-size: 9.5pt;">        Btn_tutup.Text = "Tutup"<o:p></o:p></span></div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <span style="font-family: Consolas; font-size: 9.5pt;">        Btn_cari.Enabled = False<o:p></o:p></span></div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <span style="font-family: Consolas; font-size: 9.5pt;">        Btn_simpan.Enabled = False<o:p></o:p></span></div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <span style="font-family: Consolas; font-size: 9.5pt;">        Btn_tambah.Enabled = True<o:p></o:p></span></div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <span style="font-family: Consolas; font-size: 9.5pt;">        Btn_tutup.Enabled = True<o:p></o:p></span></div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <span style="font-family: Consolas; font-size: 9.5pt;">        Txt_nis.Enabled = False<o:p></o:p></span></div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <span style="font-family: Consolas; font-size: 9.5pt;">        Txt_nama.Enabled = False<o:p></o:p></span></div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <span style="font-family: Consolas; font-size: 9.5pt;">        Txt_alamat.Enabled = False<o:p></o:p></span></div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <span style="font-family: Consolas; font-size: 9.5pt;">        Cbo_kelamin.Enabled = False<o:p></o:p></span></div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <b><span style="font-family: Consolas; font-size: 9.5pt;">        btn_update.Enabled = False<o:p></o:p></span></b></div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <b><span style="font-family: Consolas; font-size: 9.5pt;">        btn_hapus.Enabled = False<o:p></o:p></span></b></div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <span style="font-family: Consolas; font-size: 9.5pt;">    End Sub<o:p></o:p></span></div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <br /></div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <span style="font-family: Consolas; font-size: 9.5pt;">4. Tambahkan script dibawah ini pada tombol cari<o:p></o:p></span></div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <span style="color: #f1f2f3; font-family: Consolas; font-size: 9.5pt;">   </span><span style="font-family: Consolas; font-size: 9.5pt;">     btn_hapus.Enabled = True<o:p></o:p></span></div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <span style="font-family: Consolas; font-size: 9.5pt;">        btn_update.Enabled = True<o:p></o:p></span></div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <span style="font-family: Consolas; font-size: 9.5pt;">   sehingga menjadi seperti dibawah ini<o:p></o:p></span></div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <span style="font-family: Consolas; font-size: 9.5pt;">   Private Sub Btn_cari_Click(ByVal sender As System.Object, ByVal e As System.EventArgs)   Handles Btn_cari.Click<o:p></o:p></span></div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <span style="font-family: Consolas; font-size: 9.5pt;">        If Txt_nis.Text = "" Then<o:p></o:p></span></div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <span style="font-family: Consolas; font-size: 9.5pt;">            MsgBox("Nis masih kosong", MsgBoxStyle.Exclamation, "Peringatan")<o:p></o:p></span></div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <span style="font-family: Consolas; font-size: 9.5pt;">        Else<o:p></o:p></span></div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <span style="font-family: Consolas; font-size: 9.5pt;">        cmd = New SqlCommand("select nis,nm_siswa,alamat,jenis_kelamin from siswa where   nis='" & Txt_nis.Text & "'", conn)<o:p></o:p></span></div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <span style="font-family: Consolas; font-size: 9.5pt;">        rd = cmd.ExecuteReader<o:p></o:p></span></div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <span style="font-family: Consolas; font-size: 9.5pt;">        rd.Read()<o:p></o:p></span></div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <span style="font-family: Consolas; font-size: 9.5pt;">            If rd.HasRows Then<o:p></o:p></span></div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <span style="font-family: Consolas; font-size: 9.5pt;">                Txt_nis.Text = rd("nis")<o:p></o:p></span></div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <span style="font-family: Consolas; font-size: 9.5pt;">                Txt_nama.Text = rd("nm_siswa")<o:p></o:p></span></div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <span style="font-family: Consolas; font-size: 9.5pt;">                Txt_alamat.Text = rd("alamat")<o:p></o:p></span></div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <span style="font-family: Consolas; font-size: 9.5pt;">                Cbo_kelamin.Text = rd("jenis_kelamin")<o:p></o:p></span></div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <span style="font-family: Consolas; font-size: 9.5pt;">                Btn_simpan.Enabled = False<o:p></o:p></span></div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <b><span style="font-family: Consolas; font-size: 9.5pt;">                btn_hapus.Enabled = True<o:p></o:p></span></b></div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <b><span style="font-family: Consolas; font-size: 9.5pt;">                btn_update.Enabled = True<o:p></o:p></span></b></div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <span style="font-family: Consolas; font-size: 9.5pt;">            Else<o:p></o:p></span></div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <span style="font-family: Consolas; font-size: 9.5pt;">                MsgBox("Data tidak ditemukan")<o:p></o:p></span></div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <span style="font-family: Consolas; font-size: 9.5pt;">            End If<o:p></o:p></span></div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <span style="font-family: Consolas; font-size: 9.5pt;">            rd.Close()<o:p></o:p></span></div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <span style="font-family: Consolas; font-size: 9.5pt;">        End If<o:p></o:p></span></div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <span style="font-family: Consolas; font-size: 9.5pt;">    End Sub<o:p></o:p></span></div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <br /></div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <span style="font-family: Consolas; font-size: 9.5pt;">5. Tambahkan script dibawah ini pada tombol delete<o:p></o:p></span></div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <span style="font-family: Consolas; font-size: 9.5pt;">Private Sub btn_hapus_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btn_hapus.Click<o:p></o:p></span></div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <span style="font-family: Consolas; font-size: 9.5pt;">        If Txt_nis.Text = "" Then<o:p></o:p></span></div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <span style="font-family: Consolas; font-size: 9.5pt;">            MsgBox("NIS tidak boleh kosong", MsgBoxStyle.Exclamation, "Peringatan")<o:p></o:p></span></div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <span style="font-family: Consolas; font-size: 9.5pt;">        Else<o:p></o:p></span></div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <span style="font-family: Consolas; font-size: 9.5pt;">            If MsgBox("Apakah anda akan menghapus data ini?", MsgBoxStyle.YesNo, "Informasi") = MsgBoxResult.Yes Then<o:p></o:p></span></div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <span style="font-family: Consolas; font-size: 9.5pt;">                cmd = New SqlCommand("delete from siswa where nis='" & Txt_nis.Text & "'", conn)<o:p></o:p></span></div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <span style="font-family: Consolas; font-size: 9.5pt;">                cmd.ExecuteNonQuery()<o:p></o:p></span></div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <span style="font-family: Consolas; font-size: 9.5pt;">                MsgBox("Data berhasil dihapus", MsgBoxStyle.Information, "Informasi")<o:p></o:p></span></div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <span style="font-family: Consolas; font-size: 9.5pt;">                Call awal()<o:p></o:p></span></div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <span style="font-family: Consolas; font-size: 9.5pt;">            End If<o:p></o:p></span></div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <span style="font-family: Consolas; font-size: 9.5pt;">        End If<o:p></o:p></span></div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <span style="font-family: Consolas; font-size: 9.5pt;">    End Sub<o:p></o:p></span></div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <br /></div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <br /></div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <span style="font-family: Consolas; font-size: 9.5pt;">6. Tambahkan script dibawah ini pada tombol update<o:p></o:p></span></div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <span style="font-family: Consolas; font-size: 9.5pt;">Private Sub btn_update_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btn_update.Click<o:p></o:p></span></div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <span style="font-family: Consolas; font-size: 9.5pt;">        If Txt_nis.Text = "" Or Txt_nama.Text = "" Or Txt_alamat.Text = "" Or Cbo_kelamin.Text = "" Then<o:p></o:p></span></div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <span style="font-family: Consolas; font-size: 9.5pt;">            MsgBox("Data belum lengkap", MsgBoxStyle.Exclamation, "Peringatan")<o:p></o:p></span></div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <span style="font-family: Consolas; font-size: 9.5pt;">        Else<o:p></o:p></span></div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <span style="font-family: Consolas; font-size: 9.5pt;">            cmd = New SqlCommand("update siswa set nis='" & Txt_nis.Text & "',nm_siswa='" & Txt_nama.Text & "',alamat='" & Txt_alamat.Text & "',jenis_kelamin='" & Cbo_kelamin.Text & "'", conn)<o:p></o:p></span></div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <span style="font-family: Consolas; font-size: 9.5pt;">            cmd.ExecuteNonQuery()<o:p></o:p></span></div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <span style="font-family: Consolas; font-size: 9.5pt;">            MsgBox("Data berhasil diupdate", MsgBoxStyle.Information, "Informasi")<o:p></o:p></span></div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <span style="font-family: Consolas; font-size: 9.5pt;">            Call awal()<o:p></o:p></span></div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <span style="font-family: Consolas; font-size: 9.5pt;">        End If<o:p></o:p></span></div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <span style="font-family: Consolas; font-size: 9.5pt;">    End Sub<o:p></o:p></span></div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <br /></div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <span style="font-family: Consolas; font-size: 9.5pt;">8. jika sudah maka coba jalankan program tersebut dengan cara tekan F5 atau klik menu Debug – Start Debugging<o:p></o:p></span></div> <div class="separator" style="clear: both; text-align: center;"> </div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <br /></div> <div class="separator" style="clear: both; font-family: Consolas; font-size: 9.5pt; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgJgzp-SAOlJAfaacYSFwSbPtcIhBzFXu7FZ95sdQQ_gh51QpdqLdsoE2-Rp7wbVgBzRYN5P9vVf-jTcsAdAat2ncseI8m_VVFfV6gooq-dULtpjrOxS1bScPPY9yHXmmnrNRPVGvUaOTbh/s1600/Crud_dengan_VB.Net_dan_SQL_Server_2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="171" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgJgzp-SAOlJAfaacYSFwSbPtcIhBzFXu7FZ95sdQQ_gh51QpdqLdsoE2-Rp7wbVgBzRYN5P9vVf-jTcsAdAat2ncseI8m_VVFfV6gooq-dULtpjrOxS1bScPPY9yHXmmnrNRPVGvUaOTbh/s320/Crud_dengan_VB.Net_dan_SQL_Server_2.png" width="320" /></a></div> <div class="separator" style="clear: both; font-family: Consolas; font-size: 9.5pt; text-align: center;"> <br /></div> <blockquote class="tr_bq"> <div style="text-align: center;"> Jika anda ingin mendownload source code silahkan klik <a href="http://adf.ly/cshu9" rel="nofollow" target="_blank">disini</a></div> <div style="text-align: center;"> dan untuk passwordnya <a href="http://adf.ly/fHCDH">disini</a></div> <div> <br /></div> </blockquote> <div class="separator" style="clear: both; font-family: Consolas; font-size: 9.5pt; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: justify;"> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">semoga berhasil<br />sekian untuk postingan saya kali ini</span></span></div> <div class="separator" style="clear: both; font-family: Consolas; font-size: 9.5pt; text-align: left;"> <br /></div>

CRUD Dengan VB.NET Bagian 2

Malam semua, kali ini saya akan melanjutkan postingan sebelumnya yaitu Crud Dengan VB.Net Bagian 1 Jika kemarin kita sudah mempelajari ba...

Read more »

Membuat login aman dari SQL Injection

Malem semua kali ini saya akan memposting tentang membuat login aman dari SQL Injection,<br /> ya walaupun ini cara lama,mungkin ada yang belum tau :D<br /> <span style="background-color: white; color: #222222; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 15px; line-height: 21px; text-align: justify;">Secara singkat <b>SQL injection</b> adalah menambahkan perintah SQL Query melalui dengan tujuan untuk memodifikasi sql query yang sudah ada atau menciptakan SQL Query baru.</span><br /> <span style="background-color: white; color: #222222; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 15px; line-height: 21px; text-align: justify;">Sebagai contoh :</span><br /> <span style="background-color: white; color: #222222; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 15px; line-height: 21px; text-align: justify;">saya mempunyai SQL Query untuk login program yang saya buat dengan VB.NET seperti ini</span><br /> <blockquote class="tr_bq"> <span style="color: #222222; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif;"><span style="line-height: 20.98958396911621px;">select username,password from admin where username=' " & txt_username.text & " ' and password=' " & txt_password.text & " '</span></span> </blockquote> <div style="text-align: justify;"> <span style="color: #222222; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif;"><span style="line-height: 20.98958396911621px;">tapi jika pengguna program menginputkan username 'OR '1'='1 dan password 'OR '1'='1 lalu </span></span><br /> <span style="color: #222222; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif;"><span style="line-height: 20.98958396911621px;"><br /></span></span></div> <div style="text-align: justify;"> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjMP64NU4_DVkcHkB9cOaA368TZayO0TQyRfEE9es-UEdV2bbPSyVEW66gbsnntAkuwnDCfpj0VNBpaAz5Cnv_A5WQbdB00r08yM4bl2bEoR2IFRiAwzpkRkVUpgUWPlZoLZYclNfheS2VC/s1600/Screenshot_2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="180" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjMP64NU4_DVkcHkB9cOaA368TZayO0TQyRfEE9es-UEdV2bbPSyVEW66gbsnntAkuwnDCfpj0VNBpaAz5Cnv_A5WQbdB00r08yM4bl2bEoR2IFRiAwzpkRkVUpgUWPlZoLZYclNfheS2VC/s320/Screenshot_2.png" width="320" /></a></div> <span style="color: #222222; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif;"><span style="line-height: 20.98958396911621px;"><br /></span></span></div> <div style="text-align: justify;"> <span style="color: #222222; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif;"><span style="line-height: 20.98958396911621px;">setelah program di jalankan maka SQL Query kita akan menjadi seperti ini :</span></span></div> <blockquote class="tr_bq"> <span style="color: #222222; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif;"><span style="line-height: 20.98958396911621px;">select username,password from admin where username=' ' or '1'='1' and password=' ' or '1'='1'</span></span> </blockquote> maka ini akan menghasilkan nilai TRUE, sehingga user (anonymous) berhasil login ke aplikasi yang kita buat tanpa perlu mengetahui username atau password yang sebenarnya<br /> <br /> Tapi, ada beberapa cara yang dapat digunakan untuk mengatasi agar hal itu tidak terjadi<br /> <br /> 1. Menghilangkan karakter kutip 1 (') sebagai contoh replace(txt_username.text," ' ","")<br /> sebagai contoh :<br /> <blockquote class="tr_bq"> select username,password from admin where username=' " & Replace(txt_username.Text, " ' ", "") & " ' and password=' " & replace(txt_password.Text," ' ","") & " '</blockquote> 2. Membatasi MaxLength Textbox sesuai dengan Lenght Field yang ada di database dengan itu maka user tidak bisa mengisi Textbox secara bebas<br /> <br /> cara diatas adalah beberapa cara yang dapat digunakan dari sekumpulan cara yang dapat digunakan untuk membuat login aman dari SQL Injection<br /> <br /> cara diatas juga berlaku untuk bahasa pemrograman lain seperti PHP,C#,VB.NET dan lain - lain<br /> kita hanya perlu menerapkan logika yang sama dengan bahasa pemrograman yang kita gunakan<br /> sekian postingan saya malam ini semoga dapat menambah wawasan kita semua

Membuat login aman dari SQL Injection

Malem semua kali ini saya akan memposting tentang membuat login aman dari SQL Injection, ya walaupun ini cara lama,mungkin ada yang belum t...

Read more »

Mengatasi error "String or binary data would be truncated. The statement has been terminated."

<span style="font-family: Courier New, Courier, monospace;">Malam semua setelah beberapa jam yang lalu saya memposting tentang <a href="http://dwirandyherdinanto.blogspot.com/2013/10/crud-dengan-vbnet-bagian-1.html" target="_blank">CRUD dengan VB.NET Bagian 1</a> kali ini saya akan memposting </span><br /> <span style="font-family: Courier New, Courier, monospace;">C<b>ara mengatasi error "String or binary data would be truncated.</b></span><br /> <pre class="brush: sql; title: ; notranslate" title=""><b><span style="font-family: Courier New, Courier, monospace;">The statement has been terminated."</span></b></pre> <pre class="brush: sql; title: ; notranslate" title=""><span style="font-family: Courier New, Courier, monospace;"> </span></pre> <pre class="brush: sql; title: ; notranslate" title=""><span style="font-family: Courier New, Courier, monospace;">yah beberapa waktu yang lalu saya pernah mengalami mengalami error tersebut</span></pre> <pre class="brush: sql; title: ; notranslate" title=""><span style="font-family: Courier New, Courier, monospace;">saya sempat bingung juga kenapa bisa terjadi error tersebut,padalah script untuk insert data nya sudah benar</span></pre> <pre class="brush: sql; title: ; notranslate" title=""><span style="font-family: Courier New, Courier, monospace;"> </span></pre> <pre class="brush: sql; title: ; notranslate" title=""><span style="font-family: Courier New, Courier, monospace;">lalu setelah searching di google saya menemukan solusinya</span></pre> <pre class="brush: sql; title: ; notranslate" title=""><span style="font-family: Courier New, Courier, monospace;">ternyata error itu disebabkan karena kita menginputkan data yang karakternya melebihi dari Lenght column yang kita buat</span></pre> <pre class="brush: sql; title: ; notranslate" title=""><span style="font-family: Courier New, Courier, monospace;"> </span></pre> <pre class="brush: sql; title: ; notranslate" title=""><span style="font-family: Courier New, Courier, monospace;">sebagai contoh saya membuat table sebagai berikut</span></pre> <pre class="brush: sql; title: ; notranslate" title=""><span style="font-family: Courier New, Courier, monospace;">create table customer (</span></pre> <pre class="brush: sql; title: ; notranslate" title=""><span style="font-family: Courier New, Courier, monospace;">kd_customer varchar(5) not null primary key,</span></pre> <pre class="brush: sql; title: ; notranslate" title=""><span style="font-family: Courier New, Courier, monospace;">nama varchar(30) not null,</span></pre> <pre class="brush: sql; title: ; notranslate" title=""><span style="font-family: Courier New, Courier, monospace;">alamat varchar(30) not null)</span></pre> <pre class="brush: sql; title: ; notranslate" title=""><span style="font-family: Courier New, Courier, monospace;"> </span></pre> <pre class="brush: sql; title: ; notranslate" title=""><span style="font-family: Courier New, Courier, monospace;">lalu saya insert data dengan script sebagai berikut</span></pre> <pre class="brush: sql; title: ; notranslate" title=""><span style="font-family: Courier New, Courier, monospace;">insert into customer (kd_customer,nama,alamat) values ('CUS123','Dwi Randy Herdinanto','Bandar Jaya')</span></pre> <pre class="brush: sql; title: ; notranslate" title=""><span style="font-family: Courier New, Courier, monospace;"> </span></pre> <pre class="brush: sql; title: ; notranslate" title=""><span style="font-family: Courier New, Courier, monospace;">maka ketika dijalankan akan muncul error seperti gambar di bawah ini</span></pre> <pre class="brush: sql; title: ; notranslate" title=""><span style="font-family: Courier New, Courier, monospace;"> </span></pre> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEii6zFJ7SsnTJfNyBPDeaeqKoIq1DhIaIcpKnmezgE3aHe4XSP65DWkH_uyrqRHcUfktSbiaDGxgjZQJwpEy2FuShuf7H39dVlRThF6gB6c96P_pwzP68zLoM1e6QI8YFZ8V3EcKNjRp-Of/s1600/Screenshot_3.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="154" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEii6zFJ7SsnTJfNyBPDeaeqKoIq1DhIaIcpKnmezgE3aHe4XSP65DWkH_uyrqRHcUfktSbiaDGxgjZQJwpEy2FuShuf7H39dVlRThF6gB6c96P_pwzP68zLoM1e6QI8YFZ8V3EcKNjRp-Of/s320/Screenshot_3.png" width="320" /></a></div> <pre class="brush: sql; title: ; notranslate" title=""><span style="font-family: Courier New, Courier, monospace;"> </span></pre> <pre class="brush: sql; title: ; notranslate" title=""><span style="font-family: Courier New, Courier, monospace;">kenapa terjadi error seperti gambar itu?</span></pre> <pre class="brush: sql; title: ; notranslate" title=""><span style="font-family: Courier New, Courier, monospace;">itu terjadi karena saya mengisi kd_customer dengan cus123 yang panjang kakternya 6, sedangkan pada column kd_customer Lenght nya hanya 5,</span></pre> <pre class="brush: sql; title: ; notranslate" title=""></pre> <pre class="brush: sql; title: ; notranslate" title=""><span style="font-family: Courier New, Courier, monospace;">namun jika kita insert dengan script sebagai berikut</span></pre> <pre class="brush: sql; title: ; notranslate" title=""><span style="font-family: Courier New, Courier, monospace;">insert into customer (kd_customer,nama,alamat) values ('CUS12','Dwi Randy Herdinanto','Bandar Jaya')</span></pre> <pre class="brush: sql; title: ; notranslate" title=""><span style="font-family: Courier New, Courier, monospace;">maka ketika dijalankan akan akan berhasil disimpan seperti gambar di bawah ini</span></pre> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjyvqoev2vJcb5KkUfa1kkfKHzIB0UTi7YQR895YpxqID-qRGrifCPSG_TikSYZmarRXTDlLk1T3uYpi0IMvMFg3nwSHA83wRU-vOP08N6F0W5qz71BQcVFct9SNp8lkO2uUIwJB4dsm2KA/s1600/Screenshot3.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="154" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjyvqoev2vJcb5KkUfa1kkfKHzIB0UTi7YQR895YpxqID-qRGrifCPSG_TikSYZmarRXTDlLk1T3uYpi0IMvMFg3nwSHA83wRU-vOP08N6F0W5qz71BQcVFct9SNp8lkO2uUIwJB4dsm2KA/s320/Screenshot3.png" width="320" /></a></div> <pre class="brush: sql; title: ; notranslate" title=""><span style="font-family: Courier New, Courier, monospace;"> </span></pre> <pre class="brush: sql; title: ; notranslate" title=""><span style="font-family: Courier New, Courier, monospace;">yah sekian postingan saya kali ini</span></pre> <pre class="brush: sql; title: ; notranslate" title=""><span style="font-family: Courier New, Courier, monospace;">semoga bermanfaat bagi yang membaca :D</span></pre>

Mengatasi error "String or binary data would be truncated. The statement has been terminated."

Malam semua setelah beberapa jam yang lalu saya memposting tentang CRUD dengan VB.NET Bagian 1  kali ini saya akan memposting  C ara mengat...

Read more »

CRUD dengan VB.NET bagian 1

<span style="font-family: Arial, Helvetica, sans-serif;">Malam semua sebelum saya menlanjutkan postingan ini ada baiknya anda membaca<a href="http://adf.ly/cvtUd" rel="nofollow" target="_blank"> cara mengkoneksikan VB.NET ke SQL Server 2008</a> kali ini saya akan memposting tutorial CRUD dengan VB.NET</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">Apa itu CRUD? CRUD singkatan dari CREATE, RENAME, UPDATE, DELETE<b style="background-color: white; color: #555555; font-size: 12px; line-height: 20px;">. </b></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><b style="background-color: white; line-height: 20px;">CRUD</b><span style="background-color: white; line-height: 20px;"> adalah operasi </span><b style="background-color: white; line-height: 20px;">Create</b><span style="background-color: white; line-height: 20px;">, </span><b style="background-color: white; line-height: 20px;">read</b><span style="background-color: white; line-height: 20px;">, </span><b style="background-color: white; line-height: 20px;">update</b><span style="background-color: white; line-height: 20px;">, dan </span><b style="background-color: white; line-height: 20px;">delete</b><span style="background-color: white; line-height: 20px;"> pada database. Jadi tentu kita butuh database untuk menerapkan </span><b style="background-color: white; line-height: 20px;"><u>CRUD</u></b><span style="background-color: white; line-height: 20px;">. sebelum memulai CRUD dengan VB.NET ada baiknya anda membaca <a href="http://adf.ly/cvcGa" rel="nofollow" target="_blank">Syntak Dasar SQL Server</a>.</span></span><br /> <div> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="background-color: white; line-height: 20px;">Oke langsung saja </span></span></div> <div> <br /> <span style="background-color: white; font-family: Arial, Helvetica, sans-serif; line-height: 20px;">1. Tambahkan sebuah table ke database latihan sebagai berikut:</span><br /> <span style="font-family: Arial, Helvetica, sans-serif; line-height: 20px;">create table siswa</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">(nis varchar(10) not null primary key,</span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">nm_siswa varchar(30) not null,</span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">alamat varchar(50) not null,</span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">jenis_kelamin varchar(15) not null )</span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;"><br /></span></span> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">2. Buka project yang kita buat sebelumnya yang bernama KoneksiKeSqlServer </span></span><br /> <br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">3. Setelah project berhasil dibuka lalu Klik menu Project - Add Windows Form pada kolom Name ketikan FrmCrud</span></span><br /> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEij6GVXVdbMs3kwEnpPtE66R2ZkPwIfwBIeMVmRSPmeJuTX8K2sUGJF0JXVybOUstXo5tL8riDoBGJRZJoPZv6lR_9qI291oCLQlXsdpFiluTATmSzBVgbWrzPR1Gd0E07L4X0P05PbDLRt/s1600/Screenshot_1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="CRUD dengan VB.NET bagian 1" border="0" height="177" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEij6GVXVdbMs3kwEnpPtE66R2ZkPwIfwBIeMVmRSPmeJuTX8K2sUGJF0JXVybOUstXo5tL8riDoBGJRZJoPZv6lR_9qI291oCLQlXsdpFiluTATmSzBVgbWrzPR1Gd0E07L4X0P05PbDLRt/s320/Screenshot_1.png" title="CRUD dengan VB.NET bagian 1" width="320" /></a></div> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;"><br /></span></span> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">4. lalu desain form seperti gambar dibawah ini</span></span><br /> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEifhu9904w698_UYtX8nldN2Wo5BMWjRMil_Zv2t3woYdDfPYlmu-HttNS0wvuZyR5vX5Z7OyjKZpF61oriODUlTZT0mgJ7JjeK9EfMYC0vDboFChzMvVNeOVbG9j4TERPxJKEDSOD61Gqu/s1600/CRUD_dengan_VB.NET_bagian_1_2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="CRUD dengan VB.NET bagian 1" border="0" height="175" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEifhu9904w698_UYtX8nldN2Wo5BMWjRMil_Zv2t3woYdDfPYlmu-HttNS0wvuZyR5vX5Z7OyjKZpF61oriODUlTZT0mgJ7JjeK9EfMYC0vDboFChzMvVNeOVbG9j4TERPxJKEDSOD61Gqu/s320/CRUD_dengan_VB.NET_bagian_1_2.png" title="CRUD dengan VB.NET bagian 1" width="320" /></a></div> <br /> <table border="1" cellpadding="0" cellspacing="0" class="MsoTableGrid" style="border-collapse: collapse; border: none; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-padding-alt: 0cm 5.4pt 0cm 5.4pt; mso-yfti-tbllook: 1184;"> <tbody> <tr> <td style="border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 159.6pt;" valign="top" width="213"><div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;"> Object</div> </td> <td style="border-left: none; border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-themecolor: text1; mso-border-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 159.6pt;" valign="top" width="213"><div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;"> Property<o:p></o:p></div> </td> <td style="border-left: none; border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-themecolor: text1; mso-border-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 159.6pt;" valign="top" width="213"><div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;"> Value<o:p></o:p></div> </td> </tr> <tr> <td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 159.6pt;" valign="top" width="213"><div class="MsoNormal" style="margin-bottom: 0.0001pt;"> Textbox1<o:p></o:p></div> </td> <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 159.6pt;" valign="top" width="213"><div class="MsoNormal" style="margin-bottom: 0.0001pt;"> Name<o:p></o:p></div> </td> <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 159.6pt;" valign="top" width="213"><div class="MsoNormal" style="margin-bottom: 0.0001pt;"> Txt_nis<o:p></o:p></div> </td> </tr> <tr> <td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 159.6pt;" valign="top" width="213"><div class="MsoNormal" style="margin-bottom: 0.0001pt;"> Textbox2<o:p></o:p></div> </td> <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 159.6pt;" valign="top" width="213"><div class="MsoNormal" style="margin-bottom: 0.0001pt;"> Name<o:p></o:p></div> </td> <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 159.6pt;" valign="top" width="213"><div class="MsoNormal" style="margin-bottom: 0.0001pt;"> Txt_nama<o:p></o:p></div> </td> </tr> <tr> <td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 159.6pt;" valign="top" width="213"><div class="MsoNormal" style="margin-bottom: 0.0001pt;"> Textbox3<o:p></o:p></div> </td> <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 159.6pt;" valign="top" width="213"><div class="MsoNormal" style="margin-bottom: 0.0001pt;"> Name<o:p></o:p></div> </td> <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 159.6pt;" valign="top" width="213"><div class="MsoNormal" style="margin-bottom: 0.0001pt;"> Txt_alamat<o:p></o:p></div> </td> </tr> <tr> <td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 159.6pt;" valign="top" width="213"><div class="MsoNormal" style="margin-bottom: 0.0001pt;"> Combobox1<o:p></o:p></div> </td> <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 159.6pt;" valign="top" width="213"><div class="MsoNormal" style="margin-bottom: 0.0001pt;"> Name<o:p></o:p></div> </td> <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 159.6pt;" valign="top" width="213"><div class="MsoNormal" style="margin-bottom: 0.0001pt;"> Cbo_kelamin<o:p></o:p></div> </td> </tr> <tr style="height: 4.85pt; mso-yfti-irow: 5;"> <td style="border-top: none; border: solid black 1.0pt; height: 4.85pt; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 159.6pt;" valign="top" width="213"><div class="MsoNormal" style="margin-bottom: 0.0001pt;"> Button1<o:p></o:p></div> </td> <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; height: 4.85pt; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 159.6pt;" valign="top" width="213"><div class="MsoNormal" style="margin-bottom: 0.0001pt;"> Name<o:p></o:p></div> </td> <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; height: 4.85pt; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 159.6pt;" valign="top" width="213"><div class="MsoNormal" style="margin-bottom: 0.0001pt;"> Btn_cari<o:p></o:p></div> </td> </tr> <tr style="height: 4.85pt; mso-yfti-irow: 6;"> <td style="border-top: none; border: solid black 1.0pt; height: 4.85pt; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 159.6pt;" valign="top" width="213"><div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <br /></div> </td> <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; height: 4.85pt; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 159.6pt;" valign="top" width="213"><div class="MsoNormal" style="margin-bottom: 0.0001pt;"> Text<o:p></o:p></div> </td> <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; height: 4.85pt; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 159.6pt;" valign="top" width="213"><div class="MsoNormal" style="margin-bottom: 0.0001pt;"> Cari<o:p></o:p></div> </td> </tr> <tr> <td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 159.6pt;" valign="top" width="213"><div class="MsoNormal" style="margin-bottom: 0.0001pt;"> Button2<o:p></o:p></div> </td> <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 159.6pt;" valign="top" width="213"><div class="MsoNormal" style="margin-bottom: 0.0001pt;"> Name<o:p></o:p></div> </td> <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 159.6pt;" valign="top" width="213"><div class="MsoNormal" style="margin-bottom: 0.0001pt;"> Btn_tambah<o:p></o:p></div> </td> </tr> <tr> <td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 159.6pt;" valign="top" width="213"><div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <br /></div> </td> <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 159.6pt;" valign="top" width="213"><div class="MsoNormal" style="margin-bottom: 0.0001pt;"> Text<o:p></o:p></div> </td> <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 159.6pt;" valign="top" width="213"><div class="MsoNormal" style="margin-bottom: 0.0001pt;"> Tambah<o:p></o:p></div> </td> </tr> <tr> <td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 159.6pt;" valign="top" width="213"><div class="MsoNormal" style="margin-bottom: 0.0001pt;"> Button3<o:p></o:p></div> </td> <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 159.6pt;" valign="top" width="213"><div class="MsoNormal" style="margin-bottom: 0.0001pt;"> Name<o:p></o:p></div> </td> <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 159.6pt;" valign="top" width="213"><div class="MsoNormal" style="margin-bottom: 0.0001pt;"> Btn_tutup<o:p></o:p></div> </td> </tr> <tr> <td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 159.6pt;" valign="top" width="213"><div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <br /></div> </td> <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 159.6pt;" valign="top" width="213"><div class="MsoNormal" style="margin-bottom: 0.0001pt;"> Text<o:p></o:p></div> </td> <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 159.6pt;" valign="top" width="213"><div class="MsoNormal" style="margin-bottom: 0.0001pt;"> Tutup<o:p></o:p></div> </td> </tr> <tr> <td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 159.6pt;" valign="top" width="213"><div class="MsoNormal" style="margin-bottom: 0.0001pt;"> Button4<o:p></o:p></div> </td> <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 159.6pt;" valign="top" width="213"><div class="MsoNormal" style="margin-bottom: 0.0001pt;"> Name<o:p></o:p></div> </td> <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 159.6pt;" valign="top" width="213"><div class="MsoNormal" style="margin-bottom: 0.0001pt;"> Btn_simpan<o:p></o:p></div> </td> </tr> <tr> <td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 159.6pt;" valign="top" width="213"><div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <br /></div> </td> <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 159.6pt;" valign="top" width="213"><div class="MsoNormal" style="margin-bottom: 0.0001pt;"> Text<o:p></o:p></div> </td> <td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .5pt; mso-border-bottom-themecolor: text1; mso-border-left-alt: solid black .5pt; mso-border-left-themecolor: text1; mso-border-right-themecolor: text1; mso-border-themecolor: text1; mso-border-top-alt: solid black .5pt; mso-border-top-themecolor: text1; padding: 0cm 5.4pt 0cm 5.4pt; width: 159.6pt;" valign="top" width="213"><div class="MsoNormal" style="margin-bottom: 0.0001pt;"> Simpan<o:p></o:p></div> </td> </tr> </tbody></table> </div> <div> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="background-color: white; line-height: 20px;"><br /></span></span> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="background-color: white; line-height: 20px;">5. klik 2 kali pada form data siswa lalu ketikan script di bawah ini:</span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">Imports System.Data.SqlClient</span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">Imports System.Xml</span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">Public Class FrmCrud</span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">    Sub awal()</span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">        Txt_nis.Text = ""</span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">        Txt_nama.Text = ""</span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">        Txt_alamat.Text = ""</span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">        Cbo_kelamin.Text = ""</span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">        Cbo_kelamin.Items.Clear()</span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">        Cbo_kelamin.Items.Add("Laki - Laki")</span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">        Cbo_kelamin.Items.Add("Perempuan")</span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">        Btn_tutup.Text = "Tutup"</span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">        Btn_cari.Enabled = False</span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">        Btn_simpan.Enabled = False</span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">        Btn_tambah.Enabled = True</span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">        Btn_tutup.Enabled = True</span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">        Txt_nis.Enabled = False</span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">        Txt_nama.Enabled = False</span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">        Txt_alamat.Enabled = False</span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">        Cbo_kelamin.Enabled = False</span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">    End Sub</span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">    Private Sub FrmCrud_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load</span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">        Call ambilkoneksi()</span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">        Call awal()</span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">    End Sub</span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;"><br /></span></span> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">    Private Sub Btn_tambah_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Btn_tambah.Click</span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">        Txt_nis.Enabled = True</span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">        Txt_nama.Enabled = True</span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">        Txt_alamat.Enabled = True</span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">        Cbo_kelamin.Enabled = True</span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">        Btn_simpan.Enabled = True</span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">        Btn_cari.Enabled = True</span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">        Btn_tambah.Enabled = False</span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">        Btn_tutup.Text = "Batal"</span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">    End Sub</span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;"><br /></span></span> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">    Private Sub Btn_simpan_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Btn_simpan.Click</span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">        If Txt_nis.Text = "" Or Txt_nama.Text = "" Or Txt_alamat.Text = "" Or Cbo_kelamin.Text = "" Then</span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">            MsgBox("Data belum lengkap", MsgBoxStyle.Information, "Informasi")</span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">        Else</span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">            cmd = New SqlCommand("select nis from siswa where nis='" & Txt_nis.Text & "'", conn)</span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">            rd = cmd.ExecuteReader</span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">            rd.Read()</span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">            If rd.HasRows Then</span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">                MsgBox("NIS Sudah digunakan", MsgBoxStyle.Information, "informasi")</span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">                rd.Close()</span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">            Else</span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">                rd.Close()</span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;"><br /></span></span> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">                cmd = New SqlCommand("insert into siswa (nis,nm_siswa,alamat,jenis_kelamin) values ('" & Txt_nis.Text & "','" & Txt_nama.Text & "','" & Txt_alamat.Text & "','" & Cbo_kelamin.Text & "')", conn)</span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">                cmd.ExecuteNonQuery()</span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">                MsgBox("Data berhasil disimpan", MsgBoxStyle.Information, "Informasi")</span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">                Call awal()</span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">            End If</span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">        End If</span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">       </span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">    End Sub</span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;"><br /></span></span> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">    Private Sub Btn_tutup_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Btn_tutup.Click</span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">        If Btn_tutup.Text = "Batal" Then</span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">            Call awal()</span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">        Else</span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">            Me.Close()</span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">        End If</span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">    End Sub</span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;"><br /></span></span> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">    Private Sub Btn_cari_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Btn_cari.Click</span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">        If Txt_nis.Text = "" Then</span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">            MsgBox("Nis masih kosong", MsgBoxStyle.Exclamation, "Peringatan")</span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">        Else</span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">        cmd = New SqlCommand("select nis,nm_siswa,alamat,jenis_kelamin from siswa where nis='" & Txt_nis.Text & "'", conn)</span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">        rd = cmd.ExecuteReader</span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">        rd.Read()</span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">            If rd.HasRows Then</span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">                Txt_nis.Text = rd("nis")</span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">                Txt_nama.Text = rd("nm_siswa")</span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">                Txt_alamat.Text = rd("alamat")</span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">                Cbo_kelamin.Text = rd("jenis_kelamin")</span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">                Btn_simpan.Enabled= False</span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">            Else</span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">                MsgBox("Data tidak ditemukan")</span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">            End If</span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">            rd.Close()</span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">        End If</span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">    End Sub</span></span><br /> <span style="line-height: 20px;"><span style="background-color: white; font-family: Arial, Helvetica, sans-serif;"></span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">End Class</span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;"><br /></span></span> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">6. Lalu jalankan program dengan cara tekan F5,</span></span><br /> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgam9Gz2rFtAB88tGZfSqcYxE8Z9bpPtc8BkZP3QJ_bgKPaA_77ZjacK8lvQ0ieGj6sm-wrzmqku5aglkEukI0Xn10p-2EXNYgtnDWID-0B1zvK6uxknDTfU_W_PPaUp2V23CiiHtQTw5uE/s1600/CRUD_dengan_VB.NET_Bagian_1_3.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="CRUD dengan VB.NET bagian 1" border="0" height="178" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgam9Gz2rFtAB88tGZfSqcYxE8Z9bpPtc8BkZP3QJ_bgKPaA_77ZjacK8lvQ0ieGj6sm-wrzmqku5aglkEukI0Xn10p-2EXNYgtnDWID-0B1zvK6uxknDTfU_W_PPaUp2V23CiiHtQTw5uE/s320/CRUD_dengan_VB.NET_Bagian_1_3.png" title="CRUD dengan VB.NET bagian 1" width="320" /></a></div> <span style="font-family: Arial, Helvetica, sans-serif; line-height: 20px;"><br /></span> <br /> <blockquote class="tr_bq"> <div style="text-align: center;"> Jika anda ingin mendownload source code silahkan klik <a href="http://adf.ly/cshu9" rel="nofollow" target="_blank">disini</a></div> <div style="text-align: center;"> dan untuk passwordnya <a href="http://adf.ly/fHCDH">disini</a></div> </blockquote> <span style="font-family: Arial, Helvetica, sans-serif; line-height: 20px;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif; line-height: 20px;">semoga berhasil</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">sekian postingan saya kali ini.</span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span style="line-height: 20px;">untuk selanjutnya pada postingan CRUD dengan VB.NET bagian 2 saya akan menambahkan Update dan Delete data</span></span></div>

CRUD dengan VB.NET bagian 1

Malam semua sebelum saya menlanjutkan postingan ini ada baiknya anda membaca  cara mengkoneksikan VB.NET ke SQL Server 2008  kali ini saya a...

Read more »

Memasang Alexa Rank Di Blog

<span style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;">Malam semua kali ini saya akan posting tetang cara Memasang Alexa Rank Di Blog,sebelumnya kita harus mengetahui apakah yang dimaksud dengan Alexa Rank?</span><br /> <span style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;">Alexa Traffic Rank adalah perkiraan secara kasar popularitas sebuah Blog atau Website di negara tertentu maupun secara Global.bahkan banyak situs-situs yang terkenal juga menggunakannya, menjadikannya salah satu rujukan peringkat sebuah situs.</span><br /><br /> <div class="separator" style="background-color: #f3f3f3; clear: both; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: center;"> <a href="http://1.bp.blogspot.com/-MZJlL-edbtM/UdmMjXjg2BI/AAAAAAAAFRc/GOKBnwQ_zfE/s1600/New+Picture.jpg" imageanchor="1" style="clear: left; color: #0c6708; float: left; margin-bottom: 1em; margin-right: 1em; text-decoration: none;"><img alt="Memasang Alexa Rank Di Blog" border="0" height="120" src="http://1.bp.blogspot.com/-MZJlL-edbtM/UdmMjXjg2BI/AAAAAAAAFRc/GOKBnwQ_zfE/s200/New+Picture.jpg" style="-webkit-transition: all 500ms ease-in-out; background-color: #f7f7f7; border: 0px; overflow: hidden; padding: 2px; transition: all 500ms ease-in-out;" title="Memasang Alexa Rank Di Blog" width="200" /></a></div> <span style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;">Alexa menyediakan informasi mengenai popularitas banyaknya pengunjung harian, tampilan halaman, kata kunci, kategori dan lainnya yang perbaharui (update) setiap hari. Maka dengan memasang Alexa akan mendapatkan keuntungan lebih, agar analisa data-data lebih akurat.</span><br style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;" /><br /> <span style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;">Untuk menggunakan Alexa tidak selalu harus memasang widget-nya, tetapi yang paling penting adalah memasang meta name-nya diletakan dibagian "head".</span><br style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;" /><br style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;" /><span style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;">Daftar Alexa ada yg gratis dan berbayar, Berikut cara memasang Alexa meta name, langkah ini digunakan untuk mengklaim kepemilikan sebuah situs:</span><br style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;" /><span style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;">1. Kunjungi situs alexa.com</span><br style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;" /><span style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;">2. Daftar (Create an Account alias sign up) seperti pada umumnya menggunakan email ataupun facebook.</span><br style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;" /><span style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;">3. Verifikasi email dari alexa (jika menggunakan email) Klik link tautannya.</span><br style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;" /><span style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;">    Verifikasi notifikasi jika menggunakan facebook.</span><br style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;" /><span style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;">    Kalau sudah masuk, diatas biasanya ada tulisan 'Welcome'.</span><br style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;" /><span style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;">4. Setelah selesai verifikasi, kunjungi halaman   http://www.alexa.com/siteowners/claim</span><br style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;" /><span style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;">    Perhatikan: Pilih Verify Ownership (Select Verify)</span><br /> <div class="separator" style="background-color: #f3f3f3; clear: both; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: center;"> <br /></div> <div class="separator" style="background-color: #f3f3f3; clear: both; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: center;"> <a href="http://1.bp.blogspot.com/-53EHN3CF50M/UdmGNzSQDDI/AAAAAAAAFP8/MVf0Yk-p7JY/s1600/Verify+Ownership+1.jpg" imageanchor="1" style="color: #0c6708; text-decoration: none;"><img border="0" src="http://1.bp.blogspot.com/-53EHN3CF50M/UdmGNzSQDDI/AAAAAAAAFP8/MVf0Yk-p7JY/s1600/Verify+Ownership+1.jpg" style="-webkit-transition: all 500ms ease-in-out; background-color: #f7f7f7; background-position: initial initial; background-repeat: initial initial; border: 0px; overflow: hidden; padding: 2px; transition: all 500ms ease-in-out;" width="450" /></a></div> <br style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;" /><span style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;">5. Masukan nama Blog atau website dalam kotak tersedia, jika sudah yakin pilihannya maka lanjutkan (Get Started).</span><br style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;" /><span style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;">6. Halaman berikutnya Pilih Free (Yang Gratis).</span><br /> <div class="separator" style="background-color: #f3f3f3; clear: both; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: center;"> <br /></div> <div class="separator" style="background-color: #f3f3f3; clear: both; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: center;"> <a href="http://4.bp.blogspot.com/-nWGQfgh1dOk/UdmI6Q-wolI/AAAAAAAAFQk/JzvjNxACH5M/s1600/Free.jpg" imageanchor="1" style="color: #0c6708; text-decoration: none;"><img border="0" src="http://4.bp.blogspot.com/-nWGQfgh1dOk/UdmI6Q-wolI/AAAAAAAAFQk/JzvjNxACH5M/s1600/Free.jpg" style="-webkit-transition: all 500ms ease-in-out; background-color: #f7f7f7; background-position: initial initial; background-repeat: initial initial; border: 0px; overflow: hidden; padding: 2px; transition: all 500ms ease-in-out;" width="450" /></a></div> <br style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;" /><span style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;">7. Di Halaman </span><b style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;">Claim Your Site</b><br style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;" /><span style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;">    Pilih metode yang kedua (</span><b style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;">option 2</b><span style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;">) untuk verifikasi situs, Pilihan ini direkomendasikan.</span><br /> <div class="separator" style="background-color: #f3f3f3; clear: both; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: center;"> <br /></div> <div class="separator" style="background-color: #f3f3f3; clear: both; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: center;"> <a href="http://3.bp.blogspot.com/-nFzxoAIC5ps/UdmI697XYCI/AAAAAAAAFQ8/7HfmM4zINpc/s1600/Meta+Name.png" imageanchor="1" style="color: #0c6708; text-decoration: none;"><img border="0" src="http://3.bp.blogspot.com/-nFzxoAIC5ps/UdmI697XYCI/AAAAAAAAFQ8/7HfmM4zINpc/s1600/Meta+Name.png" style="-webkit-transition: all 500ms ease-in-out; background-color: #f7f7f7; background-position: initial initial; background-repeat: initial initial; border: 0px; overflow: hidden; padding: 2px; transition: all 500ms ease-in-out;" width="600" /></a></div> <br style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;" /><span style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;">Keterangan gbr, contoh <meta name=”alexaVerifyID” content=”</span><b style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;">xxxxxxxxxxxxxxxxx</b><span style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;">” /></span><br style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;" /><br style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;" /><span style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;">8. Buka Tab Halaman baru, Login ke Blog, buka Template Blog anda (Edit Template), Copy dan masukan kode meta name yang diberi tanda, di bagian “head” template atau diatas</span><b style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;"><b:skin></b><span style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;"> setelah itu save template.</span><br style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;" /><span style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;">9. Kembali ke halaman verifikasi Alexa, kemudian Klik Verify my ID, Jika benar maka akan ada notifikasi berhasil - your site is succesfully claimed.</span><br /> <div class="separator" style="background-color: #f3f3f3; clear: both; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: center;"> <br /></div> <div class="separator" style="background-color: #f3f3f3; clear: both; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: center;"> <a href="http://3.bp.blogspot.com/-Vz3oH4Iciw0/UdmI6E5iCmI/AAAAAAAAFQc/F2Hngt2DfsM/s1600/Claimed.png" imageanchor="1" style="color: #0c6708; margin-left: 1em; margin-right: 1em; text-decoration: none;"><img border="0" height="76" src="http://3.bp.blogspot.com/-Vz3oH4Iciw0/UdmI6E5iCmI/AAAAAAAAFQc/F2Hngt2DfsM/s320/Claimed.png" style="-webkit-transition: all 500ms ease-in-out; background-color: #f7f7f7; background-position: initial initial; background-repeat: initial initial; border: 0px; overflow: hidden; padding: 2px; transition: all 500ms ease-in-out;" width="320" /></a></div> <br style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;" /><span style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;">10. Sampai langkah ini sebenarnya telah selesai. Tambahan berikut, jika melakukan langkah berikutnya bisa mengisi data-data jika diinginkan (pilihan mau diisi atau tidak).</span><br style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;" /><br /> <div class="separator" style="background-color: #f3f3f3; clear: both; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: center;"> <a href="http://1.bp.blogspot.com/-oNGQPCj9Ekk/UdmI6dnPrYI/AAAAAAAAFQs/I285jHZBdyo/s1600/Data.jpg" imageanchor="1" style="color: #0c6708; text-decoration: none;"><img border="0" src="http://1.bp.blogspot.com/-oNGQPCj9Ekk/UdmI6dnPrYI/AAAAAAAAFQs/I285jHZBdyo/s1600/Data.jpg" style="-webkit-transition: all 500ms ease-in-out; background-color: #f7f7f7; background-position: initial initial; background-repeat: initial initial; border: 0px; overflow: hidden; padding: 2px; transition: all 500ms ease-in-out;" width="400" /></a></div> <br style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;" /><span style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;">Demikian cara memasang meta name Alexa, mudah-mudahan bermanfaat. Jika sudah terpasang, mudah-mudahan analisa terhadap Alexanya lebih akurat, karena telah terdaftar. Jika anda ingin memasang widgetnya pun mudah, tergantung kemauan.</span><br style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;" /><br style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;" /><span style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;">Berikut </span><b style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;">Cara Memasang Widget Alexa Di Blog</b><span style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;">.</span><br style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;" /><span style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;">1. Kunjungi link ini   http://www.alexa.com/siteowners/widgets</span><br style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;" /><span style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;">2. Masukan URL Blog kedalam Kotak sesuai widget yang diinginkan, Klik Build Widget.</span><br style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;" /><br /> <div class="separator" style="background-color: #f3f3f3; clear: both; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: center;"> <a href="http://3.bp.blogspot.com/-7WQzLrudm_s/UdmI7ZKEDRI/AAAAAAAAFRA/ZmHzC1lU8fc/s1600/Widget.jpg" imageanchor="1" style="color: #0c6708; text-decoration: none;"><img border="0" src="http://3.bp.blogspot.com/-7WQzLrudm_s/UdmI7ZKEDRI/AAAAAAAAFRA/ZmHzC1lU8fc/s1600/Widget.jpg" style="-webkit-transition: all 500ms ease-in-out; background-color: #f7f7f7; background-position: initial initial; background-repeat: initial initial; border: 0px; overflow: hidden; padding: 2px; transition: all 500ms ease-in-out;" width="600" /></a></div> <br style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;" /><span style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;">3. Copy Kode yang tersedia dalam kotak sesuai model widgetnya.</span><br style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;" /><br /> <div class="separator" style="background-color: #f3f3f3; clear: both; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: center;"> <a href="http://3.bp.blogspot.com/-35u34_4mJr4/UdmI7V4Ug6I/AAAAAAAAFQ4/7QaIL-2lWmw/s1600/kode+widget.jpg" imageanchor="1" style="color: #0c6708; text-decoration: none;"><img border="0" src="http://3.bp.blogspot.com/-35u34_4mJr4/UdmI7V4Ug6I/AAAAAAAAFQ4/7QaIL-2lWmw/s1600/kode+widget.jpg" style="-webkit-transition: all 500ms ease-in-out; background-color: #f7f7f7; background-position: initial initial; background-repeat: initial initial; border: 0px; overflow: hidden; padding: 2px; transition: all 500ms ease-in-out;" width="600" /></a></div> <br style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;" /><span style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;">4. Masukan kode widgetnya di Add a Gadget (HTML/JavaScript)  Di Blog.</span><br style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;" /><span style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;">    atau dimana saja ingin dipasangkan pada Template di dalam Blog.</span><span style="background-color: #f3f3f3; color: #36363c; font-family: 'lucida grande', arial, sans-serif; font-size: 15px; line-height: 27px; text-align: justify;">.</span>

Memasang Alexa Rank Di Blog

Malam semua kali ini saya akan posting tetang cara Memasang Alexa Rank Di Blog,sebelumnya kita harus mengetahui apakah yang dimaksud dengan ...

Read more »