c# - Insert the date into 2 tables -


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