beberapa waktu lalu telah ku posting cara simpan image ke database sql, jika ada yang belum baca silahkan klik disini. kali ini ku akan tulis tentang cara meload image kembali kedalam program, sebenarnya semua jenis file yang bisa di konvert ke type bloob bisa kita simpan dalam database mysql (*.doc,*.jpeg,*.bmp,*.jpg *.xls dan kawan-kawan nya), ini artinya hampir semua jenis file dapat di simpan dalam mysql. dengan cara mengkonvernya terlebih
Sekarang kita mulai saja dengan sintax sintax dalam C# untuk meload kembali gambar yang telah kita save ke dalam SQL. perhatikan potongan function di bawah ini
private void loadFromDatabase(string path)
{
path = path + "okfan.jpeg";
Byte[] blob = null;
FileStream fs = null;
MySqlConnection db = new MySqlConnection(connectionSQL);
MySqlCommand cmd = new MySqlCommand("select gambar from image where id=8",db);
db.Open();
MySqlDataReader sdr = cmd.ExecuteReader();
sdr.Read();
blob=new Byte[(sdr.GetBytes(0,0,null,0,int.MaxValue))];
sdr.GetBytes(0, 0, blob, 0, blob.Length);
sdr.Close();
db.Close();
fs = new FileStream(path,FileMode.Create,FileAccess.Write);
fs.Write(blob, 0, blob.Length);
fs.Close();
}
{
path = path + "okfan.jpeg";
Byte[] blob = null;
FileStream fs = null;
MySqlConnection db = new MySqlConnection(connectionSQL);
MySqlCommand cmd = new MySqlCommand("select gambar from image where id=8",db);
db.Open();
MySqlDataReader sdr = cmd.ExecuteReader();
sdr.Read();
blob=new Byte[(sdr.GetBytes(0,0,null,0,int.MaxValue))];
sdr.GetBytes(0, 0, blob, 0, blob.Length);
sdr.Close();
db.Close();
fs = new FileStream(path,FileMode.Create,FileAccess.Write);
fs.Write(blob, 0, blob.Length);
fs.Close();
}
script diatas adalah source untuk mencetak file dari data blob yang di load dari mysql. fs
= new FileStream(path,FileMode.Create,FileAccess.Write); adalah script untuk menentukan lokasi file yang akan kita cetak.
= new FileStream(path,FileMode.Create,FileAccess.Write); adalah script untuk menentukan lokasi file yang akan kita cetak.
blob=new Byte[(sdr.GetBytes(0,0,null,0,int.MaxValue))];
sdr.GetBytes(0, 0, blob, 0, blob.Length);
sdr.Close();
db.Close();
sedangkan beberapa baris kode diatas adalah script untuk melakukan stream blob ke dalam type data blob dalam C# (baca C Sharp). untuk baris-baris lainnya mirip dengan tutorial sebelumnya yaitu koneksi antara mysql dan C#.
untuk lebih jelasnya silahkan download binary filenya disini(ziddu) atau disini (mediafire) atau disni(4share).
untuk yang belum mempunyai database nya, silahkan download disini(ziddu) atau disini(Mediafire)
semoga tutor ini bisa bermanfaat bagi kita semua, amin......
bingung..???? kontak me on y_yahuii@yahoo.com
maaf...boleh sy tahu apa FileStream itu apa??...tiada dlm binding..jadi sy tak tahu apa macam mana nak declare fs itu..
BalasHapusFileStream merupakan salah satu function yang ada di DotNet untuk mengakses file secata stream (mengalir). Sedangkan function ini ada di library dotNet Syste.IO. Jadi untuk menggunakan fucntion ini diharuskan menyertakan library system.IO di header program. Terimakasih
BalasHapusmas punya contoh applikasi kecil kecilan misal jual beli atau yg sederhana,thx mas
BalasHapusuntuk tuturial tutorial disini selalu dipecah, sehingga tidak ada aplikasi yang sudah jadi..
BalasHapussoalnya kalau di post yang sudah jadi akan membingungkan teman teman yang masih baru belajar. Thakiu ya.....
kalo Untuk Sql Server sama egak?
BalasHapusprintah buat nampilin ke picture boxnya mana mas ?
BalasHapusoakley jawbone sunglasses oakley flak jacket sunglasses new oakley sunglasses Oakley M Frame Sunglass oakley prescription glasses warby parker sunglass hut http://www.raybansunglassesoutletsale2015.com ray ban sunglasses ray-ban sunglasses ray bans sunglasses ray ban prescription sunglasses rayban sunglasses prescription sunglasses ray ban ray ban aviators ray ban clubmaster ray bans clubmaster ray ban wayfarer ray ban new wayfarer polarized ray bans ray ban glasses ray ban prescription glasses
BalasHapuschenlina20150916
BalasHapusnike 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
hermes belt
supra shoes
celine handbags
ralph lauren
ed hardy clothing
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
BalasHapusnike blazer
moncler outlet
louis vuitton outlet
adidas superstars
nike sb
michael kors outlet online
nike uk
nike store
cheap ray ban sunglasses
toms outlet
michael kors
jordan shoes
coach canada outlet
hollisters
louis vuitton outlet
polo ralph lauren
nike air jordan
prada outlet
michael kors outlet uk
coach factory outlet
ralph lauren pas cher
michael kors
ugg boots
fitflops
coach factory outlet
louis vuitton outlet
michael kors outlet
abercrombie outlet
canada goose uk
coach factory outlet
air max 95
nike air max shoes
air jordan 13
kate spade handbags
kate spade
coach factory outlet
nike huarache trainers
christian louboutin outlet
nike trainers
coach outlet
zhengjx20160326
BalasHapusmichael kors outlet online
hollister clothing store
white converse
versace sunglasses
ralph lauren outlet
ray ban sunglasses
jordan shoes
white converse
kate spade outlet
rolex daytona
prada handbags
ray ban outlet
kate spade outlet
calvin klein dresses
supra
levis
coach factory outlet
discount oakley sunglasses
adidas shoes
nike free runs
ed hardy uk
nike store uk
true religion jeans
coach outlet
cheap ray bans
pandora charms
burberry outlet bags
hollister uk
michael kors outlet
ralph lauren pas cher
coach factory outlet online
oakley outlet store
lacoste polo shirts
polo ralph lauren outlet
nike force 1
coach outlet online
ugg outlet
hermes outlet
michael kors bags
nike huarache
coach outlet online
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
BalasHapuscopy watches
louboutin femme
ed hardy outlet
polo ralph lauren outlet
michael kors handbags
louis vuitton handbags
coach outlet
ray ban outlet
oakley sunglasses
hollister clothing
nike roshe run
burberry handbags
coach outlet store
air max 95
ray ban outlet
jordan retro 4
tory burch flats
michael kors handbags
michael kors outlet clearance
hollister clearance
michael kors outlet
jordan retro 13
michael kors outlet clearance
cheap nfl jerseys
tiffany and co
nike blazers shoes
coach factory outlet
prada handbags
timberlands
michael kors handbags
ray ban sunglasses
gucci handbgs
oakley sunglasses
louis vuitton bags
hollister clothing store
oakley outlet
tiffany and co
gucci belts
jordan 6s
louis vuitton purses
los angeles clippers
BalasHapusinstyler
bengals jersey
giuseppe zanotti shoes
boston celtics jerseys
abercrombie outlet
saints jerseys
ysl outlet online
texans jerseys
air max 2014
san diego chargers jersey
cleveland cavaliers
seattle seahawks jersey
new york knicks jerseys
valentino outlet
cleveland cavaliers jersey
jets jersey
washington redskins jerseys
fred perry polo shirts
marc jacobs
miami dolphins jersey
denver broncos jerseys
baltimore ravens jersey
new england patriots jerseys
pittsburgh steelers jersey
baltimore ravens jerseys
dallas cowboys jerseys
indianapolis colts jerseys
ferragamo outlet
colts jerseys
kansas city chiefs jersey
patriots jerseys
green bay packers jersey
nike trainers
ysl outlet
linyuan0517
chenlina20160709
BalasHapuscoach factory outlet
coach outlet store online
adidas yeezy
adidas outlet
burberry bags
polo ralph lauren
air jordans
air max 90
oakley sunglasses outlet
coach factory outlet
mont blanc
jordan 11 concord
longchamp outlet
nike roshe flyknit
louis vuitton purses
michael kors outlet
louis vuitton outlet
nike uk
fake watches
cheap nfl jerseys
tiffany outlet
louis vuitton outlet
gucci outlet
louis vuitton
true religion
michael kors handbags
hollister clothing
nike sb
polo ralph lauren outlet
celine bags
louis vuitton outlet
nike air max 90
nike factory outlet
coach factory outlet
ralph lauren outlet
beats solo
michael kors handbags
oakley vault
asics outlet
pandora jewelry
as
ray ban sunglasses
BalasHapuscoach outlet store online clearance
ralph lauren
adidas nmd uk
hermes outlet
discount oakley sunglasses
asics gel kayano
birkenstocks
uggs canada
ralph lauren uk
vans store
true religion
coach outlet online
uggs outlet
nike roshe run
louis vuitton outlet online
cheap oakley sunglasses
under armour outlet store
air max 90 white
jordan shoes
rolex replica watches
fitflops sale clearance
canada goose sale
christian louboutin uk
canada goose uk
louis vuitton purse
reebok outlet store
lacoste shoes
north face jackets
nike air max 90
coach outlet online
air jordan shoes
ray ban sunglasses outlet
longchamp bag
ugg boots
instyler max
2016722caiyan
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
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
nike blazer pas cher
BalasHapusbengals jersey
san antonio spurs
michael kors handbags
salomon shoes
toms shoes
polo ralph lauren outlet
san francisco 49ers jerseys
nike air force 1
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
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
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
Hi, Great.. Tutorial is just awesome..It is really helpful for a newbie like me.. I am a regular follower of your blog. Really very informative post you shared here. Kindly keep blogging. If anyone wants to become a .Net developer learn from Dot Net Training in Chennai. or learn thru ASP.NET Essential Training Online . Nowadays Dot Net has tons of job opportunities on various vertical industry.
BalasHapusor Javascript Training in Chennai. Nowadays JavaScript has tons of job opportunities on various vertical industry.
It seems I'm on the right track, I hope I can do well. The result was something I did and was doing to implement it.
BalasHapuswww.clickjogosclick.com
jordan 1 off white
BalasHapussupreme
off white
supreme clothing
jordan retro
off white jordan 1
curry 7
kyrie spongebob
supreme new york
kd13
f2k74b5b87 d9k78v7j26 q3l10n5h57 y1u06a7l13 c2o71y8k35 k2e02r8r10
BalasHapus