ASP.Net, C#, MVC, Sharepoint, JavaScript, Jquery

Difference between Execute Reader & XMLReader & NonQuery & Scaler & Query

2010-03-17T22:40:00.000-07:00

Execute Reader..
1.Returns a datareader with data.
2.It is done by command object.
3.It is readonly.
4.It executes only select command.
5. This is known as a forward-only retrieval of records.It uses your sql statement to read through the table from the first to the last.

Execute XMLReader..
1.Returns the recordset as a XML document.

2. Just Like Reader other than this

Execute NonQuery..
1.It will not return any data.
2.It is used with insert ,update and delete.
3.It returns only the number of rows affected.

Execute Scaler..
1.It returns only one value.
2.That value will the first column first row value.
3.This is very light-weight and is perfect when all your query asks for is one item.
4. Select Count(*) or with in group by function

Execute Query..
1.Its for command objects.
2.It returns the value given by database through select statement.

Useful Links:
www.nigelwhitworth.com

Understanding Data Reader and Data Adapter

2010-03-03T00:46:00.000-08:00

Data Reader: It take the data sequentially from the command object and requies the connection should be open while it is getting data.
Data Adapter: It fetch all the required data from database and pass it to DataSet.
DataSet: It get all the required data from Data Adapter. It contains data in the form of Data Table.

DataSet : it is a disconnected Architecture.
DataReader : it is a Connected Architecture.

Connected Architecture : Means that while SqlDataReader reads the data from database and also reading data from SqlDataReader to any variable the connection to database should be open. Also once you read some data from SqlDataReader you should save them becouse it is not possible to go back and read it again.

Disconnected Architecture : It is followed by Dataset. In this once the data has been read by Dataset from SqlDataAdapter we can close the connection to database and retirve the data from Dataset where ever we want. Dataset hold the data in the form of table and do not interact with Datasouse.

For Details click

Visual Studio Keyboard Shortcut

2010-02-27T11:52:00.000-08:00

Comment:

( Ctrl + k ) + ( Ctrl + c ) : Comment Out a Block
( Ctrl + k ) + ( Ctrl + u ) : Uncomment Out a Block

Formate:

( Ctrl + k ) + ( Ctrl + d ) : Format whole doc
( Ctrl + e ) + ( Ctrl + w ) : word wrap
( Ctrl + m ) + ( Ctrl + o ) : Collapse whole code
( Ctrl + m ) + ( Ctrl + m ) : Collapse code / Expand code

Quick Find:

( Ctrl + g ) : Go to Line
( Ctrl + r ) : Replace
( Ctrl + f ) : Find
F12 / ( Shift + F12) : Go to Definition
( Ctrl + F3 ) : Search for the current section
( Ctrl + m ) + ( Ctrl + o ) : Collapse whole code
( Ctrl + -) /( Ctrl + Shift + - ) : Go back and forth of the code nevagation
( Ctrl + . ) : To get undefined Namespace
( Ctrl + / ) : Open file and ....

Advanced Feature:

"props"
You type "prop" and then press [TAB] twice, it generates useful code for your properties and can speed your typing.

Jquery Browser Detection and taking action

2010-02-21T20:04:00.001-08:00

if($.browser.msie){
       //do for IE
    }else if($.browser.mozilla){
       //do for mozilla
    }else if($.browser.safari){
        //do for safari
    }else if($.browser.chrome){
        //do for chrome
    }else if($.browser.opera){
        //do for opera
    }