Save multiple textbox values to database
<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>
