ADO.Net Interview Questions and Answers How do pass null as a parameter value? param.Value = DBNull.Value; Category: ADO.Net Date: 10/15/2010 9:35:47 AM How do you define parameters to SqlCommand By adding them to collection Parameters. Category: ADO.Net Date: 10/15/2010 9:25:47 AM How do you save changes to Entities object? obj.SaveChanges(); Category: ADO.Net Date: 10/15/2010 8:42:48 AM 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 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 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 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 Can data set load data directly from xml? yes, by using ReadXml method Category: ADO.Net Date: 10/14/2010 11:49:47 PM 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 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 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 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 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 What provider can you use to access Excel workbook? OLEDb Category: ADO.Net Date: 10/14/2010 6:25:48 PM 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 1 2 3 4 5

Recent Answers How do you declare destructor in c#? kumar answered: by implementing finalize and dispose method What will be the result of this code Console.WriteLine(3/4 == 3.0/4.0); kumar answered: answer is 'false'