Showing posts with label Connection String. Show all posts
Showing posts with label Connection String. Show all posts

Wednesday, May 27, 2015

Difference between DataSet and DataReader


In this post I will try to explain the difference between DataSet and DataReader. My previous post Difference between stored procedure and user defined functions.


DataSet is a type of disconnected architecture which means sql live database connections is not required while fetch the data from database. DataSet contains the collection of multiple DataTables. We are able to keep the tables, views values from database in DataSet. Also we can fetch the XML values and store in DataSet. We can use DataAdapter as a mediator between DataSet and SQL DataBase tables.

Saturday, December 6, 2014

3-Tier Architecture in ASP.Net C# with step by step example


In this post we will learn how to implement the three tier architecture in our application using Asp.Net c#. My previous post Highlight gridview row color on mouseover using javascript and css


Many interviews we faced the question whether you used 3-tier architecture in your application.Because it is mandatory to know the 3-tier architecture for developing a project. Three tier architecture is a separation of our application into multiple portion which is called as a layer.So we have to understand about the layer in 3-tier architecture.

Saturday, July 11, 2009

Connection String in

Connection string in c#.In there is an easier way give the Connection String.we can add more than one Connection String in the web.config file.Then we can access these Connection Strings in any of our Pages.This is a simply superb concept in for example,You have two
Connection Strings one for your local server and another one for your live server.You simply add these two Connections in the web.config file and access the first connection in one page and in another page you can use the next connection.