Welcome, Guest! Sign Up RSS

TUTORIAL

Friday, 2019-08-23
Main » 2013 » November » 28

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: 905 | Added by: joao_franco | Date: 2013-11-28 | Comments (2)

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: 1042 | 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: 601 | Added by: joao_franco | Date: 2013-11-28 | Comments (1)

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: 488 | Added by: joao_franco | Date: 2013-11-28 | Comments (0)