Killsoft Sugdok

help me for multiple Table using access 2013

Go down

help me for multiple Table using access 2013

Post by zedron on Wed Nov 13, 2013 4:10 pm

hello guys

iam trying to insert into multiple table access 2013 using vb.net 2012

please help me 

this my code whats problems :

Code:
cmd.CommandText = "insert into PCGame (PCGameName,PCGameGenre,PCGameDVDNo,PCGameAgedFor,PCGamePrice) values ('" & txtpcname.Text & "','" & txtgenrepc.Text & "','" & txtcdno.Text & "','" & txtaged.Text & "','" & txtprice.Text & "')"
cmd.CommandText = "insert into PS3Game (PS3GameName,PS3GameGenre,PS3GameDVDNo,PS3GameAgedFor,PS3GamePrice) values ('" & txtsp3name.Text & "','" & txtsp3genre.Text & "','" & txtsp3cd.Text & "','" & txtsp3aged.Text & "','" & txtsp3price.Text & "')"
cmd.CommandText = "insert into PS4Game (PS4GameName,PS4GameGenre,PS4GameDVDNo,PS4GameAgedFor,PS4GamePrice) values ('" & txtsp4name.Text & "','" & txtsp4genre.Text & "','" & txtsp4cd.Text & "','" & txtsp4aged.Text & "','" & txtsp4price.Text & "')"
cmd.CommandText = "insert into XBOX360Game (XBOX360GameName,XBOX360GameGenre,XBOX360GameDVDNo,XBOX360GameAgedFor,XBOX360GamePrice) values ('" & txtxbox360name.Text & "','" & txtxbox360genre.Text & "','" & txtxbox360cd.Text & "','" & txtxbox360aged.Text & "','" & txtxbox360price.Text & "')"
cmd.CommandText = "insert into XBOXONEGame (XBOXONEGameName,XBOXONEGameGenre,XBOXONEGameDVDNo,XBOXONEGameAgedFor,XBOXONEGamePrice) values ('" & txtxboxonename.Text & "','" & txtxboxonegenre.Text & "','" & txtxboxonecd.Text & "','" & txtxboxoneaged.Text & "','" & txtxboxoneprice.Text & "')"
            dr.Close()

zedron
Newbie
Newbie

Posts : 5
Join date : 2013-11-12

Back to top Go down

Re: help me for multiple Table using access 2013

Post by giovhz on Thu Nov 14, 2013 8:47 am

zedron wrote:hello guys

iam trying to insert into multiple table access 2013 using vb.net 2012

please help me 

this my code whats problems :

Code:
cmd.CommandText = "insert into PCGame (PCGameName,PCGameGenre,PCGameDVDNo,PCGameAgedFor,PCGamePrice) values ('" & txtpcname.Text & "','" & txtgenrepc.Text & "','" & txtcdno.Text & "','" & txtaged.Text & "','" & txtprice.Text & "')"
cmd.CommandText = "insert into PS3Game (PS3GameName,PS3GameGenre,PS3GameDVDNo,PS3GameAgedFor,PS3GamePrice) values ('" & txtsp3name.Text & "','" & txtsp3genre.Text & "','" & txtsp3cd.Text & "','" & txtsp3aged.Text & "','" & txtsp3price.Text & "')"
cmd.CommandText = "insert into PS4Game (PS4GameName,PS4GameGenre,PS4GameDVDNo,PS4GameAgedFor,PS4GamePrice) values ('" & txtsp4name.Text & "','" & txtsp4genre.Text & "','" & txtsp4cd.Text & "','" & txtsp4aged.Text & "','" & txtsp4price.Text & "')"
cmd.CommandText = "insert into XBOX360Game (XBOX360GameName,XBOX360GameGenre,XBOX360GameDVDNo,XBOX360GameAgedFor,XBOX360GamePrice) values ('" & txtxbox360name.Text & "','" & txtxbox360genre.Text & "','" & txtxbox360cd.Text & "','" & txtxbox360aged.Text & "','" & txtxbox360price.Text & "')"
cmd.CommandText = "insert into XBOXONEGame (XBOXONEGameName,XBOXONEGameGenre,XBOXONEGameDVDNo,XBOXONEGameAgedFor,XBOXONEGamePrice) values ('" & txtxboxonename.Text & "','" & txtxboxonegenre.Text & "','" & txtxboxonecd.Text & "','" & txtxboxoneaged.Text & "','" & txtxboxoneprice.Text & "')"
            dr.Close()
