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 > Articles & Samples > Visual Basic.Net > Database
Search:
What's New - What's Hot
Listings for ADO.NET ADO.NET (155)
Listings for Data Access Data Access (69)
Listings for Data-bound Controls Data-bound Controls (56)
Listings for DataSet Object DataSet Object (56)
Listings for Miscellaneous Miscellaneous (39)
Listings for SQL Server SQL Server (83)


HOW TO: Query and Display Excel Data by Using ASP.NET, ADO.NET, and Visual C# .NET     
Total Hits: 10528  |  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....

ADO.NET Data-Binding in Windows Forms     
Total Hits: 5322  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

The Microsoft .NET Framework provides an extremely powerful and flexible mechanism for binding data to properties of controls. Although in the majority of cases you will bind to the displayed value of a control—for example, the DisplayMember property of a ListBox control or the Text property of a TextBox control—you can bind any property of a control to a data source....

HOW TO: Retrieve an Identity Value from a Newly Inserted Record from SQL Server by Using Visual Basic .NET (Q320141)      
Total Hits: 1974  |  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: Update a Database from a DataSet Object by Using Visual Basic .NET     
Total Hits: 3304  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

DataSet objects, a key part of data access in the Microsoft .NET Framework, are in-memory objects that can hold tables, views, and relationships. This article demonstrates how to take a DataSet that contains data (which is loaded from a database), modify that data, and then send it back to the database to update the original source....

HOW TO: Copy DataRows Between DataTables by Using Visual Basic .NET (Q305346)     
Total Hits: 808  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article demonstrates how to copy specific DataRow objects from one table to another by using the ImportRow method of the DataTable class....

HOW TO: Create a SQL Server Database Programmatically by Using ADO.NET and Visual Basic .NET (Q305079)     
Total Hits: 1777  |  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: Automate Microsoft Access From Visual Basic .NET (Q317113)     
Total Hits: 2951  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article provides step-by-step samples that show you how to automate Microsoft Access from Visual Basic .NET. The topics and the sample code show you how to do the following:
  • Open a database in Access
  • Print or preview an Access report
  • Show and edit an Access form
  • Avoid dialog boxes when you open a password-protected database or when user-level security is turned on
  • Automate the Access Runtime
back to the top

Automation vs. ADO.NET

A developer can work ..Read More..

HOW TO: Connect to a Database and Run a Command by Using ADO.NET and Visual Basic .NET (Q301075)     
Total Hits: 3725  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article describes how to use ActiveX Data Objects (ADO) .NET to connect to a database and run a command (such as UPDATE, INSERT and DELETE) by using a Visual Basic .NET console application....

HOW TO: Persist an ADO.NET DataSet as XML by Using Visual Basic .NET (Q308064)     
Total Hits: 624  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article demonstrates how to persist an ADO.NET DataSet object to XML....

Relations Between DataTables in a DataSet     
Total Hits: 1092  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

This is the forth installment from the Programming Visual Basic .NET chapter on ADO.NET, focusing on binding a DataSet to a Windows and a Web Forms DataGrid....

Programming Visual Basic .NET: ADO.NET, Part 2     
Total Hits: 1990  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

Learn to connect to an OLE DB data source and read data into a dataset using ADO.NET.
...

Relations Between DataTables in a DataSet     
Total Hits: 803  |  Today: 0Author: Dave Grundgeiger      Rating:  
Read Reviews | Write Review |  Your Rating: 

This is the third installment from the Programming Visual Basic .NET chapter on ADO.NET, focusing on the relations between DataTables in a DataSet, and the DataSets XML capabilities.
...

VB.NET Data Types     
Total Hits: 523  |  Today: 0Author: Budi Kurniawan      Rating:  
Read Reviews | Write Review |  Your Rating: 

Budi gives us a tour of the new data types in VB 7 (VB .NET) that are different from VB 6. These are not the only changes in the language, but hopefully this is a good start for VB 6 programmers to begin migrating to VB 7.
...

HOW TO: Read and Write a File to and from a BLOB Column by Using ADO.NET and Visual Basic .NET (Q316887)     
Total Hits: 2261  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article explains how to read and write data from BLOB (LongVarBinary) columns in a database table....

HOW TO: Use ADO Recordsets in Visual Basic .NET (Q315974)      
Total Hits: 1482  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article explains how to create a small console application that uses COM Interop to create an earlier version ( legacy ) ADO RecordSet, convert it to an ADO.NET DataSet, and then display the record count. You will see how easy it is to use COM components from within Microsoft Visual Studio .NET....

HOW TO: Populate a DataSet Object from a Database by Using Visual Basic .NET (Q301216)     
Total Hits: 2408  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

DataSet objects, a key part of data access in the Microsoft .NET Framework, are in-memory objects that can hold tables, views, and relationships. This article shows how to fill a DataSet object with the results of one or more database queries, and how to access that data after it is loaded into the DataSet object....

HOW TO: Use ADO.NET to Retrieve and Modify Records in an Excel Workbook With Visual Basic .NET (Q316934)      
Total Hits: 4589  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article discusses how you can use ADO.NET to retrieve data from a Microsoft Excel workbook, modify data in an existing workbook, or add data to a new workbook. To access Excel workbooks with ADO.NET, you can use the Jet OLE DB provider; this article provides the information that you need so that you can use the Jet OLE DB provider when Excel is the target data source.
...

HOW TO: Create and Use a Typed DataSet by Using Visual Basic .NET (Q315678)     
Total Hits: 1067  |  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: 985  |  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....

Working with Data-bound Controls in VB.NET     
Total Hits: 2170  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

This is a VB.NET version of my C# tutorial "Working with Data-bound controls in C#". Working with data-bound controls using .NET ADO.NET and WinForms is so fun. You write few lines of code and these controls take care of rest for you. In this article, I’m going to show you how to use these data-bound controls in your .NET WinForms applications using VB.NET.
...



Disclaimer - Privacy
© 2002-2017 DevASP.net