Browse by Tags
All Tags »
Data »
C# »
DataTable (
RSS)
There may be times you need to build a DataTable using code instead of retrieving the data from a database. This post provides the code for building a DataTable using VB or C# code. In C#: DataTable dt = new DataTable("Customers"); DataColumn...
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...
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 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...