int i;
if (int.TryParse(myTextBox.Text, out i))
{
using (SqlConnection con = new SqlConnection(strConnect))
{
con.Open();
while (i > 0)
{
using (SqlCommand cmd = new SqlCommand("INSERT INTO myTable (NameColumn, CityColumn) VALUES (@NM, @CT)", con))
{
cmd.Parameters.AddWithValue("@NM", name);
cmd.Parameters.AddWithValue("@CT", city);
cmd.ExecuteNonQuery();
}
i--;
}
}
}