将多列从c#传递到sql server中的用户定义的表类型。

CREATE TYPE MyTableType AS TABLE
(
    Column1 INT,
    Column2 VARCHAR(50)
)

DataTable table = new DataTable();
table.Columns.Add("Column1", typeof(int));
table.Columns.Add("Column2", typeof(string));

table.Rows.Add(1, "Value1");
table.Rows.Add(2, "Value2");

using (SqlConnection connection = new SqlConnection(connectionString))
{
    connection.Open();
    
    using (SqlCommand command = new SqlCommand("YourStoredProcedure", connection))
    {
        command.CommandType = CommandType.StoredProcedure;
        
        SqlParameter parameter = command.Parameters.AddWithValue("@TableParam", table);
        parameter.SqlDbType = SqlDbType.Structured;
        parameter.TypeName = "dbo.MyTableType";
        
        command.ExecuteNonQuery();
    }
}