What is difference between ExecuteReader, ExecuteNonQuery and ExecuteScalar?
Next Question >>
: Use for accessing data. It provides a forward-only, read-only, connected recordset.
: Use for data manipulation, such as Insert, Update, Delete.
: Use for retriving 1 row 1 col. value., i.e. Single value.
eg: for retriving aggregate function.
It is faster than other ways of retriving a single value from DB.
Related Questions (ASP.Net FAQs)
Explain the System.Data namespace in .Net Framework Class Library.
What is a .skin file in ASP.Net?
How to get the count of records in the Database table using the DataSet?
What are possible implementations of distributed applications in ASP.Net?
Explain what relationship is between a Process, Application Domain, and Application?
What is the Satellite assembly ?
What is System.Net.Mail?
What’s the Unix name for a Windows service equivalent?
From which base class do the all Web forms inherit?
What is the Code Render blocks in ASP.Net?
What happens in memory when you Box and Unbox a value-type?
Does C# support variable method arguments?
Can you allow class to be inherited, but prevent the method from being over-ridden?
Which collection class uses the unique key for the collection?
Are private class-level variables inherited?
What anonymous methods in C# 2.0?
What does the keyword virtual mean in the method definition?
What is the static class?
What is the differences between Value Types and Reference Types:
What are Resource Files? How are they used in .Net?
MS SQL SERVER FAQs
How do I create primary keys in SQL Server?
What are the Stored procedures (sprocs) in SQL Server?
How to find nth highest salary from Employee table in SQL Server?
Which join gives the Cartesian product of two tables in sql server?
What is the FOREIGN KEY in SQL Server?
What is DTS (Data Transformation Services) in SQL Server?
What is the row size in SQL Server 2000?
What is the default join in SQL Server 2000?
How is the SUBSTR keyword used in SQL?
What is the CHECK constraint in SQL Server?
How do I make a TextBox use all upper-case (or lower-case) characters?
How do I load a picture into the PictureBox control?
How to use the Splitter control?
How do I dynamically load a control from a DLL?
How can I use a TextBox to enter a password?
How to set DateTimePicker MinDate and MaxDate (Winforms)?
What are win form controls? How they are represented in .NET framework class library?
Write a simple Windows Forms MessageBox statement.
How do I trigger a Button Click event?
What control do I use to insert Separator lines between Controls in my Dialog?
What is AJAX? or Define the term AJAX?
Define the role of the UpdatePanel?
Describe the technology that makes up AJAX?
Can we use multiple ScriptManager on a page?
What is ASP.NET AJAX?
List the server controls that come up with ASP.Net AJAX?
Could we nest the UpdatePanel within each other?
Describe Goals / Profits / Benefits of using ASP.Net AJAX?
What role does the ScriptManager play?
What is the role of a ScriptManagerProxy?
What is a Document Type Definition (DTD) and where do I get one?
Can XML use non-Latin characters?
Do I have to know HTML or SGML before I learn XML?
How do you write comments in XML?
Which parts of an XML document are case-sensitive?
Does XML replace HTML?
What is inline schema, how does it work?
How can XML be used?
What is SGML (Standard Generalized Markup Language)?
What is well formed XML document?
Job Interview Question
How does ASP.Net page works?
What is Process?
How to SELECT TOP N records from mytable without using TOP keyword?
- MS SQL
How do I set Custom Date Format in DateTimePicker (WinForms)?
What is AJAX? or Define the term AJAX?
What are the difference between XML and HTML.
ASP.Net Interview Questions and Answers (FAQs)
C-Sharp (C#) Interview Questions and Answers (FAQs)
Winform (Windows Forms) Interview Questions and Answers (FAQs)
SQL SERVER Interview Questions and Answers (FAQs)
AJAX Interview Questions and Answers (FAQs)
XML Interview Questions and Answers (FAQs)
© www.faqpanel.com: 2009-2010, All Rights Reserved |
Terms and Conditions