Tidak asing lagi bahwa sebuah program dengan skala menengah keatas akan membutuhkan sebuah database, apalagi jika program tersebut berkaitan dengan SISTEM INFORMASI, mau tidak mau pasti akan menggunakan database, berikut ini adalah sebuah sistem informasi sederhana menggunakan database MYSQL dengan operasi yang menggunakan operasi INSERT, UPDATE dan DELETE. langkah pertama siapkan project dengan sbuah form kosong, dan tambahkan menustrip, button, datagridview, textbox dan label, atur dan tata sedemikian rupa sehingga interface seperti pada gambar disamping. langkah selanjutnya sebagai berikut
- tambahkan file MYSQL.Data.Dll pada program melalui "add reference" untuk membuah sebuah koneksi dengan DBMS MYSQL, jika belum familiar dengan sebuah koneksi program C# dengan MYSQL silahkan baca terlebih dahulu tutorial disini
- tambahkan function untuk melakukan load data dari database MYSQL.
- tambahkan code berikut ini untuk menghandle event pada daatagrid "update" dan "delete"
inti dari program sistem informasi adalah proses "SELECT", "INSERT", "UPDATE" dan "DELETE". pada program kecil diatas telah mengimplementasikan keempat proses tersebut, jika langkah-langkah diatas dilakukan dengan benar kurang lebih hasilnya seperti pada gambar dibawah ini,
preview program saat pertama kali program dijalankan.
proses select (mengambil data dari database)
preview program saat di klik tambah data
untuk menghapus data langsung di klik pada bagian kanan dari datagridview, berikut ini adalah preview dari operasi delete di program. misalnya akan dihapus data ke-8 yaitu data basis data.
setelah button delete di klik, muncul sebuah jendela konfirmasi, apakah data basis data yakin ingin dihapus, model dialog seperti ini berguna untuk mencegah terjadinya kecelakaan/hilangnya data, semisal ketika user tidak sengaja melakukan klik pada button delete, sehingga data tidak hilang begitu saja.
setelah jendela konfirmasi dijawab dengan "OK" maka program akan menghapus data matakuliah basis data beserta dengan SKS nya.
sedangkan untuk mekanisme update/edit langsung di datagridview/inlineform. semisal data office aplication ingin diganti dengan matakuliah office, double klik pada matakuliah "office application" langsung isi dengan nama yang baru semisal "office", jika sudah diisi dengan nama yang baru klik button update yang ada disebalah kanan.
untuk lebih jelas dalam memahami code program, silahkan download full project beserta databasenya dibawah ini.
database : MYSQL
nama database : csharpindonesia.com
nama tabel : matakuliah
IDE : visual studio 2013
download database :
4share : download disini
mediafire : download disini
ziddu : download disini
download project
4share : download disini
mediafire : download disini
ziddu : download disini
jika link download error silahkan tinggalkan laporkan, tinggalkan komentar. file akan di perbarui, semoga bisa membantu dan bermanfaat.
Artikel Terkait
- Menangkap kesalahan dengan Try Catch di C Sharp ( C# )
- embeded database (firebird) di C#
- koneksi C# dengan SQL SERVER dan mengambil data dari SQL SERVER
- membuat form login database mysql di C# (C Sharp)
- menyimpan gambar ke MYSQL di C# (C Sharp)
Asslmkm,pak minta full projectnya batteray alarm nya donk :)
BalasHapusPak, kenapa insert punya saya ga bisa pahal udah sama persis. ada 2 perintah insert, apakah =>MySqlDataReader reader = dbcmd.ExecuteReader(); tidak boleh ada 2 dalam 1 form.
BalasHapusdfdf
HapusPak, saya punya diagram seperti ini
BalasHapusServer CentOS + Mariadb server dan PC Client(Windows).
Dari pc client saya akan mengakses ke mariadb menggunakan vs c#.
bagaimana langkahnya pak..terimakasih
masalah ini sudah solved dua bulan lalu. thanks
HapusMas kalau mau bikin kode otomatis gimana yah masalahnya jika KD-0001 kita ambil angkanya aja cuman pas pengoperasian aritmatiknya dia jadi KD-2 gitu mas ... tolong bantu yah...
BalasHapusmaju terus csharp indonesia
Mantap gan, ane cobain dulu yah.
BalasHapuswah, tutorialnya mantap gan...
BalasHapus3guowenhao0827
BalasHapusbeats headphones
green bay packers jerseys
canada goose outlet
cartier watches
louis vuitton
cheap nba jerseys
chanel handbags
lebron shoes
celine outlet online
abercrombie and fitch
mizuno running
louis vuitton handbags
gucci outlet
mac cosmetics
new york giants jerseys
hollister shirts
ray ban
coach outlet
the north face uk
chanel outlet
tods shoes
cheap nhl jerseys
nhl jerseys
oakley sunglasses
salvatore ferragamo
nike air max uk
true religion outlet, http://www.truereligionjeansoutlet.com
ed hardy clothing
mont blanc pens
links of london
hermes birkin
prada shoes
ugg boots, http://www.cheapuggboots.net.co
ralph lauren polo shirts
nfl jerseys wholesale
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,christian louboutin
BalasHapuslouboutin
michael kors handbags
supra shoes
cheap uggs
replica watches
nike huarache
cheap versace
longchamp outlet
kobe bryant shoes
soccer shoes
oakley sunglasses
tommy hilfiger outlet
louis vuitton handbags
abercrombie and fitch
sac longchamp pliage
ugg boots outlet
insanity workout
ray ban sunglasses
pandora bracelets
louis vuitton pas cher
true religion outlet
cheap ray ban sunglasses
ghd
coach factory outlet
kate spade outlet
mcm outlet
rolex watches
gucci borse
tod's shoes
jordans for sale
air max 90
ray bans
q
2015-11-24 xiaozhengm
BalasHapuslouis vuitton
michael kors outlet
tommy hilfiger outlet
louis vuitton outlet
jordan 3 infrared
cheap uggs boots
north face
louis vuitton outlet
sac longchamp
rolex replica watches
louboutin pas cher
ralph lauren outlet
michael kors handbags
true religion
ed hardy uk
adidas originals
michael kors outlet
michael kors
uggs outlet
louis vuitton
hermes belt
michael kors outlet
air jordan uk
louis vuitton pas cher
michael kors handbags
ray ban
michael kors outlet online
nike air max uk
ghd
snapbacks wholesale
michael kors
jordan 3
michael kors outlet
louboutin
moncler jackets
oakley sunglasses
louis vuitton
michael kors uk
toms wedges
coach 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
BalasHapuscartier love ring
ralph lauren outlet
ecco outlet
cheap basketball shoes
coach outlet online
nike air max 90
ghd hair dryer
reebok shoes
michael kors handbags
christian louboutin uk
michael kors outlet
cheap oakley sunglasses
ugg sale
michael kors
fitflops shoes
louis vuitton borse
toms outlet
fitflops outlet
fitflops clearance
nike roshe run
ray bans
air jordan shoes
toms outlet
levi's outlet
canada goose sale
cheap ray bans
michael kors uk
ray ban outlet
lululemon athletica
sac longchamp pliage
babyliss
omega
polo ralph lauren outlet
nike trainers
burberry sale
prada handbags on sale
true religion
kate spade new york
hermes belt
puma outlet
rolex watches for sale
BalasHapuslongchamp pas cher
louboutin pas cher
ralph lauren outlet
cheap oakley sunglasses
longchamp handbags
burberry outlet
burberry outlet
hollister clothing
coach outlet
beats by dre
ralph lauren outlet
ralph lauren uk
ferragamo shoes
tiffany and co jewelry
kate spade handbags
longchamp handbags
ferragamo outlet
birkenstock sandals
ralph lauren uk
longchamp handbags
longchamp pliage
oakley sunglasses
ray ban sunglasses
true religion jeans sale
true religion jeans
hollister clothing store
toms outlet
coach outlet online
lululemon pants
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
polo outlet
BalasHapusadidas shoes
coach factory outlet
cheap nfl jerseys
michael kors canada
true religion jeans
valentino
ecco outlet
nike running shoes
christian louboutin uk
cheap ray ban outlet
michael kors canada
yeezy boost 750
ferragamo
cheap oakleys
jordan pas cher
adidas nmd runner
louboutin shoes
omega
adidas nmd uk
kate spade outlet
lululemon outlet store
adidas superstar white
cheap ray ban sunglasses
cartier love ring
calvin klein jeans
cheap oakleys
stephen curry basketball shoes
yeezy boost 350 white
air max
new balance shoes
polo ralph lauren men
micahel kors
ray ban sunglasses outlet
coach outlet store
ralph lauren
ed hardy
nike store uk
cheap basketball shoes
coach factory outlet
chenzhen20160510
vans shoes
BalasHapusredskins jerseys
air jordan 13
nike outlet store
nike roshe run shoes
jordan 4
kobe 9
tennessee titans jersey
nike soccer shoes
san antonio spurs
new york giants jersey
philadelphia eagles jerseys
chiefs jersey
browns jerseys
abercrombie outlet
san antonio spurs jersey
boston celtics
eagles jerseys
jacksonville jaguars jerseys
oklahoma city thunder
cardinals jersey
buffalo bills jersey
new balance shoes
vans outlet
air jordan 11
celine outlet online
arizona cardinals jersey
mizuno shoes
abercrombie and fitch
tods shoes
cleveland browns jersey
chicago blackhawks
miami dolphins jerseys
san francisco 49ers jersey
dallas cowboys jersey
linyuan0517
file projec nya gak bisa dibuka ? tolong pencerahannya
BalasHapuschenlina20160709
BalasHapustory burch handbags
christian louboutin shoes
nike air jordan
louis vuitton
michael kors outlet
nike outlet store
ray ban outlet
michael kors outlet
true religion
mont blanc fountain pens
louboutin pas cher
coach factory outlet
oakley outlet
true religion outlet
polo outlet
adidas originals
christian louboutin shoes
gucci outlet
pandora outlet
cheap jordan shoes
air jordans
coach outlet clearance
jordan 4
louis vuitton outlet online
cheap ray ban sunglasses
longchamp handbags
oakley sunglasses
toms outlet
michael kors outlet online
cheap oakley sunglasses
oakley sunglasses
nike air max 90
nfl jerseys wholesale
jordan 3 white cenment
christian louboutin outlet
nike free run
oakley sunglasses
cheap toms
michael kors outlet
jeremy scott shoes
as
cheap ray ban sunglasses
BalasHapusmichael kors outlet store
michael kors handbags outlet
sac longchamp
tiffany jewelry outlet
oakley sunglasses wholesale
michael kors uk
true religion jeans
louboutin pas cher
coach outlet store online
adidas trainers
michael kors outlet canada
tiffany uk
longchamp bag
ugg,uggs,uggs canada
coach factory outlet
moncler jackets
ralph lauren outlet
coach factory outlet online
mizuno running shoes
coach factory outlet
canada goose uk
christian louboutin shoes
ed hardy uk
michael kors outlet stores
louis vuitton outlet
gucci outlet online
michael kors handbags
nike free flyknit 5.0
coach factory outlet online
cheap ray ban sunglasses
polo ralph lauren outlet online
nike blazer
louboutin shoes
20160722CAIYAN
jordan 4
BalasHapuskobe 9 shoes
kobe shoes 11
michael kors handbags
adidas yeezy
cheap jordans
jordan concords
moncler outlet
canada goose coat
ralph lauren sale
ugg uk
cheap jordan shoes
louis vuitton outlet
ray-ban sunglasses
true religion jeans
nba jerseys
true religion jeans
cheap jordans
christian louboutin sale
mont blanc pens for sale
louis vuitton outlet
coach outlet
coach factory outlet
adidas trainers
the north face jackets
longchamp outlet
ray ban sunglasses
christian louboutin chaussures
christian louboutin shoes
cleveland cavaliers jerseys
minnesota vikings jerseys
christian louboutin flats
christian louboutin
adidas outlet
coach outlet
longchamp bags
coach outlet
lebron james shoes
cheap rolex watches
20168.15wengdongdong
jianbin0829
BalasHapusralph lauren uk
adidas nmd
ugg boots
nike outlet store
oakley sunglasses
ysl outlet
nike foamposite
michael kors handbags
ugg outlet
oakley sunglasses
valentino outlet
hermes belt for sale
louis vuitton outlet online
michael kors bags
michael kors handbags
adidas nmd
canada goose outlet
christian louboutin outlet
kobe bryants shoes
swarovski outlet
converse shoes sale
prada sneakers
asics
swarovski outlet
oakley sunglasses
louis vuitton bags
cheap canada goose jackets
nike air max
oakley sunglasses wholesale
calvin klein outlet
ugg outlet
JIANBIN1112
BalasHapusair max 90
canada goose outlet
kate spade handbags
the north face outlet
nike free run
ugg outlet
yeezy boost 350
ugg boots
cheap ray ban sunglasses
mulberry handbags sale
yeezy boost 350
BalasHapusdiscount oakley sunglasses
skechers shoes
oakley sunglasses wholesale
tiffany and co jewellery
kobe shoes
adidas ultra boost
adidas ultra boost
kobe shoes
adidas neo
nike outlet
BalasHapusmichael kors handbags sale
michael kors outlet
patriots jerseys
chicago bulls
michael kors handbags
instyler max 2
nike store uk
cheap mlb jerseys
michael kors handbags
nike air max
BalasHapusfitflops shoes
michael kors outlet
louis vuitton outlet
michael kors outlet
longchamp handbags
nba jerseys
ugg boots
iphone case
beats by dre
chanyuan12.29
michael kors outlet online
BalasHapusmichael kors handbags clearance
bottega veneta outlet online
ray bans
louis vuitton pas cher
coach outlet online
converse shoes
hollister clothing
tiffany jewelry
mulberry bags
20170228caihuali
louis vuitton sacs
BalasHapusnike huarache trainers
boston celtics jersey
chiefs jersey
cheap basketball shoes
chaussure louboutin pas cher
cheap jordan shoes
michael kors handbags online
michael kors handbags
washington redskins jerseys
kansas city chiefs jerseys
BalasHapuscheap nike shoes sale
oakley vault
fitflops sale clearance
ed hardy clothing
michael kors handbags
mont blanc pens outlet
skechers shoes
ed hardy
ray ban sunglasses
20170707 leilei3915
BalasHapusmont blanc
polo ralph lauren
polo outlet
yeezy shoes
michael kors outlet
pandora bracelet
ugg boots
polo ralph lauren pas cher
yeezy boost
michael kors outlet clearance
heroes of the storm system requirements
BalasHapusheroes of the storm minimum requirements
heroes of the storm pc requirements
BalasHapuspainting is poetry that is seen rather than felt, and poetry is painting that is felt rather than seen
Menmyshop
Touch Hypersonic Double Din Player Mirror
J3L Touch Double Din Player
Hypersonic Double Din Player Mirror
J3L Double Din Player Mirror
Hyundai Xcent OEM Double Din Player
banzara
Movers and packers in mohali
BalasHapusPatrachar Vidyalaya Admission Form
Patrachar Vidyalaya Shalimar Bagh
Open School admission
Cbse Patrachar
Jacques-David LeCoultre gestiva quindi la Grande Maison,replica orologi rolex l'officina del predecessore di oggi,panerai replica e l'officina ha una risorsa e una tecnologia estremamente ricche per produrre orologi.patek philippe replica Per promuovere questa creazione unica,hublot replica i due hanno co-fondato la società di orologi speciali (Spécialités Horlogères).
BalasHapusSebbene Grande Maison fosse un noto produttore di orologi,hublot replica non aveva un movimento per il tavolo ribaltabile Reverso.replica vacheron constantin La società di orologi speciali (Spécialités Horlogères) ha anche trovato Tavannes,breitling replica fornito da Tavannes.
goyard handbags
BalasHapusgolden goose outlet
moncler
golden goose
yeezy supply
golden goose sneakers
golden goose
golden goose sneakers
yeezy shoes
goyard
golden goose
BalasHapusoff white hoodie
pg 4
chrome hearts online store
kyrie irving shoes
this article other click to investigate company website see it here 7a replica bags wholesale
BalasHapusstrong>
BalasHapusThe Daily Mint is a finance blog that offers monstrous articles for small business owners. Articles are concise and written with honesty. Furthermore, it features creative articles and compelling case studies. One feature of the blog that makes it novel is that it identifies key trends in technology. Another feature is that it features industry influencers. thedailymint.com