help me for multiple Table using access 2013
3 posters
Page 1 of 1
help me for multiple Table using access 2013
hello guys
iam trying to insert into multiple table access 2013 using vb.net 2012
please help me
this my code whats problems :
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
- Posts : 5
Join date : 2013-11-12
Re: help me for multiple Table using access 2013
let ask putayputay for your problem....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()
giovhz- Newbie
- Posts : 41
Join date : 2013-03-09
Re: help me for multiple Table using access 2013
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
- Posts : 10
Join date : 2013-03-09
Re: help me for multiple Table using access 2013
hello zedron..zedron wrote:i fix it
u can use INNER JOIN to insert a multiple records in multiple tables.
putayputay- Newbie
- Posts : 10
Join date : 2013-03-09
Similar topics
» help me vb.net whent try record in access 2013
» How to connect Ms Access to vb.net
» how to insert/add record in ms access using vb.net
» how to delete record in ms access using vb.net
» how to update record in ms access using vb.net
» How to connect Ms Access to vb.net
» how to insert/add record in ms access using vb.net
» how to delete record in ms access using vb.net
» how to update record in ms access using vb.net
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum