ADO .Net

Introduction: In the last article we saw that how we can insert the data into the database using only few lines and without stored procedures. Retrieving a single record from the database: You can easily retrieve a single record for a particular person based on the primary key. Just send in the primary key and [...]

Introduction: I know you all must be really anxious to find out that how NHibernate works and how it can make your life easier.In this article we will look at the add feature of the NHibernate. I will go step by step so you understand what is going on.In future articles we will implement an [...]

Series Part I Abstract: This is an article series in which I will talk about using O/R Mapping. O/R Mapping can ease your life since you don’t need to write those hefty stored procedures. O/R Mapping will also put an end to using datasets in your applications. In the first part of the article I [...]

Introduction: In the last article we saw the differences between the dataset and typed datasets. Typed datasets are more flexible than using dataset. In this article I will explain the entity classes which is far superior than datasets and typed datasets. Why using Entity Classes: The problem using the typed datasets was that when the [...]

Introduction: A couple of days ago I ran into a confusion when I had to decide that whether to use ViewState or Data Caching. The use of ViewState as well as Data Caching technique would have provided me with the correct solution. One of the techniques was better than the other and I had to [...]

Introduction: Today you will learn to write images to SQL Server and then read and display them. In order to follow this tutorial, you will need to have SQL Server,  Visual Studio .NET and .NET Framework installed. Ensure that the SQL Server instance is running. Getting to work: First, we will need to create a [...]

Introduction: Data Access has always been the heart and sole of any application. We saw ADO in classic Asp and ADO .NET in Asp .net 1.1. We also saw the data access using the Microsoft .NET application blocks, which I personally love . In this article we will see how we can access data using [...]

SQL DMO or SQL Distributed Management Objects are available through a Development library called SQLDMO.DLL from Microsoft. This Library can be used to automate the repetitive tasks needed to be done on, SQL Databases and Servers using Enterprise manager. Tasks like Back up, Restore, Scheduled Backup etc., can be easily automated. There are a large [...]

Last Update: 18 February 2005 Note: This article assumes a basic knowledge of Oracle stored procedures and how to create and access them. While a developer can write practically anything in C#, there are times when it would be nice to have the ability to alter a process without recompiling and redeploying an application. Let’s [...]

Last Update: 11.02.2005 You’ve worked for months and months on your C# application and it has passed testing now is ready for deployment. You get everything through the appropriate administrators and the application is finally installed on the main applications server. You go to your client machine and click on the icon and your thrills [...]

1 2