28 November 2013 - Tutorial

Main » 2013 » November » 28

Koneksi LED ke paralel port menggunakan bahasa Assembly

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

Attachments: Image 1 ·Image 2

Category: Assembly | Views: 1389 | Added by: joao_franco | Date: 2013-11-28 | Comments (0)

Koneksi Visual Studio 2010 dengan MySQL

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

Attachments: Image 1 ·Image 2 ·Image 3 ·Image 4 ·Image 5 ·Image 6 ·Image 7 ·Image 8 ·Image 9 ·Image 10 ·Image 11 ·Image 12 ·Image 13 ·Image 14 ·Image 15

Category: VB.NET | Views: 1474 | Added by: joao_franco | Date: 2013-11-28 | Comments (0)

Cara Membuat View dengan MySQL

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`;

Attachments: Image 1

Category: MySQL | Views: 984 | Added by: joao_franco | Date: 2013-11-28 | Comments (0)

Cara Membuat Tabel dengan MySQL

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;

Attachments: Image 1 ·Image 2