This Issue Sponsored By

InstallShield X

http://www.installshield.com/SQLServerDeveloper0504

SQL Server Magazine's Online Resources Can Help

http://anon.doubleclick.speedera.net/anon.doubleclick/PentonMedia/SQL051204.html

In This Issue

1. Developer .NET Perspectives

  • The Future of the Compact Framework
  • 2. Resource

  • Featured Thread: Problem with Visual Basic .NET Connection
  • 3. New and Improved

  • Developer Tools for GPS and Mapping



  • Sponsor: InstallShield X

    From Windows to Linux, Servers to Mobile, Your one solution for Installation Authoring. InstallShield redefines installation authoring with InstallShield X. InstallShield X combines the power and flexibility of InstallShield DevStudio with the unparalleled platform support of InstallShield MultiPlatform into one revolutionary installation-authoring solution for all platforms, operating systems, and devices. Powerful features such as a Dialog Editor, advanced debugging tools, and Visual Studio.NET integration allow you to author MSI, InstallScript(tm), and cross-platform installations with one, easy-to-use tool. Advanced features allow you to configure database servers, install web services, and create mobile device installations. For your installation needs today, and your emerging needs tomorrow, there's only one tool you will ever need: InstallShield X.

    http://www.installshield.com/SQLServerDeveloper0504

    Developer .NET Perspectives

    by Marquis Howard, marquish@interknowlogy.com

  • The Future of the Compact Framework
  • I've seen and developed some cool, useful applications that showcase the power of the Windows .NET Compact Framework. The Compact Framework provides a set of tools for creating rich mobile applications. However, one question people often ask when considering whether they should use the Compact Framework is: What are the future plans for this technology? With Microsoft TechEd 2004 taking place next week, let's take a look at the Compact Framework's current capabilities and what Microsoft has in store for the Compact Framework in the not-too-distant future.

    You develop Compact Framework applications in Visual Studio .NET. With Visual Studio .NET, Microsoft did a great job of unifying a single development environment, no matter whether you're creating a Web, desktop, or mobile-device application. Switching between the different environments is a thing of the past. Visual Studio .NET provides a common look and feel for all types of development tasks, which simplifies the developer's job.

    Visual Studio .NET's Toolbox for each type of application looks pretty much the same. Your target platform determines the actual tools, or "controls," in the Toolbox. Because the Compact Framework is a scaled down version of the full Windows .NET Framework, Visual Studio .NET supports fewer controls in the Compact Framework than the full Framework. For example, Visual Studio .NET supports the DateTimePicker control (which lets users choose a date from a pop-up calendar) and the Calendar control (which provides users with a calendar in which they can select dates) in the full Framework but not the Compact Framework. Although you can create custom controls in the Compact Framework to perform the same functions as the DateTimePicker and Calendar controls in the full Framework, the task isn't easy. (For information about how to create a custom DateTimePicker control, go to http://msdn.microsoft.com/mobility/default.aspx?pull=/library/en-us/dnnetcomp/html/DTPick_WD.asp. For information about how to create custom controls in general, go to http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnnetcomp/html/customctrlscompactfx.asp.) Having native support for the DateTimePicker and Calendar controls in the Compact Framework would make developing a mobile-device application that relies on date-driven interaction much easier.

    Some controls in the Compact Framework don't have the same properties available as their Framework counterparts. Take, for example, the Label control. In a full Framework application, developers often use the BackColor property with the Label control. The BackColor property lets you customize a label's background color. This property, however, isn't available in the Compact Framework. Again, although you could create a custom control with this property exposed, a lot of extra work is involved.

    Fortunately, in Visual Studio 2005 (formerly code-named Whidbey), Microsoft is supercharging the Toolbox for the Compact Framework. Microsoft is not only overhauling some existing controls but also adding some new controls. For example, Microsoft is overhauling the Label control so that it will support the BackColor property and is adding the DateTimePicker and Calendar controls.

    DateTimePicker will be a drag-and-drop control. One useful feature will be the Format property. With this property, you can specify how you want the date displayed. You can select from one of the predefined formats or create your own format.

    The Calendar control will have the typical properties that you'd expect from this control. Unlike the DateTimePicker control, you can select more than one date with this control.

    Other neat controls that will be in your Visual Studio 2005 Toolbox for the Compact Framework include:

    • the WebBrowser control. The WebBrowser control lets you display Web pages in your client applications. Alternatively, you can use the control as a simple HTML document viewer or to add Dynamic HTML (DHTML)-based UI elements to your form. Either approach lets you seamlessly combine Web-based elements into your form-based application.
    • the LinkLabel control. The LinkLabel control lets you set a link to a file, folder, or Web page.
    • the Pocket PC Notification control. The Pocket PC Notification control lets you set up different types of notifications on a device, such as reminder or information messages. One way to use this control is to have it pop up a balloon message after a Web service call has returned. If the return information meets certain criteria, a notification message is sent.
    • the RichInk control I believe that RichInk control will be one of my favorites. Using this control, your application will be able to capture and save signatures as bitmap files.

    These controls are only some of the new and exciting enhancements to look forward to in Visual Studio 2005. Although Visual Studio 2005 is about a year away from release, these enhancements demonstrate that the Compact Framework has a bright future. The Compact Framework provides a robust, constantly growing set of tools that you can use to create rich, intuitive applications for mobile devices.


    Sponsor: SQL Server Magazine's Online Resources Can Help

    Visit the SQL Server Magazine Web site and access a library of valuable SQL Server tools and information. Take advantage of the search box and navigation toolbars that connect you to hot topic discussions involving SQL Server 2005, reporting services, backup and recovery and much more. Choose from a treasury of new articles, active forums, archived articles, savvy tips, endless code listings, and more! Let this resource help to save you some time. Click here:

    http://anon.doubleclick.speedera.net/anon.doubleclick/PentonMedia/SQL051204.html

    Announcements
    (brought to you by SQL Server Magazine)

  • Have You Created an Innovative SQL Server Solution?

  • If so, you qualify to enter this awards program. Announcing the 3rd annual SQL Server Magazine Innovator Awards. The grand-prize winner will win a free trip to the 2004 SQL Server Magazine Connections conference in Las Vegas and a special trophy. Fill out an entry form today to get the recognition you deserve. Click here:

    http://www.sqlmag.com/awards

  • SqlJunkies Has What Developers Need

  • SqlJunkies is your online community resource for original tutorial and how-to articles for developing applications with SQL Server 2000 and Yukon; peer-to-peer help and networking through discussion forums and newsgroups; technology tips and pointers from expert bloggers; and the latest in SQL Server-related events and news.

    http://www.sqljunkies.com

    Resource

  • Featured Thread: A Problem with Visual Basic .NET Connection
  • Expert forum member pklages needs to set a database to the single user setting so that a process can run with another application, then set the database back to the multiuser setting. He's written a Visual Basic .NET program that will change the settings with a button click. The Visual Basic .NET program opens a connection to the database, uses a stored procedure to set the single user setting, closes the connection, then exits. When pklages opens SQL Server Enterprise Manager and tries to open a connection to the database to view the data, he isn't allowed access. He thought that closing the database connection and Visual Basic .NET program would release the one connection and allow Enterprise Manager to make the other connection, but it's not. If you have any ideas about why the Visual Basic .NET program might be retaining the connection, go to the following URL:

    http://www.winnetmag.com/forums/rd.cfm?cid=1670&tid=120973

    Events Central
    (A complete Web and live events directory brought to you by Windows & .NET Magazine: http://www.winnetmag.com/events )

  • SQL Web Seminar--Integrated Business Intelligence Solutions
  • Discover the endless benefits of performance management and business intelligence within your organization. Register today for this free, interactive Web seminar on June 10, and learn how to access valuable information to understand business performance, leverage existing infrastructures to lower total costs of ownership, gain visibility in results, and much more. Register now:

    http://www.winnetmag.com/seminars/sqlBIsolutions/index.cfm?code=0520dupdate

    New and Improved

  • Developer Tools for GPS and Mapping
  • franson.biz released GpsTools 2.0, developer tools that provide an easy, cost-efficient way to include Global Positioning System (GPS) and mapping support to applications developed in Visual Studio. The samples and documentation make it easy for software developers new to geographic information systems (GIS) quickly access GPS position, speed, and satellite information, without any knowledge of low-level GPS protocols. GpsTools is available for Windows and Pocket PC as ActiveX, Windows .NET Framework, and Windows .NET Compact Framework components. Pricing starts at $49 for a single user license. Contact franson.biz at (46) (70) 238-02-00 or support@franson.biz.

    http://franson.biz/gpstools

    Contact Us

  • About Developer .NET Perspectives -- bills@interknowlogy.com
  • About the newsletter -- kbemowski@winnetmag.com
  • About technical questions -- http://www.sqlmag.com/forums
  • About product news -- products@sqlmag.com
  • About your subscription -- Developer_dot_NET_update@winnetmag.com
  • About sponsoring an UPDATE -- contact Kate Silvertooth (ksilvertooth@sqlmag.com)
  • This email newsletter is brought to you by Windows & .NET Magazine, the leading publication for IT professionals deploying Windows and related technologies. Subscribe today.

    http://www.winnetmag.com/sub.cfm?code=wswi201x1z

    View the Windows & .NET Magazine Privacy policy at

    http://www.winnetmag.com/aboutus/index.cfm?action=privacy

    Windows & .NET Magazine, a division of Penton Media, Inc.
    221 East 29th Street, Loveland, CO 80538
    Attention: Customer Service Department

    Copyright 2004, Penton Media, Inc. All Rights Reserved.