如何在ADO.NET中用存储过程在同一张表中添加多行？

CREATE PROCEDURE InsertMultipleRows
    @TableName NVARCHAR(50),
    @RowCount INT
AS
BEGIN
    SET NOCOUNT ON;

    DECLARE @Counter INT = 1;

    WHILE @Counter <= @RowCount
    BEGIN
        INSERT INTO @TableName (Column1, Column2, Column3) -- 替换为实际的表名和列名
        VALUES ('Value1', 'Value2', 'Value3'); -- 替换为实际的值

        SET @Counter = @Counter + 1;
    END
END

using (SqlConnection connection = new SqlConnection(connectionString))
{
    connection.Open();

    SqlCommand command = new SqlCommand("InsertMultipleRows", connection);
    command.CommandType = CommandType.StoredProcedure;

    command.Parameters.AddWithValue("@TableName", "YourTableName"); // 替换为实际的表名
    command.Parameters.AddWithValue("@RowCount", 5); // 替换为实际的行数

    command.ExecuteNonQuery();
}