tag:blogger.com,1999:blog-74682689935733122482023-11-16T11:04:53.449-08:00My Blog SiteBlog Berisikan tentang berbagai pengetahuanAnonymoushttp://www.blogger.com/profile/08729531800423570591noreply@blogger.comBlogger12125tag:blogger.com,1999:blog-7468268993573312248.post-45139530857245486802012-10-28T07:32:00.004-07:002012-10-28T07:32:33.497-07:007. Tentang Perintah SQL .<br />
<h3 class="post-title entry-title" itemprop="name" style="font-family: 'Indie Flower'; font-size: 26px; margin: 0px; position: relative;">
<br /></h3>
<div class="post-header" style="font-family: 'Crafty Girls'; font-size: 12.727272033691406px; line-height: 1.6; margin: 0px 0px 1em;">
<div class="post-header-line-1">
</div>
</div>
<div class="post-body entry-content" id="post-body-8322654365993107752" itemprop="description articleBody" style="font-family: 'Crafty Girls'; font-size: 12.727272033691406px; line-height: 16.363636016845703px; position: relative; width: 496.1666564941406px;">
<span style="background-color: white;"><br /></span><h3 class="post-title entry-title" itemprop="name" style="font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 22px; line-height: normal; margin: 0px; position: relative;">
<span style="background-color: white;">SQL QUERY</span></h3>
<div class="post-header" style="font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; line-height: 1.6; margin: 0px 0px 1em;">
<div class="post-header-line-1">
</div>
</div>
<div class="post-body entry-content" id="post-body-3434815295405037575" itemprop="description articleBody" style="font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; line-height: 18px; position: relative; width: 936px;">
<div style="text-align: justify;">
<span style="font-family: Verdana, sans-serif; font-size: small;"><b><span style="background-color: white;">select()</span></b></span></div>
<div style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><span style="background-color: white;"><br /></span></span></div>
<div style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><span style="background-color: white;">function select($columns='*')</span></span></div>
<div style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><span style="background-color: white;"><br /></span></span></div>
<div style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><span style="background-color: white;">Method select() menentukan bagian SELECT pada query. Parameter $columns menentukan kolom-kolom apa saja yang akan di-select, yang bisa berupa string dengan nama kolom dipisah koma, atau sebuah array dari nama kolom. Nama kolom dapat berisi prefiks table dan/atau alias kolom. Method ini akan secara otomatis memberikan quote pada nama kolom kecuali kolom tersebut mengandung tanda kurung (yang bararti kolom yang diberikan merupakan ekspresi DB).<a href="" name="more"></a></span></span></div>
<div style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><span style="background-color: white;"><br /></span></span></div>
<div style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><span style="background-color: white;">Berikut ini merupakan beberapa contoh:</span></span></div>
<div style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><span style="background-color: white;"><br /></span></span></div>
<div style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><span style="background-color: white;">// SELECT *</span></span></div>
<div style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><span style="background-color: white;">select()</span></span></div>
<div style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><span style="background-color: white;">// SELECT `id`, `username`</span></span></div>
<div style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><span style="background-color: white;">select('id, username')</span></span></div>
<div style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><span style="background-color: white;">// SELECT `tbl_user`.`id`, `username` AS `name`</span></span></div>
<div style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><span style="background-color: white;">select('tbl_user.id, username as name')</span></span></div>
<div style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><span style="background-color: white;">// SELECT `id`, `username`</span></span></div>
<div style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><span style="background-color: white;">select(array('id', 'username'))</span></span></div>
<div style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><span style="background-color: white;">// SELECT `id`, count(*) as num</span></span></div>
<div style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><span style="background-color: white;">select(array('id', 'count(*) as num'))</span></span></div>
<div style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><span style="background-color: white;"><br /></span></span></div>
<div style="text-align: justify;">
<span style="font-family: Verdana, sans-serif; font-size: small;"><b><span style="background-color: white;">selectDistinct()</span></b></span></div>
<div style="text-align: justify;">
<span style="font-family: Verdana, sans-serif; font-size: small;"><span style="background-color: white;"><br /></span></span></div>
<div style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><span style="background-color: white;">function selectDistinct($columns)</span></span></div>
<div style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><span style="background-color: white;"><br /></span></span></div>
<div style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><span style="background-color: white;">Method selectDistinct() mirip dengan select(). Hanya saja selectDistinct mengaktifkan flag DISTINCT. Misalnya,selectDistinct(id,username')` akan menghasilkan SQL berikut:</span></span></div>
<div style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><span style="background-color: white;"><br /></span></span></div>
<div style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><span style="background-color: white;">SELECT DISTINCT `id`, `username`</span></span></div>
<div style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><span style="background-color: white;"><br /></span></span></div>
<div style="text-align: justify;">
<span style="font-family: Verdana, sans-serif; font-size: small;"><b><span style="background-color: white;">insert()</span></b></span></div>
<div style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><span style="background-color: white;"><br /></span></span></div>
<div style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><span style="background-color: white;">function insert($table, $columns)</span></span></div>
<div style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><span style="background-color: white;"><br /></span></span></div>
<div style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><span style="background-color: white;">Method insert() membuat dan menjalankan statement SQL INSERT. Parameter $table menentukan table yang mana yang disisipkan, sedangkan $columns merupakan sebuah array dengan pasangan nama-nilai yang menjelaskan nilai-nilai kolom yang akan disisipkan. Method tersebut akan memberikan quote pada nama table dan akan menggunakan parameter-binding untuk nilai yang dimasukkan.</span></span></div>
<div style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><span style="background-color: white;"><br /></span></span></div>
<div style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><span style="background-color: white;">Berikut merupakan contohnya:</span></span></div>
<div style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><span style="background-color: white;"><br /></span></span></div>
<div style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><span style="background-color: white;">// buat dan jalankan SQL berikut :</span></span></div>
<div style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><span style="background-color: white;">// INSERT INTO `tbl_user` (`name`, `email`) VALUES (:name, :email)</span></span></div>
<div style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><span style="background-color: white;">$command->insert('tbl_user', array(</span></span></div>
<div style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><span style="background-color: white;"> 'name'=>'Tester',</span></span></div>
<div style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><span style="background-color: white;"> 'email'=>'tester@example.com',</span></span></div>
<div style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><span style="background-color: white;">));</span></span></div>
<div style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><span style="background-color: white;"><br /></span></span></div>
<div style="text-align: justify;">
<span style="font-family: Verdana, sans-serif; font-size: small;"><b><span style="background-color: white;">update()</span></b></span></div>
<div style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><span style="background-color: white;"><br /></span></span></div>
<div style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><span style="background-color: white;">function update($table, $columns, $conditions='', $params=array())</span></span></div>
<div style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><span style="background-color: white;"><br /></span></span></div>
<div style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><span style="background-color: white;">Method update() akan membuat dan mengeksekusi statement UPDATE SQL. Parameter $table menentukan table mana yang akan di-update; $columns adalah sebuah array dengan pasangan nama-nilai yang menentukan nilai kolom yang akan di-update; $conditions dan $params mirip dengan where(), yang akan menetapkan klausa WHERE dalam statement UPDATE. Method ini akan memberikan quote pada nama dan menggunakan parameter-binding untuk nilai yang di-update.</span></span></div>
<div style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><span style="background-color: white;"><br /></span></span></div>
<div style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><span style="background-color: white;">Berikut merupakan contohnya:</span></span></div>
<div style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><span style="background-color: white;"><br /></span></span></div>
<div style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><span style="background-color: white;">// buat dan jalankan SQL berikut:</span></span></div>
<div style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><span style="background-color: white;">// UPDATE `tbl_user` SET `name`=:name WHERE id=:id</span></span></div>
<div style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><span style="background-color: white;">$command->update('tbl_user', array(</span></span></div>
<div style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><span style="background-color: white;"> 'name'=>'Tester',</span></span></div>
<div style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><span style="background-color: white;">), 'id=:id', array(':id'=>1));</span></span></div>
<div style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><span style="background-color: white;"><br /></span></span></div>
<div style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><span style="font-size: small;"><b><span style="background-color: white;">delete()</span></b></span></span></div>
<div style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><span style="background-color: white;"><br /></span></span></div>
<div style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><span style="background-color: white;">function delete($table, $conditions='', $params=array())</span></span></div>
<div style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><span style="background-color: white;"><br /></span></span></div>
<div style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><span style="background-color: white;">Method delete() membuat dan menjalankan statement SQL DELETE. Parameter $table menentukan table yang mana yang akan dihapus; $conditions dan $params mirip dengan where(), yakni menentukan WHERE di dalam statement DELETE. Method ini akan memberikan quote pada nama.</span></span></div>
<div style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><span style="background-color: white;"><br /></span></span></div>
<div style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><span style="background-color: white;">Berikut salah satu contoh:</span></span></div>
<div style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><span style="background-color: white;"><br /></span></span></div>
<div style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><span style="background-color: white;">//buat dan eksekusi SQL berikut:</span></span></div>
<div style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><span style="background-color: white;">// DELETE FROM `tbl_user` WHERE id=:id</span></span></div>
<div style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><span style="background-color: white;">$command->delete('tbl_user', 'id=:id', array(':id'=>1));</span></span></div>
<div style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><span style="background-color: white;"><br /></span></span></div>
<div style="text-align: justify;">
<span style="background-color: white;"><span style="font-family: Verdana, sans-serif;">Sumber: </span><a href="http://www.yiiframework.com/doc/guide/1.1/id/database.query-builder" style="text-decoration: none;">http://www.yiiframework.com/doc/guide/1.1/id/database.query-builder</a></span></div>
</div>
</div>
Anonymoushttp://www.blogger.com/profile/08729531800423570591noreply@blogger.com1tag:blogger.com,1999:blog-7468268993573312248.post-86415154861319926042012-10-28T07:31:00.002-07:002012-10-28T07:31:16.160-07:006. Langkah-langkah Untuk Membuat DataBase dan Tabel di MS.Acces<br />
<h3 class="post-title entry-title" itemprop="name" style="font-size: 26px; margin: 0px; position: relative;">
<br /></h3>
<div class="post-header" style="font-size: 12.727272033691406px; line-height: 1.6; margin: 0px 0px 1em;">
<div class="post-header-line-1">
</div>
</div>
<div class="post-body entry-content" id="post-body-6654292088382997807" itemprop="description articleBody" style="font-size: 12.727272033691406px; line-height: 16.363636016845703px; position: relative; width: 496.1666564941406px;">
<span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></span><div style="font-size: 12px; line-height: 18px; text-align: justify;">
<span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;">Database adalah file data yang berisi objek seperti tabel, query, report dan lainnya. Pada tampilan awal dari program Acces 2007, anda dapat membuat sebuah Database baru atau membuka database yang telah dibuat sebelumnya.</span></span></div>
<div style="font-size: 12px; line-height: 18px; text-align: justify;">
<span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;">Berikut Langkah-Langkahnya:</span></span></div>
<h2 style="border-bottom-color: rgb(255, 0, 255); border-bottom-style: solid; border-bottom-width: 1px; font-size: 18px; line-height: 22px; margin: 0px 0px 5px; padding: 0px; position: relative; text-align: justify;">
<span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;">Langkah 1</span></span></h2>
<div style="border-top-color: rgb(255, 0, 255); border-top-style: solid; border-top-width: 0px; font-size: 12px; line-height: 18px; padding-top: 8px; text-align: justify;">
<span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;">Klik Menu <strong>Start-All Program – Ms. Office – Ms.Access 2007</strong></span></span></div>
<div style="font-size: 12px; line-height: 18px; text-align: justify;">
<span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;"><img alt="" class="alignnone size-full wp-image-21509" height="294" src="http://news.palcomtech.com/wp-content/uploads/2011/10/mc-acse.jpg" style="-webkit-box-shadow: rgba(0, 0, 0, 0.2) 0px 0px 0px; border-bottom-left-radius: 0px; border-bottom-right-radius: 0px; border-top-left-radius: 0px; border-top-right-radius: 0px; border: 1px solid rgb(255, 0, 255); box-shadow: rgba(0, 0, 0, 0.2) 0px 0px 0px; display: inline; margin: 0px 0px 10px; padding: 0px;" title="mc acse" width="500" /></span></span></div>
<h2 style="border-bottom-color: rgb(255, 0, 255); border-bottom-style: solid; border-bottom-width: 1px; font-size: 18px; line-height: 22px; margin: 0px 0px 5px; padding: 0px; position: relative; text-align: justify;">
<span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;"><a href="" name="more"></a>Langkah 2</span></span></h2>
<div style="border-top-color: rgb(255, 0, 255); border-top-style: solid; border-top-width: 0px; font-size: 12px; line-height: 18px; padding-top: 8px; text-align: justify;">
<span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;">Klik <strong>Blank Database, </strong>tentukan lokasi penyimpanan dan nama database, klik tombol <strong>Create</strong></span></span></div>
<div style="font-size: 12px; line-height: 18px; text-align: justify;">
<span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;"><img alt="" class="alignnone size-full wp-image-21510" height="239" src="http://news.palcomtech.com/wp-content/uploads/2011/10/mc-acse2.jpg" style="-webkit-box-shadow: rgba(0, 0, 0, 0.2) 0px 0px 0px; border-bottom-left-radius: 0px; border-bottom-right-radius: 0px; border-top-left-radius: 0px; border-top-right-radius: 0px; border: 1px solid rgb(255, 0, 255); box-shadow: rgba(0, 0, 0, 0.2) 0px 0px 0px; display: inline; margin: 0px 0px 10px; padding: 0px;" title="mc acse2" width="500" /><br />Maka akan tampil area kerja Ms. Access 2007, seperti gambar dibawah ini:</span></span></div>
<div style="font-size: 12px; line-height: 18px; text-align: justify;">
<a href="http://news.palcomtech.com/wp-content/uploads/2011/10/mc-acse3.jpg" rel="attachment wp-att-21511" style="background-color: white; font-weight: bold; text-decoration: none;"><span style="color: black; font-family: Arial, Helvetica, sans-serif;"><img alt="" class="alignnone size-full wp-image-21511" height="278" src="http://news.palcomtech.com/wp-content/uploads/2011/10/mc-acse3.jpg" style="-webkit-box-shadow: rgba(0, 0, 0, 0.2) 0px 0px 0px; border-bottom-left-radius: 0px; border-bottom-right-radius: 0px; border-top-left-radius: 0px; border-top-right-radius: 0px; border: 1px solid rgb(255, 0, 255); box-shadow: rgba(0, 0, 0, 0.2) 0px 0px 0px; display: inline; margin: 0px 0px 10px; padding: 0px; position: relative;" title="mc acse3" width="489" /></span></a></div>
<blockquote style="border: 1px solid rgb(192, 204, 211); font-size: 12px; font-style: italic; line-height: 18px; margin: 15px 25px 5px; padding: 0px 20px;">
<div style="text-align: justify;">
<span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;"><strong>Office Button : </strong>adalah pengganti menu file yang biasa anda temukan pada versi sebelumnya<br /><strong>Quick Access Toolbar </strong> : adalah customizable yang berisi perintah-perintah penting seperti save, undo, redo dan masih banyak lagi perintah yang dapat anda tambahkan sendiri sesuai dengan keperluan.<br /><strong>Ribbon : </strong>merupakan pengganti Toolbar yang sering anda temukan pada versi sebelumnya.<br /><strong>Database Object :</strong> merupakan objek-objek yang telah diaktifkan dan digunakan dalam sebuah database. Contohnya seperti : Table, Form, Report, Macro dll.<br /><strong>Object Preview : </strong>Tampilan object yang anda aktifkan seperti table, form, report, dll<br /><strong>View Shortcut </strong>: adalah fitur dalam Access 2007 yang berguna untuk mengubah tampilan objek dengan mode tertentu sesuai dengan objek yang digunakan. Contohnya: Design View, Layout View, DataSheet View, Form View dll.</span></span></div>
</blockquote>
<div style="font-size: 12px; line-height: 18px; text-align: justify;">
<span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;"><strong>A. </strong><strong>Membuat Table Menggunakan DataSheet View</strong><br /><em>Tabel Data Mahasiswa PalComTeh</em></span></span></div>
<div style="font-size: 12px; line-height: 18px; text-align: justify;">
<span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;"><img alt="" class="size-full wp-image-21512 alignnone" height="149" src="http://news.palcomtech.com/wp-content/uploads/2011/10/mc-acse4a.jpg" style="-webkit-box-shadow: rgba(0, 0, 0, 0.2) 0px 0px 0px; border-bottom-left-radius: 0px; border-bottom-right-radius: 0px; border-top-left-radius: 0px; border-top-right-radius: 0px; border: 1px solid rgb(255, 0, 255); box-shadow: rgba(0, 0, 0, 0.2) 0px 0px 0px; display: inline; margin: 0px 0px 10px; padding: 0px;" title="mc acse4a" width="500" /><br /><strong>Berikut langkah-langkahnya:</strong></span></span></div>
<h2 style="border-bottom-color: rgb(255, 0, 255); border-bottom-style: solid; border-bottom-width: 1px; font-size: 18px; line-height: 22px; margin: 0px 0px 5px; padding: 0px; position: relative; text-align: justify;">
<span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;">Langkah 1</span></span></h2>
<ul style="font-size: 12px; line-height: 18px; list-style-image: initial; list-style-position: initial; margin: 0.5em 0px; padding: 0px 2.5em;">
<li style="border: none; margin: 0px 0px 0.25em; padding: 0.25em 0px;"><span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;">Masih pada jendela Ms. Acces 2007 yang aktif</span></span></li>
<li style="border: none; margin: 0px 0px 0.25em; padding: 0.25em 0px;"><span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;"> Ketika anda mebuat database baru, sebuah tabel secara otomatis akan tampil didalam<em>Preview object</em></span></span></li>
<li style="border: none; margin: 0px 0px 0.25em; padding: 0.25em 0px;"><span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;"><em></em>Klik tombol Close untuk menutuk jendela tab <strong>Table 1 </strong>yang aktif, dengan cara klik tombol<strong>Close</strong> yang terletak di sudut kanan atas.</span></span></li>
</ul>
<div style="font-size: 12px; line-height: 18px;">
<span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;"><img alt="" class="alignnone size-full wp-image-21513" height="278" src="http://news.palcomtech.com/wp-content/uploads/2011/10/mc-acse4.jpg" style="-webkit-box-shadow: rgba(0, 0, 0, 0.2) 0px 0px 0px; border-bottom-left-radius: 0px; border-bottom-right-radius: 0px; border-top-left-radius: 0px; border-top-right-radius: 0px; border: 1px solid rgb(255, 0, 255); box-shadow: rgba(0, 0, 0, 0.2) 0px 0px 0px; display: inline; margin: 0px 0px 10px; padding: 0px;" title="mc acse4" width="500" /></span></span></div>
<h2 style="border-bottom-color: rgb(255, 0, 255); border-bottom-style: solid; border-bottom-width: 1px; font-size: 18px; line-height: 22px; margin: 0px 0px 5px; padding: 0px; position: relative; text-align: justify;">
<span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;">Langkah 2</span></span></h2>
<div style="border-top-color: rgb(255, 0, 255); border-top-style: solid; border-top-width: 0px; font-size: 12px; line-height: 18px; padding-top: 8px; text-align: justify;">
<span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;">Anda dapat membuat tabel baru, dengan cara klik <strong>Create – Table </strong>dalam group <strong>Tables</strong>, seperti gambar dibawah ini:</span></span></div>
<div style="font-size: 12px; line-height: 18px; text-align: justify;">
<span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;"><img alt="" class="alignnone size-full wp-image-21514" height="278" src="http://news.palcomtech.com/wp-content/uploads/2011/10/mc-acse5.jpg" style="-webkit-box-shadow: rgba(0, 0, 0, 0.2) 0px 0px 0px; border-bottom-left-radius: 0px; border-bottom-right-radius: 0px; border-top-left-radius: 0px; border-top-right-radius: 0px; border: 1px solid rgb(255, 0, 255); box-shadow: rgba(0, 0, 0, 0.2) 0px 0px 0px; display: inline; margin: 0px 0px 10px; padding: 0px;" title="mc acse5" width="500" /><br />Maka tabel baru akan tampil, untuk mengganti nama field pada tabel dengan cara double klik pada nama field tersebut, seperti gambar dibawah ini:</span></span></div>
<div style="font-size: 12px; line-height: 18px; text-align: justify;">
<span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;"><img alt="" class="alignnone size-full wp-image-21515" height="250" src="http://news.palcomtech.com/wp-content/uploads/2011/10/mc-acse6.jpg" style="-webkit-box-shadow: rgba(0, 0, 0, 0.2) 0px 0px 0px; border-bottom-left-radius: 0px; border-bottom-right-radius: 0px; border-top-left-radius: 0px; border-top-right-radius: 0px; border: 1px solid rgb(255, 0, 255); box-shadow: rgba(0, 0, 0, 0.2) 0px 0px 0px; display: inline; margin: 0px 0px 10px; padding: 0px;" title="mc acse6" width="500" /></span></span></div>
<div style="font-size: 12px; line-height: 18px; text-align: justify;">
<span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;">Field baru akan tampil disebelah kanan field <strong>Nama, </strong>lanjutkan dengan memberi nama field lainnya.</span></span></div>
<div style="font-size: 12px; line-height: 18px; text-align: justify;">
<a href="http://news.palcomtech.com/wp-content/uploads/2011/10/mc-acse7.jpg" rel="attachment wp-att-21516" style="background-color: white; font-weight: bold; text-decoration: none;"><span style="color: black; font-family: Arial, Helvetica, sans-serif;"><img alt="" class="alignnone size-full wp-image-21516" height="149" src="http://news.palcomtech.com/wp-content/uploads/2011/10/mc-acse7.jpg" style="-webkit-box-shadow: rgba(0, 0, 0, 0.2) 0px 0px 0px; border-bottom-left-radius: 0px; border-bottom-right-radius: 0px; border-top-left-radius: 0px; border-top-right-radius: 0px; border: 1px solid rgb(255, 0, 255); box-shadow: rgba(0, 0, 0, 0.2) 0px 0px 0px; display: inline; margin: 0px 0px 10px; padding: 0px; position: relative;" title="mc acse7" width="490" /></span></a></div>
<h2 style="border-bottom-color: rgb(255, 0, 255); border-bottom-style: solid; border-bottom-width: 1px; font-size: 18px; line-height: 22px; margin: 0px 0px 5px; padding: 0px; position: relative; text-align: justify;">
<span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;">Langkah 3</span></span></h2>
<div style="border-top-color: rgb(255, 0, 255); border-top-style: solid; border-top-width: 0px; font-size: 12px; line-height: 18px; padding-top: 8px; text-align: justify;">
<span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;">Jika telah selesai klik <strong>Datasheet – View – Design View</strong>, seperti gambar dibawah ini:</span></span></div>
<div style="font-size: 12px; line-height: 18px; text-align: justify;">
<span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;"><img alt="" class="alignnone size-full wp-image-21517" height="149" src="http://news.palcomtech.com/wp-content/uploads/2011/10/mc-acse8.jpg" style="-webkit-box-shadow: rgba(0, 0, 0, 0.2) 0px 0px 0px; border-bottom-left-radius: 0px; border-bottom-right-radius: 0px; border-top-left-radius: 0px; border-top-right-radius: 0px; border: 1px solid rgb(255, 0, 255); box-shadow: rgba(0, 0, 0, 0.2) 0px 0px 0px; display: inline; margin: 0px 0px 10px; padding: 0px;" title="mc acse8" width="500" /></span></span></div>
<div style="font-size: 12px; line-height: 18px; text-align: justify;">
</div>
<h2 style="border-bottom-color: rgb(255, 0, 255); border-bottom-style: solid; border-bottom-width: 1px; font-size: 18px; line-height: 22px; margin: 0px 0px 5px; padding: 0px; position: relative; text-align: justify;">
<span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;">Langkah 4</span></span></h2>
<div style="border-top-color: rgb(255, 0, 255); border-top-style: solid; border-top-width: 0px; font-size: 12px; line-height: 18px; padding-top: 8px; text-align: justify;">
<span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;">Kotak dialog <strong>Save As </strong>akan tampil, simpan tabel dengan nama <strong>tb_mahasiswa</strong> dan klik <strong>Ok.</strong></span></span></div>
<div style="font-size: 12px; line-height: 18px; text-align: justify;">
<span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;"><img alt="" class="alignnone size-full wp-image-21518" height="225" src="http://news.palcomtech.com/wp-content/uploads/2011/10/mc-acse9.jpg" style="-webkit-box-shadow: rgba(0, 0, 0, 0.2) 0px 0px 0px; border-bottom-left-radius: 0px; border-bottom-right-radius: 0px; border-top-left-radius: 0px; border-top-right-radius: 0px; border: 1px solid rgb(255, 0, 255); box-shadow: rgba(0, 0, 0, 0.2) 0px 0px 0px; display: inline; margin: 0px 0px 10px; padding: 0px;" title="mc acse9" width="499" /></span></span></div>
<div style="font-size: 12px; line-height: 18px; text-align: justify;">
<span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;">Anda dapat melihat keterangan tabel yang dibuat yaitu nama field, tipe data, penggunaan primary key dan lainnya.</span></span></div>
<div style="font-size: 12px; line-height: 18px;">
<span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;"><img alt="" class="alignnone size-full wp-image-21519" height="278" src="http://news.palcomtech.com/wp-content/uploads/2011/10/mc-acse10.jpg" style="-webkit-box-shadow: rgba(0, 0, 0, 0.2) 0px 0px 0px; border-bottom-left-radius: 0px; border-bottom-right-radius: 0px; border-top-left-radius: 0px; border-top-right-radius: 0px; border: 1px solid rgb(255, 0, 255); box-shadow: rgba(0, 0, 0, 0.2) 0px 0px 0px; display: inline; margin: 0px 0px 10px; padding: 0px;" title="mc acse10" width="500" /></span></span></div>
<h2 style="border-bottom-color: rgb(255, 0, 255); border-bottom-style: solid; border-bottom-width: 1px; font-size: 18px; line-height: 22px; margin: 0px 0px 5px; padding: 0px; position: relative; text-align: justify;">
<span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;">Langkah 5</span></span></h2>
<h2 style="border-bottom-color: rgb(255, 0, 255); border-bottom-style: solid; border-bottom-width: 1px; font-size: 18px; line-height: 22px; margin: 0px 0px 5px; padding: 0px; position: relative; text-align: justify;">
<span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;">Kembali ketampilan seblumnya, klik <strong>Design – View – Datasheet View</strong>, seperti gambar dibawah ini:<br /><img alt="" class="alignnone size-full wp-image-21521" height="278" src="http://news.palcomtech.com/wp-content/uploads/2011/10/mc-acse12.jpg" style="-webkit-box-shadow: rgba(0, 0, 0, 0.2) 0px 0px 0px; border-bottom-left-radius: 0px; border-bottom-right-radius: 0px; border-top-left-radius: 0px; border-top-right-radius: 0px; border: 1px solid rgb(255, 0, 255); box-shadow: rgba(0, 0, 0, 0.2) 0px 0px 0px; display: inline; margin: 0px 0px 10px; padding: 0px;" title="mc acse12" width="500" /><br />Langkah 6</span></span></h2>
<div style="border-top-color: rgb(255, 0, 255); border-top-style: solid; border-top-width: 0px; font-size: 12px; line-height: 18px; padding-top: 8px; text-align: justify;">
<span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;">Masukan data kedalama Field-field yang telah disediakan.</span></span></div>
<div style="font-size: 12px; line-height: 18px; text-align: justify;">
<span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;"><img alt="" class="alignnone size-full wp-image-21532" height="172" src="http://news.palcomtech.com/wp-content/uploads/2011/10/mc-acse14zd.jpg" style="-webkit-box-shadow: rgba(0, 0, 0, 0.2) 0px 0px 0px; border-bottom-left-radius: 0px; border-bottom-right-radius: 0px; border-top-left-radius: 0px; border-top-right-radius: 0px; border: 1px solid rgb(255, 0, 255); box-shadow: rgba(0, 0, 0, 0.2) 0px 0px 0px; display: inline; margin: 0px 0px 10px; padding: 0px;" title="mc acse14zd" width="468" /></span></span></div>
<h2 style="border-bottom-color: rgb(255, 0, 255); border-bottom-style: solid; border-bottom-width: 1px; font-size: 18px; line-height: 22px; margin: 0px 0px 5px; padding: 0px; position: relative; text-align: justify;">
<span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;">Langkah 7</span></span></h2>
<div style="border-top-color: rgb(255, 0, 255); border-top-style: solid; border-top-width: 0px; font-size: 12px; line-height: 18px; padding-top: 8px; text-align: justify;">
<span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;">Untuk menambah, mengedit atau pindah data record, dapat menggunakan fungsi record yang disediakan dibawah jendela object.</span></span></div>
<h2 style="border-bottom-color: rgb(255, 0, 255); border-bottom-style: solid; border-bottom-width: 1px; font-size: 18px; line-height: 22px; margin: 0px 0px 5px; padding: 0px; position: relative; text-align: justify;">
<span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;"><img alt="" height="444" src="http://news.palcomtech.com/wp-content/uploads/2011/10/mc-acse14zc.jpg" style="-webkit-box-shadow: rgba(0, 0, 0, 0.2) 0px 0px 0px; border-bottom-left-radius: 0px; border-bottom-right-radius: 0px; border-top-left-radius: 0px; border-top-right-radius: 0px; border: 1px solid rgb(255, 0, 255); box-shadow: rgba(0, 0, 0, 0.2) 0px 0px 0px; padding: 8px;" title="mc acse14zc" width="468" /><br /><strong>B. </strong><strong>Membuat Tabel Menggunakan Design View</strong></span></span></h2>
<div style="border-top-color: rgb(255, 0, 255); border-top-style: solid; border-top-width: 0px; font-size: 12px; line-height: 18px; padding-top: 8px; text-align: justify;">
<em style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;">Tabel Data Mahasiswa PalComTech</span></em></div>
<div style="font-size: 12px; line-height: 18px; text-align: justify;">
<span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;"><img alt="" class="alignnone size-full wp-image-21530" height="149" src="http://news.palcomtech.com/wp-content/uploads/2011/10/mc-acse14zb.jpg" style="-webkit-box-shadow: rgba(0, 0, 0, 0.2) 0px 0px 0px; border-bottom-left-radius: 0px; border-bottom-right-radius: 0px; border-top-left-radius: 0px; border-top-right-radius: 0px; border: 1px solid rgb(255, 0, 255); box-shadow: rgba(0, 0, 0, 0.2) 0px 0px 0px; display: inline; margin: 0px 0px 10px; padding: 0px;" title="mc acse14zb" width="500" /></span></span></div>
<div style="font-size: 12px; line-height: 18px; text-align: justify;">
<strong style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;">Berikut Langkah-langkahnya:</span></strong></div>
<div style="font-size: 12px; line-height: 18px; text-align: justify;">
<span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;">Masih di database <strong>Latihan 1</strong> yang aktif</span></span></div>
<h2 style="border-bottom-color: rgb(255, 0, 255); border-bottom-style: solid; border-bottom-width: 1px; font-size: 18px; line-height: 22px; margin: 0px 0px 5px; padding: 0px; position: relative; text-align: justify;">
<span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;">Langkah 1</span></span></h2>
<div style="border-top-color: rgb(255, 0, 255); border-top-style: solid; border-top-width: 0px; font-size: 12px; line-height: 18px; padding-top: 8px; text-align: justify;">
<span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;">Tambahkan tabel baru, klik <strong>Create – Table Design,</strong> seperti gambar dibawah ini:<br /><a href="http://news.palcomtech.com/wp-content/uploads/2011/10/mc-acse14za.jpg" rel="attachment wp-att-21529" style="font-weight: bold; text-decoration: none;"><img alt="" height="251" src="http://news.palcomtech.com/wp-content/uploads/2011/10/mc-acse14za.jpg" style="-webkit-box-shadow: rgba(0, 0, 0, 0.2) 0px 0px 0px; border-bottom-left-radius: 0px; border-bottom-right-radius: 0px; border-top-left-radius: 0px; border-top-right-radius: 0px; border: 1px solid rgb(255, 0, 255); box-shadow: rgba(0, 0, 0, 0.2) 0px 0px 0px; padding: 8px; position: relative;" title="mc acse14za" width="500" /></a></span></span></div>
<h2 style="border-bottom-color: rgb(255, 0, 255); border-bottom-style: solid; border-bottom-width: 1px; font-size: 18px; line-height: 22px; margin: 0px 0px 5px; padding: 0px; position: relative; text-align: justify;">
<span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;">Langkah 2</span></span></h2>
<div style="border-top-color: rgb(255, 0, 255); border-top-style: solid; border-top-width: 0px; font-size: 12px; line-height: 18px; padding-top: 8px; text-align: justify;">
<span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;">Masukan Field data yang disediakan.</span></span></div>
<div style="font-size: 12px; line-height: 18px; text-align: justify;">
<span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;"><img alt="" class="alignnone size-full wp-image-21528" height="308" src="http://news.palcomtech.com/wp-content/uploads/2011/10/mc-acse14z.jpg" style="-webkit-box-shadow: rgba(0, 0, 0, 0.2) 0px 0px 0px; border-bottom-left-radius: 0px; border-bottom-right-radius: 0px; border-top-left-radius: 0px; border-top-right-radius: 0px; border: 1px solid rgb(255, 0, 255); box-shadow: rgba(0, 0, 0, 0.2) 0px 0px 0px; display: inline; margin: 0px 0px 10px; padding: 0px;" title="mc acse14z" width="500" /></span></span></div>
<h2 style="border-bottom-color: rgb(255, 0, 255); border-bottom-style: solid; border-bottom-width: 1px; font-size: 18px; line-height: 22px; margin: 0px 0px 5px; padding: 0px; position: relative; text-align: justify;">
<span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;">Langkah 3</span></span></h2>
<div style="border-top-color: rgb(255, 0, 255); border-top-style: solid; border-top-width: 0px; font-size: 12px; line-height: 18px; padding-top: 8px; text-align: justify;">
<span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;">Jika telah selesai gunakan <strong>Primary Key</strong> pada field <strong>Nim</strong>, seperti pada gambar dibawah ini:</span></span></div>
<div style="font-size: 12px; line-height: 18px; text-align: justify;">
<span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;"><img alt="" class="alignnone size-full wp-image-21527" height="278" src="http://news.palcomtech.com/wp-content/uploads/2011/10/mc-acse111.jpg" style="-webkit-box-shadow: rgba(0, 0, 0, 0.2) 0px 0px 0px; border-bottom-left-radius: 0px; border-bottom-right-radius: 0px; border-top-left-radius: 0px; border-top-right-radius: 0px; border: 1px solid rgb(255, 0, 255); box-shadow: rgba(0, 0, 0, 0.2) 0px 0px 0px; display: inline; margin: 0px 0px 10px; padding: 0px;" title="mc acse11" width="500" /></span></span></div>
<blockquote style="border: 1px solid rgb(192, 204, 211); font-size: 12px; font-style: italic; line-height: 18px; margin: 15px 25px 5px; padding: 0px 20px;">
<div style="text-align: justify;">
<span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;"><em>Note : <strong>Primary Key</strong> berfungsi sebagai pengunci data,</em><br /><em>Agar pengimputan data yang sama tidak dapat di proses di</em><br /><em>Dalam sebuah field.</em></span></span></div>
</blockquote>
<h2 style="border-bottom-color: rgb(255, 0, 255); border-bottom-style: solid; border-bottom-width: 1px; font-size: 18px; line-height: 22px; margin: 0px 0px 5px; padding: 0px; position: relative; text-align: justify;">
</h2>
<h2 style="border-bottom-color: rgb(255, 0, 255); border-bottom-style: solid; border-bottom-width: 1px; font-size: 18px; line-height: 22px; margin: 0px 0px 5px; padding: 0px; position: relative; text-align: justify;">
<span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;">Langkah 4</span></span></h2>
<div style="border-top-color: rgb(255, 0, 255); border-top-style: solid; border-top-width: 0px; font-size: 12px; line-height: 18px; padding-top: 8px; text-align: justify;">
<span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;">Klik <strong>Design – View – Datasheet View</strong>, seperti gambar dibawah ini:</span></span></div>
<div style="font-size: 12px; line-height: 18px;">
<span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;"><img alt="" class="alignnone size-full wp-image-21526" height="278" src="http://news.palcomtech.com/wp-content/uploads/2011/10/mc-acse121.jpg" style="-webkit-box-shadow: rgba(0, 0, 0, 0.2) 0px 0px 0px; border-bottom-left-radius: 0px; border-bottom-right-radius: 0px; border-top-left-radius: 0px; border-top-right-radius: 0px; border: 1px solid rgb(255, 0, 255); box-shadow: rgba(0, 0, 0, 0.2) 0px 0px 0px; display: inline; margin: 0px 0px 10px; padding: 0px;" title="mc acse12" width="500" /></span></span></div>
<div style="font-size: 12px; line-height: 18px;">
<span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;">Jika tampil kotak dialog seperti dibawah ini, pilih <strong>Save</strong> dan simpan dengan nama<strong>Tb_data_mahasiswa, </strong>seperti gambar dibawah ini:</span></span></div>
<div style="font-size: 12px; line-height: 18px; text-align: justify;">
<a href="http://news.palcomtech.com/wp-content/uploads/2011/10/mc-acse13.jpg" rel="attachment wp-att-21525" style="background-color: white; font-weight: bold; text-decoration: none;"><span style="color: black; font-family: Arial, Helvetica, sans-serif;"><img alt="" class="alignnone size-full wp-image-21525" height="125" src="http://news.palcomtech.com/wp-content/uploads/2011/10/mc-acse13.jpg" style="-webkit-box-shadow: rgba(0, 0, 0, 0.2) 0px 0px 0px; border-bottom-left-radius: 0px; border-bottom-right-radius: 0px; border-top-left-radius: 0px; border-top-right-radius: 0px; border: 1px solid rgb(255, 0, 255); box-shadow: rgba(0, 0, 0, 0.2) 0px 0px 0px; display: inline; margin: 0px 0px 10px; padding: 0px; position: relative;" title="mc acse13" width="500" /></span></a></div>
<h2 style="border-bottom-color: rgb(255, 0, 255); border-bottom-style: solid; border-bottom-width: 1px; font-size: 18px; line-height: 22px; margin: 0px 0px 5px; padding: 0px; position: relative; text-align: justify;">
<span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;">Langkah 5</span></span></h2>
<div style="border-top-color: rgb(255, 0, 255); border-top-style: solid; border-top-width: 0px; font-size: 12px; line-height: 18px; padding-top: 8px; text-align: justify;">
<span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;">Setelah seluruh field di buat, masukanlah datanya seperti gambar dibawah ini:</span></span></div>
<div style="font-size: 12px; line-height: 18px; text-align: justify;">
<span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;"><img alt="" class="alignnone size-full wp-image-21522" height="130" src="http://news.palcomtech.com/wp-content/uploads/2011/10/mc-acse14.jpg" style="-webkit-box-shadow: rgba(0, 0, 0, 0.2) 0px 0px 0px; border-bottom-left-radius: 0px; border-bottom-right-radius: 0px; border-top-left-radius: 0px; border-top-right-radius: 0px; border: 1px solid rgb(255, 0, 255); box-shadow: rgba(0, 0, 0, 0.2) 0px 0px 0px; display: inline; margin: 0px 0px 10px; padding: 0px;" title="mc acse14" width="500" /></span></span></div>
<div style="font-size: 12px; line-height: 18px; text-align: justify;">
<span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;">Jika telah selesai tutup jendela database <strong>Latihan 1</strong>, dengan cara klik tombol <strong>Office Button </strong> dan klik <strong>Close Database.</strong><strong></strong> </span></span></div>
<div style="font-size: 12px; line-height: 18px; text-align: justify;">
<span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></span></div>
<div style="font-size: 12px; line-height: 18px; text-align: justify;">
<span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;">sumber : <a href="http://news.palcomtech.com/2011/10/cara-membuat-database-dari-microsoft-access-2007/" style="text-decoration: none;">http://news.palcomtech.com/2011/10/cara-membuat-database-dari-microsoft-access-2007/</a></span></span></div>
</div>
Anonymoushttp://www.blogger.com/profile/08729531800423570591noreply@blogger.com0tag:blogger.com,1999:blog-7468268993573312248.post-65886018925289928912012-10-28T07:28:00.005-07:002012-10-28T07:28:55.599-07:005. Data Base Dan Istilah-istilahnya<br />
<h3 class="post-title entry-title" itemprop="name" style="font-size: 26px; margin: 0px; position: relative;">
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></h3>
<div class="post-header" style="font-size: 12.727272033691406px; line-height: 1.6; margin: 0px 0px 1em;">
<div class="post-header-line-1">
</div>
</div>
<div class="post-body entry-content" id="post-body-7981848580643010574" itemprop="description articleBody" style="font-size: 12.727272033691406px; line-height: 16.363636016845703px; position: relative; width: 496.1666564941406px;">
<span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></span><div style="font-size: 12px; line-height: 18px; margin-bottom: 15px;">
<span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;">DATA BASE (BASIS DATA)</span></span></div>
<div style="font-size: 12px; line-height: 18px; margin-bottom: 15px;">
<span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;">Basis data (bahasa Inggris: database), atau sering pula dieja basisdata, adalah kumpulan informasi yang disimpan di dalam komputer secara sistematik sehingga dapat diperiksa menggunakan suatu program komputer untuk memperoleh informasi dari basis data tersebut. Perangkat lunak yang digunakan untuk mengelola dan memanggil kueri (query) basis data disebut sistem manajemen basis data (database management system, DBMS). Sistem basis data dipelajari dalam ilmu informasi.<br />Istilah “basis data” berawal dari ilmu komputer. Meskipun kemudian artinya semakin luas, memasukkan hal-hal di luar bidang elektronika, artikel ini mengenai basis data komputer. Catatan yang mirip dengan basis data sebenarnya sudah ada</span></span></div>
<span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;"><a href="" name="more"></a>sebelum revolusi industri yaitu dalam bentuk buku besar, kuitansi dan kumpulan data yang berhubungan dengan bisnis.<br />Konsep dasar dari basis data adalah kumpulan dari catatan-catatan, atau potongan dari pengetahuan. Sebuah basis data memiliki penjelasan terstruktur dari jenis fakta yang tersimpan di dalamnya: penjelasan ini di sebut skema menggambarkan obyek yang diwakili oleh suatu basis data, dan hubungan di antara obyek tersebut. Ada banyak cara untuk mengorganisasi skema, atau memodelkan struktur basis data: ini dikenal sebagai model basis data atau model data. Model yang umum digunakan sekarang adalah model relasional, yang menurut istilah layman mewakili semua informasi dalam bentuk tabel-tabel yang saling berhubungan dimana setiap tabel terdiri dari baris dan kolom (definisi yang sebenarnya menggunakan terminologi matematika). Dalam model ini, hubungan antar tabel diwakili denga menggunakan nilai yang sama antar tabel. Model yang lain seperti model hierarkis dan model jaringan menggunakan cara yang lebih eksplisit untuk mewakili hubungan antar tabel.</span></span><div style="font-size: 12px; line-height: 18px; margin-bottom: 15px;">
<span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;">Istilah basis data mengacu pada koleksi dari data-data yang saling berhubungan, dan perangkat lunaknya seharusnya mengacu sebagai sistem manajemen basis data (database management system/DBMS). Jika konteksnya sudah jelas, banyak administrator dan programer menggunakan istilah basis data untuk kedua arti tersebut.<br />Sumber: Wikipedia.<br />Data base adalah suatu koleksi data computer yang terintegrasi, diorganisasikan dan disimpan dengan cara yang memudahkan pengambilan kembali. DASD (medium file master yang baik) harus digunakan.<br />Tujuan utama dari konsep database adalah meminimumkan pengulangan data dan mencapai independensi. Pengulangan data (data redundancy ) adalah duplikasi data artinya data yang sama disimpan dalan beberapa file. Independensi data adalah kemampuan untuk membuat perubahan dalan struktur data tanpa membuat perubahan pada program yang memproses data. Independensi data dicapai dengan menempatkan spesifikasi data dalam label dan kamus yang terpidah secara fisik dari program. Program mengacu pada tabel untuk mengakses data. Perubahan pada struktur data hanya dilakukan sekali, yaitu dalam tabel.<br />Ketika perusahaan mengadopsi konsep database, hirarki data menjadi :<br />- database<br />- file<br />- catatan<br />- elemen data</span></span></div>
<div style="font-size: 12px; line-height: 18px; margin-bottom: 15px;">
<span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;">File-file tersendiri dapat tetap ada, mewakili komponen – komponen utama dari database namun organisasi fisik dari data tidak menghambat pemakai. Tersedia berbagai cara untuk mengintegrasikan isi dari file-file yang memiliki hubungan logis.</span></span></div>
<div style="font-size: 12px; line-height: 18px; margin-bottom: 15px;">
<span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;">Bentuk Data Base.<br />1. Hierarchical DataBase.<br />Biasa digunakan untuk jaringan komunikasi data yang berupa hierarchi/tree. Dasar<br />hierarchi Data base berusaha untuk menggambar realita dalam sebuah organisasi<br />kebentuk data komputer.<br />2. Network DataBase<br />Network DB dibuat karena jaringan komunikasi memiliki topology Mesh, sehingga<br />membutuhkan bentuk ini. Network Data Base memiliki struktur file yang sama,<br />sehingga file yang satu dapat mengetahui / mendapatkan informasi file yang lain<br />dengan benar.<br />3. Relational DataBase<br />Bentuk DB yang paking Fleksibel dan terbuka. Biasanya digunakan pada local saja</span></span></div>
<div style="font-size: 12px; line-height: 18px; margin-bottom: 15px;">
<span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;">Struktur Data Base.<br />Integrasi logis file dapat dicapai secara eksplisit atau secara implicit<br />• Hubungan eksplisit<br />Inverted index dan link field menetapkan hubungan eksplisit antara data yang terintefrasi secara logis dalam file yang sama. Suatu pendekatan untuk menetapkan hubungan eksplisit antara catatan dari beberapa file adalah dengan menyusun catatan- catatan tersebut dalam suatu hirarki. Ini disebut struktur hirarkis. Dalam struktur seperti ini, setiap catatan pada satu tingkat dapat dihubungkan ke berbagai catatan yang setingkat lebih rendah. Catatan yang memiliki anak disebut parent dan anak catatan itu disebut children.</span></span></div>
<div style="font-size: 12px; line-height: 18px; margin-bottom: 15px;">
<span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;">• Hubungan implicit<br />Pada awal 1970-an Edgar f. Codd dan C.J. Date, keduanya dari IBM tetapi bekerja secara terpisah, mengembangkan statu pendekatan untuk menetapkan hubungan antar catatan yang tidak harus dinyatakan secara eksplisit. Link field khusus tidakperlu disertakan dalam catatan. Pendekatan Codd dan Date dinamai struktur relasional, dan menggunakan hubungan implicit, yaitu hubungan yang dapat dinyatakan secara tidak langsung dari catatan data yang telah ada. Keuntungan utama dari struktur relasional bagi CBIS adalah fleksibelitas yang ditawarkanya dalam rancangan dan penggunaan database. Pemakai dan spesialis informasi dibebeskan dari keharusan mengidentifigasi semua informasi yang diperlukan sebelum menciptakan database.</span></span></div>
<div style="font-size: 12px; line-height: 18px; margin-bottom: 15px;">
<span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;">Tipe-tipe Data Base.<br />a. Operational DataBase.<br />DB menyimpan data detail yang dibutuhkan untuk mendukung operasi dari entire<br />organization.<br />b. Analytical DataBase.<br />Menyimpan data dan information extrated dari operational yang diseleksi dan external DB. Meliputi data dan informasi yang banyak dibutuhkan oleh manajer organisasi dan end user.</span></span></div>
<div style="font-size: 12px; line-height: 18px; margin-bottom: 15px;">
<span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;">c. Data WareHouse<br />Merupakan pusat data sentral yang ditampilkan dan diintegrasikan sehingga dapat digunakan oleh manajer dan user professional untuk macam-macam analisis bisnis, penelitian pasar dan decision support.<br />d. Distributed DataBase<br />e. End User DataBase<br />Data Base terdiri dari variasi data yang dikembangkan oleh end user pada<br />workstation.<br />f. HyperMedia DataBase.<br />g. External DataBase.</span></span></div>
<div style="font-size: 12px; line-height: 18px; margin-bottom: 15px;">
<span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;">Komponen Data Base.<br />1. File data base : memiliki elemen-elemen data yang disimpan dalam salah satu format<br />organisasi file data base.</span></span></div>
<div style="font-size: 12px; line-height: 18px; margin-bottom: 15px;">
<span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;">2. DBMS : suatu kelompok program software yang mengelola DB, mengontrol akses<br />terhadap DB, menjaga pengamanan DB dan melakukan tugas-tugas lain.<br />3. Sistem Antar-Muka Bahasa Induk (A Host Language Interfice system). Bagian dari DBMS yang berkomunikasi dengan program aplikasi, menafsirkan intruksi dan bahasa tingkat tinggi aplikasi.<br />4. Program Aplikasi<br />5. Sebuah sistem Antar muka Bahasa Alami ( A Natural Language Interface system). Suatu bahasa pertanyaan (query language) yang memungkinkan pemakai untuk mendapatkan keterangan tentang apa saja yang tersedua pada system komputer.<br />6. Kamus Data (data dictionary). Pusat penyimpanan infomasi data-data dari DB yang memuat skema DB, yang mana nama dari setiap item dalam DB serta deskripsi dan definisi atribut-atributnya yang merujuk pada data standar.<br />7. Terminal Pengaksesan dan pemutakhiran yang online. Letaknya dapat berdekatan /<br />berjauhan.<br />8. Sistem keluaran / pembuat Reportase ( The output system or report Generator).<br />Terdiri dari laporan biasa ,dokumen dan laporan khusus.</span></span></div>
<div style="font-size: 12px; line-height: 18px; margin-bottom: 15px;">
<span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;">Kriteria DataBase.<br />1. Struktur filenya memudahkan untuk mengcutkan suatu record dengan record lainnya.<br />2. Penggabungan file secara menyilang dimungkinkan, sehingga record yang<br />sebelumnya bebas karena biasa digabung dan diproses bersama secara otomatis.<br />3. File program/datanya bersifat bebas, sehingga memudahkan untuk pemutakhiran dan<br />perawatan DB.<br />4. Memilih rumusan bersama (common definition) dalam kaitannya dengan<br />definisi data, format record dan berbagai jenis deskripsi lainnya.<br />5. Memiliki DBMS untuk mengelola data.<br />6. Kamus Data<br />7. Memiliki memori akses langsung yang besar untuk memuat data DBMS.<br />8. Memiliki program dan piranti komunikasi yang canggih, yang memungkinkan<br />pengguna untuk mengakses data secara serempak.<br />9. Memiliki teknik-teknik penyalinan (back up), penghidupan kembali (restart) dan perolehan kembali (recovery) yang canggih yang dapat merekrontuksi kembali file-file DB jika ada data yang rusak/hilang.<br />10. Adanya Query Language.</span></span></div>
<div style="font-size: 12px; line-height: 18px; margin-bottom: 15px;">
<span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;">Manajerial DataBase Meliputi :<br />1. System Intelegent<br />Untuk perencanaan strategis, baik dalam substansi jumlahnya maupun sifatnya bagi kegiatan manajemen puncak.<br />2. Masalah-masalah management khusus<br />3. Model Manajemen<br />4. Tugas Kunci system informasi.</span></span></div>
<div style="font-size: 12px; line-height: 18px; margin-bottom: 15px;">
<span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;">Perangkat Lunak Data Base.</span></span></div>
<div style="font-size: 12px; line-height: 18px; margin-bottom: 15px;">
<span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;">Perangkat lunak yang menetapkan dan memelihara integrasi logis antar file, baik eksplisit maupun implicit disebut system manajemen database( datavase management system ) DBMS. IDS dari General Electric adalaj contoh pertamanya dan kemudian diikuti oleh sejumlah usaha serupa dari pemasok perangkat keras dan perangkat lunak lain. Contoh DBMS yang menggunakan struktur hirarkis adalah IMS (Infirmation Management System) dari IBM dan System 2000 dari Intel.<br />Perangkat lunak basis data yang banyak digunakan dalam pemrograman dan merupakan perangkat basis data aras tinggi (high level) antara lain :<br /># Microsoft SQL Server<br /># Oracle<br /># Sybase<br /># Interbase<br /># XBase<br /># Firebird<br /># MySQL<br /># PostgreSQL<br /># Microsoft Access<br /># dBase III<br /># Paradox<br /># FoxPro<br /># Visual FoxPro<br /># Arago<br /># Force<br /># Recital<br /># dbFast<br /># dbXL<br /># Quicksilver<br /># Clipper<br /># FlagShip<br /># Harbour<br /># Visual dBase<br /># Lotus Smart Suite Approach<br />Selain perangkat lunak di atas, terdapat juga perangkat lunak pemrograman basis data aras rendah (low level), diantaranya:<br /># Btrieve<br /># Tsunami Record Manager</span></span></div>
<div style="font-size: 12px; line-height: 18px; margin-bottom: 15px;">
<span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;">Menciptakan Data Base.<br />Proses menciptakan database mencakup tiga langkah utama, yaitu;<br />1. Menentukan kebutuhan data, meliputi pendekatan berorientasi proses,<br />pendekatan model perusahaan.<br />2. Menjelaskan data, dengan cara system kamus data, data description<br />language.<br />3. Memasukan data.<br />Pengelola Data Base.<br />Seorang spesialis informasi yang bertanggung jawab atas database disebut pengelola database atau DBA. Tugas DBA terbagi dalam empat bidang utama, yaitu :<br />1. Perencanaan database, mencakup sama dengan para manajer untuk mendefinisikan skema perusahaan dengan para pemakai untuk mendefinisikan subskema mereka. Selain itu juga perperan penting dalam memilih DBMS.<br />2. Penerapan database, terdiri dari menciptakan data base yang sesuai dengan DBMS yang dipilih, serta menetapkan dan menegakkan kebijakan dan prosedur penggunaaan database.<br />3. Operasi database, mencakup menawarkan program pendidikan kepada<br />pemakai datavase dan menyediakan bantuan saat diperlukan.<br />4. Keamanan database, meliputi pemantauan kegiatan database dengan menggunakan statistic yang disediakan DBMS. Selain itu juga memastikan bahwa data base tetap aman.</span></span></div>
<div style="font-size: 12px; line-height: 18px; margin-bottom: 15px;">
<span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;">DBMS (Data Base Management System)</span></span></div>
<div style="font-size: 12px; line-height: 18px; margin-bottom: 15px;">
<span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;">DBMS: Suatu cara dalam bentuk system yang berguna dalam menyimpan data penggunaan cara yang tepat dapat mempercepat penyimpanan data, pemrosesan data dan pengambilan data.<br />Empat hal penting dalam DBMS, yaitu :<br />a. Query language<br />b. Security consideration<br />c. Biaya tidak langsung pemrosesan<br />d. Kecocokan dengan tipa aplikasi<br />Elemen-elemen Utama dari DBMS :</span></span></div>
<div style="font-size: 12px; line-height: 18px; margin-bottom: 15px;">
<span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;">a. Data description language processor<br />b. Performance statistics processor<br />c. Modul backup/recovery<br />d. Manajer database</span></span></div>
<div style="font-size: 12px; line-height: 18px; margin-bottom: 15px;">
<span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;">Keuntungan DBMS :<br />a. Mengurangi pengulangan data<br />b. Mencapai independesi data<br />c. Mengintegrasikan data beberapa file<br />d. Mengambil data dan informasi secara cepat<br />e. Meningkatkan keamanan<br />f. Meningkatkan presentasi kesiapan data (data availability) yang berarti tersedia pada waktu dibutuhkan.<br />g. Mempercepat penyimpanan dan pengambilan data.<br />h. Mempercepat dan mempermudah pemrosesan data<br />i. Mengurangi penyimpanan data yang rangkap<br />j. Mempermudah pemrograman karena lebih fleksibel.</span></span></div>
<div style="font-size: 12px; line-height: 18px; margin-bottom: 15px;">
<span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;">Kerugian DBMS :<br />a. Kurangnya ahli Data Base<br />b. Biaya pemrosesan data sangat tinggi<br />c. Kebutuhan software dan Hardware yang bertambah<br />d. Penggabungan dan pengamanan data<br />Mengikat pemakai untuk :<br />• Memperoleh perangkat lunak yang mahal<br />• Memperoleh konfigurasi perangkat keras yang besar<br />• Mempekerjakan dan mempertahankan staf DBA.</span></span></div>
<div style="font-size: 12px; line-height: 18px; margin-bottom: 15px;">
<span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;">KESIMPULAN<br />Basis data adalah kumpulan informasi yang disimpan di dalam komputer<br />secara sistematik sehingga dapat diperiksa menggunakan suatu program komputer<br />untuk memperoleh informasi dari basis data tersebut. Perangkat lunak yang digunakan<br />untuk mengelola dan memanggil kueri (query) basis data disebut sistem manajemen<br />basis data (database management system, DBMS). Sistem basis data dipelajari dalam<br />ilmu informasi.<br />Data base adalah suatu koleksi data computer yang terintegrasi,<br />diorganisasikan dan disimpan dengan cara yang memudahkan pengambilan kembali.<br />DASD (medium file master yang baik) harus digunakan.<br /><br />sumber : <a href="http://wartawarga.gunadarma.ac.id/2011/01/database-14/" style="text-decoration: none;">http://wartawarga.gunadarma.ac.id/2011/01/database-14/</a></span></span></div>
</div>
Anonymoushttp://www.blogger.com/profile/08729531800423570591noreply@blogger.com0tag:blogger.com,1999:blog-7468268993573312248.post-6963003349522589812012-10-28T07:27:00.000-07:002012-10-28T07:27:06.049-07:004. Membaca Dan Menulis File<br />
<h3 class="post-title entry-title" itemprop="name" style="font-size: 26px; margin: 0px; position: relative;">
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></h3>
<div class="post-header" style="font-size: 12.727272033691406px; line-height: 1.6; margin: 0px 0px 1em;">
<div class="post-header-line-1">
</div>
</div>
<div class="post-body entry-content" id="post-body-1288460676486001067" itemprop="description articleBody" style="font-size: 12.727272033691406px; line-height: 16.363636016845703px; position: relative; width: 496.1666564941406px;">
<span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></span><div class="postContent" style="margin: 0px; padding: 0px;">
<ol style="margin: 0px; padding: 0px 0px 0px 35px;">
<li style="margin: 0px; padding: 0px;"><span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;">Buka Microsoft Visual Studio 2010.</span></span></li>
<li style="margin: 0px; padding: 0px;"><span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;">Buat project baru di Console Application in Visual C#.</span></span></li>
<li style="margin: 0px; padding: 0px;"><span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;">Tambahkan project references <strong style="margin: 0px; padding: 0px;">System.IO </strong>, <strong style="margin: 0px; padding: 0px;">System.Collections </strong>.</span></span></li>
<li style="margin: 0px; padding: 0px;"><span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;">Tambahkan code berikut didalam Main</span></span></li>
</ol>
<pre style="margin: 0em; padding: 0px; width: 505px;"><span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;">static void Main(string[] args)<a href="" name="more"></a></span></span></pre>
<pre style="margin: 0em; padding: 0px; width: 505px;"><span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;"> {</span></span></pre>
<pre style="margin: 0em; padding: 0px; width: 505px;"><span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;"> //Membuka sebuah file test.txt di E</span></span></pre>
<pre style="margin: 0em; padding: 0px; width: 505px;"><span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;"> StreamReader objReader = new StreamReader("E:\\test.txt");</span></span></pre>
<pre style="margin: 0em; padding: 0px; width: 505px;"></pre>
<pre style="margin: 0em; padding: 0px; width: 505px;"><span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;"> //buat sebuah variabel string karena nilainya akan dimasukkan ke dalam ArrayList</span></span></pre>
<pre style="margin: 0em; padding: 0px; width: 505px;"><span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;"> string sLine = "";</span></span></pre>
<pre style="margin: 0em; padding: 0px; width: 505px;"><span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;"> ArrayList arrText = new ArrayList();</span></span></pre>
<pre style="margin: 0em; padding: 0px; width: 505px;"><span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;"> while (sLine != null)</span></span></pre>
<pre style="margin: 0em; padding: 0px; width: 505px;"><span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;"> {</span></span></pre>
<pre style="margin: 0em; padding: 0px; width: 505px;"><span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;"> sLine = objReader.ReadLine();</span></span></pre>
<pre style="margin: 0em; padding: 0px; width: 505px;"><span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;"> if (sLine != null)</span></span></pre>
<pre style="margin: 0em; padding: 0px; width: 505px;"><span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;"> arrText.Add(sLine);</span></span></pre>
<pre style="margin: 0em; padding: 0px; width: 505px;"><span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;"> }</span></span></pre>
<pre style="margin: 0em; padding: 0px; width: 505px;"><span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;"> objReader.Close();</span></span></pre>
<pre style="margin: 0em; padding: 0px; width: 505px;"><span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;"> //menampilkan isi ArrayList ke layar</span></span></pre>
<pre style="margin: 0em; padding: 0px; width: 505px;"><span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;"> foreach (string sOutput in arrText)</span></span></pre>
<pre style="margin: 0em; padding: 0px; width: 505px;"><span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;"> Console.WriteLine(sOutput);</span></span></pre>
<pre style="font-size: 12px; margin: 0em; padding: 0px; width: 505px;"><span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;"> Console.ReadLine();</span></span></pre>
<pre style="font-size: 12px; margin: 0em; padding: 0px; width: 505px;"><span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;"> }</span></span></pre>
<pre style="font-size: 12px; margin: 0em; padding: 0px; width: 505px;"></pre>
<pre style="font-size: 12px; margin: 0em; padding: 0px; width: 505px;"><span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;">sumber :<a href="http://ahmadta09.student.ipb.ac.id/2012/01/26/membaca-file-text-di-c/" style="text-decoration: none;">http://ahmadta09.student.ipb.ac.id/2012/01/26/membaca-file-text-di-c/</a></span></span></pre>
</div>
</div>
Anonymoushttp://www.blogger.com/profile/08729531800423570591noreply@blogger.com0tag:blogger.com,1999:blog-7468268993573312248.post-64457073534458907472012-10-28T07:25:00.004-07:002012-10-28T07:25:55.275-07:003.Menjalankan File Flash di c#<br />
<h3 class="post-title entry-title" itemprop="name" style="font-size: 26px; margin: 0px; position: relative;">
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></h3>
<div class="post-header" style="font-size: 12.727272033691406px; line-height: 1.6; margin: 0px 0px 1em;">
<div class="post-header-line-1">
</div>
</div>
<div class="post-body entry-content" id="post-body-4640710490744609655" itemprop="description articleBody" style="font-size: 12.727272033691406px; line-height: 16.363636016845703px; position: relative; width: 496.1666564941406px;">
<span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></span><span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;">Pada tulisan yang lalu sudah pernah dibahas pembuatan PDF Reader dengan VB.NET menggunakan komponen bawaan Adobe Acrobat PDF Reader. Nah kali ini penulis ingin membagi cara pembuatan Flash Viewer menggunakan komponen bawaan produk Adobe yang lain yaitu Adobe Flash Player lebih tepatnya Shockwave Player</span></span><br />
<div class="post-body entry-content" id="post-body-2457612773468178708" itemprop="articleBody" style="line-height: 1.4; position: relative; width: 496.1514892578125px;">
<span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;"><br />Langkahnya buat Project baru, karena menggunakan bahasa C# maka pilih C#.NET - WindowsApplication. Kemudian pada Toolbox klik kanan Choose Items..<br /></span></span><div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhobCrraLZVIGgx9xZzsMhlTeo4iMGR0fs6LWF6UuZTy8dcrwCtNxobXDN4MoGCOSvxtWk404rfEh28x86r5NCuEVeepsJY3lzyhQG5LgK_lSBj2EVozv-kcjGwOBx5UJWgyNdE6qU3zf9w/s1600/cariprogram_clip_image002_0000.jpg" imageanchor="1" style="background-color: white; margin-left: 1em; margin-right: 1em; text-decoration: none;"><span style="color: black; font-family: Arial, Helvetica, sans-serif;"><img border="0" height="178" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhobCrraLZVIGgx9xZzsMhlTeo4iMGR0fs6LWF6UuZTy8dcrwCtNxobXDN4MoGCOSvxtWk404rfEh28x86r5NCuEVeepsJY3lzyhQG5LgK_lSBj2EVozv-kcjGwOBx5UJWgyNdE6qU3zf9w/s320/cariprogram_clip_image002_0000.jpg" style="-webkit-box-shadow: rgba(0, 0, 0, 0.2) 0px 0px 0px; border-bottom-left-radius: 0px; border-bottom-right-radius: 0px; border-top-left-radius: 0px; border-top-right-radius: 0px; border: 1px solid rgb(255, 0, 255); box-shadow: rgba(0, 0, 0, 0.2) 0px 0px 0px; padding: 8px; position: relative;" width="320" /></span></a></div>
<span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;"><a href="" name="more"></a><br />Setelah muncul Choose Toolbox Items, kemudian pilih Shockwave Flash Object. Perlu diingat, komponen ini hanya muncul apabila sudah menginstall program Adobe Flash.<br /><br /><a href="http://draft.blogger.com/blogger.g?blogID=4748866306127278484" name="more" style="text-decoration: none;"></a><br /></span></span><div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiuspJt2Q5-UUF9PiohB7YQkLC0ywSTYUiYUkkTa1F8cPurAG0HLdgYId5IwCZS3eG7cNmqHQUTX8Fe72bgGJ5dbtciV4Ic_82a9GTqOvG1tAsj6wB-NbyfIV6apTl6rfh2OaPtbueFYqlj/s1600/cariprogram_clip_image004.jpg" imageanchor="1" style="background-color: white; margin-left: 1em; margin-right: 1em; text-decoration: none;"><span style="color: black; font-family: Arial, Helvetica, sans-serif;"><img border="0" height="219" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiuspJt2Q5-UUF9PiohB7YQkLC0ywSTYUiYUkkTa1F8cPurAG0HLdgYId5IwCZS3eG7cNmqHQUTX8Fe72bgGJ5dbtciV4Ic_82a9GTqOvG1tAsj6wB-NbyfIV6apTl6rfh2OaPtbueFYqlj/s320/cariprogram_clip_image004.jpg" style="-webkit-box-shadow: rgba(0, 0, 0, 0.2) 0px 0px 0px; border-bottom-left-radius: 0px; border-bottom-right-radius: 0px; border-top-left-radius: 0px; border-top-right-radius: 0px; border: 1px solid rgb(255, 0, 255); box-shadow: rgba(0, 0, 0, 0.2) 0px 0px 0px; padding: 8px; position: relative;" width="320" /></span></a></div>
<span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;"><br />Kemudian pada Form1 tambahkan Button1, OpenFileDialog1 dan<br /></span></span><div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEis8qIX0Y85bnwWeRhFUJr0Srw4G3BtOuYtD7t4orSdrbAZdHHoKONZrg89KuN92WiQzx93jNzRJ2o-A5xmUWQDvjyj1x4ZDizHIp2axrD-GAayK6HtN2XCVbCV6yXSWZmG4z_kzU7oYUOq/s1600/cariprogram_clip_image006.jpg" imageanchor="1" style="background-color: white; margin-left: 1em; margin-right: 1em; text-decoration: none;"><span style="color: black; font-family: Arial, Helvetica, sans-serif;"><img border="0" height="179" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEis8qIX0Y85bnwWeRhFUJr0Srw4G3BtOuYtD7t4orSdrbAZdHHoKONZrg89KuN92WiQzx93jNzRJ2o-A5xmUWQDvjyj1x4ZDizHIp2axrD-GAayK6HtN2XCVbCV6yXSWZmG4z_kzU7oYUOq/s320/cariprogram_clip_image006.jpg" style="-webkit-box-shadow: rgba(0, 0, 0, 0.2) 0px 0px 0px; border-bottom-left-radius: 0px; border-bottom-right-radius: 0px; border-top-left-radius: 0px; border-top-right-radius: 0px; border: 1px solid rgb(255, 0, 255); box-shadow: rgba(0, 0, 0, 0.2) 0px 0px 0px; padding: 8px; position: relative;" width="320" /></span></a></div>
<span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;"><br />Setelah itu klik dua kali pada Button1 dan tambahkan kode program berikut ini :<br /><br /><br /> private void button1_Click(object sender, EventArgs e)<br /> {<br /> if (openFileDialog1.ShowDialog() == DialogResult.OK)<br /> {<br /> axShockwaveFlash1.Movie = openFileDialog1.FileName;<br /> axShockwaveFlash1.MovieData = openFileDialog1.FileName;<br /> axShockwaveFlash1.Play();<br /> }<br /> }<br /><br /><br />Kemudian jalankan projectnya, Klik tombol Open, pilih file Flash *.swf, maka Flash tersebut akan dimainkan di dalam Form.<br /></span></span><div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhLneQ6JDC7rs8Q7Hyje2S1aHRXyzwHwR_cXFZCx_UZrLYuS_b3GEIXHiNwmVYE5kXhoLw7-aJVhN9qGjX1z88ZSRFLWHIUTSIvW5O1mgEkqds0ceXyuYezIbllT6jYNhmUkvcFitiH-cvV/s1600/cariprogram_clip_image008.jpg" imageanchor="1" style="background-color: white; margin-left: 1em; margin-right: 1em; text-decoration: none;"><span style="color: black; font-family: Arial, Helvetica, sans-serif;"><img border="0" height="308" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhLneQ6JDC7rs8Q7Hyje2S1aHRXyzwHwR_cXFZCx_UZrLYuS_b3GEIXHiNwmVYE5kXhoLw7-aJVhN9qGjX1z88ZSRFLWHIUTSIvW5O1mgEkqds0ceXyuYezIbllT6jYNhmUkvcFitiH-cvV/s320/cariprogram_clip_image008.jpg" style="-webkit-box-shadow: rgba(0, 0, 0, 0.2) 0px 0px 0px; border-bottom-left-radius: 0px; border-bottom-right-radius: 0px; border-top-left-radius: 0px; border-top-right-radius: 0px; border: 1px solid rgb(255, 0, 255); box-shadow: rgba(0, 0, 0, 0.2) 0px 0px 0px; padding: 8px; position: relative;" width="320" /></span></a></div>
<span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;"><br /><br />Kode program selengkapnya dapat didownload di Google Docs, <a href="https://docs.google.com/open?id=0B4i1FYc_4RXzVm5pTXRsS0daZ0U" style="text-decoration: none;" target="_blank">disini</a>. Setelah muncul klik File - Download untuk mengunduh.</span></span></div>
<div class="post-body entry-content" id="post-body-2457612773468178708" itemprop="articleBody" style="line-height: 1.4; position: relative; width: 496.1514892578125px;">
<span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></span></div>
<div class="post-body entry-content" id="post-body-2457612773468178708" itemprop="articleBody" style="line-height: 1.4; position: relative; width: 496.1514892578125px;">
<span style="background-color: white;"><span style="font-family: Arial, Helvetica, sans-serif;">sumber : <a href="http://cariprogram.blogspot.com/2012/07/menampilkan-flash-player-pada-cnet.html" style="text-decoration: none;">http://cariprogram.blogspot.com/2012/07/menampilkan-flash-player-pada-cnet.html</a></span></span></div>
</div>
Anonymoushttp://www.blogger.com/profile/08729531800423570591noreply@blogger.com0tag:blogger.com,1999:blog-7468268993573312248.post-85293653913397939162012-10-28T07:22:00.004-07:002012-10-28T07:22:44.934-07:002. Random Number<br />
<h3 class="post-title entry-title" itemprop="name" style="font-family: 'Indie Flower'; font-size: 26px; margin: 0px; position: relative;">
<br /></h3>
<div class="post-header" style="font-family: 'Crafty Girls'; font-size: 12.727272033691406px; line-height: 1.6; margin: 0px 0px 1em;">
<div class="post-header-line-1">
</div>
</div>
<div class="post-body entry-content" id="post-body-7770498719663449754" itemprop="description articleBody" style="font-family: 'Crafty Girls'; font-size: 12.727272033691406px; line-height: 16.363636016845703px; position: relative; width: 496.1666564941406px;">
<span style="background-color: white;"><br /></span><div class="post-header" style="font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; line-height: 1.6; margin: 0px 0px 1em;">
<div class="post-header-line-1">
</div>
</div>
<div class="post-body entry-content" id="post-body-8864785894874595065" itemprop="description articleBody" style="font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; line-height: 18px; position: relative; width: 936px;">
<div style="text-align: justify;">
<span style="background-color: white; font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNormal" style="text-align: center;">
<div style="text-align: justify;">
<div style="text-align: center;">
<span style="background-color: white; font-family: Verdana, sans-serif;"><img src="http://i1251.photobucket.com/albums/hh555/FirmanFattah/Picture3-1.jpg?t=1329219353" style="-webkit-box-shadow: rgba(0, 0, 0, 0.2) 0px 0px 0px; border-bottom-left-radius: 0px; border-bottom-right-radius: 0px; border-top-left-radius: 0px; border-top-right-radius: 0px; border: 1px solid transparent; box-shadow: rgba(0, 0, 0, 0.2) 0px 0px 0px; padding: 8px;" /></span></div>
</div>
</div>
<div class="MsoNormal">
<div style="text-align: justify;">
<span style="background-color: white;"><a href="" name="more"></a><span style="font-family: Verdana, sans-serif;"><br /></span></span></div>
</div>
<div class="MsoNormal">
<div style="text-align: justify;">
<span style="background-color: white; font-family: Verdana, sans-serif;"> akan saya ubah menjadi seperti ini.<o:p></o:p></span></div>
</div>
<div class="MsoNormal">
<div style="text-align: justify;">
<span style="background-color: white; font-family: Verdana, sans-serif;"><br /></span></div>
</div>
<div class="MsoNormal" style="text-align: center;">
<div style="text-align: justify;">
<div style="text-align: center;">
<span style="background-color: white; font-family: Verdana, sans-serif;"><img src="http://i1251.photobucket.com/albums/hh555/FirmanFattah/Picture6.jpg?t=1329219353" style="-webkit-box-shadow: rgba(0, 0, 0, 0.2) 0px 0px 0px; border-bottom-left-radius: 0px; border-bottom-right-radius: 0px; border-top-left-radius: 0px; border-top-right-radius: 0px; border: 1px solid transparent; box-shadow: rgba(0, 0, 0, 0.2) 0px 0px 0px; padding: 8px;" /></span></div>
</div>
</div>
<div class="MsoNormal">
<div style="text-align: justify;">
<span style="background-color: white; font-family: Verdana, sans-serif;"><br /></span></div>
</div>
<div class="MsoNormal">
<div style="text-align: justify;">
<span style="background-color: white; font-family: Verdana, sans-serif;"><br /></span></div>
</div>
<div class="MsoNormal">
<div style="text-align: justify;">
<span style="background-color: white; font-family: Verdana, sans-serif;">Saya membuat sebuah array of string yang nantinya tiap data yang ada di index akan ditampilkan. Kemudian saya membuat sebuah objek dari class random. Setelah itu saya membuat sebuah variabel integer yang berguna untuk menyimpan angka yang diacak. Kemudian di dalam statement perulangan, variabel j di-assign dengan random.Next(0,9); yang berfungsi mengacak angka dari 0 hingga 9. Saya tekan F5 dan hasilnya akan seperti ini.<o:p></o:p></span></div>
</div>
<div class="MsoNormal">
<div style="text-align: justify;">
<span style="background-color: white; font-family: Verdana, sans-serif;"><br /></span></div>
</div>
<div class="MsoNormal" style="text-align: center;">
<div style="text-align: justify;">
<div style="text-align: center;">
<span style="background-color: white; font-family: Verdana, sans-serif;"><img height="320" src="http://i1251.photobucket.com/albums/hh555/FirmanFattah/Picture7.jpg?t=1329219353" style="-webkit-box-shadow: rgba(0, 0, 0, 0.2) 0px 0px 0px; border-bottom-left-radius: 0px; border-bottom-right-radius: 0px; border-top-left-radius: 0px; border-top-right-radius: 0px; border: 1px solid transparent; box-shadow: rgba(0, 0, 0, 0.2) 0px 0px 0px; padding: 8px;" width="640" /></span></div>
</div>
</div>
<div class="MsoNormal">
<div style="text-align: justify;">
<span style="background-color: white;"><br /></span></div>
</div>
<div class="MsoNormal">
<div style="text-align: justify;">
<span style="background-color: white; font-family: Verdana, sans-serif;"><br /></span></div>
</div>
<div class="MsoNormal">
<div style="text-align: justify;">
<span style="background-color: white; font-family: Verdana, sans-serif;">Sumber: <a href="http://students.netindonesia.net/blogs/firman/archive/2012/02/14/c-random.aspx" style="text-decoration: none;">http://students.netindonesia.net/blogs/firman/archive/2012/02/14/c-ran</a></span></div>
</div>
</div>
</div>
Anonymoushttp://www.blogger.com/profile/08729531800423570591noreply@blogger.com0tag:blogger.com,1999:blog-7468268993573312248.post-45188023779335312182012-10-28T07:20:00.000-07:002012-10-28T07:20:55.032-07:001.Menggerakan Object Dengan Tombol Keyboard<br />
<h3 class="post-title entry-title" itemprop="name" style="font-family: 'Indie Flower'; font-size: 26px; margin: 0px; position: relative;">
<br /></h3>
<div class="post-header" style="font-family: 'Crafty Girls'; font-size: 12.727272033691406px; line-height: 1.6; margin: 0px 0px 1em;">
<div class="post-header-line-1">
</div>
</div>
<div class="post-body entry-content" id="post-body-4680542865071918048" itemprop="description articleBody" style="font-family: 'Crafty Girls'; font-size: 12.727272033691406px; line-height: 16.363636016845703px; position: relative; width: 496.1666564941406px;">
<span style="background-color: white;"><span style="font-family: Verdana, sans-serif; font-size: 14px; line-height: 18px;">Masih tetep sama tema postingan sebelumnya, tentang tutorial menggunakan Macromedia Flash. Disini gue bukan masternya lho, gue hanya share apa yang gue pelajarin. Gimana sih cara biar objek bisa kita gerakan dengan keyboard? Oke, di post ini bakal gue bahas tuh</span><span style="font-family: Verdana, sans-serif; font-size: 14px; line-height: 18px;"> </span><b style="font-family: Verdana, sans-serif; font-size: 14px; line-height: 18px;">Cara Menggerakan Objek Dengan Keyboard</b><span style="font-family: Verdana, sans-serif; font-size: 14px; line-height: 18px;">.</span></span><br />
<div style="font-family: Verdana, Geneva, sans-serif; font-size: 14px; line-height: 18px;">
<span style="background-color: white;"><a href="http://www.blogger.com/blogger.g?blogID=7468268993573312248" name="more"></a><span style="font-family: Verdana, sans-serif;"><br /></span></span>
<div>
<span style="background-color: white; font-family: Verdana, sans-serif;">Biasanya kita liat digame-game flash itu karakter atau objek bisa bergerak kan? Mungkin ini dasar dari itu semua. Kita harus belajar segala sesuatunya dari dasarnya dulu, Asik dah <b>#RidwanQuote</b>! Hahaha. Gak usah lama-lama dengerin curhatan gue deh, mendingan langsung aja masuk ke tutornya. So, keep stay yoo~</span></div>
</div>
<div style="font-family: Verdana, Geneva, sans-serif; font-size: 14px; line-height: 18px;">
<span style="background-color: white;"><a href="http://dwiapriliawulandari.blogspot.com/2012/10/1menggerakan-object-dengan-tombol.html" name="more" style="text-decoration: none;"></a><b><u><span style="font-family: Verdana, sans-serif; font-size: small;">Step 1</span></u></b></span></div>
<div style="font-family: Verdana, Geneva, sans-serif; font-size: 14px; line-height: 18px;">
<span style="background-color: white; font-family: Verdana, sans-serif;">Yang pasti kalian buka dulu dah tuh Macromedia Flash-nya. Kalo udah, sekarang kalian buat objek. Bebas, kotak, bulet, segitiga, x -_- Muehehe. Dari gambar juga bisa.</span></div>
<div style="font-family: Verdana, Geneva, sans-serif; font-size: 14px; line-height: 18px; text-align: center;">
<span style="background-color: white; font-family: Verdana, sans-serif;"><br /></span></div>
<div class="separator" style="clear: both; font-family: Verdana, Geneva, sans-serif; font-size: 14px; line-height: 18px; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiJqxw1gPPXkH5Au9rOXqFxl4RWOiQZ5FXvkR-JW03LxRhh3fCGk3Jxo9DJa9H9Y4suU7HjLqzJGUhG8HwXWlbyC1FnwC9ToKvWxXBC4omyL0boqEla_-p2pAIoEnR6H2CTvrkYQ9YbNHQZ/s1600/Step+1.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em; text-decoration: none;"><span style="background-color: white; font-family: Verdana, sans-serif;"><span style="color: black;"><img border="0" height="220" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiJqxw1gPPXkH5Au9rOXqFxl4RWOiQZ5FXvkR-JW03LxRhh3fCGk3Jxo9DJa9H9Y4suU7HjLqzJGUhG8HwXWlbyC1FnwC9ToKvWxXBC4omyL0boqEla_-p2pAIoEnR6H2CTvrkYQ9YbNHQZ/s400/Step+1.jpg" style="-webkit-box-shadow: rgba(0, 0, 0, 0.2) 0px 0px 0px; border-bottom-left-radius: 0px; border-bottom-right-radius: 0px; border-top-left-radius: 0px; border-top-right-radius: 0px; border: none; box-shadow: rgba(0, 0, 0, 0.2) 0px 0px 0px; padding: 8px; position: relative;" width="400" /></span></span></a></div>
<div class="separator" style="clear: both; font-family: Verdana, Geneva, sans-serif; font-size: 14px; line-height: 18px; text-align: center;">
<span style="background-color: white; font-family: Verdana, sans-serif; font-size: xx-small;"><b>"Macromedia Flash | Cara Menggerakan Objek"</b></span></div>
<div class="separator" style="clear: both; font-family: Verdana, Geneva, sans-serif; font-size: 14px; line-height: 18px; text-align: center;">
<span style="background-color: white; font-family: Verdana, sans-serif;"><br /></span></div>
<div class="separator" style="clear: both; font-family: Verdana, Geneva, sans-serif; font-size: 14px; line-height: 18px;">
<span style="background-color: white; font-family: Verdana, sans-serif; font-size: small;"><b><u>Step 2</u></b></span></div>
<div class="separator" style="clear: both; font-family: Verdana, Geneva, sans-serif; font-size: 14px; line-height: 18px;">
<span style="background-color: white; font-family: Verdana, sans-serif;">Setelah objek kalian buat, select objek lalu tekan F8 untuk meng-convert ke simbol. Beda dengan post sebelumnya yang memilih<b>type Button</b>, kali ini kita pilih <b>type Movie clip</b>, next pilih OK.</span></div>
<span style="background-color: white;"><br style="font-family: Verdana, Geneva, sans-serif; font-size: 14px; line-height: 18px;" /></span>
<div class="separator" style="clear: both; font-family: Verdana, Geneva, sans-serif; font-size: 14px; line-height: 18px; text-align: center;">
<span style="background-color: white; font-family: Verdana, sans-serif; margin-left: 1em; margin-right: 1em;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjD_TVu5ot9QIGAHjHPAqHo6geUgCvgLNpMQUk8YBKBMlpTiMJT6srr2zzrlmFbQIP3Zu1vR3kRqBk74qXQf0jUaa1HBE8w4VG16oJPobfxyscYMSzd225HMfK2qSGKd0klCdCxe2e3ZIDG/s1600/Step+2.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em; text-decoration: none;"><img border="0" height="221" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjD_TVu5ot9QIGAHjHPAqHo6geUgCvgLNpMQUk8YBKBMlpTiMJT6srr2zzrlmFbQIP3Zu1vR3kRqBk74qXQf0jUaa1HBE8w4VG16oJPobfxyscYMSzd225HMfK2qSGKd0klCdCxe2e3ZIDG/s400/Step+2.jpg" style="-webkit-box-shadow: rgba(0, 0, 0, 0.2) 0px 0px 0px; border-bottom-left-radius: 0px; border-bottom-right-radius: 0px; border-top-left-radius: 0px; border-top-right-radius: 0px; border: none; box-shadow: rgba(0, 0, 0, 0.2) 0px 0px 0px; padding: 8px; position: relative;" width="400" /></a></span></div>
<div class="separator" style="clear: both; font-family: Verdana, Geneva, sans-serif; font-size: 14px; line-height: 18px; text-align: center;">
<b style="background-color: white; font-family: Verdana, sans-serif; font-size: small;">"Macromedia Flash | Cara Menggerakan Objek"</b></div>
<span style="background-color: white;"><br style="font-family: Verdana, Geneva, sans-serif; font-size: 14px; line-height: 18px;" /><span style="font-family: Verdana, sans-serif; font-size: small;"><b><u>Step 3</u></b></span><br style="font-family: Verdana, Geneva, sans-serif; font-size: 14px; line-height: 18px;" /><span style="font-family: Verdana, sans-serif; font-size: 14px; line-height: 18px;">Lanjut ke step berikutnya. Sekarang kita main sedikit di script-nya. Select objek trus teken F9 untuk masuk ke menu <b>Action</b>. Nah, disini kalian tulis script-nya.</span><br style="font-family: Verdana, Geneva, sans-serif; font-size: 14px; line-height: 18px;" /><span style="font-family: Verdana, sans-serif; font-size: 14px; line-height: 18px;"><br /></span></span><br />
<div class="separator" style="clear: both; font-family: Verdana, Geneva, sans-serif; font-size: 14px; line-height: 18px; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhCRVRbBUN2tRnTcGPKIncfOFECEkGlZybTw9FpHx2t5ObU7cA2ydiSBVE_Q55IzGOM6KDlyo8X-gLgEZBlTtqMOsFNwbagbBlaM_PT2LNdwnXpQyLK3joVtjgieVQU2oYTMg5J0K7watBz/s1600/Script.jpg" imageanchor="1" style="background-color: white; margin-left: 1em; margin-right: 1em; text-decoration: none;"><span style="color: black;"><img border="0" height="318" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhCRVRbBUN2tRnTcGPKIncfOFECEkGlZybTw9FpHx2t5ObU7cA2ydiSBVE_Q55IzGOM6KDlyo8X-gLgEZBlTtqMOsFNwbagbBlaM_PT2LNdwnXpQyLK3joVtjgieVQU2oYTMg5J0K7watBz/s400/Script.jpg" style="-webkit-box-shadow: rgba(0, 0, 0, 0.2) 0px 0px 0px; border-bottom-left-radius: 0px; border-bottom-right-radius: 0px; border-top-left-radius: 0px; border-top-right-radius: 0px; border: none; box-shadow: rgba(0, 0, 0, 0.2) 0px 0px 0px; padding: 8px; position: relative;" width="400" /></span></a></div>
<div style="font-family: Verdana, Geneva, sans-serif; font-size: 14px; line-height: 18px; text-align: center;">
<span style="background-color: white; font-family: Verdana, sans-serif;"><br /></span></div>
<div class="separator" style="clear: both; font-family: Verdana, Geneva, sans-serif; font-size: 14px; line-height: 18px; text-align: center;">
<span style="background-color: white; font-family: Verdana, sans-serif; margin-left: 1em; margin-right: 1em;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgL8C0JU0keejxEYMCVKEk1qNxVOFT7HMz5g2dTvp8pl6c4vrX2f3E5dySYv4xXikCkOdkybfRFmLl-NerBlcPjzabXJ6YHriKFGlXv7kecJO1zGWhNi9j_PnsU4a0NDIPDqRDAKIKAGtEh/s1600/Step+3.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em; text-decoration: none;"><img border="0" height="220" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgL8C0JU0keejxEYMCVKEk1qNxVOFT7HMz5g2dTvp8pl6c4vrX2f3E5dySYv4xXikCkOdkybfRFmLl-NerBlcPjzabXJ6YHriKFGlXv7kecJO1zGWhNi9j_PnsU4a0NDIPDqRDAKIKAGtEh/s400/Step+3.jpg" style="-webkit-box-shadow: rgba(0, 0, 0, 0.2) 0px 0px 0px; border-bottom-left-radius: 0px; border-bottom-right-radius: 0px; border-top-left-radius: 0px; border-top-right-radius: 0px; border: none; box-shadow: rgba(0, 0, 0, 0.2) 0px 0px 0px; padding: 8px; position: relative;" width="400" /></a></span></div>
<div class="separator" style="clear: both; font-family: Verdana, Geneva, sans-serif; font-size: 14px; line-height: 18px; text-align: center;">
<b style="background-color: white; font-family: Verdana, sans-serif; font-size: small;">"Macromedia Flash | Cara Menggerakan Objek"</b></div>
<span style="background-color: white;"><br style="font-family: Verdana, Geneva, sans-serif; font-size: 14px; line-height: 18px;" /><span style="font-family: Verdana, sans-serif; font-size: small;"><b><u>Step 4</u></b></span><br style="font-family: Verdana, Geneva, sans-serif; font-size: 14px; line-height: 18px;" /><span style="font-family: Verdana, sans-serif; font-size: 14px; line-height: 18px;">Pastiin kalo script yang kalian tulis itu sama kaya yang ada diatas yoo~ Kalo udah selesai nulis scriptsi-nya #halah! Gak pake "SI", cuma "SCRIPT" doang. Kalo udah selesai nulis script-nya itu artinya sudah jadi. Tekan CRTL + Enter untuk mencoba-nya. Monggo dicoba~</span><br style="font-family: Verdana, Geneva, sans-serif; font-size: 14px; line-height: 18px;" /><span style="font-family: Verdana, sans-serif; font-size: 14px; line-height: 18px;"><br /></span></span><br />
<div class="separator" style="clear: both; font-family: Verdana, Geneva, sans-serif; font-size: 14px; line-height: 18px; text-align: center;">
<span style="background-color: white; font-family: Verdana, sans-serif; margin-left: 1em; margin-right: 1em;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhtPcfRG-1Jp2N4uDpHRM6XQe5i9LMX8E_CbP-UJJm-nZJIsO67mBfTzPgVmkdTnORAw3YF-yNezD0jJoF02VGsC_JAecYKsYWxzC7uRF5aRMdmBEsHNWYrKBKi9G-PSyNSRbrJbSUIm6Tv/s1600/Step+4.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em; text-decoration: none;"><img border="0" height="221" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhtPcfRG-1Jp2N4uDpHRM6XQe5i9LMX8E_CbP-UJJm-nZJIsO67mBfTzPgVmkdTnORAw3YF-yNezD0jJoF02VGsC_JAecYKsYWxzC7uRF5aRMdmBEsHNWYrKBKi9G-PSyNSRbrJbSUIm6Tv/s400/Step+4.jpg" style="-webkit-box-shadow: rgba(0, 0, 0, 0.2) 0px 0px 0px; border-bottom-left-radius: 0px; border-bottom-right-radius: 0px; border-top-left-radius: 0px; border-top-right-radius: 0px; border: none; box-shadow: rgba(0, 0, 0, 0.2) 0px 0px 0px; padding: 8px; position: relative;" width="400" /></a></span></div>
<div class="separator" style="clear: both; font-family: Verdana, Geneva, sans-serif; font-size: 14px; line-height: 18px; text-align: center;">
<b style="background-color: white; font-family: Verdana, sans-serif; font-size: small;">"Macromedia Flash | Cara Menggerakan Objek"</b></div>
<div style="font-family: Verdana, Geneva, sans-serif; font-size: 14px; line-height: 18px; text-align: center;">
<span style="background-color: white; font-family: Verdana, sans-serif;"><br /></span></div>
<div style="font-family: Verdana, Geneva, sans-serif; font-size: 14px; line-height: 18px;">
<span style="background-color: white;"><span style="font-family: Verdana, sans-serif;">Sumber :</span><a href="http://www.oneeblog.com/2012/04/tutorial-macromedia-flash-cara.html" style="text-decoration: none;">http://www.oneeblog.com/2012/04/tutorial-macromedia-flash-cara.html</a></span></div>
</div>
Anonymoushttp://www.blogger.com/profile/08729531800423570591noreply@blogger.com1tag:blogger.com,1999:blog-7468268993573312248.post-871079975510722822012-10-04T01:44:00.001-07:002012-10-04T01:44:25.882-07:00Tugas Pemograman visual<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<b><span style="font-family: "Times New Roman","serif"; font-size: 18.0pt; mso-bidi-font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">1. Fungsi Tanggal dan Waktu di C#</span></b><span style="font-family: "Times New Roman","serif"; font-size: 18.0pt; mso-bidi-font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";"></span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">misal kita bikin fungsi ambil tanggal hari ini</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">private void button1_Click(object sender, EventArgs e)</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";"> {</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
DateTime tgl = DateTime.Now;</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
label1.Text = tgl.ToString();</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";"> }</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm; text-align: justify;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">Ketika method tersebut dijalankan biasanya secara default
akan menghasilkan “bulan/tgl/tahun jam:menit:detik AM/PM”.</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm; text-align: justify;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">Ada beberapa pilihan cara memparsing nilai dari variabel tgl
tadi</span></div>
<div class="MsoListParagraphCxSpFirst" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: 38.8pt; margin-right: 0cm; margin-top: 0cm; mso-add-space: auto; mso-list: l0 level1 lfo1; text-indent: -18.0pt;">
<span style="font-family: Symbol; font-size: 14.0pt; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font: 7.0pt "Times New Roman";">
</span></span></span><span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">ToLongDateString : Akan menghasilkan
tanggal dalam format <span style="mso-spacerun: yes;"> </span>longdate (panjang)</span></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: 38.8pt; margin-right: 0cm; margin-top: 0cm; mso-add-space: auto; mso-list: l0 level1 lfo1; text-indent: -18.0pt;">
<span style="font-family: Symbol; font-size: 14.0pt; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font: 7.0pt "Times New Roman";">
</span></span></span><span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">ToShortDateString : Akan
menghasilkan tanggal dalam format shortdate (pendek)</span></div>
<div class="MsoListParagraphCxSpLast" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: 38.8pt; margin-right: 0cm; margin-top: 0cm; mso-add-space: auto; mso-list: l0 level1 lfo1; text-indent: -18.0pt;">
<span style="font-family: Symbol; font-size: 14.0pt; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font: 7.0pt "Times New Roman";">
</span></span></span><span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">ToString(string format) : akan
menghasilkan tanggal sesuai dengan format yang kita inginkan.</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">Anggap saja method yang pertama tadi menghasilkan nilai
variabel tgl = 10/24/2008 2:48:19 PM. maka :</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";"> String tglshort = tgl.ToShortDateString(); //akan
menghasilkan "10/24/2008".</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";"> String tgllong = tgl.ToLongDateString(); //akan
menghasilkan "Friday, October 24, 2008".</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";"> String tglformat =
tgl.ToString("dd-MMM-yyyy"); //akan menghasilkan
"24-Oct-2008".</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">dimana dd = tanggal, MMM = bulan dalam format 3 huruf, yyyy
= tahun.</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">format ini bisa dirubah2 misal “dd/MM/yyyy” atau
“MM/dd/yyyy” atau “MMM dd, yyyy”, dll</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">Semua cara parsing diatas akan memberikan nilai kembalian
dengan tipe string.</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">Sumber: </span><span style="font-family: "Verdana","sans-serif";"><a href="http://bagbigbug.com/techno/merubah-format-tanggal-di-c">http://bagbigbug.com/techno/merubah-format-tanggal-di-c</a></span><br />
<br />
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<b><span style="font-family: "Times New Roman","serif"; font-size: 17.0pt; mso-bidi-font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">2. Fungsi string di C#</span></b><span style="font-family: "Times New Roman","serif"; font-size: 17.0pt; mso-bidi-font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";"></span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">String adalah suatu tipe data bentukan seperti halnya array,
bahakan string bisa disebut array of char, yaitu array dari tipe data char
(karakter), sehingga membentuk suatu tipe data baru yang bisa menyimpan susunan
huruf atau karekter lainnya.</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">view plainprint?</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">1. using System; </span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">2. namespace InputOutput </span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">3. { </span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">4. class
Program </span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">5. { </span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">6.
static void Main(string[] args) </span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">7. { </span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">8.
<span style="mso-spacerun: yes;"> </span>String nama = Console.ReadLine(); </span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">9.
Console.WriteLine("Nama Anda : " + nama); </span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">10.
} </span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">11.
} </span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">12.
} </span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">Jika kita compile program diatas akan meminta inputan dari
user dan menampilkannya di layar, output dari program diatas adalah :</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">view plainprint?</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">1. Nama Anda : Yohanda Mandala </span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm; text-align: justify;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">Selain itu kita juga bisa melakukan suatu rekayasa pada tipe
data string dengan menggunakan method methodnya, sebagai contoh adalah mencetak
suatu string secara terbalik seperti dalam contoh dibawah ini :</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm; text-align: justify;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">view plainprint?</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">1. using System; </span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">2.
</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">3. namespace String </span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">4. { </span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">5. class
Program </span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">6. { </span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">7. static
void Main(string[] args) </span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">8. {
</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">9.
string kata = "abcdefghi"; </span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">10.
char[] x = kata.ToCharArray(); </span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">11.
for (int i = kata.Length - 1; i >= 0; i--) </span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">12.
Console.Write(x[i]); </span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">13.
} </span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">14.
} </span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">15.
} </span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm; text-align: justify;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">Maka ketika kita compile yang keluar bukanlah string
"abcdefghij" akan tetapi justru sebaliknya yaitu
"jihgfedcba".</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm; text-align: justify;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">kata.Length() Adalah method yang digunakan untuk mendapatkan
panjang dari string tersebut. Didalam hal ini panjang dari string tersebut
adalah 10, untuk penghitungannya dimulai dari 0, sehingga karakter “a” pada
stringg tersebut berada pada indeks ke-0 dan karakter “j” berada pada indeks ke
“9”.</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm; text-align: justify;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">kata.ToCharArray() adalah method yang digunakan untuk merubah
string menjadi array of char.</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm; text-align: justify;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">Untuk melihat fungsi fungsi apa saja yang terdapat di string
pada C# bisa dilihat di dokumentasi dari C# di Visual Studio.</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">Sumber: <a href="http://yohandamandala.blogspot.com/2009/11/string-in-c.html">http://yohandamandala.blogspot.com/2009/11/string-in-c.html</a></span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14pt;"> </span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<b><span style="font-family: "Times New Roman","serif"; font-size: 18.0pt; mso-fareast-font-family: "Times New Roman";">3. Timer di C#</span></b><span style="font-family: "Times New Roman","serif"; font-size: 18.0pt; mso-fareast-font-family: "Times New Roman";"></span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm; text-align: justify;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">Tutorial kali ini adalah tutorial untuk membuat suatu jam
digital di C#, kita akan menggunakan jam local atau jam yang ada pada system.
untuk lebih jelasnya mari kita mulai membuat projectnya.</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm; text-align: justify;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">seperti biasa, siapkan project baru dengan cara klik file
pilih new project, untuk project name silahkan isi sesuai dengan keinginan,
karena tidak ada batasan dalam memberi nama pada suatu project kecuali
menggunakan karakter karakter yang memang dilarang digunakan dalam menamai
sebuah file, sekarang mari kita buat langsug projectnya</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm; text-align: justify;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">langkah pertama : tambahkan 3 komponen label pada form yang
telah disiapkan tadi, dan juga tambahkan komponen timer ke dalam form. atur dan
tata sedemikian rupa sehingga tampilannya seperti pada gambar dibawah ini</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm; text-align: justify;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">Gambar 1. Preview desain aplikasi</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm; text-align: justify;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">jika komponen timer ditambahkan kedalam form. tidak akan
terjadi perubahan, akan tetapi lihat pada bagian bawah. akan muncul icon jam.
itulah yang dinamakan dengan komponen timer</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm; text-align: justify;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm; text-align: justify;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">Langkha kedua : pada komponen timer yang telah ditambahkan
kedalam form, double klik untuk membangkitkan event timerTIck. setelah itu
tambahkan code berikut ini pada event yang muncul </span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm; text-align: justify;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
jamku = DateTime.Now;</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
label2.Text = jamku.Hour.ToString();</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
label1.Text = jamku.Minute.ToString(); </span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
label3.Text = jamku.Second.ToString(); </span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">langkah ketiga : pada event onLoad tambahkan source code
berikut ini.</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
jamku = DateTime.Now;</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
timer1.Enabled = true;</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">dan jangan lupa untuk mendeklatasikan variable global
DateTime jamku</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">langkah keempat : Done. program selesai dibut, jika langkah
langkah diatas dilakukan dengan benar maka, saat program dirunning tampilannya
akan seperti gambar dibawah ini</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">Gambar 2. Hasil running program</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">Untuk lebih memudahkan dalam memahami tutorial ini. </span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">download binary filenya disini, </span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">dan juga download full projectnya disini.</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">Sumber: <a href="http://www.csharp-indonesia.com/2011/01/membuat-jam-digital-di-c-c-sharp.html">http://www.csharp-indonesia.com/2011/01/membuat-jam-digital-di-c-c-sharp.html</a></span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14pt;"> </span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<b><span style="font-family: "Times New Roman","serif"; font-size: 18.0pt; mso-fareast-font-family: "Times New Roman";">4. Menampilkan Gambar di C#</span></b><span style="font-family: "Times New Roman","serif"; font-size: 18.0pt; mso-fareast-font-family: "Times New Roman";"></span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">Menampilkan atau mengambil gambar dengan C# pada database
yang support SqlClient yaitu SQL Server :</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">private void dataGridView1_CellClick(object sender,
DataGridViewCellEventArgs e)</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";"> {</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
textIdPerabot.Text = dataGridView1.CurrentRow.Cells[0].Value.ToString();</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
comboModel.Text = dataGridView1.CurrentRow.Cells[1].Value.ToString();</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
comboKategori.Text = dataGridView1.CurrentRow.Cells[2].Value.ToString();</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
textNmaPerabot.Text = dataGridView1.CurrentRow.Cells[3].Value.ToString();</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
textHarga.Text = dataGridView1.CurrentRow.Cells[4].Value.ToString();</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
Byte[] byteBLOBData = new Byte[0];</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
byteBLOBData = (Byte[])(dataGridView1.CurrentRow.Cells[5].Value);</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
MemoryStream stmBLOBData = new MemoryStream(byteBLOBData);</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
pictureBox1.Image = Image.FromStream(stmBLOBData);</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";"> }</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">Menyimpan gambar dengan VB.NET pada database yang support
ODBC misal MySQL :</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";"> Private Sub BtnUpdatePic_Click(ByVal
sender As System.Object, ByVal e As System.EventArgs) Handles
BtnUpdatePic.Click</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";"> Dim tpic As
Byte() = System.IO.File.ReadAllBytes(txtFile.Text)</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";"> Dim con As New
OdbcConnection</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
con.ConnectionString = "driver={mysql odbc 3.51
driver};server=localhost;database=karyawan;uid=root;password= ;"</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";"> con.Open()</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";"> Dim cmd As New
OdbcCommand</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";"> cmd.Connection =
con</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";"> cmd.CommandType =
CommandType.Text</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";"> 'PARAMETER HARUS
PAKAI TANDA TANYA ? KHUSUS UNTUK ODBC</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";"> cmd.CommandText =
"UPDATE peserta SET gambar = ? WHERE idpeserta = '102' "
',@total)"</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";"> </span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
cmd.ExecuteNonQuery()</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";"> </span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";"> cmd.Dispose()</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";"> con.Close()</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";"> End Sub</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">Menampilkan atau mengambil gambar dengan VB.NET pada
database yang support ODBC misal MySQL :</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";"> Private Sub BtnViewPictMysql_Click(ByVal
sender As System.Object, ByVal e As System.EventArgs) Handles
BtnViewPictMysql.Click</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";"> Dim fstream As
New IO.FileStream(IO.Path.GetDirectoryName(Application.ExecutablePath) &
"\tmp.dat", IO.FileMode.Create)</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
'fstream.Write(bs.Item(bs.Position)(4), 0,
System.Buffer.ByteLength(bs.Item(bs.Position)(4)))</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
'fstream.Write(dgv1.Rows(0).Cells("gambar").Value, 0,
System.Buffer.ByteLength(dgv1.Rows(0).Cells("gambar").Value))</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
fstream.Write(dgv1.SelectedRows(0).Cells("gambar").Value, 0,
System.Buffer.ByteLength(dgv1.SelectedRows(0).Cells("gambar").Value))</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";"> PicFoto.Image =
Image.FromStream(fstream)</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";"> 'PicFoto.SizeMode
= PictureBoxSizeMode.Zoom</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";"> fstream.Close()</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";"> End Sub</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">Cara lain menyimpan gambar binary ke database dengan C#.NET
:</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
con.open</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
string query = "update Jenis_Penyakit set gambar=@gambar where
NAMA_PENYAKIT = '" +
dgGambarPenyakit.Rows[dgGambarPenyakit.SelectedRows[0].Index].Cells[1].Value.ToString()
+ "'";</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
if (myconn.State.ToString() != "Open")</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
myconn.Open();</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
SqlCommand cmd = new SqlCommand(query, myconn);</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
cmd.Parameters.Add("@gambar", SqlDbType.Image, 0 , "");</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
cmd.Parameters[0].Value = tpic;</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
cmd.ExecuteNonQuery();</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">Cara lain mengambil/menampilkan gambar binary dari database
dengan C#.NET : </span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";"> private void
dgGambarPenyakit_Click(object sender, EventArgs e)</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";"> {</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
myconn = koneksi.CON;</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
SqlCommand cmdSelect = new SqlCommand("SELECT GAMBAR FROM JENIS_PENYAKIT
WHERE NAMA_PENYAKIT = '" +
dgGambarPenyakit.Rows[dgGambarPenyakit.SelectedRows[0].Index].Cells[1].Value.ToString()
+ "'", this.myconn);</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
myconn.Open();</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
byte[] barrImg = (byte[])cmdSelect.ExecuteScalar();</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
if (barrImg != null)</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
{</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
string strfn = Convert.ToString(DateTime.Now.ToFileTime());</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
FileStream fs = new FileStream(strfn,</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
FileMode.CreateNew,
FileAccess.Write);</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
fs.Write(barrImg, 0, barrImg.Length);</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
fs.Flush();</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
fs.Close();</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
this.myconn.Close();</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
picPenyakit.Image = Image.FromFile(strfn);</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
}</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
else</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
{</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
picPenyakit.Image = null;</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
}</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";"> }</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">Cara lain menyimpan gambar binary ke database dengan VB.NET
: </span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">tpic = File.ReadAllBytes(oSketsa.FileName)</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";"> If
(tpic.GetType.ToString() <> "System.Object") Then</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
da.UpdateCommand.Parameters("@Sketsa").Value = tpic</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";"> End If</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
'cm.Parameters.Add("@Sketsa", OdbcType.VarChar, 0,
"").Value = pathCAD</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";"> cm.ExecuteNonQuery()</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";"> cn.Close()</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">Cara lain mengambil/menampilkan gambar binary dari database
dengan VB.NET : </span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">If (bs.Item(bs.Position)(4).GetType.ToString() <>
"System.DBNull") Then</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
Dim fstream As New FileStream(Path.GetDirectoryName(Application.ExecutablePath)
& "\sket.dat", FileMode.Create)</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
fstream.Write(bs.Item(bs.Position)(4), 0,
System.Buffer.ByteLength(bs.Item(bs.Position)(4)))</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
pSketsa.Image = Image.FromStream(fstream)</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
pSketsa.SizeMode = PictureBoxSizeMode.Zoom</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
fstream.Close()</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
Else</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
pSketsa.Image = Nothing</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
End If</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";"> </span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">Menyimpan Gambar di Database MySQL dengan MySQLOledb</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">Public Function SiswaInsert(ByVal Siswa As Siswa) As
MySqlDataReader</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
Try</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
Dim ms As MemoryStream = New MemoryStream()</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
Siswa.Foto.Save(ms, System.Drawing.Imaging.ImageFormat.Jpeg)</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
Dim Pic_arr(ms.Length) As Byte</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
ms.Position = 0</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
ms.Read(Pic_arr, 0, Pic_arr.Length)</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
Dim StrSQL As String = "INSERT INTO siswa" & _</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
"
(Nis,Kelas_ID,Tahun_ID,Nama,Kota_lahir,Tanggal_lahir,Gender,Agama,Alamat,Telepon,Terima_dkelas,Tgl_terima,Id_ThnAjaran,Sekolah_asal,Anak_ke,Status_anak,Nama_Ayah,Nama_Ibu,Pekerjaan_Ayah,Pekerjaan_Ibu,Penghasilan_Ortu,Alamat_Ortu,Telp_Ortu,Foto_Siswa)
"
& _</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
"
VALUES
(@Nis,@Kelas_ID,@Tahun_ID,@Nama,@Kota_lahir,@Tanggal_lahir,@Gender,@Agama,@Alamat,@Telepon,@Terima_dkelas,@Tgl_terima,@Id_ThnAjaran,@Sekolah_asal,@Anak_ke,@Status_anak,@Nama_Ayah,@Nama_Ibu,@Pekerjaan_Ayah,@Pekerjaan_Ibu,@Penghasilan_Ortu,@Alamat_Ortu,@Telp_Ortu,@Foto_Siswa);"</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
Dim myCommand As MySqlCommand = New MySqlCommand(StrSQL, myconnection.open)</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
myCommand.CommandType = CommandType.Text</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
Dim parameterS_Nis As MySqlParameter = New MySqlParameter("@Nis",
MySqlDbType.VarChar, 4)</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
parameterS_Nis.Value = Siswa.Nis</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
Dim parameterS_Kelas As MySqlParameter = New
MySqlParameter("@Kelas_ID", MySqlDbType.Int16)</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
parameterS_Kelas.Value = Siswa.Kelas</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
Dim parameterS_Angkatan As MySqlParameter = New
MySqlParameter("@Tahun_ID", MySqlDbType.Int16)</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
parameterS_Angkatan.Value = Siswa.Angkatan</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
Dim parameterS_Nama As MySqlParameter = New MySqlParameter("@Nama",
MySqlDbType.VarChar, 50)</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
parameterS_Nama.Value = Siswa.Nama</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
Dim parameterS_KotaLahir As MySqlParameter = New
MySqlParameter("@Kota_lahir", MySqlDbType.VarChar, 30)</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
parameterS_KotaLahir.Value = Siswa.KotaLahir</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
Dim parameterS_TglLahir As MySqlParameter = New
MySqlParameter("@Tanggal_lahir", MySqlDbType.Date)</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
parameterS_TglLahir.Value = Siswa.TglLahir</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
Dim parameterS_Kelamin As MySqlParameter = New
MySqlParameter("@Gender", MySqlDbType.VarChar, 1)</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
parameterS_Kelamin.Value = Siswa.Kelamin</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
Dim parameterS_Agama As MySqlParameter = New
MySqlParameter("@Agama", MySqlDbType.VarChar, 10)</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
parameterS_Agama.Value = Siswa.Agama</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
Dim parameterS_Alamat As MySqlParameter = New
MySqlParameter("@Alamat", MySqlDbType.VarChar, 100)</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
parameterS_Alamat.Value = Siswa.Alamat</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
Dim parameterS_Telepon As MySqlParameter = New
MySqlParameter("@Telepon", MySqlDbType.VarChar, 15)</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
parameterS_Telepon.Value = Siswa.Telepon</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
Dim parameterS_TerimadKelas As MySqlParameter = New
MySqlParameter("@Terima_dkelas", MySqlDbType.VarChar, 30)</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
parameterS_TerimadKelas.Value = Siswa.TerimadKelas</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
Dim parameterS_TglTerima As MySqlParameter = New
MySqlParameter("@Tgl_terima", MySqlDbType.Date)</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
parameterS_TglTerima.Value = Siswa.TglTerima</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
Dim parameterS_ThnAjaran As MySqlParameter = New
MySqlParameter("@Id_ThnAjaran", MySqlDbType.Int16)</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
parameterS_ThnAjaran.Value = Siswa.ThnAjaran</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
Dim parameterS_AsalSekolah As MySqlParameter = New
MySqlParameter("@Sekolah_asal", MySqlDbType.VarChar, 30)</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
parameterS_AsalSekolah.Value = Siswa.AslSekolah</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
Dim parameterS_AnakKe As MySqlParameter = New
MySqlParameter("@Anak_ke", MySqlDbType.VarChar, 30)</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
parameterS_AnakKe.Value = Siswa.AnakKe</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
Dim parameterS_StatusAnak As MySqlParameter = New
MySqlParameter("@Status_anak", MySqlDbType.VarChar, 30)</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
parameterS_StatusAnak.Value = Siswa.StatusAnak</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
Dim parameterS_NamaAyah As MySqlParameter = New MySqlParameter("@Nama_Ayah",
MySqlDbType.VarChar, 50)</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
parameterS_NamaAyah.Value = Siswa.NamaAyah</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
Dim parameterS_NamaIbu As MySqlParameter = New
MySqlParameter("@Nama_Ibu", MySqlDbType.VarChar, 50)</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
parameterS_NamaIbu.Value = Siswa.NamaIbu</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
Dim parameterS_KerjaAyah As MySqlParameter = New
MySqlParameter("@Pekerjaan_Ayah", MySqlDbType.VarChar, 30)</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
parameterS_KerjaAyah.Value = Siswa.KerjaAyah</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
Dim parameterS_KerjaIbu As MySqlParameter = New
MySqlParameter("@Pekerjaan_Ibu", MySqlDbType.VarChar, 30)</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
parameterS_KerjaIbu.Value = Siswa.KerjaIbu</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
Dim parameterS_HasilOrtu As MySqlParameter = New MySqlParameter("@Penghasilan_Ortu",
MySqlDbType.VarChar, 100)</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
parameterS_HasilOrtu.Value = Siswa.PenghaslianOrtu</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
Dim parameterS_AlamatOrtu As MySqlParameter = New
MySqlParameter("@Alamat_Ortu", MySqlDbType.VarChar, 100)</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
parameterS_AlamatOrtu.Value = Siswa.AlamatOrtu</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
Dim parameterS_TelpOrtu As MySqlParameter = New
MySqlParameter("@Telp_Ortu", MySqlDbType.VarChar, 15)</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
parameterS_TelpOrtu.Value = Siswa.TelponOrtu</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
Dim parameterS_Foto As MySqlParameter = New
MySqlParameter("@Foto_Siswa", MySqlDbType.Blob)</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
parameterS_Foto.Value = Pic_arr</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
With myCommand.Parameters</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
.Add(parameterS_Nis)</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
.Add(parameterS_Kelas)</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
.Add(parameterS_Angkatan)</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
.Add(parameterS_Nama)</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
.Add(parameterS_KotaLahir)</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
.Add(parameterS_TglLahir)</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
.Add(parameterS_Kelamin)</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
.Add(parameterS_Agama)</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
.Add(parameterS_Alamat)</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
.Add(parameterS_Telepon)</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
.Add(parameterS_TerimadKelas)</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
.Add(parameterS_TglTerima)</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
.Add(parameterS_ThnAjaran)</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
.Add(parameterS_AsalSekolah)</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
.Add(parameterS_AnakKe)</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
.Add(parameterS_StatusAnak)</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
.Add(parameterS_NamaAyah)</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
.Add(parameterS_NamaIbu)</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
.Add(parameterS_KerjaAyah)</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
.Add(parameterS_KerjaIbu)</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
.Add(parameterS_HasilOrtu)</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
.Add(parameterS_AlamatOrtu)</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
.Add(parameterS_TelpOrtu)</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
.Add(parameterS_Foto)</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
End With</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
Dim result As MySqlDataReader =
myCommand.ExecuteReader(CommandBehavior.CloseConnection)</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
Return result</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
Catch SqlEx As MySqlException</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
Throw New Exception(SqlEx.Message.ToString())</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
End Try</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";"> End Function</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">Mengambil Gambar dari MySQL dengan MySQLOledb</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">Dim objDataTable As New DataTable</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";"> Private Sub btnOk_Click(ByVal sender As
System.Object, ByVal e As System.EventArgs) Handles btnOk.Click</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";"> Try</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
Dim DataControl As New AccessData.DataControl</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
Dim myData As DataSet = DataControl.GetDataSet("Select * from siswa where
nis = '" & txtNis.Text & "'")</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
objDataTable = myData.Tables("data")</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
If objDataTable.Rows.Count > 0 Then</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
AddSiswa.Show()</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
AddSiswa.txtNis.Text = objDataTable.Rows(0)("nis").ToString</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
AddSiswa.txtNama.Text =
objDataTable.Rows(0)("nama").ToString</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
Dim stmBLOBData As MemoryStream = New MemoryStream()</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
stmBLOBData.Write(objDataTable.Rows(0)("Foto_Siswa"), 0,
System.Buffer.ByteLength(objDataTable.Rows(0)("Foto_Siswa")))</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
AddSiswa.PictureBox1.Image = Image.FromStream(stmBLOBData)</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
Else</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
MsgBox("Data Tidak Ditemukan")</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
End If</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";"> Catch ex As
Exception</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
MsgBox(ex.Message)</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";"> End Try</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";"> End Sub</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">Sumber: <a href="http://cariprogram.blogspot.com/2012/05/menyimpan-dan-mengambil-gambar-binary.html">http://cariprogram.blogspot.com/2012/05/menyimpan-dan-mengambil-gambar-binary.html</a></span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14pt;"> </span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<b><span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">5. Membaca File Teks dan Menampilkan Isinya</span></b><span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";"></span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
</div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">Saya akan mencoba menunjukkan kepada anda bagaimana
mangambil informasi dari sebuah file text (.txt) dan kemudian menggunakan
ArrayList untuk menampilkan informasi tersebut ke user. Berikut
langkah-langkahnya:</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">1.
Buka Microsoft Visual Studio 2010.</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">2.
Buat project baru di Console Application in Visual C#.</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">3.
Tambahkan project references System.IO , System.Collections .</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">4.
Tambahkan code berikut didalam Main</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">static void Main(string[] args)</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";"> {</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
//Membuka sebuah file test.txt di E</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
StreamReader objReader = new StreamReader("E:\\test.txt");</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
//buat sebuah variabel string karena nilainya akan dimasukkan ke dalam
ArrayList</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
string sLine = "";</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
ArrayList arrText = new ArrayList();</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
while (sLine != null)</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
{</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
sLine = objReader.ReadLine();</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
if (sLine != null)</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
arrText.Add(sLine);</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
}</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
objReader.Close();</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
//menampilkan isi ArrayList ke layar</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
foreach (string sOutput in arrText)</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
Console.WriteLine(sOutput);</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">
Console.ReadLine();</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";"> }</span></div>
<div class="MsoNormal" style="line-height: normal; margin-top: 0cm;">
<a href="http://www.blogger.com/goog_93666217"><span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; mso-fareast-font-family: "Times New Roman";">http://ahmadta09.student.ipb.ac.id/2012/01/26/membaca-file-text-di-c/</span></a></div>
<div class="MsoNormal">
<a href="http://umihanifah33.blogspot.com/"><span style="font-family: "Times New Roman","serif"; font-size: 14.0pt; line-height: 150%;">http://umihanifah33.blogspot.com</span></a></div>
<span style="font-family: "Times New Roman","serif"; font-size: 14pt;"> </span></div>
<span style="font-family: "Times New Roman","serif"; font-size: 14pt;"> </span></div>
<span style="font-family: "Times New Roman","serif"; font-size: 14pt;"> </span></div>
Anonymoushttp://www.blogger.com/profile/08729531800423570591noreply@blogger.com0tag:blogger.com,1999:blog-7468268993573312248.post-900618122715500232012-09-29T02:47:00.002-07:002012-09-29T02:47:21.865-07:00Membuat Fungsi Terbilang Microsoft Excel 2007<h2>
Membuat Fungsi Terbilang Microsoft Excel 2007</h2>
<div style="text-align: center;">
<a href="http://elhaidar.files.wordpress.com/2011/01/13.jpg"><img alt="" class="aligncenter size-full wp-image-477" src="http://elhaidar.files.wordpress.com/2011/01/13.jpg?w=500" title="1" /></a></div>
<div style="text-align: justify;">
Fungsi terbilang disini adalah fungsi untuk mengkonversi angka menjadi terbilang. Contoh angka <strong>2500</strong> akan dikonversi menjadi <strong>dua ribu lima ratus, </strong>fungsi ini banyak digunakan untuk membuat faktur, nota atau kwitansi.</div>
<span id="more-475"></span><br />
Untuk membuat fungsi ini di Microsoft Excel caranya sebagai berikut:<br />
<ul>
<li style="text-align: justify;">Buat document baru, atau buka document
yang sudah ada dan ingin diberi fungsi terbilang ini. Kemudian buka
Microsoft Visual Basic Editor dari menu <strong>Tools > Macro > Visual Basic Editor </strong>untuk office 2003 atau langsung tekan tombol <strong>Alt + F11 </strong>untuk office 2007.</li>
<li style="text-align: justify;">Buat sebuah module baru dengan cara klik menu <strong>Insert > Module </strong>kemudian tambahkan script berikut. :</li>
</ul>
<pre style="padding-left: 60px;"><strong>Function Terbilang(n As Long) As String 'max 2.147.483.647</strong>
<strong>Dim satuan As Variant, Minus As Boolean</strong>
<strong>On Error GoTo terbilang_error</strong>
<strong>satuan = Array("", "Satu", "Dua", "Tiga", "Empat", "Lima", "Enam", "Tujuh", "Delapan", "Sembilan", "Sepuluh", "Sebelas")</strong>
<strong>If n < 0 Then</strong>
<strong>Minus = True</strong>
<strong>n = n * -1</strong>
<strong>End If</strong>
<strong>Select Case n</strong>
<strong>Case 0 To 11</strong>
<strong>Terbilang = " " + satuan(Fix(n))</strong>
<strong>Case 12 To 19</strong>
<strong>Terbilang = Terbilang(n Mod 10) + " Belas"</strong>
<strong>Case 20 To 99</strong>
<strong>Terbilang = Terbilang(Fix(n / 10)) + " Puluh" + Terbilang(n Mod 10)</strong>
<strong>Case 100 To 199</strong>
<strong>Terbilang = " Seratus" + Terbilang(n - 100)</strong>
<strong>Case 200 To 999</strong>
<strong>Terbilang = Terbilang(Fix(n / 100)) + " Ratus" + Terbilang(n Mod 100)</strong>
<strong>Case 1000 To 1999</strong>
<strong>Terbilang = " Seribu" + Terbilang(n - 1000)</strong>
<strong>Case 2000 To 999999</strong>
<strong>Terbilang = Terbilang(Fix(n / 1000)) + " Ribu" + Terbilang(n Mod 1000)</strong>
<strong>Case 1000000 To 999999999</strong>
<strong>Terbilang = Terbilang(Fix(n / 1000000)) + " Juta" + Terbilang(n Mod 1000000)</strong>
<strong>Case Else</strong>
<strong>Terbilang = Terbilang(Fix(n / 1000000000)) + " Milyar" + Terbilang(n Mod 1000000000)</strong>
<strong>End Select</strong>
<strong>If Minus = True Then</strong>
<strong>Terbilang = "Minus" + Terbilang</strong>
<strong>End If</strong>
<strong>Exit Function</strong>
<strong>terbilang_error:</strong>
<strong>MsgBox Err.Description, vbCritical, "^_^Terbilang Error"</strong>
<strong>End Function</strong></pre>
<pre style="padding-left: 60px;"><strong>
</strong></pre>
<pre style="padding-left: 60px;"><strong>
</strong></pre>
<ul>
<li style="text-align: justify;">Tutup kembali Visual Basis Editor dan
kembali ke lembar kerja excel, coba ketikkan angka sembarang di
sembarang tempat. Misal di cell <strong>C5</strong> ketikkan<strong>1250200 </strong>(nb: Maksimal 2147483647)</li>
<li style="text-align: justify;">Kemudia di cell yang yang lain / tempat menaruh hasil terbilang ketikkan formula<strong>=terbilang(C5)</strong></li>
<li style="text-align: justify;">Kemudian di cell tersebut akan muncul hasil terbilang yaitu satu juta dua ratus lima puluh ribu dua ratus<strong><br />
</strong></li>
</ul>
<div style="text-align: center;">
<a href="http://elhaidar.files.wordpress.com/2011/01/terbilang3.png"><img alt="" class="aligncenter size-full wp-image-480" src="http://elhaidar.files.wordpress.com/2011/01/terbilang3.png?w=500" title="TERBILANG" /></a></div>
<ul>
<li style="text-align: justify;">Jika ingin di belakang hasil terbilang ada kata Rupiah tambahkan di dalam formula<strong>=terbilang(C5) & “Rupiah”</strong></li>
<li style="text-align: justify;"><strong>Sumber: <a href="http://elhaidar.wordpress.com/2011/01/07/membuat-fungsi-terbilang-microsoft-excel-2007/">http://elhaidar.wordpress.com/2011/01/07/membuat-fungsi-terbilang-microsoft-excel-2007/</a></strong></li>
<li style="text-align: justify;"><strong> </strong></li>
</ul>
Anonymoushttp://www.blogger.com/profile/08729531800423570591noreply@blogger.com0tag:blogger.com,1999:blog-7468268993573312248.post-47989146900977811502012-09-22T08:12:00.001-07:002012-09-29T02:56:16.525-07:00CARA MENYISIPKAN FOOTNOTE DAN ENDNOTE<div style="text-align: justify;">
<span class="Apple-style-span" style="line-height: 18px;"><span class="Apple-style-span" style="font-family: 'Trebuchet MS', sans-serif;">Langkah membuat Footnote :</span></span></div>
<span class="Apple-style-span" style="line-height: 18px;"><span class="Apple-style-span" style="color: #222222; line-height: 20px;"></span></span><br />
<ol style="text-align: justify;">
<li><span class="Apple-style-span" style="font-family: 'Trebuchet MS', sans-serif;">Letakkan kursor pada akhir kata atau kalimat yang akan diberi footnote.</span></li>
<li><span class="Apple-style-span" style="font-family: 'Trebuchet MS', sans-serif;">Klik References kemudian klik Insert Footnote<br />
<br />
<img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiqfPrkdzuC1gP6d2-Mt3dEhKgvfJLAawPPW6H4pCW4-DqxnT7uvznDRft_YfGkiasW9IByWKjbbDpzj02yiaWkOdfB8oFubaCoSi-KJA8Wq78DeLR1-ZaR3HyZgN4QQRqgBpnZKF3BKPoc/s980/insert-footnote.png" style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; background-position: initial initial; background-repeat: initial initial; border-bottom-color: rgb(204, 204, 204); border-bottom-style: none; border-bottom-width: 1px; border-color: initial; border-left-color: rgb(204, 204, 204); border-left-style: none; border-left-width: 1px; border-right-color: rgb(204, 204, 204); border-right-style: none; border-right-width: 1px; border-top-color: rgb(204, 204, 204); border-top-style: none; border-top-width: 1px; border-width: initial; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px;" title="http://ketikankomputer.blogspot.com" /> </span></li>
<li><span class="Apple-style-span" style="font-family: 'Trebuchet MS', sans-serif;">Ketikkan catatan atau isi dari footnote tersebut.</span></li>
<li><span class="Apple-style-span" style="font-family: 'Trebuchet MS', sans-serif;">Maka
dibelakang kata atau kalimat yang diberi footnote akan muncul angka
kecil, dan dibagian bawah halaman terdapat angka dan keterangan yang
telah anda berikan.</span></li>
<li><span class="Apple-style-span" style="font-family: 'Trebuchet MS', sans-serif;">Jika pointer diarahkan pada angka footnote, maka akan muncul keterangan atau isi footnote tersebut. </span></li>
<li><span class="Apple-style-span" style="font-family: 'Trebuchet MS', sans-serif;">Lakukan
hal yang sama untuk membuat footnote selanjutnya, dan secara otomatis
nomor footnote juga akan berubah sesuai dengan urutan. </span></li>
</ol>
<div style="text-align: justify;">
<span class="Apple-style-span" style="font-family: 'Trebuchet MS', sans-serif;"><br />
</span></div>
<div style="text-align: justify;">
<span class="Apple-style-span" style="font-family: 'Trebuchet MS', sans-serif;">Langkah membuat Endnote (kurang lebih sama dengan Footnote):</span></div>
<ol style="text-align: justify;">
<li><span class="Apple-style-span" style="font-family: 'Trebuchet MS', sans-serif;">Letakkan kursor pada akhir kata atau kalimat yang akan diberi Endnote.</span></li>
<li><span class="Apple-style-span" style="font-family: 'Trebuchet MS', sans-serif;">Klik References kemudian klik Insert Endnote<br />
<br />
<img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiqfPrkdzuC1gP6d2-Mt3dEhKgvfJLAawPPW6H4pCW4-DqxnT7uvznDRft_YfGkiasW9IByWKjbbDpzj02yiaWkOdfB8oFubaCoSi-KJA8Wq78DeLR1-ZaR3HyZgN4QQRqgBpnZKF3BKPoc/s980/insert-footnote.png" style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; background-position: initial initial; background-repeat: initial initial; border-bottom-color: rgb(204, 204, 204); border-bottom-style: none; border-bottom-width: 1px; border-color: initial; border-left-color: rgb(204, 204, 204); border-left-style: none; border-left-width: 1px; border-right-color: rgb(204, 204, 204); border-right-style: none; border-right-width: 1px; border-top-color: rgb(204, 204, 204); border-top-style: none; border-top-width: 1px; border-width: initial; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px;" title="http://ketikankomputer.blogspot.com" /> </span></li>
<li><span class="Apple-style-span" style="font-family: 'Trebuchet MS', sans-serif;">Ketikkan catatan atau isi dari endnote tersebut.</span></li>
<li><span class="Apple-style-span" style="font-family: 'Trebuchet MS', sans-serif;">Maka
dibelakang kata atau kalimat yang diberi endnote akan muncul angka
kecil, dan dibagian akhir halaman terdapat angka dan keterangan yang
telah anda berikan.</span></li>
<li><span class="Apple-style-span" style="font-family: 'Trebuchet MS', sans-serif;">Jika pointer diarahkan pada angka endnote, maka akan muncul keterangan atau isi endnote tersebut. </span></li>
<li><span class="Apple-style-span" style="font-family: 'Trebuchet MS',sans-serif;">Lakukan
hal yang sama untuk membuat endnote selanjutnya, dan secara otomatis
nomor endnote juga akan berubah sesuai dengan urutan. Sumber :<a href="http://koleksi-stmikbjb.blogspot.com/2012/04/cara-membuat-footnote-dan-endnote-pada.html">http://koleksi-stmikbjb.blogspot.com/2012/04/cara-membuat-footnote-dan-endnote-pada.html</a> </span></li>
</ol>
Anonymoushttp://www.blogger.com/profile/08729531800423570591noreply@blogger.com1tag:blogger.com,1999:blog-7468268993573312248.post-88955025992861739532012-09-22T07:11:00.002-07:002012-09-29T02:59:54.633-07:00Cara menambahkan tanggal pada header atau footer di ms word 2007<h3 class="post-title entry-title">
</h3>
<div style="text-align: justify;">
</div>
<div style="text-align: justify;">
Sebagaimana telah kita ketahui bahwa informasi yang ada di header maupun
di footer akan selalu tampil pada setiap halaman khususnya pada section
yang sama. Untuk menampilkan tanggal maupun keterangan lain yang
berbeda pada beberapa halaman, maka anda harus membuat beberapa section
untuk mewujudkan hal tersebut.</div>
<div style="text-align: justify;">
</div>
<div style="text-align: justify;">
Cara menambahkan tanggal pada header maupun footer dapat anda ikuti langkah mudah berikut ini.</div>
<ol style="text-align: justify;">
<li style="text-align: justify;">Buka header atau footer yang akan anda
beri tanggal dengan cara klik ganda pada area header maupun footer atau
bisa anda buka caranya pada <a href="http://ketikankomputer.blogspot.com/2012/08/membuat-header-dan-footer-di-ms-word.html" target="_blank"><u>halaman ini</u></a>.</li>
<li style="text-align: justify;">Atur kursor tempat tanggal akan diletakkan yaitu rata kiri, rata kanan atau center.</li>
<li style="text-align: justify;">Jika sudah, pada tab <b>Design</b> pilih <b>Date & Time</b> pada group menu Insert.<br />
<br />
<img alt="menambahkan tanggal di header atau footer pada ms word 2007" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj8jvx_XLKrgm9nOb2uArqRJoUddX5HFGrhq2IVAM0jI52nEepU5q-EpPp3j2X2kldZOtn8KifalrziddggOyuAbYq6QzFbWwZYhJINpRmigKOwSnxGHFfQvDdcwXOMAqVM8zS4gZntb4uK/s1600/date+%2526+time.png" title="menambahkan tanggal di header atau footer pada ms word 2007" /></li>
<li style="text-align: justify;">Pada jendela <b>Date and Time </b>pilih format tanggal yang dikehendaki kemudian klik <b>OK </b><br />
<br />
<img alt="Date and time" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhBmv1b12yD5Olo3oSmN4rTxp449DQgDrXD4h_s7LENHEcZXxO-Kq3n__F-4u65tgPZXL_XIlUunL-DEwjmx51jTy1fORaaxP4DG3LZc2arE2ENNR73HvRawd0dH1WzeT8KiFTlthR1sTQc/s1600/date+and+time.png" title="Date and time" /></li>
<li style="text-align: justify;">Maka tanggal telah ditambahkan di <b>Header atau di Footer</b></li>
<li style="text-align: justify;">Klik pada area lembar kerja ms word 2007 anda</li>
</ol>
Sumber: <a href="http://ketikankomputer.blogspot.com/2012/08/cara-menambahkan-tanggal-pada-header.html">http://ketikankomputer.blogspot.com/2012/08/cara-menambahkan-tanggal-pada-header.html</a> <br />
<ol style="text-align: justify;">
</ol>
Anonymoushttp://www.blogger.com/profile/08729531800423570591noreply@blogger.com0tag:blogger.com,1999:blog-7468268993573312248.post-36690946783546785082012-09-20T09:48:00.001-07:002012-09-29T03:01:42.963-07:00Cara membuat mail merge di Ms Word 2007<h3 class="post-title entry-title" style="text-align: justify;">
<br />
</h3>
<div style="text-align: justify;">
</div>
<div style="text-align: justify;">
<i>Mail merge atau surat masal</i> adalah salah satu fasilitas di Ms
Word untuk mempermudah user melakukan pekerjaan dengan hanya membuat
satu format surat namun dengan berbagai tujuan alamat dan nama yang
berbeda. Tentu hal ini akan sangat mempermudah sekali pekerjaan kita.
Kita tidak perlu lagi mengetik satu persatu tujuan dan nama alamat yang
dituju, cukup hanya dengan mengetik daftar nama serta alamat yang
dikehendaki maka nama, alamat yang dibuat akan langsung bergabung atau
merger dengan format surat tadi.</div>
<div style="text-align: justify;">
</div>
<div style="text-align: justify;">
Tidak hanya format surat saja kegunaan mail merge ini, Jika kita
mengetik dengan format yang sama atau blanko formulir yang sama namun
dengan isian yang berbeda, maka mail merge lah solusinya. Cukup buat
format blangko atau formulir yang dikehendaki dan membuat daftar isian
formulir, maka sudah cukup. Hasilnya, setiap isian dari formulir
tersebut akan silih berganti sesuai dengan daftar yang telah dibuat.</div>
<div style="text-align: justify;">
</div>
<div style="text-align: justify;">
Untuk <b>membuat mail merge </b>berikut ini adalah langkah-langkahnya :</div>
<ol style="text-align: justify;">
<li>Buat dokumen terlebih dahulu (bisa berupa surat, blangko formulir, atau dokumen yang lain)</li>
<li>Klik ribbon <b>Mailings </b>kemudian klik <b>Start Mail Merge</b>, pilih <b>Step by Step Mail Merge Wizard</b><br />
<br />
<img alt="membuat mail merge" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjmkO6VK1Kd3qJ_ol3c1hhsCqNNoAc9ujV3w2LwlJ82qQayuY5XYJr-Mo9cuMoLnHq4w0MenhBgQSiIN_g2nb11T5CjkVPvV6x7rCAZjI-E5nxzqU7RvWI-jlzVNYY9Ls9eftAQKeteWCBG/s1600/1.PNG" title="http://ketikankomputer.blogspot.com" /></li>
<li>Akan muncul panel Mail Merge disebelah kanan jendela Word anda.</li>
<li>Pada Select document type pilih <b>Letters </b>kemudian klik <b>Next </b>pada bagian bawah untuk melanjutkan.<br />
<br />
<img alt="membuat mail merge" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhDW8QBZkGPpQdszWeBBi7WZmgJMp2SOZQA3NKVUiizjTyY1Qk3-O3-BXzlAR2LpV5vER7XnWmiVIdl617N5xUGhBpcfCIaqAokjFtFF0YWYQb0OKSJ-hyYnavPqe6e-76Ed9XU8zJcTjlN/s1600/2.PNG" title="http://ketikankomputer.blogspot.com" /></li>
<li>Pilih <b>Use the current document</b> kemudian klik <b>Next</b><br />
<br />
<img alt="membuat mail merge" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhHb6S003vqP8yHb6A0jqv6u0tnux5yeB6BqC_aD7Cimu2VZxJIJpEDgH5tm05jmyWJfvJj3q9SuclhbNJhGdFaKIerKWEy-jP8eLFsW1H_o8Dgi12QJBeJqg332ffMwPIC2xNT8vJRmD6n/s1600/3.PNG" title="http://ketikankomputer.blogspot.com" /></li>
<li>Pada pilihan select recipients, jika anda belum membuat daftarnya pilih saja <b>Type a new list</b> kemudian klik <b>Create</b>.<br />
<br />
<img alt="membuat mail merge" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj00DApPAwH4zDFgrJrPhthAnQmShWgmJh6RIkaGuqaB-Bd9U5cD-N4IIcB-ZxLBuyp0meS3_BDAJvOMILj3H8UvV1DbvfeJgXCVcNCwuKjN7UuTL5RO3xjzSncO-EpLm4P-hGvWitRUOmF/s1600/4.PNG" title="http://ketikankomputer.blogspot.com" /></li>
<li>Akan muncul jendela <b>New Address list.</b>
Untuk memudahkan pekerjaan kita nantinya sebaiknya kolom yang ada
dihapus kemudian dibuat kolom isian yang baru sesuai dengan yang
dibutuhkan.</li>
<ul type="a">
<li>Klik <b>Customize columns</b><br />
<br />
<img alt="membuat mail merge" height="265" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjUYmJl1MC0Zp8t0sdgmvvcZisq-UwYQEr35VnAV_gcoJCSiSd3epJIliWFiEVMXQuEP0iVbbsFEAgGEkxoPWa5XHZUsnflt5TIZ69uRO9eYrWg8gtSZ_OIV_bAr3MfJHzyLgS5Fy2HFE2T/s400/5.PNG" title="http://ketikankomputer.blogspot.com" width="400" /></li>
<li>Pilih filed name kemudian klik tombol <b>delete</b>, sampai semua nama kolom terhapus.<br />
<br />
<img alt="membuat mail merge" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjU9oElZ6iLaB0Hgx6KmzrhwVaKxif7ibWDJsWyiomvS__EwgZxM1e4vg1tJH6Bqks7aHb5auTiNRvk39VPBbYFzGqA1mB1yOwYjW3h7j-uUDO9ANNF67wIZF-0eKiNhCoeLC6nBKoSk3iq/s1600/6.PNG" title="http://ketikankomputer.blogspot.com" /></li>
<li>Untuk membuat field name baru klik <b>Add </b>kemudian beri nama sesuai dengan kebutuhan (seperti Nama, Alamat, dsb)<br />
<br />
<img alt="membuat mail merge" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhbZaski8hraXbLZoD_2rgazzBjfyAtWDR7s9r1vOII8FlZDDZz8jIYJDCtMObZRjpRqAzaM3yXuRF6ea8ZxO3NDGgL5aV82-SZg4uuYTOiQsdQe8pSmXTNHdXo679fTDkEEuZZlbFwRq4L/s1600/7.PNG" title="http://ketikankomputer.blogspot.com" /></li>
<li>Tambahkan beberapa filed sesuai dengan kebutuhan anda.</li>
<li>Jika dirasa sudah cukup klik <b>OK</b><br />
<br />
<img alt="membuat mail merge" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhAWnZy7aFyS_iqbFcNGlePxWZApKRgp4pGnzPZd-bfguUfTnFc9wQUhhQNv3mR6T1USUqC-aDj4YVrtdNgzcM6_wOoFA-H9w1Z2rRpe8gHPAByf0Ve9sssWg4s3oLzXhvXms2d8NK9IiZi/s1600/8.PNG" title="http://ketikankomputer.blogspot.com" /></li>
<li>Muncul jendela <b>New address list</b>. Masukkan data-data yang dibutuhkan sampai selesai, kemudian klik <b>OK</b><br />
<br />
<img alt="membuat mail merge" height="263" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjcZEXvsWtcvo5RkjR2Bo9AC4P-gvltJAY8wpFm-IugY7oocamH5MBFbQfc2IVVwRH6k4EA8qYBEkZppn5sOhhTPo49J8TQE1O88f_1VXWqYVakadGFkDfmPQ8798EHPWRJjm3esJwI38m9/s400/9.PNG" title="http://ketikankomputer.blogspot.com" width="400" /></li>
<li>Untuk menghapus entry klik pada entry yang mau dihapus kemudian klik <b>delete</b>. Untuk menambah entry baru klik pada <b>new entry</b>.</li>
<li>Simpan pada folder dimana tempat dokumen tersimpan kemudian klik <b>Save</b>.<br />
<br />
<img alt="membuat mail merge" height="252" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjZnRVh0BJOUcoGT8TlnC35tXsZywKIcpsgQK41EyX12ftFzbPsAxReT7PTiLdO9e8NzZNA8NsjFGV1K8AgQLdhnZ9tcE0WAts9NKbuC1NLhVPLeRHF6dVTSZvu1kSSPV9MqWZjAaS5Axka/s400/10.PNG" title="http://ketikankomputer.blogspot.com" width="400" /></li>
<li>muncul daftar list yang sudah siap untuk dimasukkan. Untuk
memasukkan semua beri tanda centang pada kotak yang ada, atau bisa anda
pilih sendiri sesuai kebutuhan daftar yang ada dengan menghilangkan
tanda centang pada list tersebut.<br />
<br />
<img alt="membuat mail merge" height="294" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhBh-9_bBBN7-GAKpzuNzu-Eom7z3XoBE-NoClRHzHXCSchPrlsfRXPyfJXBkgKKaQy8T9ZBY3-VhzuRU5I1rvNPv3VO5R3pZrhTzyiGse4rshzb5G-Ij7i6FLZZMg1V-K6lQLsyhL0hajD/s400/11.PNG" title="http://ketikankomputer.blogspot.com" width="400" /></li>
</ul>
<li>Klik Next : Write your letter untuk melajutkan </li>
<li>Sampai disini kita akan memasukkan daftar field yang telah kita buat tadi untuk dimasukkan pada dokumen. <i>Arahkan kursor pada tempat filed diletakkan</i>. <br />
<br />
<img alt="membuat mail merge" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhWCiC6bZObzmaQ-rh2Dtym1d7_pEk_3QDhw54RVXe3sEQHjuyOgeRCghFufY1XyHqBDLesX9uo1-KqzOu0vjyZS33IE8bC4ZR5nHBJDFrbVKdazdSGdJjMsRQ6vvOahJeOP9z04qQThbKL/s1600/13.PNG" title="http://ketikankomputer.blogspot.com" /></li>
<li>Pada pilihan write your letter, pilih <b>More item</b><br />
<br />
<img alt="membuat mail merge" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgdNXaoBmWsf4W6GbT-FFVL3hLDwi-kgH4Pqc4Ik1DARm_AtlDEIHnM-nCPe-SslQh1dq3W6QUFhBuojPEUacL0zEacsLovUGXPSnuyQpez0oSXEcPm_5_2vo9oAt6Q0_edTHqMyqpcMQn0/s1600/12.PNG" title="http://ketikankomputer.blogspot.com" /></li>
<li>Pada jendela yang muncul pilih nama filed sesuai dengan dokumen kemudian klik <b>insert</b><br />
<br />
<img alt="membuat mail merge" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgiPhFFASX7I4qK8GH5A5obeLyfzTkjE9zJZnYPkG0RYzbcmIYig2DNmNuNMJXDxR2CSkoWLOntmcO17rSfunxHxFjW6u97TfmaYutvWmIxjqKe1kKEFBkfAm-VXrRZ1YBi2oVqKA8iNeyD/s1600/14.PNG" title="http://ketikankomputer.blogspot.com" /></li>
<li>Ulangi langkah diatas sampai data diisi dengan field yang sesuai. Sehingga tampilannya akan seperti dibawah ini. <br />
<br />
<img alt="membuat mail merge" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjRDxias_yfnvWCwVjg7_nLvrPCx1WgCu_YRhVRFVRKkjlJvnaJLt-VQ3g6z3zKlKOxqbIfr2quvPMiZITZ3GLSiMOLXHvHJEshpID4tyen0t60sf8BWktUmB6phuoiBTApkKx5uBkMtcwv/s1600/15.PNG" title="http://ketikankomputer.blogspot.com" /></li>
<li>kemudian klik <b>Next </b>untuk melihat hasil merge data. Klik tanda panah kekanan atau kekiri pada preview your letters untuk melihat hasil.<br />
<br />
<img alt="membuat mail merge" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhCq15VWRnJCrT58CHN7hAQiyiAhG22azZ3H924kOBwcoYmep7ikXJG_FmqnHI-75liTCfFiezp-T2wNNFMn1h5om30f3JzHVm00mxfmZ_2P-tDMDBBnPsBDvYIcRei_KhVlx1ZsqrrC82e/s1600/16.PNG" title="http://ketikankomputer.blogspot.com" /><br />
<br />
<img alt="membuat mail merge" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg3Wn1VgSd_IpsMORZ6uhXKso3UHlj56Mn4AJA9hzrbmSDuStkg0RYRKhcs_B6zoPBewvjmqKrGxretCoTW-slAN1exi8Df6m1rFiFWG_Dwt-Bdo3F96V_UsKazfil23JOgWonR1iv3jZ9y/s1600/17.PNG" title="http://ketikankomputer.blogspot.com" /></li>
<li>Jika ada yang masih salah datanya bisa
diubah datanya pada edit recipient list. Jika sudah cukup klik Next
untuk complete the merger.</li>
<li>Terdapat dua pada pilihan complete merger yaitu <b>Print </b>dan <b>Edit individual letters</b>.
Jika anda pilih merger print, maka data merger akan langsung dicetak
melalui printer. Jika dipilih Edit individual letters maka data akan
ditampilkan pada beberapa halaman langsung di Ms Word. Silahkan pilih
sesuai kebutuhan.<br />
<br />
<img alt="membuat mail merge" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiO0qBLa1SxCs-qFh4VtCRV2UCjObr7i2XmKrjncWXHbp_H2QqPYUeSd8DX4nGnNI_WKDE28qv6pczaECvvjp2lebhItsTblwA2XoMhofmgE5LIrVD7NUtD1qcWAih6oOZ1SbB6FFuvoDF6/s1600/18.PNG" title="http://ketikankomputer.blogspot.com" /> </li>
</ol>
<br />
Sumber: <a href="http://ketikankomputer.blogspot.com/2011/11/cara-membuat-mail-merge-di-ms-word-2007.html">http://ketikankomputer.blogspot.com/2011/11/cara-membuat-mail-merge-di-ms-word-2007.html</a> <br />
<ol style="text-align: justify;">
</ol>
Anonymoushttp://www.blogger.com/profile/08729531800423570591noreply@blogger.com0