Win Surprise Gifts!!!
Top 5 Contributors of the Month
Post New Question
Subscribe to Interview Questions
There is a dataset, i want to retrieve only those records from the dataset which has been updated or changed.
Which property is used to get the updated data?
Posted By :
Posted Date :
March 22, 2011
haschanges property , please correct me if i am wrong.
You can also find related Interview Question to
There is a dataset, i want to retrieve only those records from the dataset which has been updated or changed. Which property is used to get the updated data?
What is the difference between Data Reader & Dataset?
Data Reader is connected datasource, read only, forward only record set.
Dataset is disconnected datatsource resides in memory database that can store multiple tables, relations and constraints;
You are working with a DataSet and want to be able to display data, sorted different ways. How do you do so?
Select the correct answer.
1. Use the Sort method on the DataTable object.
2. Use the DataSet object's Sort method.
3. Use a DataView object for each sort.
4. Create a DataTable for each sort, using the DataTable object's Copy method, and then Sort the result
Correct Answer is :
3. Use a DataView object for each sort.
Explain the steps involved to populate dataset with data?
Initialize Adapter passing SQL and connection as parameter.;
Call Fill method of the adapter passes dataset as the parameter.;
Can I have data from two different sources into a single dataset?
Yes, it is possible.
Is it possible to have tables in the dataset that are not bound to any data source?
Yes, I can create table object in code and add it to the dataset.
Which method do you invoke on the DataAdapter control to load your generated
dataset with data?
How to fill DataSet with data?
To fill DataSet with data we have to use Fill() method of DataAdapter object.
Fill() has several overloads. But the simple one is
The first parameter will take the name of the dataset to be filled and the second parameter specifies the name of the DataTable in the DataSet which will contain the data.
i have 3 aspx pages: page1.aspx, page2.aspx, page3.aspx. i have one Database table Employee (Empname, Age, EmpId, mobile, Country) with 1000 records inserted. now i want to retrieve the records in page1.aspx only once and i should use this data between the 3 pages without using Session variable. How to achieve this ?
need help on this question
Which object allows for faster reading of data the Datareader or Dataset?
How can you clear a Data from all the table in the dataset?
using Dataset.Clear() method you can clear all the data from DataSet
What is typed dataset in C#?
A typed dataset is similar to a dataset with only difference is that the sehema is already present in typed dataset. so if any mismatch in the column will generate compile time errors rather than runtime error as in the case of normal dataset. Also accessing the column value is much easier than the normal dataset as the column definition will be available in the schema.
What happens when we issue Dataset.ReadXml command?
Reads XML schema and data into the DataSet.
What is method to get XML and schema from Dataset?
getXML () and get Schema ()
Difference between Dataset and Datareader?
Data Set is a connectionless service and Data reader is a connection oriented service. Dataset is used to store the data, it contains collections of Datatable. Datareader is used to connect to the database for retrieving data.
Data Reader - Forward only where as Dataset - Can loop through dataset.
Data Reader - Connected Recordset where as DataSet - Disconnected Recordset
Data Reader - Less Memory Occupying where as DataSet - It occupies more memory
Data Reader - Only Single Table can be used where as Dataset - Datatable Concept allows data to be stored in multiple tables.
Data Reader - Read only where as DataSet - Can add/update/delete using the dataset
Data Reader - No relationship can be maintained where as DataSet - Relationship can be maintained.
Data Reader - No Xml Storage available where as DataSet - Can be stored as XML.
The Dataset is a core of disconnected architecture. Disconnected architecture means once you have retrieved the data from the database the data source is dropped. The disconnected data become very commonly. The dataset for the disconnected data from the Dataset object. The DataReader is a readonly, forward only stream from the database. While using the datareader can improve the application performance reduces the system overhead because only one buffer row at a time in memory.
Quick Links For Interview Questions Categories:
Find questions, FAQ's and their answers related to .NET, C#, Vb.Net, Sql Server and many more.
Now you can find lots of .NET, C#, Vb.Net, SQL Server,Windows, ASP.Net related Questions and their Answers here at www.dotnetspark.com. Our aim is to help you pass your certification Exams (MCP, MCSD, MCAD etc.,) with flying scores and get good name in your company.
So, Start looking our
section daily and improve your .NET Skills. You can also help others by posting Interview Questions and their Answers in this section.
Hall of Fame
Terms of Service
Tell A Friend