Visual Studio .NET 2002/2003 has great designer support for ADO.NET with Windows Forms and Web applications. However, I'm not doing data access directly from the presentation layer, but instead from components in a library.
Whidbey will have ADO.NET designer support for component libraries! This feature is not in the alpha builds, but it will be available with the Beta. :-)