title: Insert the date into 2 tables
body: <p>I have 2 tables like Item and Image, first table tbl_Item has 2 fields those are item code,item name and second table tbl_Image has 2 fields like item code and item image. I have fields like item code, item name, item image and one button. When i click the submit button those records are inserted into both two tables. I want to insert the data into two tables  How it is possible? Can any body suggest me?</p>
  
  <pre><code>    cmd.Connection = new SqlConnection(ConfigurationManager.ConnectionStrings[1].ToString());
      cmd.CommandText = "insert into tbl_item (@itemcode,@itemname) values(ItemCode,ItemName)";
      cmd.CommandText = "insert into tbl_image (@itemcode,@itemimage) values(ItemCode,ItemImage)";
  </code></pre>