تکرار رکورد با استفاده از for

[salmah]

با سلام می خوام با این دستور اطلاعاتی که کاربر ثبت می کنه به صورت تکراری داخل جدول ثبت بشه
و هر بار مقدار rid هم همون مقدار i بشه.
این کد را نوشتم ولی یک بار ثبت میشه و مقدار i=1 میشه

for (int i = 1; i < 20; i++)
{

SqlConnection cnc = new SqlConnection();
SqlCommand command = new SqlCommand();
SqlDataAdapter adapter = new SqlDataAdapter();
SqlCommandBuilder builder = new SqlCommandBuilder(adapter);



DataSet dst4 = new DataSet();


cnc.ConnectionString = ConfigurationManager.ConnectionStrings["shabtConnectionString"].ToString();

command.Connection = cnc;
command.CommandText = "SELECT * FROM tcod";
adapter.SelectCommand = command;
adapter.Fill(dst4, "tcod");

string dm = "13" + TextBox4.Text + "/" + DropDownList1.SelectedValue + "/" + DropDownList2.SelectedValue;

DataRow row = dst4.Tables["tcod"].NewRow();
row["nid"] = dd_nid.SelectedValue;
row["bid"] = dd_bid.SelectedValue;
row["oid"] = dd_oid.SelectedValue;
row["rid"] = i;
row["cod"] = TextBox1.Text;
row["dtamoj"] = dm;
row["shom"] = TextBox3.Text;

dst4.Tables["tcod"].Rows.Add(row);

int result = adapter.Update(dst4, "tcod");
Response.Redirect("addcod4.aspx");



}

[nice_boy_a]

سلام.

SqlConnection cnc = new SqlConnection();
SqlCommand command = new SqlCommand();
SqlDataAdapter adapter = new SqlDataAdapter();
SqlCommandBuilder builder = new SqlCommandBuilder(adapter);
DataSet dst4 = new DataSet();
cnc.ConnectionString = ConfigurationManager.ConnectionStrings["shabtConnectionString"].ToString();
command.Connection = cnc;
command.CommandText = "SELECT * FROM tcod";
adapter.SelectCommand = command;
adapter.Fill(dst4, "tcod");

for (int i = 1; i < 20; i++)
{
string dm = "13" + TextBox4.Text + "/" + DropDownList1.SelectedValue + "/" + DropDownList2.SelectedValue;

DataRow row = dst4.Tables["tcod"].NewRow();
row["nid"] = dd_nid.SelectedValue;
row["bid"] = dd_bid.SelectedValue;
row["oid"] = dd_oid.SelectedValue;
row["rid"] = i;
row["cod"] = TextBox1.Text;
row["dtamoj"] = dm;
row["shom"] = TextBox3.Text;

dst4.Tables["tcod"].Rows.Add(row);

int result = adapter.Update(dst4, "tcod");
}
Response.Redirect("addcod4.aspx");

[salmah]

تشکر درست شد