Search - Articles
DevASP.NET for ASP.NET, VB.NET, XML and C# (C-Sharp) Developers Tuesday, March 03, 2009
Dev Articles
Search Directory
ASP.NET
VB.Net
C-Sharp
SQL Server
 


Home >Search > Knowledge Base > Visual Basic.Net > Database
Search:
What's New - What's Hot
Listings for ADO.NET ADO.NET (63)
Listings for Data Provider Data Provider (8)
Listings for DataSet Object DataSet Object (31)
More Categories for SQL Server SQL Server (1)


How to: Edit Rows in a DataTable  Version: 0.00     Price: $0.00  
Total Hits: 82  |  Today: 0Author: Microsoft Corporation      Rating:  
Read Reviews | Write Review |  Your Rating: 

In order to edit an existing row in a DataTable, you need to locate the DataRow you want to edit, and then assign the updated values to the desired columns....

How to: Save Dataset Changes to a Database  Version: 0.00     Price: $0.00  
Total Hits: 41  |  Today: 0Author: Microsoft Corporation      Rating:  
Read Reviews | Write Review |  Your Rating: 

After the data in your dataset has been modified and validated, you probably want to send the updated data back to a database. In order to send the modified data to a database, you call the Update method of a TableAdapter or data adapter. The adapter's Update method updates a single data table and executes the correct command (INSERT, UPDATE, or DELETE) based on the RowState of each data row in the table....

How to: Insert New Records into a Database  Version: 0.00     Price: $0.00  
Total Hits: 123  |  Today: 0Author: Microsoft Corporation      Rating:  
Read Reviews | Write Review |  Your Rating: 

To insert new records into a database, you can use the TableAdapter.Update method, or one of the TableAdapter's DBDirect methods (specifically the TableAdapter.Insert method). For more information, see TableAdapter Overview.

If your application does not use TableAdapters, you can use command objects to interact and insert new records in your database (for example, SqlCommand)....

How to create a SQL Server database programmatically by using ADO.NET and Visual Basic .NET     
Total Hits: 238  |  Today: 0Author: Microsoft Corporation      Rating:  
Read Reviews | Write Review |  Your Rating: 

Programmers often need to create databases programmatically. This article describes how to use ADO.NET and Visual Basic .NET to programmatically create a Microsoft SQL Server database.
1. Create a new Visual Basic .NET Windows Application project. Form1 is added to the project by default.
2. Place a Command button on Form1, and change its Name property to btnCreateDatabase and its Text property to Create Database....

How to connect to a database and run a command by using ADO.NET and Visual Basic .NET     
Total Hits: 253  |  Today: 0Author: Microsoft Corporation      Rating:  
Read Reviews | Write Review |  Your Rating: 

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 Basic .NET console application.
The following list outlines the recommended hardware, software, network infrastructure, and service packs that are required:
• Microsoft Windows XP, Microsoft Windows Server 2003, Microsoft Windows 2000 Professional, Microsoft Windows 2000 Server, Microsoft Windows 2000 Advanced Server, or Microsoft...

HOW TO: Reuse the SqlCommand and OleDbCommand Objects in Visual Basic .NET (Q317150)     
Total Hits: 690  |  Today: 0Author: MSDN      Rating:  
Read Reviews | Write Review |  Your Rating: 

This step-by-step article describes how to reuse the SqlCommand object in your Visual Basic .NET code....

HOW TO: Read and Write a File to and from a BLOB Column by Using Chunking in ADO.NET and Visual Basic .NET (Q317034)     
Total Hits: 845  |  Today: 0Author: MSDN      Rating:  
Read Reviews | Write Review |  Your Rating: 

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....

HOW TO: Debug Stored Procedures in Visual Studio .NET (Q316549)     
Total Hits: 497  |  Today: 0Author: MSDN      Rating:  
Read Reviews | Write Review |  Your Rating: 

This step-by-step article explains two ways that you can debug SQL Server stored procedures and the necessary configuration settings and steps for each approach....

