Home > Microsoft .Net Development Tips > Microsoft Office Development > WinForms development using SQL Server 2005 and Visual Basic 2005
Win Development Tips:
EMAIL THIS
 TIPS & NEWSLETTERS TOPICS 

MICROSOFT OFFICE DEVELOPMENT

WinForms development using SQL Server 2005 and Visual Basic 2005


SearchVB.com staff
05.25.2007
Rating: --- (out of 5)


Office Development Channel
Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us    Add to Google


For WinForms developers, data-driven development can be a bit tricky. Visual Basic 2005 does provide built-in designers, which walk folks through processes like connecting to a database, running data queries and then bringing data into the UI, but additional assistance never hurt anyone.

That's where Microsoft's Visual Basic WinForms over Data Video Series comes into play. This eight-part series, narrated by Visual Basic team member and frequent blogger Beth Massi, illustrates how to set up a SQL Server 2005 database and connect it to a WinForms application written in Visual Basic 2005. The steps detailed in this series can be taken using the free tools, too -- SQL Server 2005 Express and Visual Basic 2005 Express.

Part 1: Create a SQL Server 2005 database -- Watch | Download
Part 2: Create a WinForms app, connect it to a database -- Watch | Download
Part 3: Create a Master-Detail Form in Visual Basic 2005 -- Watch | Download
Part 4: Create a search form using Visual Basic 2005 -- #ilrContainerLogin, ilrContainerRegister { width: 430px; margin: 0; } .ilrLoginRed { padding-left:3px; padding-top:15px; padding-bottom:15px; } #ilrFormWrapper { width:428px; margin:0px; border:1px solid #d4d4d4; } #ilrFormHeaderBack { background-image: url('http://media.techtarget.com/digitalguide/images/Misc/ilr_header_background.gif'); background-repeat: no-repeat; height:34px; } .ilrFormHeader { padding:5px 5px 5px 35px; font-size: 16px; font-family: arial, helvetica, sans-serif; color:#787878; } #ilrFormBody { background-color:#ffffd4; } .ilrFormBodyHeader { padding-top:15px; padding-left:12px; padding-right:12px; padding-bottom:20px; } .ilrFormBodyHeaderLogin { padding-top:15px; padding-left:9px; padding-right:8px; padding-bottom:20px; } .ilrFormBodyFooter { padding-top:15px; padding-left:12px; padding-right:40px; padding-bottom:20px; } form.ilr { margin: 0; padding: 0; min-width: 428px; max-width: 428px; width: 428px; } form.ilrLogin { margin: 0; padding: 0; min-width: 428px; max-width: 428px; width: 428px; } form.ilr label { display: block; float: left; width: 140px; margin: 5px 0 0; text-align: left; } form.ilrLogin label { display: block; float: left; width: 65px; margin: 5px 0 0; text-align: left; } form.ilr br { clear:left; } form.ilrLogin br { clear:left; } form.ilr input, form.ilr option, form.ilr select { width:auto; margin:4px 5px 0 0px; } form.ilrLogin input, form.ilrLogin option, form.ilrLogin select { width:auto; margin:4px 5px 0 0px; } .inputImage { padding-left:150px; padding-bottom:15px; } .inputImageLogin { padding-left:175px; padding-bottom:15px; } .formFieldsPadding { padding-left:35px; }


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us    Add to Google



RELATED CONTENT
Visual Basic and Visual Basic .NET
Compose XML more quickly using Visual Basic 9
Virtualization keeps Legacy Apps alive
VB 9 Anonymous Types help create flexible objects
Visual Studio Team System Add-ins: Conchango Scrum for Team System and Scrum Dashboard
Book Excerpt: Sams Teach Yourself Visual Basic 2008 in 24 Hours -- Complete Starter Kit
Check out CodePlex for a ton of interesting .NET projects
Book excerpt: Murach's VB 2008
Book excerpt: Printing in Visual Basic 2005
Visual Basic 2008 and closures
Visual Basic 2005 and objects: Building a business object layer

Microsoft Office Development
Downloadable MSDN library released for VS 2008 SP 1
Check the MSDN Virtual Labs for regular, compelling new content
Windows XP SP3 pack includes new XML parser, enhanced IP security
Book excerpt: Building personalized solutions in SharePoint 2007
Book excerpt: Building document management solutions in SharePoint 2007
XAML as an everywhere presentation format
Where are the Visual Studio 2008 Tools for Office?
ClickOnce: Automated smart client deployment
Book excerpt: SharePoint 2007 and content types
Update desktops automatically using the AppUpdater component

Microsoft SQL Server
Using the Visual Studio 2005 DataSet Designer to build a data access layer
The CTE, the hierarchical query and SQL Server 2005
SQL Server 2005 recursive functions and the CTE
Choose the right .NET data provider, optimize application performance
The fallacy of the data layer -- or, a new architectural model for software designs
Book excerpt: ADO.NET and SQL Server 2005
Addressing common SQL Server questions
Book Excerpt: The .NET Framework and SQL Server 2005
Configuring ASP.NET 2.0 apps to SQL Server 2005 databases
Book excerpt: Retrieve data from a SQL Server 2005 table

RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary


efb6e/4CreatingASearchForm.wmv">Watch | Download
Part 5: Create a lookup list using a ComboBox -- Watch | Download
Part 6: Filter data in a WinForms client application -- Watch | Download
Part 7: Use AutoComplete in a ComboBox or TextBox -- Watch | Download
Part 8: Format data in WinForms controls -- Watch | Download

  • More on WinForms development from SearchVB.com
    What's new in WinForms 2.0?
    Applications: Chapter 14 of WinForms 2.0 Programming

  • More on SQL Server 2005 development from SearchVB.com
    Book excerpt: Retrieve data from a SQL Server 2005 table


    Rate this Tip
    To rate tips, you must be a member of SearchWinDevelopment.com.
    Register now to start rating these tips. Log in if you are already a member.




    DISCLAIMER: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.



    • Database Programming Solutions - .NET XML, Visual Studio LINQ, ORM .NET
    About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
    SEARCH 
    TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.

    TechTarget Corporate Web Site  |  Media Kits  |  Site Map




    All Rights Reserved, Copyright 2000 - 2009, TechTarget | Read our Privacy Policy     		  TechTarget - The IT Media ROI Experts