Browse Blog Posts by Tags

All Tags » VB » Data (RSS)

Browse Blog Posts by Tags

Showing related tags and posts for the Blogs application. See all tags in the site

DAL: Using a Data Provider Factory

Whether it be SQL Server, Access, Oracle, or mySql, most applications write to one kind of database. But what if your application requirements are such that you have to support multiple database types? Then the DbProviderFactory is for you. For example, say you are building a product to sell to HR departments...

Posted to Deborah's Developer MindScape by Deborah Kurata on Fri, Sep 25 2009
Filed under: Filed under: VB, C#, .NET, CSharp, Data, DataTable
Update a Microsoft Access Database

Despite the fact that there is a free version of SQL Server called SQL Server Express , there are still applications that require using a Microsoft Access database. But since these are dwindling in number, there are few articles or posts devoted to accessing Access. This post (and my prior post that...

Posted to Deborah's Developer MindScape by Deborah Kurata on Tue, Aug 25 2009
Filed under: Filed under: VB, C#, .NET, CSharp, Data, DataTable
Retrieve a DataTable using Microsoft Access

Despite the fact that there is a free version of SQL Server called SQL Server Express , there are still applications that require using a Microsoft Access database. But since these are dwindling in number, there are few articles or posts devoted to accessing Access. This post (and my next post that demonstrates...

Posted to Deborah's Developer MindScape by Deborah Kurata on Tue, Aug 25 2009
Filed under: Filed under: VB, C#, .NET, CSharp, Data, DataTable
Reading Fixed Length Files

There may be times that you need to read fixed length files into your application. For example, you obtain output from a legacy system or other application in a fixed length text file format, and you need to read and use that data in your application. NOTE: For more information on fixed length files...

Posted to Deborah's Developer MindScape by Deborah Kurata on Tue, Aug 25 2009
Filed under: Filed under: VB, C#, .NET, CSharp, Data, DataTable, text file
Reading Comma Delimited Files

There may be times that you need to read comma separated value (CSV) files into your application. For example, you obtain output from a legacy system or other application in a comma delimited text file format, and you need to read and use that data in your application. NOTE: For more information on delimited...

Posted to Deborah's Developer MindScape by Deborah Kurata on Tue, Aug 25 2009
Filed under: Filed under: VB, C#, .NET, CSharp, Data, DataTable, text file
DAL: Save Data Using a SQL Statement

This post provides an implementation of a method that saves data to a SQL Server database using a SQL statement. Your application can use this method to insert, update, or delete rows in any database table. See this for a post detailing how to retrieve data using a SQL statement. The code is first shown...

Posted to Deborah's Developer MindScape by Deborah Kurata on Fri, Aug 21 2009
Filed under: Filed under: VB, C#, .NET, CSharp, Data
DAL: Save Data Using a Stored Procedure

This post provides an implementation of a method that saves data to a SQL Server database using a stored procedure. You application can use this method to insert, update, or delete rows in any database table. NOTE: This post assumes you already have a stored procedure defined to insert, update, or delete...

Posted to Deborah's Developer MindScape by Deborah Kurata on Fri, Aug 14 2009
Filed under: Filed under: VB, C#, .NET, CSharp, Data
Populating a Business Object from a DataTable

Most business applications have business objects such as customer, order, or invoice. Often, the data access layer (DAL) provides the data and your code needs to use that data to manually populate a business object. This post describes how to manually populate a business object from a DataTable. It uses...

Posted to Deborah's Developer MindScape by Deborah Kurata on Fri, Jul 10 2009
Filed under: Filed under: VB, C#, .NET, CSharp, OOP, Data, DataTable
DAL: DataTable Visualizer

This post details how to use the DataTable Visualizer. The DataTable Visualizer is a debugging tool that allows you to see and edit the contents of a DataTable while you are debugging. NOTE: There is also a DataSet Visualizer that works the same way for DataSets instead of DataTables. To use the DataTable...

Posted to Deborah's Developer MindScape by Deborah Kurata on Fri, Jul 10 2009
Filed under: Filed under: VB, C#, .NET, CSharp, Data, DataTable, Debugging
DAL: Access a DataReader using a SQL Statement

This post provides an implementation of a method that accesses a DataReader from a SQL Server database using a SQL statement. Your application can then use the DataReader to read the data from your database or bind directly to an ASP.NET control such as a grid. If you are not familiar with a DataReader...

Posted to Deborah's Developer MindScape by Deborah Kurata on Thu, Jul 9 2009
Filed under: Filed under: VB, C#, .NET, CSharp, Data, DataReader
DAL: Access a DataReader using a Stored Procedure

This post provides an implementation of a method that accesses a DataReader using a stored procedure in a SQL Server database. Your application can then use the DataReader to read the data from your database or bind directly to an ASP.NET control such as a grid. If you are not familiar with a DataReader...

Posted to Deborah's Developer MindScape by Deborah Kurata on Thu, Jul 9 2009
Filed under: Filed under: VB, C#, .NET, CSharp, Data, DataReader
DAL: Using Stored Procedures

A stored procedure is a set of structured query language (SQL) statements that provide a particular operation on the data (or structure) of a database and are stored within the database. For example, a retrieval stored procedure contains a Select statement to select a set of data from one or more tables...

Posted to Deborah's Developer MindScape by Deborah Kurata on Wed, Jul 8 2009
Filed under: Filed under: VB, C#, .NET, CSharp, Data
DAL: Retrieve a DataTable using a SQL Statement

This post provides an implementation of a method that retrieves a DataTable from a SQL Server database using a SQL Statement. Your application can then use the DataTable to populate your business objects or to bind directly to a UI control such as a Combo Box or Grid (such as the DataGridView). See this...

Posted to Deborah's Developer MindScape by Deborah Kurata on Tue, Jul 7 2009
Filed under: Filed under: VB, C#, .NET, CSharp, Data, DataTable
DAL: Retrieve a DataTable using a Stored Procedure

This post provides an implementation of a method that retrieves a DataTable from a SQL Server database using a stored procedure. Your application can then use the DataTable to populate your business objects or to bind directly to a UI control such as a Combo Box or Grid (such as the DataGridView). NOTE...

Posted to Deborah's Developer MindScape by Deborah Kurata on Tue, Jul 7 2009
Filed under: Filed under: VB, C#, .NET, CSharp, Data, DataTable
DAL: Data Access Layer

One of the common ways to access data in a .NET application is to use the drag and drop TableAdapter tools or the new Entity Framework tools. But what if you want to write your data access code yourself? There are many ways to access data in an application without using the drag and drop tools: SQL Server...

Posted to Deborah's Developer MindScape by Deborah Kurata on Tue, Jul 7 2009
Filed under: Filed under: VB, C#, .NET, CSharp, Data, DataReader, DataTable

Page 1 of 1 (15 items)

Questions? Contact Susan at Susan-at-msmvps.com. Each post's copyright held by the original author. All rights reserved. Blog site is an independent site not sponsored by Microsoft.
Our servers would like to thank www.ownwebnow.com and www.exchangedefender.com. We wouldn't be here without the generosity of Vlad Mazek and his companies.

Powered by Community Server (Commercial Edition), by Telligent Systems

Theme based on the Paperclip Blog Theme included in Community Server.
Enhanced to a Site-Wide Theme by Interscape Technologies.

Recent Posts

Tags

Browse Blog Posts by Tags