Imp 90 % questions asked by everyone
Ramesh Maruthi
Top frequently asked questions in an interview
1) what is the difference between Abstarct class and interfaces?
Probably "Difference Between abstract Class and Interface" is the most frequent question being asked in .Net world . In this tutorial, I will explain the difference theoretically followed by code snippet. Theoretically there are basically 5 differences between Abstract Class and Interface which are listed as below :-
interface TestInterface
{
int x = 4; // Filed Declaration in Interface
void getMethod();
string getName();
}
abstract class TestAbstractClass
int i = 4;
int k = 3;
public abstract void getClassName();
} It will generate a compile time error as :- Error 1 Interfaces cannot contain fields . So we need to omit Field Declaration in order to compile the code properly. interface TestInterface {void getMethod();string getName(); }
} Above code compiles properly as no field declaration is there in Interface.
// Constructor Declaration
public TestInterface()
public TestAbstractClass()
Above code will generate a compile time error as :- Error 1 Interfaces cannot contain constructors So we need to omit constructor declaration from interface in order to compile our code . Following code compile s perfectly :-
public interface TestInterface
Above code compiles perfectly. It is not allowed to give any access specifier to the members of the Interface.
public void getMethod();
public string getName();
} Above code will generate a compile time error as :- Error 1 The modifier 'public' is not valid for this item. But the best way of declaring Interface will be to avoid access specifier on interface as well as members of interface. interface Test
2) what is d difference btwn overriding and overloading ?
Overloading a)In this approach we can define multiple methods with same name changing their signature means different parameters b) This can be performed within class as well as within child class c) Doesn't require any permission from parent for overloading its method in child Overriding a.It is an approach of defining multiple methods with same name and same signature b. this can be performed only under child class c. Requires an explicit permission from parent to override its methods in child
3) String Builder and String class ?
String:
A string is a sequential collection of Unicode characters that is used to represent text. String is a class which belongs to the namespace System. String.
String Concatenation can be done using '+' opearator or String.Concat method.
String.Concat method concatenates one or more instances of String.
Sample code:
string string1 = "Today is " + DateTime.Now.ToString ("D") + ".";
Console.WriteLine (string1);
string string2 = "Hi " + "This is Jitendra ";
string2 += "SampathiRao.";
Console.WriteLine(string2);
StringBuilder:
StringBuilder is a class which belongs to the namespace System.Text. This class cannot be inherited.
In StringBuilder we are using Append () method.
StringBuilder number = new StringBuilder (10000);
for (int i = 0; i<1000; i++)
returnNumber.Append (i.ToString ());
So where we can use these classes?
The answer is for simple String manipulations we can use String class. But the string manipulations are more it is better to use StringBuilder class.
Why the StringBuilder class is better for more string manipulations instead of String class?
The String object is immutable. Every time you use one of the methods in the System. Stringclass, you create a new string object in memory, which requires a new allocation of space for that new object. In situations where you need to perform repeated modifications to a string, the overhead associated with creating a new String object can be costly. It's nothing but performance of the application might be decreased. So we are using StringBuilder in such cases.
StringBuilder object is mutable. The System.Text.StringBuilder class can be used when you want to modify a string without creating a new object. For example, using the StringBuilder class can boost performance when concatenating many strings together in a loop." Differences between String and StringBuilder:
It belongs to String namespace
It belongs to String. Textnamespace
String object is immutable
StringBuilder object is mutable
Assigning:
String s= "somethingimportant";
StringBuilder sbuild= newStringBuilder("something important");
We can use '+' operator or Concatmethod to concatenate the strings.
Here we are using Append method.
When string concatenation happens,additional memory will be allocated.
Here additional memory will beallocated when the string buffer capacity exceeds only.
4) what is the diff btwn array and array list ?
Mirosoft.Net has many namespaces for different purposes. Among them the System.Collections is a very important namespace in the programmers perceptive. While coding, we look for classes that can reduce manual operation. For instance if you want to sort the values in an array then you have to do the manual operations. Here obviously we look for the classes that can automate the sorting by just calling a method. In other words we can call this namespace as a utility namespace. Let us see the classes in this namespace.
Collection Classes:
The System.Collections namespace has many classes for the individual purpose. We are going to discuss the frequently used classes in this article.
ArrayList:
The ArrayList is one of the important classes in the System.Collection namespace. We can say it is the next generation of the Array in C#.
ArrayList is a dynamic array; it will increase the size of the storage location as required. It stores the value as object. The allocation of the ArrayList can be achieved through the TrimToSize property.
Methods:
1
Add
It will add the element as objectin the ArrayList
2
AddRange
It will add the collections ofelements in the object as individual objects in the ArrayList
3
Clear
It will clear the all objects inthe ArrayList
4
BinarySearch
It will return the position of thesearch object as integer value.
5
Insert
It will insert the element in thespecified location of the index in the ArrayList.
6
InsertRange
It will insert the elements in theobject as individual objects in the specified location.
7
Remove
It will remove the given object inthe first occurrence in the ArrayList.
8
RemoveAt
It will remove the object asspecified in the argument.
9
RemoveRange
It will remove the set of objectsin the ArrayList from the range specified.
10
Sort
It will do the sorting of theelements in the ascending order.
11
Reverse
It will arrange the elements inthe reverse order in the ArrayList.
12
GetEnumerator
It will return the collection ofobjects in the ArrayList as enumerator.
13
Contains
It checks whether the objectsexists or not.
Properties in the ArrayList
S.No
PropertyName
Description
Capcity
This property is used to set orget the size to the ArrayList.
As you know it will increase thesize of the storage as much as required. Default size will be 16.
Count
It returns the total number ofelements in the ArrayList.
IsFixedSize
It returns the Whether theArrayList is fixed size or not. It returns the Boolean value.
IsReadOnly
It returns the Whether theArrayList is Readyonly or not. It returns the Boolean value.
Advantages:
Disadvantages:
Difference between Array and ArrayList
Array
ArrayList
Array uses the Vector array to store the elements
ArrayList uses the LinkedList to store the elements.
Size of the Array must be defined until redim used( vb)
No need to specify the storage size.
Array is a specific data type storage
ArrayList can be stored everything as object.
No need to do the type casting
Every time type casting has to do.
It will not lead to Runtime exception
It leads to the Run time error exception.
Element cannot be inserted or deleted in between.
Elements can be inserted and deleted.
There is no built in members to do ascending ordescending.
ArrayList has many methods to do operation like Sort,Insert, Remove, BinarySeacrh,etc..,
Conclusion:
So far we have seen the ArrayList and its members and properties. I hope that this has given enough practical idea about the ArrayList. Next we are going to discuss about the BitArray in the same collection class. If you have any query or further clarifications about this ArrayList please free to post your feedback and corrections.
5) what are cursors and constraints ?
Cursors :
A cursor is a database object that helps in accessing and manipulating data in a given result set.The main advantage of cursors is that you can process data row-by-row. A result set is defined as a collection of rows obtained from a SELECT statement that meet the criteria specified in te WHERE clause. Cursors,therefore,serve as a mechanism for applications to operate on a single row or a set of rows.Cursors enable the processing of rows in the given result set in the following ways: 1>Allow specific rows to be retrieved from the result set. 2>Allow the current row in the result set to be modified. 3>Help navigate from the current row in the result set to a different row. 4>Allow data modified by other users to be visible in the result set.
1. Declare the cursor 2. Initialize the cursor 3. Open the cursor 4. Fetch each row until the status is 0 5. close the cursor 6. deallocate the cursor
/* Create two variables that would store the values returned by the fetch statement */ DECLARE @DepartmentName char(25) DECLARE @DepartmentHead char(25) /* Define the cursor that can be used to access the records of the table,row by row */ DECLARE curDepartment cursor for SELECT vDepartmentName,vDepartmentHead from Department -- Open the cursor OPEN curDepartment -- Fetch the rows into variables FETCH curDepartment into @DepartmentName,@DepartmentHead --Start a loop to display all the rows of the cursor WHILE(@@fetch_status=0) BEGIN Print 'Department Name =' + @DepartmentName Print 'Department Head =' + @DepartmentHead --Fetch the next row from the cursor FETCH curDepartment into @DepartmentName,@DepartmentHead END -- Close the cursor CLOSE curDepartment -- Deallocate the cursor DEALLOCATE curDepartment
Following are different types of cursors available in SQL Server 2005 Base table Static Forward-only Forward-only/Read-only Keyset-driven Base table: Base table cursors are the lowest level of cursor available. Base table cursors can scroll forward or backward with minimal cost, and can be updated
Static: Cursor can move to any record but the changes on the data can't be seen. Dynamic: Most resource extensive. Cursor can move anywhere and all the changes on the data can be viewed. Forward-only: Cursor moves one step forward, can't move backwards. Keyset-driven: Only updated data can be viewed, deleted and inserted data cannot be viewed.
Constraint:
SQL Constraints
SQL constraints are used to specify rules for the data in a table.
If there is any violation between the constraint and the data action, the action is aborted by the constraint.
Constraints can be specified when the table is created (inside the CREATE TABLE statement) or after the table is created (inside the ALTER TABLE statement).
SQL CREATE TABLE + CONSTRAINT Syntax
CREATE TABLE table_name ( column_name1 data_type(size) constraint_name, column_name2 data_type(size) constraint_name, column_name3 data_type(size) constraint_name, .... );
In SQL, we have the following constraints:
While unique and primary keys both enforce uniqueness on the column(s) of one table, foreign keys define a relationship between two tables. A foreign key identifies a column or group of columns in one (referencing) table that refers to a column or group of columns in another (referenced) table – in our example above, the Employee table is the referenced table and the Employee Salary table is the referencing table.
7) Difference Between SCOPE_IDENTITY() and @@IDENTITY
@@IDENTITY - Returns the last identity values that were generated in any table in the current session. @@IDENTITY is not limited to a specific scope.
SCOPE_IDENTITY() - Return the last identity values that are generated in any table in the current session. SCOPE_IDENTITY returns values inserted only within the current scope.
8) Delegates and Events ?
The delegate topic seems to be a confusing and tough for most of the developers. In this article I will explain the basics of delegates and Event handling in C# in a simple manner.
Delegate is one of the base types in .NET. Delegate is a class, which is used to create delegate at runtime.
Delegate in C# is similar to a function pointer in C or C++. It's a new type of object in C#. Delegate is very special type of object as earlier the entire the object we used to defined contained data but delegate just contains the details of a method.
There might be situation in which you want to pass methods around to other methods. For this purpose we create delegate.
A delegate is a class that encapsulates a method signature. Although it can be used in any context, it often serves as the basis for the event-handling model in C# but can be used in a context removed from event handling (e.g. passing a method to a method through a delegate parameter).
One good way of understanding delegates is by thinking of a delegate as something that gives a name to a method signature.
Example: public delegate int DelegateMethod(int x, int y);
Any method that matches the delegate's signature, which consists of the return type and parameters, can be assigned to the delegate. This makes is possible to programmatically change method calls, and also plug new code into existing classes. As long as you know the delegate's signature, you can assign your own-delegated method.
This ability to refer to a method as a parameter makes delegates ideal for defining callback methods.
In class we create its object, which is instance, but in delegate when we create instance that is also referred as delegate (means whatever you do you will get delegate).
Delegate does not know or care about the class of the object that it references. Any object will do; all that matters is that the method's argument types and return type match the delegate's. This makes delegates perfectly suited for "anonymous" invocation.
In simple words delegates are object oriented and type-safe and very secure as they ensure that the signature of the method being called is correct. Delegate helps in code optimization.
1) Singlecast delegates
2) Multiplecast delegates
Delegate is a class. Any delegate is inherited from base delegate class of .NET class library when it is declared. This can be from either of the two classes from System.Delegate or System.MulticastDelegate.
Singlecast delegate point to single method at a time. In this the delegate is assigned to a single method at a time. They are derived from System.Delegate class.
When a delegate is wrapped with more than one method that is known as a multicast delegate.
In C#, delegates are multicast, which means that they can point to more than one function at a time. They are derived from System.MulticastDelegate class.
There are three steps in defining and using delegates:
1. Declaration
To create a delegate, you use the delegate keyword.
[attributes] [modifiers] delegate ReturnType Name ([formal-parameters]);
The attributes factor can be a normal C# attribute.
The modifier can be one or an appropriate combination of the following keywords: new, public, private, protected, or internal.
The ReturnType can be any of the data types we have used so far. It can also be a type void or the name of a class.
The Name must be a valid C# name.
Because a delegate is some type of a template for a method, you must use parentheses, required for every method. If this method will not take any argument, leave the parentheses empty.
Example:
public delegate void DelegateExample();
The code piece defines a delegate DelegateExample() that has void return type and accept no parameters.
2. Instantiation
DelegateExample d1 = new DelegateExample(Display);
The above code piece show how the delegate is initiated
3. Invocation
d1();
The above code piece invoke the delegate d1().
using System;
namespace ConsoleApplication5
class Program
public delegate void delmethod();
public class P
public static void display()
Console.WriteLine("Hello!");
public static void show()
Console.WriteLine("Hi!");
public void print()
Console.WriteLine("Print");
static void Main(string[] args)
// here we have assigned static method show() of class P to delegate delmethod()
delmethod del1 = P.show;
// here we have assigned static method display() of class P to delegate delmethod() using new operator
// you can use both ways to assign the delagate
delmethod del2 = new delmethod(P.display);
P obj = new P();
// here first we have create instance of class P and assigned the method print() to the delegate i.e. delegate with class
delmethod del3 = obj.print;
del1();
del2();
del3();
Console.ReadLine();
namespace delegate_Example4
public delegate void delmethod(int x, int y);
public class TestMultipleDelegate
public void plus_Method1(int x, int y)
Console.Write("You are in plus_Method");
Console.WriteLine(x + y);
public void subtract_Method2(int x, int y)
Console.Write("You are in subtract_Method");
Console.WriteLine(x - y);
TestMultipleDelegate obj = new TestMultipleDelegate();
delmethod del = new delmethod(obj.plus_Method1);
// Here we have multicast
del += new delmethod(obj.subtract_Method2);
// plus_Method1 and subtract_Method2 are called
del(50, 10);
Console.WriteLine();
//Here again we have multicast
del -= new delmethod(obj.plus_Method1);
//Only subtract_Method2 is called
del(20, 10);
Point to remember about Delegates:
Usage areas of delegates
An Anonymous Delegate
You can create a delegate, but there is no need to declare the method associated with it. You do not have to explicitly define a method prior to using the delegate. Such a method is referred to as anonymous.
In other words, if a delegate itself contains its method definition it is known as anonymous method.
public delegate void Test();
public class Program
static int Main()
Test Display = delegate()
Console.WriteLine("Anonymous Delegate method");
};
Display();
return 0;
} } Note: You can also handle event in anonymous method.
Event and delegate are linked together.
Event is a reference of delegate i.e. when event will be raised delegate will be called.
In C# terms, events are a special form of delegate. Events are nothing but change of state. Events play an important part in GUI programming. Events and delegates work hand-in-hand to provide a program's functionality.
A C# event is a class member that is activated whenever the event it was designed for occurs.
It starts with a class that declares an event. Any class, including the same class that the event is declared in, may register one of its methods for the event. This occurs through a delegate, which specifies the signature of the method that is registered for the event. The event keyword is a delegate modifier. It must always be used in connection with a delegate.
The delegate may be one of the pre-defined .NET delegates or one you declare yourself. Whichever is appropriate, you assign the delegate to the event, which effectively registers the method that will be called when the event fires.
Once an event is declared, it must be associated with one or more event handlers before it can be raised. An event handler is nothing but a method that is called using a delegate. Use the += operator to associate an event with an instance of a delegate that already exists.
obj.MyEvent += new MyDelegate(obj.Display);
An event has the value null if it has no registered listeners.
Although events are mostly used in Windows controls programming, they can also be implemented in console, web and other applications.
namespace delegate_custom
public delegate void MyDelegate(int a);
public class XX
public event MyDelegate MyEvent;
public void RaiseEvent()
MyEvent(20);
Console.WriteLine("Event Raised");
public void Display(int x)
Console.WriteLine("Display Method {0}", x);
XX obj = new XX();
obj.RaiseEvent();
}}
9) ASP.NET page cycle?
Each request for an .aspx page that hits IIS is handed over to HTTP Pipeline. HTTP Pipeline is a chain of managed objects that sequentially process the request and convert it to plain HTML text content. The start point of HTTP Pipeline is the HttpRuntime class. The ASP.NET infrastructure creates each instance of this class per AppDomain hosted within the worker process. HttpRuntime class picks up an HttpApplication object from an internal pool and sets it to work on the request. It finds out what class has to handle the request. The association between the resources and handlers are stored in the configurable file of the application. In web.config and also inmachine.config you will find these lines in section.
If you run through the following program, it will be much easier to follow
<add verb="*" path="*.aspx" type="System.Web.UI.PageHandlerFactory"/>
This extension can be associated with HandlerClass or HandlerFactory class. HttpApplicationobject gets the page object that implements the IHttpHandler Interface. The process of generating the output to the browser is started when the object calls ProcessRequest method. Page Life Cycle Once the HTTP page handler class is fully identified, the ASP.NET runtime calls the handler'sProcessRequest to start the process. This implementation begins by calling the methodFrameworkInitialize(), which builds the control trees for the page. This is a protected and virtual member of TemplateControl class, class from which page itself derives. Next the processRequest() makes page transits various phases: initialization, loading of viewstate and postback data, loading of page's user code and execution postback server-side events. Then page enters in render mode, the viewstate is updated and HTML generated is sent to the output console. Finally page is unloaded and request is considered completely served. Stages and corresponding events in the life cycle of the ASP.NET page cycle:
Stage
Events/Method
Page Initialization
Page_Init
View State Loading
LoadViewState
Postback data processing
LoadPostData
Page Loading
Page_Load
PostBack Change Notification
RaisePostDataChangedEvent
PostBack Event Handling
RaisePostBackEvent
Page Pre Rendering Phase
Page_PreRender
View State Saving
SaveViewState
Page Rendering
Page_Render
Page Unloading
Page_UnLoad
Some of the events listed above are not visible at the page level. It will be visible if you happen to write server controls and write a class that is derived from page
(1) PreInit
The entry point of the page life cycle is the pre-initialization phase called "PreInit". This is the only event where programmatic access to master pages and themes is allowed. You can dynamically set the values of master pages and themes in this event. You can also dynamically create controls in this event.
EXAMPLE : Override the event as given below in your code-behind cs file of your aspx page
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
public partial class _Default : System.Web.UI.Page
protected void Page_PreInit(object sender, EventArgs e)
// Use this event for the following:
// Check the IsPostBack property to determine whether this is the first time the page is being processed.
// Create or re-create dynamic controls.
// Set a master page dynamically.
// Set the Theme property dynamically.
(2)Init
This event fires after each control has been initialized, each control's UniqueID is set and any skin settings have been applied. You can use this event to change initialization values for controls. The "Init" event is fired first for the most bottom control in the hierarchy, and then fired up the hierarchy until it is fired for the page itself.
protected void Page_Init(object sender, EventArgs e)
// Raised after all controls have been initialized and any skin settings have been applied. // Use this event to read or initialize control properties.
(3)InitComplete
Raised once all initializations of the page and its controls have been completed. Till now the viewstate values are not yet loaded, hence you can use this event to make changes to view state that you want to make sure are persisted after the next postback
protected void Page_InitComplete(object sender, EventArgs e)
// Raised by the Page object. Use this event for processing tasks that require all initialization be complete.
(4)PreLoad
Raised after the page loads view state for itself and all controls, and after it processes postback data that is included with the Request instance
Loads ViewState : ViewState data are loaded to controls
Note : The page viewstate is managed by ASP.NET and is used to persist information over a page roundtrip to the server. Viewstate information is saved as a string of name/value pairs and contains information such as control text or value. The viewstate is held in the value property of a hidden control that is passed from page request to page request.
Loads Postback data : postback data are now handed to the page controls
Note : During this phase of the page creation, form data that was posted to the server (termed postback data in ASP.NET) is processed against each control that requires it. Hence, the page fires the LoadPostData event and parses through the page to find each control and updates the control state with the correct postback data. ASP.NET updates the correct control by matching the control's unique ID with the name/value pair in the NameValueCollection. This is one reason that ASP.NET requires unique IDs for each control on any given page.
protected override void OnPreLoad(EventArgs e)
// Use this event if you need to perform processing on your page or control before the Load event.
// Before the Page instance raises this event, it loads view state for itself and all controls, and // then processes any postback data included with the Request instance.
(5)Load
The important thing to note about this event is the fact that by now, the page has been restored to its previous state in case of postbacks. Code inside the page load event typically checks for PostBack and then sets control properties appropriately. This method is typically used for most code, since this is the first place in the page lifecycle that all values are restored. Most code checks the value of IsPostBack to avoid unnecessarily resetting state. You may also wish to call Validate and check the value of IsValid in this method. You can also create dynamic controls in this method.
protected void Page_Load(object sender, EventArgs e)
// The Page calls the OnLoad event method on the Page, then recursively does the same for each child// control, which does the same for each of its child controls until the page and all controls are loaded.
// Use the OnLoad event method to set properties in controls and establish database connections.
(6)Control (PostBack) event(s)
ASP.NET now calls any events on the page or its controls that caused the PostBack to occur. This might be a button's click event or a dropdown's selectedindexchange event, for example.
These are the events, the code for which is written in your code-behind class(.cs file).
protected void Button1_Click(object sender, EventArgs e)
// This is just an example of control event.. Here it is button click event that caused the postback
(7)LoadComplete
This event signals the end of Load.
protected void Page_LoadComplete(object sender, EventArgs e)
// Use this event for tasks that require that all other controls on the page be loaded.
(8)PreRender
Allows final changes to the page or its control. This event takes place after all regular PostBack events have taken place. This event takes place before saving ViewState, so any changes made here are saved.
For example : After this event, you cannot change any property of a button or change any viewstate value. Because, after this event, SaveStateComplete and Render events are called.
protected override void OnPreRender(EventArgs e)
// Each data bound control whose DataSourceID property is set calls its DataBind method.
// The PreRender event occurs for each control on the page. Use the event to make final // changes to the contents of the page or its controls.
(9)SaveStateComplete
Prior to this event the view state for the page and its controls is set. Any changes to the page's controls at this point or beyond are ignored.
protected override void OnSaveStateComplete(EventArgs e)
// Before this event occurs, ViewState has been saved for the page and for all controls. // Any changes to the page or controls at this point will be ignored.
// Use this event perform tasks that require view state to be saved, but that do not make any changes to controls.
(10)Render
This is a method of the page object and its controls (and not an event). At this point, ASP.NET calls this method on each of the page's controls to get its output. The Render method generates the client-side HTML, Dynamic Hypertext Markup Language (DHTML), and script that are necessary to properly display a control at the browser.
Note: Right click on the web page displayed at client's browser and view the Page's Source. You will not find any aspx server control in the code. Because all aspx controls are converted to their respective HTML representation. Browser is capable of displaying HTML and client side scripts.
// Render stage goes here. This is not an event
(11)UnLoad
This event is used for cleanup code. After the page's HTML is rendered, the objects are disposed of. During this event, you should destroy any objects or references you have created in building the page. At this point, all processing has occurred and it is safe to dispose of any remaining objects, including the Page object.
Cleanup can be performed on-
(a)Instances of classes i.e. objects
(b)Closing opened files
(c)Closing database connections.
protected void Page_UnLoad(object sender, EventArgs e)
// This event occurs for each control and then for the page. In controls, use this event to do final cleanup // for specific controls, such as closing control-specific database connections.
// During the unload stage, the page and its controls have been rendered, so you cannot make further // changes to the response stream.
//If you attempt to call a method such as the Response.Write method, the page will throw an exception.
10)Request and response in iis ?
When client request for some information from a web server, request first reaches to HTTP.SYS of IIS. HTTP.SYS then send the request to respective Application Pool. Application Pool then forward the request to worker process to load the ISAPI Extension which will create an HTTPRuntime Object to Process the request via HTTPModule and HTTPHanlder. After that the ASP.NET Page LifeCycle events starts.
11) what are ADO.net objects ?
ADO.NET is designed to help developers work efficiently with multi tier databases, across intranet or Internet scenarios.
The ADO.NET object model consists of two key components as follows:
Connection
The Connection object is the first component of ADO.NET. The connection object opens a connection to your data source.
All of the configurable aspects of a database connection are represented in the Connection object, which includes ConnectionString and ConnectionTimeout.
Connection object helps in accessing and manipulating a database. Database transactions are also dependent upon the Connection object.
In ADO.NET the type of the Connection is depended on what Database system you are working with. The following are the commonly using the connections in the ADO.NET
Command
The Command object is used to perform action on the data source. Command object can execute stored procedures and T-SQL commands.
You can execute SQL queries to return data in a DataSet or a DataReader object. Command object performs the standard Select, Insert, Delete and Update T-SQL operations.
The DataReader is built as a way to retrieve and examine the rows returned in response to your query as quickly as possible.
No DataSet is created; in fact, no more than one row of information from the data source is in-memory at a time. This makes the DataReader quiet efficient at returning large amounts of data.
The data returned by a DataReader is always read only. This class was built to be a lightweight forward only, read only, way to run through data quickly (this was called a firehose cursor in ADO).
However, if you need to manipulate schema or use some advance display features such as automatic paging, you must use a DataAdapter and DataSet.
DataReader object works in connected model.
The DataAdapter takes the results of a database query from a Command object and pushes them into a DataSet using the DataAdapter.Fill() method. Additionally the DataAdapter.Update() method will negotiate any changes to a DataSet back to the original data source.
DataAdapter object works in connected model. DataAdapter performs five following steps:
It is used to save changes made in-memory cache of data on backend. The work of Command Builder is to generate Command as per changes in DataRows.
Command Builder generates command on basis of row state. There are five row state:
Command Builder works on add, delete and modified row state only.
Detached is used when object is not created from row state.
The Transaction object is used to execute backend transaction. Transactions are used to ensure that multiple changes to database rows occur as a single unit of work.
The Connection class has a BeginTransaction method that can be used to create a Transaction.
A definite best practice is to ensure that Transactions are placed in Using statements for rapid cleanup if they are not committed. Otherwise the objects (and any internal locks that may be needed) will remain active until the GC gets around to cleaning it up.
Parameter object is used to solve SQL Injection attack problem while dealing with the user input parameters.
Parameter object allows passing parameters into a Command object the Parameter class allows you to quickly put parameters into a query without string concatenation.
Note: See my other article on ADO.NET Objects Part II.
Hope the article would have helped you in understanding ADO.NET objects.
Your feedback and constructive contributions are welcome. Please feel free to contact me for feedback or comments you may have about this article.
ADO.NET is designed to help developers work efficiently with multi-tier databases, across intranet or Internet scenarios.
The DataSet Object is the parent object to most of the other objects in the System.Data namespace. The dataset is a disconnected, in-memory representation of data.
Its primary role is to store a collection of DataTables and the relations and constraints between those DataTables.
DataSet also contains several methods for reading and writing XML, as well as merging other DataSets, DataTables and DataRows.
Some of the advantages of the new DataSet object are:
DataTable stores a table of information, typically retrieved from a data source. DataTable allows you to examine the actual rows of a DataSet through rows and columns collections.
Once the DataTable is filled the database connection is released and operates disconnected only.
You can complex-bind a control to the information contained in a data table. Controls like DataGrid are used for this purpose
DataTable also stores metatable information such as the primary key and constraints.
The DataRow class permits you to reference a specific row of data in a DataTable. This is the class that permits you to edit, accept, or reject changes to the individual DataColumns of the row.
You would use a DataRow object and its properties and methods to retrieve and evaluate the values in a DataTable object.
The DataRowCollection represents the actual DataRow objects that are in the DataTable object, and the DataColumnCollection contains the DataColumn objects that describe the schema of the DataTable object.
DataColumns
DataColumns is the building block of the DataTable. A number of such objects make up a table. Each DataColumn object has a DataType property that determines the kind of data that the column is holding. data table
DataColumn instances are also the class of object that you use to read and write individual columns of a database. The Items property of a DataRow returns a DataColumn.
A DataView is an object that provides a custom view of data in a DataTable. DataViews provide sorting, filtering, and other types of customizations.
Each DataTable object has a DefaultView property, which holds the default DataView object for that DataTable. Modifying the DefaultView object sets the default display characteristics for the DataTable.
You can create an instance of a DataView and associate it with a particular DataTable in a DataSet. This permits you to have two or more different views of the same DataTable simultaneously available.
DataRelation
A DataRelation identifies that two or more of the DataTables in a DataSet contain data related in a one-to-one or one-to-many (parent-child) association. You define a relationship between twotables by adding a new DataRelation object to the DataSet's
Constraints
Each DataColumn may have multiple Constraints. Conditions such as unique are applied through this class. Constraint objects are maintained through the DataTables Constraints collection.
A DataRowView is a special object that represents a row in a DataView. Each DataView can have a different RowStateFilter, the DataRowView obtained from a DataView will contain data consistent with the DataView's RowStateFilter, providing a custom view of the data.
12) what is d diff bwtn stored procedure and functions ?
1. Procedures can have input/output parameters for it whereas functions can have only input parameters. 2. Procedure allows select as well as DML statement in it whereas function allows only select statement in it. 3. We can go for transaction management in procedure whereas we can't go in function. 4. Procedures can not be utilized in a select statement whereas function can be embedded in a select statement.
13) what is d diff btwn stored procedure and triggers?
14) Diff b/w Dataset n datareader ?
DataReader
DataReader is used to read the data from database and it is a read and forward only connection oriented architecture during fetch the data from database. DataReader will fetch the data very fast when compared with dataset. Generally we will use ExecuteReader object to bind data to datareader.
To bind DataReader data to GridView we need to write the code like as shown below:
Protected void BindGridview()
using (SqlConnection conn = new SqlConnection("Data Source=abc;Integrated Security=true;Initial Catalog=Test"))
con.Open();
SqlCommand cmd = new SqlCommand("Select UserName, First Name,LastName,Location FROM Users", conn);
SqlDataReader sdr = cmd.ExecuteReader();
gvUserInfo.DataSource = sdr;
gvUserInfo.DataBind();
conn.Close();
DataSet
DataSet is a disconnected orient architecture that means there is no need of active connections during work with datasets and it is a collection of DataTables and relations between tables. It is used to hold multiple tables with data. You can select data form tables, create views based on table and ask child rows over relations. Also DataSet provides you with rich features like saving data as XML and loading XML data.
protected void BindGridview()
SqlConnection conn = new SqlConnection("Data Source=abc;Integrated Security=true;Initial Catalog=Test");
conn.Open();
SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
gvUserInfo.DataSource = ds;
DataAdapter
DataAdapter will acts as a Bridge between DataSet and database. This dataadapter object is used to read the data from database and bind that data to dataset. Dataadapter is a disconnected oriented architecture. Check below sample code to see how to use DataAdapter in code:
SqlConnection con = new SqlConnection("Data Source=abc;Integrated Security=true;Initial Catalog=Test");
DataTable DataTable represents a single table in the database. It has rows and columns. There is no much difference between dataset and datatable, dataset is simply the collection of datatables.
DataTable dt = new DataTable();
da.Fill(dt);
gridview1.DataSource = dt;
gvidview1.DataBind();
15 ) differnce btwn javascript jquery and ajax?
Javascript 1)Javascript is a client-side (in the browser) scripting language. 2)Javascript lets you supercharge your HTML with animation, interactivity, and dynamic visual effects 3)JavaScript can make web pages more useful by supplying immediate feedback. 4)JavaScript is the common term for a combination of the ECMAScript programming language plus some means for accessing a web browser's windows and the document object model (DOM). 5)JavaScript was designed to add interactivity to HTML pages 6)Everyone can use JavaScript without purchasing a license jQuery 1)jQuery is a library/framework built with Javascript. 2)It abstracts away cross-browser compatibility issues and it emphasises unobtrusive and callback-driven Javascript programming 3)jQuery (website) is a javascript framework that makes working with the DOM easier by building lots of high level functionality that can be used to search and interact with the DOM 4)jQuery implements a high-level interface to do AJAX requests 5)jQuery is a fast and concise JavaScript Library that simplifies HTML document traversing, event handling, animating, and Ajax interactions for rapid web development AJAX 1)AJAX (Asynchronous Javascript XML) is a method to dynamically update parts of the UI without having to reload the page - to make the experience more similar to a desktop application. 2)AJAX is a technique to do an XMLHttpRequest (out of band Http request) from a web page to the server and send/retrieve data to be used on the web page 3)It uses javascript to construct an XMLHttpRequest, typically using different techniques on various browsers. 4)AJAX is a set of functions of the language JavaScript 5)Examples of applications using AJAX: Google Maps, Gmail, Youtube, and Facebook tabs.
Why AJAX?
This is probably one of the most asked questions about AJAX.
The main advantage of using AJAX enabled ASP.NET Web applications is improved efficiency and reduce the page refresh time. AJAX enables us to refresh only parts of a Web page that have been updated, rather refreshing the entire page.
For example, if you have four controls on a Web page say a DropDownList, a TextBox, a ListBox, and a GridView. The GridView control shows some data based on the selection in DropDownList and other controls. Now let's say GridView also has paging and sorting options. So whenever you move to next page or apply sort, the entire page and all four controls on the page will be refreshed and you will notice a page flicker because ASP.NET has to render the entire page on the client side and it happens once
In an AJAX-enabled Web page, you will see only the GridView data is being refreshed and rest of the page and controls do not. Doing so, we not only get better performance and faster refresh, we also get a better or should I say "smoother" user experience.
You may want to see a live example of AJAX enabled GridView on our www.mindcracker.com web site in Jobs section here: http://www.mindcracker.com/Jobs/. On this page, if you click on Next page link, you will see only GridView data is being refreshed. We are also implementing AJAX on C# Corner and other sites as well.
What Browsers AJAX Support?
AJAX is JavaScript based and supports most of the browsers including Internet Explorer, Mozilla Firefox, and Apple Safari.
ASP.NET AJAX is a combination of client-script libraries (JavaScript) and ASP.NET servercomponents that are integrated to provide a robust development framework. If you look at your library folder, you will see following .js files listed in Figure 1.
Figure 1.
The ASP.NET AJAX server controls consist of server and client code that integrate to produce AJAX-like behavior. The following controls are available in AJAX 1.0 library:
The ASP.NET AJAX Control Toolkit is a collection of samples and components that show you some of the experiences you can create with rich client ASP.NET AJAX controls and extenders. The Control Toolkit provides both samples and a powerful SDK to simplify creating and reusing your custom controls and extenders. You can download the ASP.NET AJAX Control Toolkit from the ASP.NET Ajax Web site.
16 ) What is the differnce between wcf and web services?
A Web Service is programmable application logic accessible via standard Web protocols. One of these Web protocols is the Simple Object Access Protocol (SOAP). SOAP is a W3C submitted note (as of May 2000) that uses standards based technologies (XML for data description and HTTP for transport) to encode and transmit application data.
Consumers of a Web Service do not need to know anything about the platform, object model, or programming language used to implement the service; they only need to understand how to send and receive SOAP messages (HTTP and XML).
Windows Communication Foundation (WCF) is a framework for building service-oriented applications. Using WCF, you can send data as asynchronous messages from one service endpoint to another. A service endpoint can be part of a continuously available service hosted by IIS, or it can be a service hosted in an application. An endpoint can be a client of a service that requests data from a service endpoint. The messages can be as simple as a single character or word sent as XML, or as complex as a stream of binary data.
In what scenarios must WCF be used
· A secure service to process business transactions.
· A service that supplies current data to others, such as a traffic report or other monitoring service.
· A chat service that allows two people to communicate or exchange data in real time.
· A dashboard application that polls one or more services for data and presents it in a logical presentation.
· Exposing a workflow implemented using Windows Workflow Foundation as a WCF service.
· A Silverlight application to poll a service for the latest data feeds.
· Service Orientation
· Interoperability
· Multiple Message Patterns
· Service Metadata
· Data Contracts
· Security
· Multiple Transports and Encodings
· Reliable and Queued Messages
· Durable Messages
· Transactions
· AJAX and REST Support
· Extensibility
WCF is a replacement for all earlier web service technologies from Microsoft. It also does a lot more than what is traditionally considered as "web services".
WCF "web services" are part of a much broader spectrum of remote communication enabled through WCF. You will get a much higher degree of flexibility and portability doing things in WCF than through traditional ASMX because WCF is designed, from the ground up, to summarize all of the different distributed programming infrastructures offered by Microsoft. An endpoint in WCF can be communicated with just as easily over SOAP/XML as it can over TCP/binary and to change this medium is simply a configuration file mod. In theory, this reduces the amount of new code needed when porting or changing business needs, targets, etc.
ASMX is older than WCF, and anything ASMX can do so can WCF (and more). Basically you can see WCF as trying to logically group together all the different ways of getting two apps to communicate in the world of Microsoft; ASMX was just one of these many ways and so is now grouped under the WCF umbrella of capabilities.
Web Services can be accessed only over HTTP & it works in stateless environment, where WCF is flexible because its services can be hosted in different types of applications. Common scenarios for hosting WCF services are IIS,WAS, Self-hosting, Managed Windows Service.
The major difference is that Web Services Use XmlSerializer. But WCF Uses DataContractSerializer which is better in Performance as compared to XmlSerializer.
XmlSerializer
DataContractSerializer
· Only Public fields or Properties of .NET types can be translated into XML
Public
· Only the classes which implement IEnumerable interface
IEnumerable
· Classes that implement the IDictionary interface, such as Hash table cannot be serialized
IDictionary
· A practical benefit of the design of the DataContractSerializer is better performance overXmlserializer.
Xmlserializer
· XML Serialization does not indicate which fields or properties of the type are serialized into XML whereasDataCotractSerializer
DataCotractSerializer
· Explicitly shows the which fields or properties are serialized into XML
· The DataContractSerializer can translate the HashTable into XML
HashTable
The development of web service with ASP.NET relies on defining data and relies on the XmlSerializer to transform data to or from a service.
The WCF uses the DataContractAttribute and DataMemeberAttribute to translate .NET FW types into XML.
DataContractAttribute
DataMemeberAttribute
Collapse | Copy Code
[DataContract]
public class Item
[DataMember]
public string ItemID;
public decimal ItemQuantity;
public decimal ItemPrice;
The DataContractAttribute can be applied to the class or a strcture. DataMemberAttribute can be applied to field or a property and theses fields or properties can be either public or private.
DataMemberAttribute
public
private
Important difference between DataContractSerializer and XMLSerializer.
XMLSerializer
· A practical benefit of the design of the DataContractSerializer is better performance over XML serialization.
· XML Serialization does not indicate which fields or properties of the type are serialized into XML whereasDataContractSerializer explicitly shows which fields or properties are serialized into XML.
· The DataContractSerializer can translate the HashTable into XML.
To develop a service using ASP.NET, we must add the WebService attribute to the class and WebMethodAttributeto any of the class methods.
WebService
WebMethodAttribute
[WebService]
public class Service : System.Web.Services.WebService
[WebMethod]
public string Test(string strMsg)
return strMsg;
To develop a service in WCF, we will write the following code:
[ServiceContract]
public interface ITest
[OperationContract]
string ShowMessage(string strMsg);
public class Service : ITest
public string ShowMessage(string strMsg)
The ServiceContractAttribute specifies that an interface defines a WCF service contract, OperationContract attribute indicates which of the methods of the interface defines the operations of the service contract.
ServiceContractAttribute
OperationContract
A class that implements the service contract is referred to as a service type in WCF.
ASP.NET web services are compiled into a class library assembly and a service file with an extension .asmx will have the code for the service. The service file is copied into the root of the ASP.NET application and Assembly will be copied to the bin directory. The application is accessible using URL of the service file.
Assembly
WCF Service can be hosted within IIS or WindowsActivationService.
WindowsActivationService
· Compile the service type into a class library
· Copy the service file with an extension .SVC into a virtual directory and assembly into bin sub directory of the virtual directory.
· Copy the web.config file into the virtual directory.
Clients for the ASP.NET Web services are generated using the command-line tool WSDL.EXE.
WCF uses the ServiceMetadata tool (svcutil.exe) to generate the client for the service.
ServiceMetadata
The Header of the SOAP Message can be customized in ASP.NET Web service.
WCF provides attributes MessageContractAttribute, MessageHeaderAttribute andMessageBodyMemberAttribute to describe the structure of the SOAP Message.
MessageContractAttribute
MessageHeaderAttribute
MessageBodyMemberAttribute
Issuing a HTTP GET Request with query WSDL causes ASP.NET to generate WSDL to describe the service. It returns the WSDL as a response to the request.
GET
The generated WSDL can be customized by deriving the class of ServiceDescriptionFormatExtension.
ServiceDescriptionFormatExtension
Issuing a Request with the query WSDL for the .svc file generates the WSDL. The WSDL that generated by WCF can be customized by using ServiceMetadataBehavior class.
ServiceMetadataBehavior
In ASP.NET Web services, unhandled exceptions are returned to the client as SOAP faults.
In WCF Services, unhandled exceptions are not returned to clients as SOAP faults. A configuration setting is provided to have the unhandled exceptions returned to clients for the purpose of debugging.
16) SOAP, WSDL, UDDI overview.
XML- Describes only data. So, any application that understands XML-regardless of the application's programming language or platform-has the ability to format XML in a variety of ways (well-formed or valid).
SOAP- Provides a communication mechanism between services and applications. WSDL- Offers a uniform method of describing web services to other programs.
UDDI- Enables the creation of searchable Web services registries.
Nice and well explained answer ...