Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 28-11-2009
Member
 
Join Date: Nov 2009
Posts: 1,118
How to use dataset in ASP.Net?

Hello,

I am having problem regarding the database. I am developing a project in ASP.net and wanted to connect it to the database but my problem is that i want to use dataset instead of linking it through the SQL command. Any one with the great knowledge of the ASP.NET can step forward to tell me about the same. I assume that you know how urgently i need this information.

Help will be appreciated
Reply With Quote
  #2  
Old 28-11-2009
Member
 
Join Date: May 2008
Posts: 2,293
Re: How to use dataset in ASP.Net?

Hi folks,

I am giving you the simplest step to perform the dataset with ASP.NET.
To fetch the database object into dataset you have to first create database and then create database connection, dataset object. Database connection will create the connection between the database. After the connection has been established then create a dataadapter object and connect it to the database. Then fill the DataAdapter with the Fill method.

Thanks
Reply With Quote
  #3  
Old 28-11-2009
Member
 
Join Date: Oct 2005
Posts: 2,389
Re: How to use dataset in ASP.Net?

Hi,

I will suggest you not to create use dataset, instead of that use link to sql. It much faster then the Dataset. Normally you will not find it difficult but when you will connect it to the database then the main problem will arise. The problem you will see after you bind the dataset to a grid as well as when you will try to introduce inline editing and paging. So in my opinion "Use SQL to perform fast.

I hope you will like the idea.
Reply With Quote
  #4  
Old 28-11-2009
Member
 
Join Date: May 2008
Posts: 2,383
Re: How to use dataset in ASP.Net?

The DataSet, which is an in-memory cache of data retrieved from a data source, is a major component of the ADO.NET architecture. The DataSet consists of a collection of DataTable objects that you can relate to each other with DataRelation objects. You can also enforce data integrity in the DataSet by using the UniqueConstraint and ForeignKeyConstraint objects. For further details about working with DataSet objects, see DataSets, DataTables, and DataViews (ADO.NET).

To know more about the dataset click on the link below"

DATASET
__________________
The FIFA Manager 2009 PC Game
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , , , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "How to use dataset in ASP.Net?"
Thread Thread Starter Forum Replies Last Post
Dataset vs DataReader in .Net Vireshh Software Development 3 07-05-2011 11:32 AM
How to create a new DataSet Leonard Windows Software 5 23-03-2010 08:52 AM
Feed a dataSet from a SqlDataReader Layton Software Development 5 23-01-2010 10:25 AM
How is DataSet.xsd used in any particular website Guns-n-Roses Software Development 3 25-09-2009 12:52 PM
Working with XML and DataSet Aanand Software Development 3 01-05-2009 02:38 PM


All times are GMT +5.5. The time now is 09:04 PM.