.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 >> C# >> Post New Question Subscribe to Interview Questions

Explain Types of Data Source in .net?

Posted By :Narayanan     Posted Date :August 16, 2012    Points :40   Category :C# 
DataSource: Allow data binding on Win Form Controls.
Types of DataSource:
1) Database 2) Service3) Object.
Database :Lets you connect to a database and choose the database objects for your application. This option creates a dataset.
Service:Opens the Add Service Reference dialog box that lets you create a connection to a service that returns the data for your application.
Object:Lets you choose an object that can later be used to generate data-bound controls.

You can also find related Interview Question to Explain Types of Data Source in .net?  below: 

Different types of replication? Explain Each one..

The SQL Server 2000-supported replication types are:


Snapshot replication:
Snapshot replication distributes data exactly as it appears at a specific moment in time and does not monitor for updates to the data. Snapshot replication is best used as a method for replicating data that changes infrequently or where the most up-to-date values (low latency) are not a requirement. When synchronization occurs, the entire snapshot is generated and sent to Subscribers.

Transactional replication:

Transactional replication, an initial snapshot of data is applied at Subscribers, and then when data modifications are made at the Publisher, the individual transactions are captured and propagated to

Merge replication:
Merge replication is the process of distributing data from Publisher to Subscribers, allowing the Publisher and Subscribers to make updates while connected or disconnected, and then merging the updates between sites when they are connected. (More...)

Explain different types of cursors.

Implicit cursors:
these cursors are invoked implicitly. User need not create, open, fetch or close the cursor.

Explicit cursors:
these cursors are not invoked implicitly. User needs to create, open, fetch or close the cursor.

Static Cursor:
Stores a complete copy of the result set. Used mostly where scrolling is required. Static cursors don't support updates.

Forward -only cursors:
This cursor supports updates but not scrolling. It supports only fetching serially. Rows are not retrieved from the database until they are fetched.

Forward - only cursors /Read only cursor:
These are the fastest of the cursors and cannot be updated. They cannot be created on query that returns only read only columns.

Key set driven:
It is a scrollable cursor that cannot be updated. These cursors are controlled by a set of physical identifiers called as key set. The keyset is built in a temporary table when the cursor is opened. (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...)

Explain about data provider?

ADO.NET has two primary parts in its architecture out of which one is data provider. It has its own set of objects and it consists of its own classes. Some of them are connection, parameter, data reader, command and data adapter. This provides access to data sources such as Oracle, SQL server, etc. (More...)

Can SharePoint be linked to an external data source?

SharePoint data can be opened with Access and Excel as an external data source. Thus, SharePoint can be referenced as an external data source. SharePoint itself cannot reference an external datasource. (More...)

What are the data types available in JavaScript?

Object is the only data type available. (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...)

Can you store multiple data types in System.Array?

No, If the System.Array is of Some Particular Data Type.(Primitive Data Type)

yes, If the System.Array is of Object Type.

Ex :

create an array of objects.

int in = 50;
string st = "Fifty";

object [] obj = new object[2];
obj[0] = in;
obj[1] = st; (More...)

What are the data types which are supported as Lookup column in SharePoint.

Only Single Line of Text and Calculated columns are supported as lookup columns. (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