HOW TO: Render DataTable Columns as XML Attributes Instead of Elements Using Visual Basic .NET (Q310345)      
Total Hits: 334  |  Today: 0Author: MSDN      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article demonstrates how to render DataTable columns as Extensible Markup Language (XML) attributes. A DataTable represents one table of in-memory relational data. You can create a DataTable and use it independently, or other Microsoft .NET Framework objects can use the DataTable, most commonly as a member of a DataSet object....

HOW TO: Update a SQL Server Database Using the SqlDataAdapter Object in Visual Basic .NET (Q308055)      
Total Hits: 2587  |  Today: 0Author: MSDN      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article contains Microsoft Visual Basic .NET code samples that demonstrate how to use the SqlDataAdapter object to update a SQL Server database with data modifications that are run on a DataSet object that is populated with data from a table in the database....

DOC: Error in SqlCommandBuilder Code Sample (Q316758)      
Total Hits: 321  |  Today: 0Author: MSDN      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article refers to the following Microsoft .NET Framework Class Library namespace.When you execute the code in the MSDN documentation for the SqlCommandBuilder class, you may receive this Exception.
An unhandled exception of type 'System.Data.MissingPrimaryKeyException' occurred in system.data.dll...

HOW TO: Execute SQL Parameterized Stored Procedures Using the ODBC .NET Provider and Visual Basic .NET (Q309486)      
Total Hits: 652  |  Today: 0Author: MSDN      Rating:  
Read Reviews | Write Review |  Your Rating: 

This step-by-step describes how to call a parameterized SQL Server stored procedure using the ODBC .NET Managed Provider and Visual Basic .NET....

HOW TO: Page Through a Query Result for Better Performance     
Total Hits: 366  |  Today: 0Author: MSDN      Rating:  
Read Reviews | Write Review |  Your Rating: 

This step-by-step article provides guidelines about how to implement paging. This article provides a few examples of paging and describes the advantage of each method....

FIX: Cannot Close Form When Tag Property Is Bound to Read-Only Field     
Total Hits: 157  |  Today: 0Author: MSDN      Rating:  
Read Reviews | Write Review |  Your Rating: 

If the Tag property of a Windows Forms control is bound to a read-only field in a DataSet object, you cannot move the focus away from the control, and you cannot close the form....

HOW TO: Use QueryPerformanceCounter to Time Code in Visual Basic .NET      
Total Hits: 707  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

When you test code to identify performance bottlenecks, it is best to use the highest resolution timer that the system has to offer. This step-by-step article describes how to use the QueryPerformanceCounter function to time application code.
...

HOW TO: Query and Display Excel Data by Using ASP.NET, ADO.NET, and Visual C# .NET     
Total Hits: 10520  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

This step-by-step article demonstrates how to display data from an Excel worksheet through an ASP.NET (.aspx) page by using Visual C# .NET....

HOW TO: Retrieve an Identity Value from a Newly Inserted Record from SQL Server by Using Visual Basic .NET (Q320141)      
Total Hits: 1967  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

This step-by-step article describes how to retrieve the identity value when you add a record into a SQL Server table with an identity field.
...

HOW TO: Create a SQL Server Database Programmatically by Using ADO.NET and Visual Basic .NET (Q305079)     
Total Hits: 1774  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

Programmers often need to create databases programmatically. This article describes how to use ADO.NET and Visual Basic .NET to programmatically create a Microsoft SQL Server database....

HOW TO: Create and Use a Typed DataSet by Using Visual Basic .NET (Q315678)     
Total Hits: 1059  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article shows how to create and use a typed DataSet in a small Web application. Typed DataSets , which inherit from the DataSet class, create first-class members of a DataSet 's DataTables and DataColumns , yielding the many benefits that come with the use of strong typing.

...

HOW TO: Programmatically Create a Hierarchical DataSet Object with ADO.NET in Visual Basic .NET (Q316260)     
Total Hits: 977  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

This step-by-step article describes how to create a hierarchical DataSet object that you can use as a structure for your programs. You may not have the exact data or structure that you want to use for your project. You can use the method in this article to create prototypes for your examples. It may also be easier to submit only the data that you do have to the database without using the shape command syntax to send the data to the database....



Disclaimer - Privacy
© 2002-2017 DevASP.net