Database dengan SQL Server Compact Edition c c c
c {endesain Database c c c c c c c c c c cc c c c c c c c c c c c c c c c c c c c c c c c c c c c c c c c c c c c c c cc yc ¦abel Barang
Nama Field
Data ¦ pe
Length
Primer Ke
c
c
c
c
c
c
c
c
c
c
c
c
! " c
c
#$c
c
c c
c {embuat Database c c c c % c c c c c& c cc c c c '(c c ) c * c c c c c + c c,-cc( . c c c cc #c c % c c c c Dindows Form Apllicationc c c c Form Penjualanc ,c c Project rAdd New Item
c
c & c % c c /c 0 c c ) c Datac c 1 Local Databasec c c c21 3 c cName
c c c / c4 c,56c
5c c c cAddc
c
c Gambar 24. Jendela Add New Itemc c c & c% cData Source Configuration Dizardc c c21
3c c c
DataSet name c c c,c / cc 7c 1 c c cFinishc
c Gambar 25. Jendela Data Source Configuration Wizard c
c {embuat ¦abel Barang c c c % c c c c c c c c c
c c c c c c c c) c cc #c c cÿiewrServer Explorerc c c% c c*8 c c c / cc c
c
c Gambar 26.Jendela Server Explorer c c ,c & c% c c*8 c c c c¦ablesc c cCreate ¦ablesc c c % cNew ¦ablec c 0c c c c c c % c1 c cc9 .9 c c c c c Column Namec c c c Data ¦ pec c % c c c cLengthc " c c c c c c Primar c % c esc c c c c c c:c c c c c cOKc
c Gambar 27. Jendela New Table untuk TabelBarang c
c {engkonfigurasi Data Source c " c c c c c c cDat c rShow Data Sourcesc & c c c c c
c;1
c c c c c c c c c c; <c = c c1 c c c c c c c . c cc #c c c c1
crConfigure DataSet with Dizardc
c
c Gambar 28. Jendela Data Source Configuration Wizard c c ,c & c% c c c)9 c>? c c c% c c c c
c9 .9 c c c cc c c c c Finishc c c 9 c c c c c c c cc
c Gambar 29. Hasil Konfigurasi DataSource TokoArsiaDataSet c c c c 9 c c c@c c c c9 c1
c
c
8c
c
c
c
c
1 A c c c cc
c Gambar 30.File TokoArsiaDataSet.xsdc c
c
c
c
c
c
c Gambar 31. Jendela Properties DataAdapter c c c
c {endesain Antarmuka Aplikasi ( c % c c c c % c c c c c c
c c= c c% c c c . c cc yc {endesain Form ¦ampil
@c& c c c c@c1 c c c c c c c
c c #c c@c c c c c2@1 3c ,c 1 c c c c c c c@1 c c cc Komponen
Properties
@#c
4 6cc@1 c41 8 6cc1 c c c
c
c4 6cc 1 c 4 6cc1 c
c
c4 6cc1 c 4 c 6cc 1 c 4 cA 6cc1 c
1 c
4 6cc1 1 c
& #c
4 6cc& #c
& ,c
4 6cc& ,c4 6cc@8 c
c #c
c4 6cc1 c 46cc
c4B 6cc! c 4 6cc1 c 41 8 6cc c c1 c c
( #c
4 6cc" c41 8 c 6ccA ) c 41 8 6ccc1c1*(cCBcc
c
B+ /c
4 6cc c 4 6cc1 c
1 8 8#c
4 6cc18 ) c
)8#c
4 6cc)) c41 8 6cc c 40 6cc c c c! c
#c
4 6cc ) c41 8 6cc) c
,c
4 6cc /c41 8 6cc /c c
c
4 6cc 1 c41 8 6cc1 c
5c
4 6cc = c41 8 6cc= c
c
4 6cc ! c41 8 6cc! c
7c
4 6cc 1 c41 8 6cc1 c
c c c c c c% c@1 c c c#c ccc
c Gambar 32. Desain Form Tampilc c yc Konfigurasi Kontrol GridData ÿiew
B + /c c c c c c c c c c c c c c #c c c DataGridÿiew ¦asksc c B + /c c c Choose Data Sourcec c 1 c
c
c Gambar 33. Menu DataGridView Tasksc c ,c c cEdit Columnsc c c c c & c % c * c ) c c c c 1 8 c c c . c c c c cc
c Gambar 34. Jendela Edit Columnsc c yc {embuat ¦abelAdapter
( c % c c c c c c c c c c c c c c #c c9 c1
8c c% c c*8 c
c
c Gambar 35. Desain File TokoArsiaDataSet.xsdc c ,c 1 c c1 1 c c c c '(c@ B c46c c & c Querc c" c¦oolbox DataSetc c c c c c1 c c c c% c¦ableAdapter Quer Configuration Dizardc 5c c cNextc c c cD c c c
c Gambar 36. Jendela Toolbox DataSetc
c Gambar 37. Jendela TableAdapter Query Configuration Wizard c c
c
c Gambar 38. Jendela Choose a Query Type c c & c % c Choose a Quer
¦ pec c c
c 2SELEC¦ which return rows3c
% c c cNextc
c Gambar 39. Jendela Specify a SQL SELECT statementc c 7c & c % c Specif
a SQL SELEC¦ statementc c c c '(c c c
c c cQuer Builderc Ec & c% cQuer Builderc c c '(c c cc *(*)1cccccccc c c c! " c @CFAcccccccccc1 c >!*C*cccccccc c(0*cGc
c
cH c c c c2xe u e ue yc c c c c c c $ " " % c c c c cue y ! #e e c c & c c c & c
c
c{
'(
c
c c ) c V c c * c ue +y
,u ./e +c
c * 01 c 2 c (c 0 c * 0c
/ cc 3c c c c
>
() cccccccc ? @A c B c c C " c > DCF{cccccccccc c E CCcccccccc F c(0cH G c c
c
*
4
56
7
Je
c 8e 9
:;e
B ;<98ec
c
*
4
=6
7
Je
c 8e 9
:;e
P etec
##c c cNextc c % c c1 c #,c & c " c Choose {ethod to Generate c c A
c c c Fill a Data¦ablec c 2@ 3c c A
c c c Return
a
Data
¦ablec c
2B 3c c c cNextc #c c c% c9 c c c '(c c
c@ c cB c c
cFinishc c c c1 c
c Gambar 42. Jendela Choose Methods to Generate c
c Gambar 43. Jendela Wizard Resultsc c c
c
! c c cc c1 1 c c c c ccc
c Gambar 44. TabelAdapter untuk Kode c c c c c c c . c c c c 1 c c cc Nama {ethod/Fungsi
Statemen
@ c B c
*(*)1c c c c! " cc @CFAc1 c >!*C*c c(0*cGc
@ c B c
*(*)1c c c c! " cc @CFAc1 c >!*C*c c(0*cGc
@ ! c B ! c
*(*)1c c c c! " cc @CFAc1 c >!*C*c! " c(0*cGc
*(*)1cc c c c! " c @CFAcccc1 c H >!*C*c4 c(0*c & 6cFCcc @ c H B c 4 c(0*c & 6cFCcc H 4 c(0*c & 6cFCc H 4! " c(0*c & 6c = c 1 c
=&1*cc1 c H H H *1c I ,c I c! " I 5c H >!*C*c4 I #6c
+ c c B c
*(*)1c cc @CFAc1 cc H >!*C*c4 c(0*c 6c
c c c c c
c
! c c1 c c c cc
c Gambar 45. Hasil Akhir pembuatan TabelAdapter c c yc {endesain Form Operasi
1 c c@cF c c 9c c c J c c c
c c c c
#c 1 c@c c c c&% c ,c c c c cc Komponen
Properties
@#c
c4 6cc@F c41 8 6cc0 c c c
B8#c
c4 6ccB c41 8 6cc c c 41 c0 86cc#c
( #c
c4 6cc c41 8 6cc c c
( ,c
c4 6cc c41 8 6cc c c
( c
c4 6cc c41 8 6cc c c
( 5c
c4 6cc ! c41 8 6cc! c" c
( c
c4 6cc Cc41 8 6ccCc
A 1 8 8#c
c4 6cc c4 )00cF 6cc1 c 4A 6ccGGc4& c) 6cc. .c 41 c0 86cc#c
1 8 8#c
c4 6cc c41 c0 86cc,c
A 1 8 8,c
c4 6cc c4A 6cccc 4& c) 6cc. .c41 c0 86ccc
A 1 8 8c
c4 6cc! c4A 6cccc 4& c) 6cc. .c41 c0 86cc5c
#c
c4 6cc c41 8 6cc c 41 c0 86ccc
c
c
,c
c4 6cc ! c41 8 6cc! c 41 c0 86cc7c
c
c4 6cc 1 c41 8 6cc1 c 41 c0 86ccEc
c4 6cc 0 c 4 6cc1 c
c
c
c4 6cc0 c 4 6cc 0 c 4 A 6cc1 c
1 c
4 6cc0 1 c
c
c Gambar 46. Desain Form Operasic c c
c Script Form ¦ampil c c c@c1 c c c c ccc ë
ë !" #$ $ ! $ ! !" ë % !" # % $& " ë ' (% !" #' (% $ ! $ ! !" ë '%
c
!" # '% ) $ ) ' (" ë # % !" ## % * + " ) ,) -$!' & !- * !.) / !.) %!.) #!0 .) # ) ) $ ) ' (" # " ë 1'% !" #1'% ) * + " ,) -$! '& !- * ! ) $ ) ' (" ë * + " & * /( 2 ( ! -,- $ ! -* !- " & / /( 2 ( ! -,- $ ! -/ !- " & %/( 2 ( ! -,- $ ! - %!- " & #! /( 2 ( ! -,- $ ! -#!0 - " * !&!* " / !& !/ " %!&! %" #!0 &!#!" ë % !" #% . /, & ) , , & % ) , +3 4 -* -% "" ' $ ! * ! ! " +3 4 -/ -% "" ' $ ! / ! ! " +3 4 - %-% "" ' $ ! % ! ! " +3 4 -#!-% "" ' $ ! #! !
c
!" +3 4 - -% "" ' $ ! * ! !"" +3$ ,) -* -" ' $! ,-ë'% - " +3 & %+! %)$ ! !. ( +3%5)6" ' $! ,-&% %- $! ,+3 -#- " $! ,-&7-8$ , ,8 -9 %7- 8% ! 8-9 '-$! ,+3 --" +3 $ , ,) -- $ ,) -* - $ ) ë +,'! !" # +,'! +3$ , ,5: --" ' ) +3 c
c Script Form Operasi c c c@c1 c c c c ccc ë & ;<! & =>& ë % !" $* ! ,) -- $/ ! ,) -- $ %! ,)6 $#!0 ,)6 ë !" #$ $+ ! $+ ! !" ë % !" # % ;)$* ! , <)$/ ! , =)$ %! ," >)$#!0 ," & +3 ) " ' & +!
c
+ ! * + ! !;" )+ ! !. ( +35)6" ' ! +;<=>" $! ,-* '- $! , - % - " $* ! ,) -- $* ! " +3 )-&' - )-&-8$* ! ,8 -' '- +3 $! ,$! ,+3 - -" ! 3 ) ! !
!" !&!.3'" ) $& " ë % !" # % ) $& " ë # % !" ## % ;)$* ! , ! &;" $! ,-&'' - $! ,+3 -# -" ! 3 ) ! !
!" !&!.3'" $# ) $ ) ) $& " ë * ! !" #* ! & +! + ! * + ! ! $* ! ," )+ ! !. ( +3 4 $* ! , --"" ' $! ,- !%* !- $! , , -* * !-" $* ! ,) -- $* ! " +3:); ) " ' $! ,-* '- $! , , - * - " $* ! ,) -- $* ! " +3
c
ë / !? !" #/ !? @$ * ' 3 $* ! ,) $* ! , 1" c
c Gambar 47. Hasil Akhir Aplikasi Adventori Barang c c
c