Pada sistem informasi yang komplek yang melibatkan ribuan atau puluh ribuan data pasti akan dipusingkan dengan masalah memori, ini disebabkan setiap data yang ditampilkan membutuhkan memori. Salah satu teknik untuk memecahkan permasalahan ini adalah teknik Pagging, apa itu Pangging?. Pangging adalah suatu cara atau teknik yang digunakan untuk membagi data besar yang akan ditampilkan kedalam beberapa sub, dengan kata lain teknik ini membagi data yang begitu besar ke beberapa sub sehingga tidak menghabiskan memori komputer saat ditampilkan diform, paging identik dengan membuat tombol next, preview, last, first dan sebagainya. Ada banyak sekali teknik paging, pada tutorial ini menggunakan teknik paging berdasarkan query SQL, sehingga sedikit banyak harus mengerti tentang query query SQL. Untuk mengimplementasikan teori diatas kedalam project ikuti langkah demi langkah dibawah ini, seperti biasa buat project baru klik file new project pada IDE Visual studio setelah muncul kotak project save silahkan isi nama project sesuai dengan keinginan dan klik OK
langkah 1 : pada form yang ada tambahkan control label, numericupdown, datagridview dan button. Atur dan tata sedemekian rupa sehingga tampilannya seperti pada gambar dibawah ini
Gambar 1. Desain aplikasi sistem
langkah 2 : lakukan koneksi MYSQL dengan C#, untuk langkah demi langkah cara melakukan koneksi antara C# dengan MYSQL silahkan baca artikel Koneksi C# dengan MYSQL disini
langkah 3 : double klik pada button satu, button yang berlabelkan "Load Data" untuk membangkitkan event single klik pada button tersebut. Masukan script berikut ini
sebelumnya tambahkan variabel global pada program, berikut sourecode nya
langkah 4 : double klik pada button dua untuk membangkitkan event single pada button tersebut, tambahkan script berikut ini
begitu juga dengan button 3 (button yang berlabelkan next) untuk membangkitkan event single klik pada button tersebut, masukan source code berikut ini. Untuk mempelajari lebih detail tentang event klik disini
langkah 5 : double klik pada control numericupdown1 untuk membangkitakan event numeric updown value change, masukan source code berikut ini
langkah 6 : done. Program selesai. Jika langkah langkah diatas dilakukan dengan benar, saat program dijalankan program akan menampilkan form dengan datagrid yang akan menampilkan data, jika button next dan prev diklik data akan berganti sesuai dengan urutannya. Untuk lebih jelasnya tentang hasil running program berikut ini adalah hasil dari program yang telah dijalankan. Saat pertama kali dijalankan program akan tampil seperti pada gambar 1 diatas, setelah button Load Data tampilan preview akan seperti pada program dibawah ini
Gambar 2. Preview program yang telah dijalankan
ketika button next ditekan, hasilnya seperti pada gambar dibawah ini
Gambar 3. Preview program yang telah dijalankan
ketika button prev ditekan lagi, hasilnya seperti berikut ini
Gambar 4. Preview program yang telah dijalankan
downloal binary filenya disini
download full projectnya disini
download file database MYSQL nya disini
for more information contact us on informasi@csharp-indonesia.com
NB : Dalam tutorial ini program ditulisa menggunakan IDE Visual studio 2010. dengan target framework 2.0 . Sehingga minimal komputer harus terinstal windows xp untuk bisa menjalankan program *.exe nya, Sedangkan untuk membuka projectnya mau tidak mau harus menginstal microsoft visual studio 2010
pak kalau saya ingin gabung dengan email ini bagaimana caranya??
BalasHapusuntuk fasilitas subscrib memang belum ada, ini dikarenakan situs ini masih dalam perbaikan. setelah perbaikan saudara bisa memanfaatkan fasilitas subscrip
BalasHapusterimakasih
regard,
www.csharp-indonesia.com
Lumayan juga buat referensi pemula...
BalasHapussemoga bisa bermanfaat
BalasHapusbagaimana jika saya menggunaakan DB SQLServer ?
BalasHapusmemang untuk DBMS SQLSERVER tidak suport dengan LIMIT, akan tetepi konsep utama dari program ini adalah pengambilan data dan memanipulasinya menggunakan Query SQL, sehingga LIMIT bisa digantikan dengan TOP pada SQL SERVER
BalasHapussemoga bisa membantu
Regard,
www.csharp-indonesia.com
link my sqlnya dah mati ya gan ?
BalasHapusmaaf gan di vs 2010 kan tidak ada loadgrid.... gantinya apa ya... maklum masim awam gan...tolong dong gan
BalasHapus9guowenhao0827
BalasHapusnorth face outlet
timberland shoes
cheap jordans
louis vuitton,borse louis vuitton,louis vuitton sito ufficiale,louis vuitton outlet
oakley sunglasses, http://www.oakleysunglassesdiscount.us.com
air force one shoes
cheap nike shoes
hollister canada, http://www.hollistercanada.com
michael kors outlet store, http://www.michaelkorsoutlet-store.us.com
herve leger dresses
ray ban
louis vuitton outlet
new balance shoes
true religion jeans, http://www.truereligionjean.in.net
ralph lauren outlet
lululemon outlet, http://www.yogapants.us.com
boston celtics jersey
nike running shoes
basketball shoes,basketball sneakers,lebron james shoes,sports shoes,kobe bryant shoes,kobe sneakers,nike basketball shoes,running shoes,mens sport shoes,nike shoes
louis vuitton outlet
oakley canada, http://www.oakleysunglassescanada.com
cleveland cavaliers jersey
michael kors canada, http://www.michaelkorsoutletcanada.in.net
air max 90
louis vuitton
los angeles clippers jerseys
chelsea jersey
lebron james shoes
coach outlet store
karen millen uk
prada outlet
louis vuitton outlet
coach outlet
cheap toms
true religion jeans, http://www.truereligionjeansoutlet.com
chenlina20150916
BalasHapusgucci outlet
football shoes
tods outlet
abercrombie and fitch
ray ban sunglasses
kate spade handbags
soccer shoes
air max
adidas shoes
nike blazer
timberland boots
longchamp pas cher
mizuno running shoes
giuseppe zanotti sneakers
vans shoes
ray bans
cheap oakleys
fake oakleys
juicy couture
louis vuitton pas cher
canada goose uk
longchamp handbags
nike roshe runs
true religion jeans
ghd hair straighteners
nike huarache trainers
nike roshe run
p90x workouts
air max 95
rolex watches
nike trainers
barbour uk
nike store uk
polo outlet
nike tn
ralph lauren polos shirts
rolex replica watches
adidas original trainers
ugg sale
ugg boots
as
qihang1005,insanity workout
BalasHapusreplica watches
air force 1
jordan shoes
mont blanc pens
hollister kids
kobe bryant shoes
adidas superstar
ray ban sunglasses outlet
tommy hilfiger outlet
pandora
ray-ban sunglasses
canada goose outlet
nike cortez
kate spade outlet
fake oakley sunglasses
pandora bracelets
prada
ed hardy clothing
vans shoes
michael kors
nike trainers
michael kors handbags
nike running shoes
ralph lauren outlet
burberry outlet
pandora charms
toms outlet
nike elite socks
instyler curling iron
moncler jackets
louboutin
coach outlet
tod's shoes
mcm outlet
mizuno running shoes
coach outlet canada
q
2015-11-24 xiaozhengm
BalasHapusgucci outlet
coach outlet
ghd straighteners
canada gooses outlet
barbour uk
mizuno running shoes
tory burch outlet
ray ban
christian louboutin outlet
michael kors outlet
michael kors
michael kors
nike tn
running shoes
adidas outlet store
christian louboutin
cheap oakley sunglasses
christian louboutin uk
gucci outlet
michael kors uk
adidas trainers
ghd hair straighteners
michael kors uk
adidas gazelle
nike outlet store
nike cortez
michael kors handbags
jordan 8s
cheap jordan shoes
nike outlet
abercrombie
michael kors outlet
sac longchamp
jordan retro 3
ray ban sunglasses
true religion outlet
nike free runs
mulberry bags
cheap jordans
ray ban sunglasses
coach outlet
nike outlet
ninest123 12.15
BalasHapusoakley sunglasses, louboutin shoes, michael kors outlet online, prada outlet, louis vuitton outlet online, oakley sunglasses, nike free, oakley sunglasses, replica watches, burberry outlet, christian louboutin, nike air max, tiffany jewelry, tiffany jewelry, ralph lauren outlet, ray ban sunglasses, burberry factory outlet, cheap jordans, longchamp outlet, michael kors, ralph lauren polo, michael kors outlet online, replica watches, gucci handbags, michael kors outlet, ray ban sunglasses, uggs on sale, michael kors handbags, nike outlet, nike air max, uggs on sale, uggs outlet, christian louboutin, prada handbags, uggs outlet, tory burch outlet, louis vuitton outlet, louboutin uk, longchamp bags, longchamp outlet, ray ban sunglasses, cheap oakley sunglasses, louis vuitton handbags, oakley sunglasses, louis vuitton, uggs on sale, michael kors outlet online, louis vuitton outlet
louboutin pas cher, timberland pas cher, nike trainers uk, true religion jeans, nike roshe run pas cher, nike air max pas cher, nike blazer pas cher, lunette ray ban pas cher, abercrombie and fitch, lululemon outlet, michael kors outlet online, michael kors, coach outlet store online, coach purses, new balance, nike air max, hollister uk, michael kors, lunette oakley pas cher, true religion outlet, nike tn pas cher, replica handbags, nike air max uk, longchamp soldes, nike free, longchamp pas cher, north face uk, ralph lauren pas cher, michael kors uk, north face pas cher, vanessa bruno pas cher, true religion outlet, polo ralph lauren uk, nike air force, converse, vans pas cher, nike roshe uk, burberry pas cher, sac guess pas cher, true religion outlet, nike air max uk, ray ban uk, hogan sito ufficiale, jordan pas cher, hermes pas cher, mulberry uk, polo lacoste pas cher, nike free pas cher, abercrombie and fitch UK
BalasHapuschi flat iron, iphone cases, wedding dresses, hollister clothing, reebok outlet, herve leger, converse, mac cosmetics, iphone 6 plus cases, vans outlet, jimmy choo outlet, giuseppe zanotti, timberland boots, ray ban, celine handbags, polo ralph lauren, vans scarpe, iphone 6 cases, ghd hair, beats by dre, oakley, mont blanc, p90x workout, iphone 6s cases, instyler ionic styler, valentino shoes, north face outlet, mcm handbags, abercrombie and fitch, insanity workout, iphone 5s cases, bottega veneta, gucci, nike air max, hollister, iphone 6s plus cases, nike air max, new balance shoes, lululemon outlet, babyliss pro, soccer shoes, north face outlet, ipad cases, asics running shoes, nfl jerseys, s6 cases, nike roshe run, softball bats, soccer jerseys, salvatore ferragamo, hermes handbags, louboutin
BalasHapussac louis vuitton, ugg,uggs,uggs canada, supra shoes, coach outlet, canada goose outlet, doke & gabbana, hollister, montre pas cher, pandora jewelry, swarovski uk, ugg pas cher, canada goose, juicy couture outlet, links of london uk, moncler uk, moncler, louis vuitton, canada goose jackets, louis vuitton uk, thomas sabo uk, barbour, moncler, moncler jackets, lancel, canada goose outlet, ugg,ugg australia,ugg italia, barbour jackets uk, canada goose, replica watches, karen millen uk, moncler, pandora jewelry, juicy couture outlet, swarovski jewelry, canada goose jackets, toms shoes, louis vuitton, marc jacobs, pandora charms, ugg uk, canada goose uk, canada goose pas cher, moncler outlet, bottes ugg pas cher, pandora uk, wedding dresses uk, moncler, moncler pas cher, sac louis vuitton, converse shoes outlet
BalasHapusninest123 12.15
zhengjx20160326
BalasHapusferragamo
michael kors bags
toms outlet store
cheap jordan shoes
michael kors outlet online
nike air max 95
designer handbags wholesale
vans outlet store
michael kors outlet
coach factory
michael kors outlet
converse sale
louis vuitton bags
polo outlet
cheap jordans
coach factory outlet online
mont blanc pens
ray ban sunglasses outlet
reebok
toms shoes
mizuno running shoes
ugg outlet online
jordan pas cher
coach factory outlet online
coach factory outlet
michael kors watches
ed hardy
louboutin
armani exchange
ghd
pandora jewelry
hollister hoodies
oakley sunglasses outlet
cartier
louboutin pas cher
asics running shoes
burberry outlet
babyliss hair dryer
louis vuitton handbags
michael kors outlet
oakley sunglasses wholesale
BalasHapustiffany jewelry
lululemon pants
swarovski crystal
ray-ban sunglasses
lululemon uk
ferragamo shoes
ralph lauren polo shirts
babyliss flat iron
coach handbags outlet
oakley sunglasses
ferragamo outlet
swarovski crystal
hollister uk
oakley sunglasses
rolex watches for sale
tiffany jewelry
ralph lauren uk
mulberry handbags sale
tiffany outlet
fitflops sale
cheap oakley sunglasses
louis vuitton handbags
ralph lauren pas cher
ralph lauren uk
true religion outlet
true religion outlet
oakley sunglasses
ray ban sunglasses
michael kors outlet uk
cai20160329
zhengjx20160411
BalasHapushollister clothing
nike air max uk
michael kors outlet online sale
louis vuitton bags
cheap toms
ralph lauren outlet
cheap ray ban sunglasses
lebron 12
abercrombie and fitch
tory burch boots
air jordan shoes
basketball shoes
coach outlet
cheap ray ban sunglasses
cheap ray ban sunglasses
montblanc pen
adidas running shoes
christian louboutin sale
cheap rolex watches
longchamp le pliage
ray bans
michael kors outlet online
nike free 5.0
toms
oakley outlet
air jordan shoes
louis vuitton purses
coach factory outlet online
louis vuitton
gucci outlet online
ray ban sunglasses uk
nike air force 1 white
michael kors bags
kd 7 shoes
louis vuitton outlet
michael kors
michael kors purses
louis vuitton outlet online
oakley vault
coach outlet store online
true religion
BalasHapusmichael kors handbags
cheap jordan shoes
cheap nike air max
jordan shoes
lacoste shoes
wholesale nike shoes
michael kors canada
skechers outlet
coach outlet online
louis vuitton outlet online
chi flat iron
ray ban sunglasses sale
asics gel kayano
michael kors outlet canada
coach factory outlet
nike cortez white
discount nike air max
christian louboutin shoes
nike tn pas cher
ralph lauren pas cher
louis vuitton pas cher
sac longchamp
michael kors outlet store
coach outlet online
supra outlet
designer handbags wholesale
valentino bags
converse outlet
air max 90
versace sunglasses
christian louboutin outlet
michael kors outlet
nike huarache
fake oakleys
louis vuitton handbags
nike huarache black
ferragamo outlet
true religion jeans
rolex daytona
chenzhen20160510
chicago bulls
BalasHapusdetroit lions jerseys
new york jets jersey
new york giants jerseys
titans jersey
san antonio spurs jerseys
nike mercurial
nike outlet store
jordan 11
dolphins jerseys
tennessee titans jerseys
cheap nike shoes
nike foamposite
lacoste pas cher
new york jets jerseys
puma shoes
oklahoma city thunder jersey
los angeles lakers
golden state warriors jersey
washington redskins jersey
valentino shoes
lions jerseys
miami heat jersey
boston celtics jersey
houston texans jersey
buffalo bills jerseys
nike outlet store online
mac cosmetics sale
converse shoes
indianapolis colts jersey
nike outlet
ed hardy clothing
linyuan0517
chenlina20160709
BalasHapusray ban sunglasses
michael kors canada
louis vuitton outlet
michael kors purses
rolex watches
replica watches
mont blanc pens
jordan 3
louis vuitton outlet
michael kors handbags
kobe 9
tod's shoes
christian louboutin outlet
oakley sunglasses
louis vuitton
adidas ultra boost
nike trainers uk
louis vuitton
giuseppe zanotti
marc jacobs handbags
kevin durant shoes 7
tods outlet online
michael kors outlet
ray ban sunglasses
kate spade handbags
adidas shoes
michael kors handbags
coach outlet
adidas superstar
louis vuitton handbags
rolex submariner
nike air max
supra sneakers
coach outlet store online
coach factory outlet
toms shoes
michael kors outlet
michael kors outlet online sale
adidas originals
oakley sunglasses
as
stan smith adidas
BalasHapusabercrombie outlet
louis vuitton pas cher
jordans
jimmy choo
michael kors uk
yeezy boost 350 white
michael kors outlet online
coach outlet store
ugg sale
nmd adidas
louis vuitton handbags
uggs
michael kors outlet clearance
longchamp handbags
nike tn pas cher
ugg outlet
cheap nike air max
omega replica watches
converse sale
cheap ray bans
fitflops
moncler outlet online
michael kors bags
jimmy choo outlet store
michael kors canada
toms outlet store
pandora charms
adidas shoes
coach outlet online
christian louboutin outlet
abercrombie kids
moncler outlet store
true religion outlet
michael kors handbags outlet
bottega veneta shoes
20160722CAIYAN
jimmy choo
BalasHapusair jordan uk
cheap nike shoes
fitflops
skechers outlet
louis vuitton pas cher
nike trainers
louis vuitton sacs
michael kors outlet store
adidas nmd runner
mont blanc pens outlet
BalasHapusmichael kors handbags
armani exchange
nike tn pas cher
titans jersey
ed hardy
chicago bears jerseys
seattle seahawks jerseys
michael kors uk
lions jerseys
hugo boss sale
BalasHapusralph lauren
cowboys jerseys
nike trainers uk
valentino shoes
fitflops shoes
ugg outlet
cheap jordans
chargers jerseys
instyler max 2
20170707 leilei3915
BalasHapuspolo ralph lauren outlet
polo outlet
michael kors outlet online
michael kors outlet online
polo outlet
prada outlet
ray ban pas cher
polo ralph lauren
ralph lauren polo
cheap jordans
Your site is good Actually, i have seen your post and That was very informative and very entertaining for me
BalasHapuslaptop troubleshoot repair
printer set up
data recovery services
Wifi Setup services
laptop troubleshoot repair
printer set up
Coach Factory Coach Factory Outlet Coach Outlet Online Fila Outlet Balenciaga Shoes Cheap Kate Spade Handbag Kate Spade Outlet Air Max Tn Plus Nike Air Max
BalasHapusVictoria Secret Outlet
Komentar ini telah dihapus oleh pengarang.
BalasHapusjust information we only provide information for those who need it cara menggugurkan hamil
BalasHapusA. obat telat datang bulan
B. posisi berhubungan agar cepat hamil
C. makanan dan minuman agar cepat hamil
D. panduan agar cepat hamil
E. cara agar cepat hamil
F. cara agar cepat hamil setelah selesai haid
G. cara alami untuk segera mendapat kehamilan
curry 7 shoes
BalasHapussupreme clothing
yeezy boost
supreme
kd 10
balenciaga shoes
supreme clothing
yeezy
balenciaga
jordan shoes