i have 2 tables item , image, first table tbl_item has 2 fields item code,item name , second table tbl_image has 2 fields item code , item image. have fields item code, item name, item image , 1 button. when click submit button records inserted both 2 tables. want insert data 2 tables how possible? can body suggest me?
cmd.connection = new sqlconnection(configurationmanager.connectionstrings[1].tostring()); cmd.commandtext = "insert tbl_item (@itemcode,@itemname) values(itemcode,itemname)"; cmd.commandtext = "insert tbl_image (@itemcode,@itemimage) values(itemcode,itemimage)";
if want insert both record in single command execution join query ";".
such
cmd.commandtext = "insert tbl_item (@itemcode,@itemname) values(itemcode,itemname);insert tbl_image (@itemcode,@itemimage) values(itemcode,itemimage)";
Comments
Post a Comment