| ADO.NET 101: SQL Connection |
| The Code Project |
| A tutorial on connecting to SQL 2000 Server |
|
| Article 2 - Dynamic creation of database |
| The Code Project |
| Display data using Dataset and Data Grid control after the database is created |
|
| BETA-PRB: CommandBuilder Changes Modified Commands Back to Original (Q310366) |
| Microsoft Support |
| The CommandBuilder object may rebuild a command that you try to modify during the next call to the DataAdapter.Update method, and your changes to the command may be lost. |
|
| BETA-PRB: Error in SQL Server 7.0 When You Call Command.Prepare Before You Add Parameters (Q310368) |
| Microsoft Support |
| When you create a parameterized command against Microsoft SQL Server 7.0, if you call the Prepare method before you add parameters to the command, you receive the following error message: "An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in system.data.dll. Additional information: System error. " |
|
| BUG: SqlConnection Presents Misleading User Interface for ConnectionString Property |
| Microsoft Support |
| (316321) - When you try to set the ConnectionString property for a SqlConnection object at design time, the OLEDB DataLinks dialog box permits you to select any OLE DB provider on your system to generate a connection string for the SqlConnection object. When you... |
|
| BUG: SqlConnection Presents Misleading User Interface for ConnectionString Property |
| http://www.kbalertz.com/ |
| (316321) - When you try to set the ConnectionString property for a SqlConnection object at design time, the OLEDB DataLinks dialog box permits you to select any OLE DB provider on your system to generate a connection string for the SqlConnection object. When you... |
|
| Building a Custom Data Provider for Use with the .NET Data Access Framework |
| MSDN |
| The System.Data.dll assembly in the .NET Framework contains namespaces whose base classes can be used to create custom data providers. These namespaces also define a number of data access interfaces and base classes that let developers create data providers that will interoperate with other custom providers. Using the ADO.NET classes Connection, Command, DataReader, and DataAdapter, writing a provider is easier than writing one for OLE DB. This article explains these classes and their implementation, and how they can be used to write a variety of different kinds of data providers. |
|
| Building Message Board Web Services with C# and .NET -- Part I, The Web Services |
| C#Today |
| In this article, Chris Pike looks at how web services are constructed using C# and .NET. He does this by examining one of the most popular web applications, the message board. Amongst the topics looked at are the issues concerned with designing web service applications, and how to create the web service in Visual Studio .NET and C#. |
|
| Creating a SQL Server Database Programmatically |
| C# Corner |
| SQL provides statements to create new databases and database objects. You can execute these statements from your program to create databases programmatically. In this article, I’ll show you how to create a new SQL Server database and its objects such as table, stored procedures, views and add and view data. I’ll also show you how to change database table schema programmatically. You’ll see how SQL statement ALTER TABLE is useful when you need to change a database table schema programmatically. |
|
| Deferred ASP.NET Session State Management |
| MSDN |
| Conserve your environment by waiting to load your Session State data into memory until needed. |
|
| How to perform bulk updates and inserts by using the OpenXML method with .NET providers in Visual Basic .NET |
| http://www.kbalertz.com/ |
| (316244) - Explains how to use OpenXML with .NET providers to perform bulk updates and inserts in Visual Basic .NET. Requires SQL Server 2000 to perform this task. |
|
| How to perform bulk updates and inserts by using the OpenXML method with .NET providers in Visual Basic .NET |
| http://www.kbalertz.com/ |
| (316244) - Explains how to use OpenXML with .NET providers to perform bulk updates and inserts in Visual Basic .NET. Requires SQL Server 2000 to perform this task. |
|
| How to read and write a file to or from a BLOB column by using ADO.NET and Visual C# .NET |
| Microsoft Support |
| (317016) - This article describes how to read and write data from LongVarBinary BLOB columns in a database table. This article contains examples of both the SqlDataAdapter class and the OleDbDataAdapter class. The only differences between the two classes, other... |
|
| How to read and write a file to or from a BLOB column by using ADO.NET and Visual C# .NET |
| http://www.kbalertz.com/ |
| (317016) - This article describes how to read and write data from LongVarBinary BLOB columns in a database table. This article contains examples of both the SqlDataAdapter class and the OleDbDataAdapter class. The only differences between the two classes, other... |
|
| How to read and write a file to or from a BLOB column by using ADO.NET and Visual C# .NET |
| http://www.kbalertz.com/ |
| (317016) - This article describes how to read and write data from LongVarBinary BLOB columns in a database table. This article contains examples of both the SqlDataAdapter class and the OleDbDataAdapter class. The only differences between the two classes, other... |
|
| How to sum the fields in a Windows Forms DataGrid control and display the calculated totals in a footer by using Visual C# .NET |
| http://www.kbalertz.com/ |
| (842290) - Explains how to calculate the sums of the values in the columns of a Windows Forms DataGrid control and display these sums in a footer. Requires knowledge of Visual C# .NET. |
|
| How to sum the fields in a Windows Forms DataGrid control and display the calculated totals in a footer by using Visual C# .NET |
| http://www.kbalertz.com/ |
| (842290) - Explains how to calculate the sums of the values in the columns of a Windows Forms DataGrid control and display these sums in a footer. Requires knowledge of Visual C# .NET. |
|
| How to sum the fields in a Windows Forms DataGrid control and then display the calculated totals in a footer by using Visual Basic .NET |
| http://www.kbalertz.com/ |
| (836672) - Explains how to calculate the sums of the values in the columns of a Windows Forms DataGrid control and display these sums in a footer. Requires knowledge of Visual Basic .NET. |
|
| How to update parent-child data with an identity column from a Windows Forms Application by using a Web service in Visual C++ .NET |
| http://www.kbalertz.com/ |
| (815711) - Discusses how to create an ASP.NET Web service to access and to update a database. The article discusses how to modfiy data that is in two tables that have a parent-child relationship with an identity column that uses the Web service. |
|
| How to update parent-child data with an identity column from a Windows Forms Application by using a Web service in Visual C++ .NET |
| http://www.kbalertz.com/ |
| (815711) - Discusses how to create an ASP.NET Web service to access and to update a database. The article discusses how to modfiy data that is in two tables that have a parent-child relationship with an identity column that uses the Web service. |
|
| How to Use a StreamWriter with NETCOBOL for .NET |
| DotNetJunkies |
| The simplest and most common all time working code I could think of was writing "Hello World" as a string in a text file. But then I dropped the idea of the conventional "Hello World" and thought of handling an exception and writing the exception handled in the file instead. We'll do a comparision with one of the Language Compilers provided by Microsoft, so we'll choose VB.NET. |
|
| HOW TO: Connect to a Database and Run a Command by Using ADO.NET and Visual J# .NET |
| http://www.kbalertz.com/ |
| (322045) - This article describes how to use ADO.NET to connect to a database and to run a command (such as the UPDATE, the INSERT or the DELETE command) by using a Visual J# .NET console application. Requirements The following list outlines the recommended... |
|
| HOW TO: Perform Bulk Updates and Inserts Using OpenXML with .NET Providers in Visual C# .NET |
| http://www.kbalertz.com/ |
| (315968) - This step-by-step article describes how to do bulk inserts and updates with different Microsoft .NET data providers by using the OpenXML method. Although the sample in this article uses the SqlClient managed provider, you can also use the OLEDB or the... |
|
| HOW TO: Read and Write a File to and from a BLOB Column by Using ADO.NET and Visual C++ .NET |
| http://www.kbalertz.com/ |
| (317017) - Use this step-by-step guide to read and write data to and from BLOB (LongVarBinary) columns in a database table. NOTES This article contains examples for both the SqlClient and the OleDb DataAdapter classes. The only differences, apart from the class... |
|
| HOW TO: Read and Write a File to and from a BLOB Column by Using Chunking in ADO.NET and Visual C# .NET |
| http://www.kbalertz.com/ |
| (317043) - This step-by-step article describes how to use the Microsoft SQL Server READTEXT and UPDATETEXT statements to read and write data from BLOB (LongVarBinary) columns in a database table. Because of network constraints, you may have to retrieve a large... |
|
