使用asp.net c#将大型asp.net控件数据按行插入sql表中

string connectionString = "Data Source=数据库服务器地址;Initial Catalog=数据库名称;User ID=用户名;Password=密码";
SqlConnection connection = new SqlConnection(connectionString);

connection.Open();

SqlCommand command = new SqlCommand();
command.Connection = connection;

foreach (GridViewRow row in gridView.Rows)
{
    // 获取每一行中的数据
    string column1Value = row.Cells[0].Text;
    string column2Value = row.Cells[1].Text;
    // ...

    // 构造插入数据的SQL语句
    string insertQuery = "INSERT INTO 表名 (列1, 列2) VALUES (@Column1Value, @Column2Value)";
    command.CommandText = insertQuery;

    // 添加参数并设置参数值
    command.Parameters.Clear();
    command.Parameters.AddWithValue("@Column1Value", column1Value);
    command.Parameters.AddWithValue("@Column2Value", column2Value);
    // ...

    // 执行插入操作
    command.ExecuteNonQuery();
}

connection.Close();