Ebook List

Ebook page contain :

• Visual Basic 2005 Cookbook
• Visual Basic 2005, a developers notebook.chm
• OReilly.Visual.Basic.2005.in.a.Nutshell.3rd.Edition.Jan.2006.chm
• Visual Basic 2005 Express Edition For Dummies Dec 2005 eBook-DDU.pdf

You can download from here

Blogged with the Flock Browser

Tags: ebook, vb 2005, visual basic 2005

Visual Studio 2005 Cookbook – Database, Using SQL Parameters

Recipe 13.4. Using SQL Parameters

Problem

You need to insert a lot of records into a table, and you would like to simply replace the new data values in the SQL statement without having to build the SQL statement from scratch each time.

Solution

Attach one or more Parameter objects to the Command object.

Discussion

The following SQL Server example inserts new records

Visual Studio 2005 Cookbook – Database, Retrieving Results from a Database Query

Recipe 13.3. Retrieving Results from a Database Query

Problem

You’ve issued INSERT, UPDATE, and DELETE statements through a command object, but you need to retrieve some data with a SELECT statement.

Solution

Use a DataReader object to quickly review the results of a SELECT statement.

Discussion

The following code retrieves a

Visual Basic 2005 Cookbook – Database, Issuing SQL Commands

Recipe 13.2. Issuing SQL Commands

Problem

Now that you’ve established a connection to a database through a provider, you’re ready to issue SQL commands. But how?

Solution

Use a Command object to issue SQL commands directly to your database through the provider connection.

Discussion

The following code updates a SQL Server table named Table1, changing every Column2 field to 25 whenever Column1 has a value of 0:

	' ----- Connect to the database.
	Dim connectionString As String = _
	   "Data Source=MySystem\SQLEXPRESS;" & _
	   "Initial Catalog=MyDatabase;Integrated Security=true"
	Dim theDatabase As New SqlClient.SqlConnection(connectionString)
	theDatabase.Open()

	' ----- Prepare the SQL statement for use.
	Dim sqlStatement As New SqlClient.SqlCommand( _
	   "UPDATE Table1 SET Column2 = 25 WHERE Column1 = 0", _
	   theDatabase)
	sqlStatement.ExecuteNonQuery()

	' ----- Clean up.
	theDatabase.Close()
	theDatabase.Dispose()

Just like connections, command objects are provider-specific. When using the SQL Server

Visual Basic 2005 Cookbook – Database, Connecting to a Data Provider

Recipe 13.1. Connecting to a Data Provider

Problem

You are writing an application that interacts with a database, and you need to connect to it to run some queries.

Solution

Use a Connection object and a “connection string” to establish the connection you will use for queries and updates.

Discussion

The following set of statements establishes a connection to a SQL Server Express database named MyDatabase running on the system named MySystem, using the active Microsoft Windows login account for its security access:

	Dim theDatabase As System.Data.SqlClient.SqlConnection
	Dim connectionString As String = _
	   "Data Source=MySystem\SQLEXPRESS;" & _
	   "Initial Catalog=MyDatabase;Integrated Security=true"

	theDatabase = New SqlClient.SqlConnection(connectionString)
	theDatabase.Open( )
	' ---- Perform database processing here, then…
	theDatabase.Close( )
	theDatabase.Dispose( )

ADO.NET includes several different database libraries. The most generic library, found in the System.Data namespace, defines the core classes used to manage database sets in memory. There are distinct classes for tables, columns, and rows of data; classes that let you establish relationships between the tables; and classes that let you bundle tables and relationships in one large “data set.” You will probably use these classes quite a bit in your code, but they

Visual Basic 2005 Cookbook – Creating a Console Application

Recipe 1.2. Creating a Console Application

Problem

You want to develop a Console application that converts between the Fahrenheit, Celsius, and kelvin temperature systems.

Solution

Create a Windows Console application, and add logic to perform all the calculations based on the user’s input. First, read through Recipe 1.1 for background information on using Visual Studio and on converting between the various temperature systems.

Discussion

Start Visual Studio 2005, and then use the File  New Project menu command to create a new project. Select the Windows project type, and then select the Console Application template. Click OK

Visual Basic 2005 Cookbook, Recipe 1.1. Creating a Windows Forms Application

Recipe 1.1. Creating a Windows Forms Application

Problem

You want to develop a Windows Forms application that converts between the Fahrenheit, Celsius, and kelvin temperature systems.

Solution

Sample code folder: Chapter 01\Forms Version

Create a Windows Forms application, and add the appropriate controls and logic.

Discussion

Start Visual Studio 2005, and then create a new project. The Start Page includes a link to do this, or you can use the File New Project menu command. The New Project dialog appears, as shown in Figure 1-1.

Figure 1-1. Visual Studio’s New Project dialog

Each template listed in this dialog starts with the most basic and empty Visual Basic project and adds just enough source code and configuration settings to get you started

Visual Basic 2005 Cookbook Overview

Visual Basic 2005 Cookbook

Visual Basic 2005 Cookbook By John Clark Craig, Tim Patrick ……………………………………….. Publisher: O’Reilly Pub Date: September 2006 Print ISBN-10: 0-596-10177-5 Print ISBN-13: 978-0-59-610177-0 Pages: 740

Overview This book will help you solve more than 300 of the most common and not-so-common tasks that working Visual Basic 2005 programmers face every day. If you’re a seasoned .NET developer, beginning Visual Basic programmer, or a developer seeking a simple and clear migration path from VB6 to Visual Basic 2005, the Visual Basic 2005 Cookbook delivers a practical collection of problem-solving recipes for a broad range of Visual Basic programming tasks. The concise solutions and examples in the Visual Basic 2005 Cookbook range from simple tasks to the more complex, organized by the types of problems you need to solve. Nearly every recipe contains a complete, documented code sample showing you how to solve the specific problem, as well as a discussion of how the underlying technology works and that outlines alternatives, limitations, and other considerations. As with all O’Reilly Cookbooks, each recipe helps you quickly understand a problem, learn how to solve it, and anticipate potential tradeoffs or ramifications. Useful features of the book include: Over 300 recipes written in the familiar O’Reilly Problem-Solution-Discussion format Hundreds of code snippets, examples, and complete solutions available for download VB6 updates to alert VB6 programmers to code-breaking changes in Visual Basic 2005 Recipes that target Visual Basic 2005 features not included in previous releases Code examples covering everyday data manipulation techniques and language fundamentals Advanced projects focusing on multimedia and mathematical transformations using linear algebraic methods Specialized topics covering files and file systems, printing, and databases In addition, you’ll find chapters on cryptography and compression, graphics, and special programming techniques. Whether you’re a beginner or an expert, the Visual Basic 2005 Cookbook is sure to save you time, serving up the code you need, when you need it.