Melanjutkan pada posting tutorial sebelumnya yaitu DELETE dan SELECT MYSQL di datagridview, selanjutnya pada tutorial ini akan dibahas cara melakuakan proses insert sekaligus melakukan load data setelah proses insert data selesai dilakukan, mengapa proses load data setelah proses insert itu dirasa penting?, jika setelah melakukan proses insert program tidak melakukan refresh/update pada data yang ditampilkan oleh program, maka user akan mengira bahwa data tersebut belum masuk ke database, sehingga user akan menginputkannya lagi dan akhirnya akan terjadi redundasi data didalam database. inilah alasan mengapa setalah proses pada database program segera menampilan data yang telah dimodifikasi tersebut, entah dilakukan proses update, delete maupun insert pada database. Berikut ini adalah potongan source code untuk melakukan insert data dari datagirdview ke database mysql
untuk mengimplementasikan source code diatas kedalam project, ikuti langkah demi langkah berikut ini
langkah 1 : siapkan project kosong, pada IDE visual studio, klik file new project, setelah
beberapa saat muncul kotak project name silahkan isi nama project sesuai dengan keinginan, tidak ada aturan khusus dalam menulis nama project
langkah 2 : tambahkan beberapa komponen toolbox yang digunakan dalam project seperti label, button, picturebox dan datagridview. Atur dan tata sedemikian rupa sehingga tampilannya seperti pada gambar dibawah ini
Gambar 1. Desain Aplikasi
langlah 3 : Double klik pada button 1 (button yang berlabelkan insert) untuk membangkitkan event single klik pada button tersebut. masukan source code berikut ini, sebelum itu pastikan anda telah membaca tutorial tentang koneksi MYSQL disini
langkah 4 : tambahkan function loadData() pada jendela source code. Sedangkan isi dari function loadData() adalah sebahagai berikut ini
langkah 5 : done, program selesai dibuat. Jika langkah langkah diatas dilakukan dengan benar maka saat program dijalankan program akan menampilkan form dimana bila button load data di klik akan menampilkan semua data yang ada di database, sedangkan jika button insert di klik data yang ada di textbox1 dan data di textbox2 akan ditambahkan ke database MYSQL. Berikut ini adalah preview hasil running program.
Gambar 2. Preview hasil running program
download contoh program disini
download project disini
download file database disini
for more information contact on informasi@csharp-indonesia.com
pandauan download : klik link download yang disediaan diatas, setelah itu akan muncul halaman adf.ly, tunggu beberapa detik sampai pada pojok kanan atas muncul tulisan skip ad. klik tombol tersebut ,setelah itu akan muncul halaman ziddu, silahkan klik pada button download yang muncul pada halaman ziddu
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
Artikel Terkait
Artikel Terkait
- hidden cell koneksi MYSQL di dataGridView di C# (C Sharp)
- koneksi C# dengan DBMS Mysql
- perbedaan koneksi antara read only dengan read write di C#
- membuat form login dengan database Mysql di C# ( C Sharp )
- mengambil data dari MYSQL ke datagridview menggunakan dataset ...
- menyimpan gambar ke MYSQL di C# (C Sharp)
- Koneksi embeded database SQLITE di C# (C Sharp)
- koneksi C# dengan SQL SERVER dan mengambil data dari SQL ...
- membuat button next previous first last di C# (pagging) C Sharp
- Membuat button DELETE dan SELECT MYSQL di dataGridView di ...
- Mengambil nilai tunggal DataSet dan mengetahui panjang Dataset ...
- Load data dari MYSQL setelah proses INSERT data ke MYSQL di ...
- Men Disable Fungsi Sort Pada DataGridView di C# (C Sharp)
- load gambar dari MYSQL via C# (CSharp)
- Gambar di MySql (C#)
- Mengambil data dari DataTable di C# (C Sharp)
- embeded database (firebird) di C#
- membuat form login database mysql di C# (C Sharp)
- Load Data dari Excel ke DataGridView di C#
- membuat button di dataGridView di C# C Sharp
kalau misalkan kita mau munculkan form editing atau update ketika klik dobel di rows datagridnya bagaimana mas?
BalasHapuskalau misalkan kita mau munculkan form editing atau update ketika klik dobel di rows datagridnya bagaimana mas?
BalasHapussilahkan klik macam-macam event di http://www.csharp-indonesia.com/2010/10/macam-macam-event-di-c-c-sharp.html
BalasHapusSemoga bermanfaat,
Regard,
www.csharp-indonesia.com
wes dijawab.. heheheh :-D
BalasHapus6guowenhao0827
BalasHapusmichael kors outlet online
baltimore ravens jerseys
san antonio spurs jerseys
true religion jeans, http://www.truereligionoutletstore.us.com
replica watches
gucci,borse gucci,gucci sito ufficiale,gucci outlet
miami heat jersey
burberry outlet online
converse shoes
dansko outlet
true religion jeans
abercrombie and fitch
toms outlet
jordan 4
cheap soccer jerseys
burberry outlet
chanel outlet
christian louboutin outlet
coach outlet online
air jordan 11
adidas outlet
lebron james shoes
oakley sunglasses, http://www.oakleysunglasses-outlet.us.com
michael kors outlet online
hollister pas cher
michael kors outlet
true religion outlet
cheap uggs, http://www.uggboot.com.co
christian louboutin
instyler
coach outlet
chicago bulls jersey
louis vuitton handbags
juicy couture outlet
coach outlet canada
chenlina20150916jordan shoes
BalasHapusair max 90
mcm handbags
cheap uggs
ed hardy outlet
fitflops sale clearance
michael kors outlet
oakley sunglasses
coach outlet store online
mulberry handbags
kobe bryant shoes
pandora
pandora jewelry
replica watches
ghd
moncler outlet
hollister co
retro jordans
oakley sunglases cheap
chaussure louboutin
oakley sunglasses wholesale
air jordans
nike air max 90
north face uk
toms outlet
tommy hilfiger outlet
sac longchamp
michael kors
gucci borse
toms shoes
longchamp
burberry outlet
sac longchamp pliage
prada uk
kate spade uk
air force 1
michael kors handbags
fitflop uk
adidas shoes uk
ray-ban sunglasses
as
2015-11-24 xiaozhengm
BalasHapussac longchamp pliage
longchamp handbags
jordan 13
coach outlet
pandora jewelry
coach factory outlet
nike uk
michael kors outlet
coach outlet
oakley sunglasses
ugg boots
christian louboutin outlet
jordan 6
sac longchamp pas cher
nike air max
oakley sunglasses
michael kors outlet online
michael kors handbags
michael kors outlet online
coach outlet
coach outlet
gucci 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
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
zhengjx20160411
BalasHapusray bans
nike air max uk
gucci outlet
ralph lauren
michael kors outlet
cheap ray ban sunglasses
air jordan shoes
longchamp outlet
burberry outlet online
coach outlet
nike air max
retro 11
gucci outlet
kobe shoes
kate spade outlet
louis vuitton outlet online
burberry sale
coach outlet
ugg outlet
longchamp handbags
polo ralph lauren
nike trainers women
ralph lauren home
toms wedges
oakley sunglasses
louis vuitton bags
oakley vault
coach outlet online
coach outlet clearance
kate spade outlet
michael kors outlet
replica rolex watches
true religion jeans
oakley sunglasses
replica watches
tory burch outlet online
christian louboutin sale
coach outlet online
nike sb janoski
polo ralph lauren outlet
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
BalasHapuslouis vuitton
oakley sunglasses
abercrombie and fitch new york
polo ralph lauren
louis vuitton bags
air jordan pas cher
true religion jeans
michael kors outlet
ralph lauren
replica watches
jordan retro 11
true religion outlet
louis vuitton handbags
toms outlet
kate spade handbags
louis vuitton handbags
true religion jeans sale
coach factory outlet
gucci handbags
coach outlet
jordan shoes
coach outlet
oakley vault
michael kors outlet store
louis vuitton outlet
true religion outlet
louis vuitton outlet
louis vuitton handbags
kate spade handbags
ray ban sunglasses
coach outlet store online clearances
toms shoes
air huarache
coach factory outlet
christian louboutin outlet
kd 8 shoes
air max 90
giuseppe zanotti sandals
ralph lauren outlet
louis vuitton handbags
as
cheap oakleys
BalasHapusrolex watches for sale
canada goose sale
air max
louis vuitton bags
cheap nfl jerseys
polo ralph lauren uk
rolex submariner
timberland boots outlet
louboutin outlet
louboutin shoes
michael kors bags
michael kors outlet online
valentino bags
coach purses on sale
canada goose uk
vans outlet store
air max 90
michael kors outlet clearance
cheap jordan shoes
puma outlet
gucci borse
burberry outlet canada
dior sunglasses 2016
michael kors outlet online
white converse
cheap jordan shoes
polo ralph lauren outlet online
birkenstock uk
louis vuitton purse
michael kors outlet
nike air max 90
canada goose coats
nike flyknit racer
true religion sale
cheap ray bans
adidas nmd r1
armani exchange
20160722CAIYAN
mont blanc
BalasHapustoms shoes
boston celtics jerseys
jordan femme pas cher
cheap uggs
jordans
adidas ultra boost
fitflops
fitflops sale clearance
ralph lauren outlet
louis vuitton
cheap jerseys
ed hardy clothing
ugg outlet
michael kors outlet
canada goose
gucci outlet
cheap uggs
ugg boots
mont blanc pens
ralph lauren uk
louis vuitton outlet stores
michael kors outlet
michael kors outlet
michael kors handbags
michael kors outlet
red bottom shoes
kate spade outlet
coach outlet
uggs on sale
coach outlet store online
gucci outlet
louis vuitton outlet
louis vuitton outlet
uggs for men
moncler jackets
louis vuitton outlet
oakley sunglasses wholesale
abercrombie and fitch
rolex watches outlet
20168.15wengdongdong
nike blazer low
BalasHapusoakley sunglasses
michael kors handbags wholesale
polo ralph lauren
michael kors handbags outlet
indianapolis colts jerseys
gucci borse
michael kors outlet online
michael kors handbags outlet
giants jersey
coach outlet
BalasHapusmlb jerseys
cheap oakley sunglasses
new england patriots jerseys
falcons jersey
broncos jerseys
miami dolphins jerseys
christian louboutin shoes
gucci sale
cleveland cavaliers jersey
BalasHapusشركة نقل عفش من الرياض الى جدة
شركة نقل عفش من الرياض الى الامارات شركة شحن عفش من الرياض الى الامارات
شركة نقل عفش من الرياض الى الاردن شركة شحن عفش من الرياض الى الاردن
شركة نقل عفش من الرياض الى الدمام
supreme new york
BalasHapusyeezys
michael kors outlet
timberland boots
curry 6 shoes
christian louboutin outlet
kyrie irving shoes
nike air max
lebron 16
balenciaga
jordan 1 off white
BalasHapussupreme
off white
supreme clothing
jordan retro
off white jordan 1
curry 7
kyrie spongebob
supreme new york
kd13