Browse by Tags
All Tags »
Data (
RSS)
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...