ADO.Net Interview Questions and Answers
ADO.Net : How do pass null as a parameter value?

How do pass null as a parameter value?

param.Value = DBNull.Value;
Category: ADO.Net Date: 10/15/2010 9:35:47 AM
ADO.Net : How do you define parameters to SqlCommand

How do you define parameters to SqlCommand

By adding them to collection Parameters.
Category: ADO.Net Date: 10/15/2010 9:25:47 AM
ADO.Net : How do you save changes to Entities object?

How do you save changes to Entities object?

obj.SaveChanges();
Category: ADO.Net Date: 10/15/2010 8:42:48 AM
ADO.Net : What systems does the LINQ to SQL supports?

What systems does the LINQ to SQL supports?

SQL Server and SQL Server compact
Category: ADO.Net Date: 10/15/2010 5:55:48 AM
ADO.Net : What classes can you use to process XML data in memory?

What classes can you use to process XML data in memory?

XmlDocument, XPathDocument, XPathNavigator and LINQ to XML
Category: ADO.Net Date: 10/15/2010 4:21:48 AM
ADO.Net : How do you set up the connection timeout for SqlConnection object?

How do you set up the connection timeout for SqlConnection object?

By using ConnectionTimeout property
Category: ADO.Net Date: 10/15/2010 4:11:48 AM
ADO.Net : How do you handle binary large objects in DataReader?

How do you handle binary large objects in DataReader?

Binary large objects are stored in dataset as array of bytes
Category: ADO.Net Date: 10/15/2010 1:24:47 AM
ADO.Net : Can data set load data directly from xml?

Can data set load data directly from xml?

yes, by using ReadXml method
Category: ADO.Net Date: 10/14/2010 11:49:47 PM
ADO.Net : What does the ExecuteScalar() method?

What does the ExecuteScalar() method?

ExecuteScalar returns first column of first row from result set.
Category: ADO.Net Date: 10/14/2010 11:39:47 PM
ADO.Net : How do you delete row using dataset?

How do you delete row using dataset?

By calling Delete() method on given row
Category: ADO.Net Date: 10/14/2010 10:57:48 PM
ADO.Net : What is typed dataset?

What is typed dataset?

Is a class that derives from a DataSet and provides strongly typed method, events and properties. Ad....
Category: ADO.Net Date: 10/14/2010 9:02:47 PM
ADO.Net : How do you refresh dataset?

How do you refresh dataset?

By calling one more time Fill method on DataAdapter
Category: ADO.Net Date: 10/14/2010 9:02:47 PM
ADO.Net : How do you define in connection string that SqlConnection should use SQL Server authentication?

How do you define in connection string that SqlConnection should use SQL Server authentication?

By specifying User ID and Password and setting Integrated Security to false
Category: ADO.Net Date: 10/14/2010 8:10:48 PM
ADO.Net : What provider can you use to access Excel workbook?

What provider can you use to access Excel workbook?

OLEDb
Category: ADO.Net Date: 10/14/2010 6:25:48 PM
ADO.Net : How can you call stored procedure from c# code?

How can you call stored procedure from c# code?

By calling it using SqlCommand object
Category: ADO.Net Date: 10/14/2010 6:15:47 PM
2 3 4 5 
Recent Answers
How do you declare destructor in c#?
kumar answered: by implementing finalize and dispose method