let ask putayputay for your problem....

/
[You must be registered and logged in to see this link.]

[You must be registered and logged in to see this link.]
avatar
giovhz
Newbie
Newbie

Posts : 41
Join date : 2013-03-09

Back to top Go down

Re: help me for multiple Table using access 2013

Post by zedron on Thu Nov 21, 2013 7:46 am

i fix it

zedron
Newbie
Newbie

Posts : 5
Join date : 2013-11-12

Back to top Go down

Re: help me for multiple Table using access 2013

Post by putayputay on Thu Nov 28, 2013 11:03 am

zedron wrote:hello guys

iam trying to insert into multiple table access 2013 using vb.net 2012

please help me 

this my code whats problems :

Code:
cmd.CommandText = "insert into PCGame (PCGameName,PCGameGenre,PCGameDVDNo,PCGameAgedFor,PCGamePrice) values ('" & txtpcname.Text & "','" & txtgenrepc.Text & "','" & txtcdno.Text & "','" & txtaged.Text & "','" & txtprice.Text & "')"
cmd.CommandText = "insert into PS3Game (PS3GameName,PS3GameGenre,PS3GameDVDNo,PS3GameAgedFor,PS3GamePrice) values ('" & txtsp3name.Text & "','" & txtsp3genre.Text & "','" & txtsp3cd.Text & "','" & txtsp3aged.Text & "','" & txtsp3price.Text & "')"
cmd.CommandText = "insert into PS4Game (PS4GameName,PS4GameGenre,PS4GameDVDNo,PS4GameAgedFor,PS4GamePrice) values ('" & txtsp4name.Text & "','" & txtsp4genre.Text & "','" & txtsp4cd.Text & "','" & txtsp4aged.Text & "','" & txtsp4price.Text & "')"
cmd.CommandText = "insert into XBOX360Game (XBOX360GameName,XBOX360GameGenre,XBOX360GameDVDNo,XBOX360GameAgedFor,XBOX360GamePrice) values ('" & txtxbox360name.Text & "','" & txtxbox360genre.Text & "','" & txtxbox360cd.Text & "','" & txtxbox360aged.Text & "','" & txtxbox360price.Text & "')"
cmd.CommandText = "insert into XBOXONEGame (XBOXONEGameName,XBOXONEGameGenre,XBOXONEGameDVDNo,XBOXONEGameAgedFor,XBOXONEGamePrice) values ('" & txtxboxonename.Text & "','" & txtxboxonegenre.Text & "','" & txtxboxonecd.Text & "','" & txtxboxoneaged.Text & "','" & txtxboxoneprice.Text & "')"
            dr.Close()

u can use the INNER JOIN to insert multiple record in multiple tables.

putayputay
Newbie
Newbie

Posts : 10
Join date : 2013-03-09

Back to top Go down

Re: help me for multiple Table using access 2013

Post by putayputay on Thu Nov 28, 2013 11:07 am

zedron wrote:i fix it
hello zedron..
u can use INNER JOIN to insert a multiple records in multiple tables.

putayputay
Newbie
Newbie

Posts : 10
Join date : 2013-03-09

Back to top Go down

Re: help me for multiple Table using access 2013

Post by Sponsored content


Sponsored content


Back to top Go down

Back to top


 
Permissions in this forum:
You cannot reply to topics in this forum