Source: www.computervideos.110mb.com
Now see how to pass values from VB.Net to SQL Server Stored Procedure and return results back! Download View Online
Wednesday, November 7, 2007
Passing Params from VB.Net to Stored Procedures
Tags SQL Server, VB.Net
Calling a Stored Procedure from your VB.Net Program
Source: www.computervideos.110mb.com
Explains how to call a SQL Server stored procedure from VB.NET. Download View Online
Tags SQL Server, VB.Net
What is a SQL Parameter? Check this out!
Source: www.computervideos.110mb.com
See how easy it is to create Parameters in SQL Server and then pass values to it using VB.Net. Download View Online
Tags SQL Server, VB.Net
Sunday, November 4, 2007
Saturday, November 3, 2007
Creating new DotNetNuke modules
Source: JumpStart TV
In this video, Brian shows you how to create modules for DotNetNuke. He covers the code to build your own module, which expands the power of the most widely used portal software on the web. View online
Tags DotNetNuke, VB.Net
Joining Tables
Source: JumpStart TV
Part 1: In this video for beginners you'll begin to learn how to write queries that use more than one table using T-SQL. Kathi walks you through common tactics to efficiently pull out data from a normalized system. View online
Part 2: In this session, Kathi continues her popular series and shows some of the more advanced joining techniques in T-SQL. She shows T-SQL self, outer and cross joins and gives many examples on how to use them. View online
Tags SQL Server, T-SQL
Writing simple SELECT statements
Source: JumpStart TV
Part 1: In this video, you'll learn how to write basic select statements. This beginner video takes you from the ground up writing T-SQL. View online
Part 2: In this second part video from Kathi, she covers how to write T-SQL in much more indepth. She covers how to handle NULLs and many more items in this video. View online
Part 3: In this video, Kathi continues her T-SQL series and exands how to use the WHERE clause. View online
Tags SQL Server, T-SQL
Using Database DDL Triggers
Source: JumpStart TV
In this short demonstration, you'll learn how to use DDL database triggers to prevent changes to product and audit changes to comply with Sarbanes-Oxley and other change management requirements. View online
Tags SQL Server, T-SQL
Designing .NET Class Libraries
This class presents best practices for designing frameworks that are reusable object-oriented libraries. The guidelines are applicable to frameworks ranging in size and in their scale of reuse from large system frameworks to small components shared among several applications. They started as a small set of naming and design conventions, but have been enhanced, scrutinized, and refined to a point where they are generally considered the canonical way to design frameworks at Microsoft. They carry the experience and cumulative wisdom of thousands of developer hours, over three versions of the .NET Framework.View online
Tags C#, Software Design
Using Common Table Expressions
How and when to use this new feature of SQL Server 2005.
Source: TrainingSpot.com. Watch Online
Tags SQL Server
Understanding and Implementing Default Constraints
Shows how to implement Default Constraints on columns.
Source: TrainingSpot.com. Watch Online
Tags SQL Server
VB.NET 2005 Tutorial: IF
The Second Visual Basic .NET 2005 tutorial shows of one of the most essential functions in programming in general. The IF function.
Source: Connect Untouchable. Download
Tags VB.Net
VB.NET 2005 Tutorial: Hello World
Source: Connect Untouchable
The first tutorial guides you through the making of your first simple application! Great for getting started! Download
Tags VB.Net
Understanding Security and Network Connectivity in SQL Server 2005 Express Edition
Source: LearnVisualStudio.NET
Explore scenarios for connecting to SQL Server 2005 Express databases, enabling and disabling user instances, login permissions, and other security precautions. Download
Tags SQL Server
How to call other applications using the Process control
Source: LearnVisualStudio.NET
This video shows how to use the Process control to automate running external applications like Notepad and Internet Explorer from within your code. Download
Tags Visual Studio