.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal

Home >> Interview Question >> ADO.Net >> Post New Question Subscribe to Interview Questions

You are working with a DataSet and want to be able to display data, sorted different ways. How do you do so?

Posted By :Virendra Dugar     Posted Date :October 12, 2009    Points :10   Category :ADO.Net 
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.

You can also find related Interview Question to You are working with a DataSet and want to be able to display data, sorted different ways. How do you do so?  below: 

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; (More...)

Which property on a Combo Box do you set with a column name, prior to setting the Data Source, to display data in the combo box?

ComboBox.DataValueField = "ColumnName"

When we use Databind method for the Combo box we set Display Member and Display Value property to column name. (More...)

How many ways you can display text using Silverlight?

Silverlight supports displaying static pre formatted text that is comprised out of glyph elements and also dynamic text that uses TextBlock. With glyphs, one needs to position the characters individually while TextBlock supports simple layout. (More...)

Explain the steps involved to populate dataset with data?

Open connection.;
Initialize Adapter passing SQL and connection as parameter.;
Initialize Dataset.;
Call Fill method of the adapter passes dataset as the parameter.;
Close connection.; (More...)

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. (More...)

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
[CODE]Fill(DataSet, DataTable)[/CODE]
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. (More...)

What are the ways you can display all the tables in Sql Server?

Way 1:

SELECT Table_Name
FROM information_schema.Tables

Way 2:

FROM SysObjects
WHERE Xtype = 'U' (More...)

In How many ways Data can be Export from Sql Table to Excel Sheet?

Some of these options include
1) Data Transformation Services (DTS),
2) SQL Server Integration Services (SSIS)
3) Bulk Copy (BCP)
4)OPENROWSET() (More...)

Quick Links For Interview Questions Categories:
ASP.Net Windows Application   .NET Framework   C#   VB.Net   ADO.Net  
Sql Server   SharePoint   Silverlight   OOPs   JQuery   JavaScript/VBScript
Biztalk Patten/Practices .IIS WCF WPF WWF
Networking Aptitude Others   All      

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 Interview Question 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    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend