July 2004 - Posts

Pablo Castro just posted a new Article on MSDN

Published Mon, Jul 12 2004 15:09 | William

And It's very cool

Filed under: Data Access

Part I - Subclassed ADO.NET 2.0 DataSet with Binary Serialization Support

Published Mon, Jul 12 2004 3:30 | William

I'm just finishing up with it but need to go to sleep. Anyway, here's a quick shell of a DataSet subclassed to handle serialization to Binary for you. I have some work to do for the Deserialization routine - it's still pretty easy but a little trickier...

Filed under: Data Access

Portable Media Center (Creative Zen, Samsung Yepp) can be Pre-Ordered on Amazon

Published Mon, Jul 12 2004 3:20 | William

I haven't used a Samsung Yepp - YH 990 yet, but I”ve used the heck out of the Creative Zen . They can now be Pre-Ordered on Amazon. If you have a few extra dollars, you won't be disappointed with one of the gadgets.

"Shared Memory Provider: This network connection does not exist" - With C# Express/ Visual Basic .NET Express & ADO.NET 2.0

Published Mon, Jul 12 2004 1:21 | William

I've had this "Shared Memory Provider: This network connection does not exist" problem each time I try to connect to a given SQL Server on my network but there's an easy resolution. I was lazy and have a ConnectionString or two in text files that VS 2003...

Filed under: Data Access

Binary Serialization of DataSets

Published Mon, Jul 12 2004 1:00 | William

Haven't written anything in VB.NET for a while so I figured I'd give it a try. Anyway, I posted an article at www.knowdotnet.com/articles/binaryserialization.html but here's the gist of it. I have a subclassed dataset that has WriteBinary and ReadBinary...

Filed under: Data Access

Updated list of Windows Mobile/Compact Framework Links

Published Sun, Jul 11 2004 18:37 | William

Compiling links and keeping them update is always a pain - Thanks for Derek Mitchell for these!

Filed under: Compact Framework

ADO.NET 2.0 Object Binding by Rocky Lhotka

Published Sat, Jul 10 2004 5:48 | William

Rocky is a superb writer and does a great job discussing some Cool New Features in ADO.NET 2.0.

Filed under: Data Access

Rory's Back! Yet I feel REALLY Inadequate now

Published Sat, Jul 10 2004 4:07 | William

Yes, I know, absolutely 0 flare on my sight.. maybe someday http://neopoleon.com/blog/posts/7070.aspx

Filed under: News

SqlBulkCopy Sample

Published Sat, Jul 10 2004 3:23 | William

I'm having some network connectivity issues and it's pissing me off b/c I can't figure it out. Anyway, I've got some pretty impressive numbers so far. I'm testing it with all of the SqlBulkCopyOptions(CheckConstriants, Defualts, FireTriggers, KeepIdentity...

Filed under: Data Access

.AcceptChangesDuringUpdate

Published Sat, Jul 10 2004 2:30 | William

Just came across something that was totally by accident - the SqlDataAdapter's .AcceptChangesDuringUpdate method. Back in the day, as in now, when you call the .Update method, .AcceptChanges is called as each row is updated. This can be a pain if you...

Filed under: Data Access

Official word on ObjectSpaces

Published Fri, Jul 9 2004 9:58 | William

I've mentioned it previously but ObjectSpaces are dead in VS 2005. The official statement is here. Fortunately there's enough other cool stuff to keep occupied with in the interim ;-)

Filed under: Data Access

Dino Esposito on ADO.NET 2.0

Published Fri, Jul 9 2004 1:07 | William

Just came across Dino's latest post on ADO.NET 2.0 based on his speech at TechEd Europe.

Filed under: Data Access

Life in Georgia...

Published Fri, Jul 9 2004 1:04 | William

Growing up in Miami I got used to this type of crap but I still have to chuckle when I see it

Filed under: Humor

Binary Serialization, DataTables and DataSets

Published Fri, Jul 9 2004 1:01 | William

An interesting feature indeed. If you haven't heard, ADO.NET 2.0 has a much better serialization story than the previous versions did. The main thing is that you can use WriteXML/ReadXML on a DataTable, not just a DataSet. If you've played with DataSets...

Filed under: Data Access

Compact Framework Chat - Beginning now

Published Thu, Jul 8 2004 13:00 | William

Here's the link http://communities2.microsoft.com/home/chatroom.aspx?siteid=34000070

Filed under: Compact Framework

New Bulk Insert Feature..

Published Thu, Jul 8 2004 3:35 | William

Well, I'm still up - tried to sleep but just tossed and turned. I can't wait, I get to head to work in just 4 hours and there's just about 0 chance of getting much sleep tonight. Probably will get tired around 4:30 like usual. Anyway, I started working...

Filed under: Data Access

Scott just posted some new cool articles

Published Thu, Jul 8 2004 1:15 | William

You'll definitely want to check http://www.odetocode.com/blogs/scott/ out. I love playing with WS and have used Google's quite a bit. Used Amazon's when I've been up too late a few times, but Scott has a very cool piece.

A quick TransactionScope Example

Published Thu, Jul 8 2004 0:57 | William

Ok, I promised I'd have some examples by Monday and I'm late. Anyway, I'm working on a full fledged article where I really test this thing including MessageQueue as well but this gives you the gist of it. Basically it's just a fleshed out example of what...

Filed under: Data Access

Swooning over Deklarit again...

Published Wed, Jul 7 2004 16:57 | William

I know, I swoon over them all the time but it's just such a damned cool and time saving tool. Actually pulled of an app today, 6 classes, three forms, w/ lookups and filtering - in just under 15 minutes. I know I know, big deal. But it really is b/c there...

Filed under: Data Access

The TransactionScope Object - it rocks

Published Wed, Jul 7 2004 16:11 | William

Angel just posted this example on using the TransactionScope. If you haven't had a chance to play with it or see what it's about - you're definitely missing out in a big way.

Filed under: Data Access