title: Save multiple textbox values to database
body: <p>I'm trying to save multiple textbox values to database into multiple rows. My form is as follows</p>
  
  <p>textbox1 texbox 2  ---- row 1 in database</p>
  
  <p>textbox3 textbox 4  ------row 2 in database</p>
  
  <p>edit: I should clarify that textbox 1 and texbox 3 are in the same column and using the same param1</p>
  
  <p>Ive been to save single values before using </p>
  
  <pre><code> cnn.Open();
      SqlTransaction tran = cnn.BeginTransaction();
      cmd.Connection = cnn;
      cmd.Transaction = tran;
      cmd.CommandText = "stored procedure";
      cmd.CommandType = CommandType.StoredProcedure;
      cmd.Connection = cnn;
      SqlParameter p1 = new SqlParameter("@param1", SqlDbType.Int);
      SqlParameter p2 = new SqlParameter("@param2", SqlDbType.Int);
      cmd.Parameters.Add(p1);
      cmd.Parameters.Add(p2);
  </code></pre>