Welcome, Guest! Sign Up RSS

TUTORIAL

Thursday, 2024-03-28
Membuat tabel SQLite dengan SQLiteMan menggunakan query di field berikut


masukkan query pada field tersebut kemudian klik tombol berikut

... Read more »
Category: SQLite | Views: 13615 | Added by: joao_franco | Date: 2013-12-14 | Comments (20)

Membuat tabel SQLite dengan SQLiteMan menggunakan query di field berikut


masukkan query pada field tersebut kemudian klik tombol berikut

... Read more »
Category: SQLite | Views: 1677 | Added by: joao_franco | Date: 2013-12-14 | Comments (0)

Requirement:
- SQLiteMan

Berikut adalah langkah-langkah dalam membuat file database sql:
1. Klik File kemudian pilih New atau dengan shorcut ctrl+N


2. Extensi file dari SQLite terserah kita, kita bisa menamainya dengan .sqlite / .index / .bookmark dan lain-lain:
... Read more »
Category: SQLite | Views: 1473 | Added by: joao_franco | Date: 2013-12-14 | Comments (0)

Berikut adalah tutorial lanjutan dari
Koneksi Visual Studio 2010 dengan MySQL

1. Pertama kita buka form yang berisi data barang, kemudian klik tbbarangbindingnavigator (jangan double clik) maka akan muncul property dari tbbarangbindingnavigator.
Ubah property visible dari true menjadi false

... Read more »
Category: VB.NET | Views: 6228 | Added by: joao_franco | Date: 2013-12-12 | Comments (0)

-- List of world's countries containing the official short names in English as given in ISO 3166-1,
-- the ISO 3166-1-alpha-2 code provided by the International Organization for Standardization
-- (http://www.iso.org/iso/prods-services/iso3166ma/02iso-3166-code-lists/country_names_and_code_elements)
-- and the ISO alpha-3 code provided by the United Nations Statistics Division
-- (http://unstats.un.org/unsd/methods/m49/m49alpha.htm)
--
-- compiled by Stefan Gabos
-- version 1.2 (last revision: December 09, 2012)
--
-- http://stefangabos.ro/other-projects/list-of-world-countries-with-national-flags/

DOWNLOAD
Category: MySQL | Views: 904 | Added by: joao_franco | Date: 2013-11-30 | Comments (0)


port yang digunakan ada 3 macam:
- 278
- 378
- 3bc

Code
.model small
.code

org 100h

mulai :  
mov dx,03bch
mov al,255
out dx,al
int 20h
end mulai

... Read more »
Attachments: Image 1 ·Image 2
Category: Assembly | Views: 1384 | Added by: joao_franco | Date: 2013-11-28 | Comments (0)

Sebelum melakukan koneksi download dan install terlebih dahulu
mysql-connector-net-6.3.1 dari dev.mysql.com
setelah terinstal:
1. buka Visual Studio 2010
2. pilih new project pilih windows form application

... Read more »
Category: VB.NET | Views: 1469 | Added by: joao_franco | Date: 2013-11-28 | Comments (0)

Contoh View dari tabel penjualan dan tabel barang yang telah dibuat pada tutorial sebelumnya di sini

Code
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `jualdetail` AS select `p`.`kd_brg` AS `kd_brg`,`b`.`nm_brg` AS `nm_brg`,`b`.`mrk_brg` AS `mrk_brg`,`b`.`kat_brg` AS `kat_brg`,`b`.`harga` AS `harga`,`p`.`jumlah` AS `jumlah`,`p`.`harga` AS `harga total`,`p`.`nm_pembeli` AS `nm_pembeli`,`p`.`tanggal` AS `tanggal` from (`tbbarang` `b` join `tbpenjualan` `p`) where (`p`.`kd_brg` = `b`.`no_brg`) order by `p`.`tanggal`;

... Read more »
Attachments: Image 1
Category: MySQL | Views: 979 | Added by: joao_franco | Date: 2013-11-28 | Comments (0)

Contoh tabel penjualan

Code
CREATE TABLE IF NOT EXISTS `tbpenjualan` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `kd_brg` varchar(200) NOT NULL,
  `nm_pembeli` varchar(200) NOT NULL,
  `tanggal` date NOT NULL,
  `jumlah` int(10) NOT NULL,
  `harga` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

... Read more »
Attachments: Image 1 ·Image 2
Category: MySQL | Views: 803 | Added by: joao_franco | Date: 2013-11-28 | Comments (0)