Binding a user defined table type for use within an IN clause.

bind_table_type.cs

DataTable dt = new DataTable();
dt.Columns.Add("id", typeof(int));
var row = dt.NewRow();
row["id"] = 1;
dt.Rows.Add(row);
row = dt.NewRow();
row["id"] = 2;
dt.Rows.Add(row);
SqlConnection conn = new SqlConnection("Data Source=localhost;Integrated Security=SSPI;Initial Catalog=test");
conn.Open();
SqlCommand cmd = new SqlCommand("usp_GetDetails @ids", conn);
SqlParameter param = cmd.Parameters.AddWithValue("@ids", dt);
param.SqlDbType = SqlDbType.Structured;
param.TypeName = "dbo.PrimaryKeyINT";
var reader = cmd.ExecuteReader(CommandBehavior.CloseConnection);
while (reader.Read()) {
    Object[] values = new Object[reader.FieldCount];
    int fieldCount = reader.GetValues(values);
    Console.WriteLine(String.Format("ID:{0}, Product:'{1}', Date:{2}, Price:{3}", values));
}
Console.ReadLine();