|
|
|
|
|
Total Hits: 72 | Today: 0
|
Author: Barton Friedland
|
Rating:
|
|
In .NET Anatomy: Creating Templated DataGrid Controls Using Visual Studio .NET : Part 1 we learned how to create the ASP.NET project and the SQL database. Now, we are ready to move on and create the ADO.NET component....
|
|
|
|
Total Hits: 99 | Today: 0
|
Author: Nick Harrison
|
Rating:
|
|
The dream of transparent data access is to not have to care about where the data is coming from. You have more important things to worry about, like providing a nice user interface and getting the business logic right on time. Ideally, it should not matter if the data is coming from SQL Server, Oracle, Outlook, or anywhere else useful data may be stored. It should not matter if you choose to develop against Access at home, SQL Server in development, and use Oracle in production. In a perfect wor...
|
|
|
|
Total Hits: 62 | Today: 0
|
Author: Dino Esposito
|
Rating:
|
|
One of the key elements that makes ADO.NET superior to ADO is the level of integration with XML. In ADO, XML is just an I/O format. In addition, the ADO XML format is totally inflexible and doesn't allow any type of customization. Fortunately, since XML is much more deeply integrated into ADO.NET, you can use it to serialize ADO.NET objects. This deeper integration also allows for the dual programming interface which enables you to work on the same data set both hierarchically and relationally. ...
|
|
|
|
Total Hits: 183 | 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: 322 | Today: 0
|
|
Rating:
|
|
You can use the new ODBC .NET Data Provider that works with the ODBC Oracle7.x driver or higher. You need to have MDAC 2.6 or later installed and then download ODBC .NET from the MS Web Site http://msdn.microsoft.com/downloads/default.asp?url=/code/sample.asp?url=/msdn-files/027/001/668/msdncompositedoc.xml&frame=true....
|
|
|
|
Total Hits: 1126 | Today: 0
|
Author: Andrew R. Phillips
|
Rating:
|
|
Programming in C# with ADO.Net is much easier than it sounds. Microsoft has made it simpler for anyone to connect. ADO.NET has the ADOData class and if you are using a SQL Server Database you can use SQLDataSet classed for betrer speed and performance....
|
|
|
|
Total Hits: 87 | Today: 0
|
Author: Joydip Kanjilal
|
Rating:
|
|
In the first part of this series of articles on Data Access Layer, we have had a look at what the strategies are, for designing and implementing a Generic Data Access Layer. We have had a look at the enumerators and the factory classes that we will be using. In this part of this article of three part series, we will discuss how we can implement the DatabaseHelper class, one that would be responsible for performing the actual database operations....
|
|
|
|
Total Hits: 95 | Today: 0
|
Author: easerve
|
Rating:
|
|
Deleting records from SQL Server 2000 database using ADO.NET a fairly strait forward process, much like deleting records from SQL Server 2000 Database....
|
|
|
|
Total Hits: 73 | Today: 0
|
Author: narendra
|
Rating:
|
|
Visual Studio.NET's code generation features serve the purpose of creating trivial applications very well but when it comes time to create a more complicated application, a good programmer needs to know how to work with ADO.NET DataAdapters at the code level....
|
|
|
|
Total Hits: 90 | Today: 0
|
Author: Dan Fox
|
Rating:
|
|
Implementing data access functionality is a core activity of most developers working with the .NET Framework, and the data access layers they build are an essential part of their applications. This article outlines five ideas to consider when building a data access layer with Visual Studio .NET and the .NET Framework. The tips include taking advantage of object-oriented techniques and the .NET Framework infrastructure by using base classes, making classes easily inheritable by following guidelin...
|
|
|
|
Total Hits: 118 | Today: 0
|
Author: Neeraj Saluja
|
Rating:
|
|
Establishing a Connection with a database server is a hefty and high resource consuming process. If in any application needs to fire any query against any database server, we need to first establish a connection with server and then execute the query against that database server....
|
|
|
|
Total Hits: 443 | Today: 0
|
Author: Nidal Arabi
|
Rating:
|
|
There are multiple cases where you are asked to provide a filter on your DataGrid. For example, you need a filter when using a typed text or even when allowing the user to select from a specified list.
In this article I will explain one way of providing the end user with a professional look and performance even if you are dealing with millions of records.
For demonstration purposes I will be using the NorthWind database available from Microsoft for download.
Take a look a Figure 1 to g...
|
|
|
|
Total Hits: 951 | Today: 0
|
Author: John Kilgo
|
Rating:
|
|
With a little preparation on the Excel side and very little work on the ADO.NET side you can connect to and read Excel workbooks just as though they were database tables. Since Excel has an OleDB provider, we can use ADO.NET's OleDb functionality to connect to Excel. It does take a little preparation on the Excel side however. You might think that since Excel has rows and columns we might be able to use that and refer to A1 and B3, etc. We can't (as far as I know). We must resort to another meth...
|
|
|
|
Total Hits: 193 | Today: 0
|
Author: Ruffin Bailey
|
Rating:
|
|
You shouldn't have to learn six objects beginning with the word "Data" to start using ADO.NET. More importantly, you shouldn't have to depend on learning a brand new object model for Microsoft's DataGrid object to customize the HTML you're sending to the end user. In this article Ruffin compares classic ASP and ADO to Microsoft's ASP.NET and ADO.NET technologies, easing the transition to ADO.NET for current ADO developers.You shouldn't have to learn six objects beginning with the word "Data" to ...
|
|
|
|
Total Hits: 918 | Today: 0
|
Author: Mahesh Chand
|
Rating:
|
|
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....
|
|
|
|
Total Hits: 566 | Today: 0
|
|
Rating:
|
|
All right, so you're tired of hearing the theory and concepts behind ADO.NET. Me too. Let's look at and discuss some techniques and code that will allow us to read data into our ASP.NET web pages....
|
|
|
|
Total Hits: 508 | Today: 0
|
Author: Sudhakar Jalli
|
Rating:
|
|
A very interesting database features incorporated into the .NET as ADO.NET. The whole database programming no matter which language, has been rewashed, cleansed and sprayed with a new programming model -- disconnected data architecture, tight integration with XML, common data representation with the capability to get data from multiple and varied data sources and optimized facilities....
|
|
|
|
Total Hits: 763 | Today: 0
|
|
Rating:
|
|
Allows you to easily build your database code. The application allows you to build database code that works against both OLEDB (System.Data.ADO) as well as SQL Server (System.Data.SQL) .NET Data providers....
|
|
|
|
Total Hits: 337 | Today: 0
|
Author: K.M.Hussain
|
Rating:
|
|
Accessing and Updating Data using ADO.NET: Accessing data has become a major programming task for modern software programming, both for standalone applications and for web-based applications....
|
|
|
|
Total Hits: 493 | Today: 0
|
Author: Rob Macdonald
|
Rating:
|
|
Microsoft is introducing a new model for accessing data through the .NET Framework. Rob Macdonald explains how ADO.NET works and how it differs from ADO. Among the many things that are changing with .NET is data access. Under the .NET Framework, data access is handled by a set of classes called ADO.NET which are essentially an augmentation of the existing ActiveX Data Objects (ADO)....
|
|
|
|
|
|
