public void AddSqlParameters() 
{
// ...
// create categoriesDataSet and categoriesAdapter
// ...

  categoriesAdapter.SelectCommand.Parameters.Add(
    "@CategoryName", SqlDbType.VarChar, 80).Value = "toasters";
  categoriesAdapter.SelectCommand.Parameters.Add(
    "@SerialNum", SqlDbType.Int).Value = 239;
  categoriesAdapter.Fill(categoriesDataSet);

}

using (var con = new SqlConnection("Server=.;Database=;Integrated Security=true"))
          {
              con.Open();

              using (var createType = new SqlCommand("CREATE TYPE MyIds AS TABLE (Id int)"))
              {
                  createType.Connection = con;
                  createType.ExecuteNonQuery();
              }
              using (var com = new SqlCommand("SELECT Id, FirstName FROM People WHERE Id IN (SELECT Id FROM @param)"))
              {
                  com.Connection = con;

                  var dt = new DataTable("Ids");
                  dt.Columns.Add("Id", typeof (int));
                  dt.Rows.Add(1);
                  dt.Rows.Add(2);
                  dt.Rows.Add(3);
                  dt.Rows.Add(4);
                  dt.Rows.Add(5);

                  com.Parameters.AddWithValue("@param", dt);
                  com.Parameters["@param"].TypeName = "MyIds";

                  using (var reader = com.ExecuteReader())
                  {
                      while (reader.Read())
                          Console.WriteLine("{0} {1}", reader["Id"], reader["FirstName"]);
                  }
              }

              using (var createType = new SqlCommand("DROP TYPE MyIds"))
              {
                  createType.Connection = con;
                  createType.ExecuteNonQuery();
              }
          }