|
|
|
|
|
|
| | Total Hits: 10 | Today: 0 | Author: Naimishforu | Rating:  |
| | 
Let's use the following simple program to demonstrate how C# uses datasets to examine the information in a database.
In this program, a dataset is created and then populated from a Microsoft Access database called EasyNomad. The information in the dataset is then displayed in a list box.
Because we are using an OLE database, we must use the System.Data.OleDb namespace.... |
| | Total Hits: 14 | Today: 0 | Author: Naimishforu | Rating:  |
| |
ADO.NET is described by a set of classes that describe different elements of the data. The DataSet object derives from System.Data.DataSet class, which is used to describe a subset of the overall database.... |
| | Total Hits: 15 | Today: 0 | Author: Naimishforu | Rating: |
| |
ADO.NET is a set of classes that together allow your applications to interact with the information stored in a database.
The main difference between ADO.NET and its earlier version, ADO (ActiveX Data Object), is that ADO.NET uses a disconnected architecture. This means that ADO.NET doesn't work directly on the information in the database but on a local copy of that information.... |
| | Total Hits: 15 | Today: 0 | Author: Muhammad Mosa | Rating:  |
| |
This article will discuss the Abstract Factory Design Pattern and its real world applications in .Net Framework 2.0.... |
| | Total Hits: 16 | Today: 0 | Author: JasonShort | Rating: |
| |
ADO.NET is a set of libraries included in the .Net framework to facilitate the communication of applications with various data storage mechanisms. These libraries form the basis for all third parties to provide data access services to users of .Net applications.
Visual Studio 2005 and 2008 did not change the data access model. In fact ADO.NET 2 is the longest running Microsoft data access technology without a major revision. I don’t know if this is going to change in .Net 4, but the st... |
| | Total Hits: 15 | Today: 0 | Author: Huseyin Altindag | Rating:  |
| |
This is a simple ADO.NET database application that returns results from a database table, writes the output to a DataGrid and TextBoxes, and uses Buttons (First, Previous, Next, Last) to navigate through the records. After getting lots of responses and suggestions from the users, I changed some points and made the code more readable. Like everyone else I also searched for a most requested method in MSDN Library to trap the keystrokes (Up, Down, Esc...) in Windows Forms and included it in the co... |
| | Total Hits: 14 | Today: 0 | Author: JasonShort | Rating: |
| |
This article was originally published on the VistaDB blog, but has been moved to this location permanently.
Each of these items could be a blog post unto themselves, but I am going to try really hard to not be too verbose and just cover the core of the concept and why you need to do it.... |
| | Total Hits: 16 | Today: 0 | Author: Bahrudin Hrnjica | Rating: |
| |
Putting and retrieving image files in to a database, is not a simple task. I you want to look on the Internet for such a sample, you will be surprised that there is no C++ sample for that. There is only information, that you have to use the Safearray, SetChunk, and GetChunk methods.
This article will show how you can put image files in to a database via ADO, as well as how you can retrieve them. With this example, you can use any file format such as Word, Excel etc., not just image file f... |
| | Total Hits: 14 | Today: 0 | Author: Manas Patnaik | Rating: |
| |
Well most of our applications are driven by a relational database and business layer associated with it. The amount of time spent to establish a communication between these two can be substantial. So Microsoft has introduced a framework for easy data abstraction called Entity Framework (AEF). AEF does wonders in support of LINQ to Entity and in this article we will have a detailed demonstration.... |
| | Total Hits: 14 | Today: 0 | Author: Dino Esposito | Rating: |
| |
Providing an engine to query the domain model is a primary responsibility of any DAL. If your DAL is then based on an O/RM tool, then providing an API to query the model become s a primary responsibility of the O/RM of choice. For this reason, some O/RM products offer their own variation of the SQL language adapted to work on the domain model. So you have Entity SQL with Entity Framework and the HQL language in NHibernate. More in general each O/RM provides its own specific API for you to arrang... |
| | Total Hits: 14 | Today: 0 | Author: Deeraj | Rating: |
| |
This article gives an insight into how to perform transactions using ADO.NET Entity Framework. This article is being authored for it to be at a very basic level and will not consider database isolation levels. Also, this article assumes that readers are already aware of ADO.NET Entity Framework.... |
| | Total Hits: 14 | Today: 0 | Author: Dinesh Dugg | Rating: |
| |
This example deals with displaying databases installed on the current computer, the tables of the selected database and the data of the selected table.
For this 2 comboboxes and one datagridview has been taken in a windows application.... |
| | Total Hits: 7 | Today: 0 | Author: Kishork80 | Rating: |
| |
When we process data using ADO or previous versions of ADO.NET, each command is executed sequentially i.e. Synchronously. The command code waits for each command to complete before the next one is processed.... |
| | Total Hits: 7 | Today: 0 | Author: SheoNarayan | Rating: |
| |
DataTableReader is a very useful ADO.NET class that can be used to retrieve / pass the data between layers in readonly and forward only format. In this article, I shall discuss about the DataTableReader class. Its very useful but perhaps rarely used in everyday programming even if it is best suitable in passing data between layers in place of DataTable.... |
| | Total Hits: 8 | Today: 0 | Author: dasblinkenlight | Rating: |
| |
Although Entity Framework does not have built-in support for the sql_variant data type [1][2] of SQL Server, it is possible to work around this limitation. This article describes an approach that lets you read columns of type sql_variant using an Entity Framework EDM.... |
| | Total Hits: 8 | Today: 0 | Author: Abhishek Sur | Rating:  |
| |
For the last 2 days, I thought of unleashing few of the hidden facts of Data Storage. It is true, that introduction of .NET framework without introducing Generic in first place is one of the biggest mistakes. Because of Non-Generic data structure a large amount of data is been unnecessarily boxed and unboxed without any reason as such. After Generics was introduced with .NET 2.0, most of these classes which made you do type conversions is either been totally depreciated or few of them rarely us... |
| | Total Hits: 7 | Today: 0 | Author: Sunasara Imdadhusen | Rating: |
| |
In ADO.NET 2.0, the DataView Object has a new method called ToTable, which allows you to create a new table based on data in the DataView.... |
| | Total Hits: 7 | Today: 0 | Author: Bipin Joshi | Rating: |
| |
While working with databases the first thing you need to do is to connect with a database. In this part of the series of articles, we will see how to use SqlConnection class to connect with SQL server database.... |
| | Total Hits: 8 | Today: 0 | Author: bipin joshi | Rating: |
| |
In the previous article of the series we saw how to connect with a SQL server database. Connection with database is useful only if we can execute SQL statements against the database. This article is meant to show you how to execute SELECT statements against SQL server database and iterate through the returned results using DataReader.... |
| | Total Hits: 8 | Today: 0 | Author: Bipin Joshi | Rating: |
| |
In the previous article of the series we saw how to execute SELECT queries using SqlConnection, SqlCommand and SqlDataReader classes. In this part we will see how to execute action queries like INSERT, UPDATE and DELETE using SqlCommand class.... |
|
|
|
|
|
|