UpdateBatchSize Fires Individual Statements

In Pablo Castro webcast, First Look at ADO.NET 2.0, he mentions the use of UpdateBatchSize which I think would be handy.
However, I was not able to get it to work.



Dim t As New Global.System.Data.SqlClient.SqlDataAdapter("Select * from Table_1", Global.System.Configuration.ConfigurationManager.ConnectionStrings("ConnectionString1").ConnectionString)
Dim d As New Global.System.Data.DataTable
t.FillSchema(d, SchemaType.Source)
Dim cb As New Global.System.Data.SqlClient.SqlCommandBuilder(t)
For c As Int32 = 1 To 10000
Dim r As Global.System.Data.DataRow = d.NewRow
r("id") = Global.System.Guid.NewGuid
r("val") = CType(Rnd(), Int32)
d.Rows.Add(r)
Next
t.UpdateBatchSize = 100
t.Update(d)
d.Dispose()
t.Dispose()



What ends up showing in Sql Server Profiler (Sql Server 2005) is each Insert being executed in it's own statement:
exec sp_executesql N'INSERT INTO [Table_1] ([id], [val]) VALUES (@p1, @p2)',N'@p1 uniqueidentifier,@p2 int',@p1='3793CB5E-3B7A-45E7-9A53-0BD528BB6B07',@p2=1

I think I made this example very simple and yet can't fathom why it won't batch the statements.

I'm somewhat aware of SqlBulkCopy and was very pleased with that speed, but don't think it would handle the Update,Delete,Insert that the SqlDataAdapter.Update would.

Originally started using xsd DataSets until I saw the data tutorials in the Learning section here in which case I copied out the autogenerated TableAdapter classes and fuddling with them to do what I want since batching was not something I saw in TableAdapters.

Does anyone see what I'm missing here?
Nathan