Good article to detect the status of a windows service using a ServiceController class in .Net - Detect Windows Service Status

Configuration settings has got its own importance in asp.net. It stores various settings for a lot of programming areas in asp.net. Some of them being, storing connection strings, page-level trace settings, httphandlers, httpmodules, authentication & authorization settings and a lot more.

Its hard to remember all of these settings and their attributes. The below link is a good for reference link that covers most of the configuration settings:

http://msdn.microsoft.com/en-us/library/b5ysx397(VS.71).aspx

Databinding is one of the most important aspect in ASP.Net. Databinding, and one does not think about using Eval and Bind methods, not possible. Mostly you will find these methods used in .aspx page, and within <%# and %> delimiters.

Both retrieve values from the data-bound fields underneath the data-bound controls and renders them to the html page within your data-bound controls. In addition to just retrieving the value from database field, the Bind method can also submit your changes back into the database. This is the main difference between Eval & Bind methods.

Eval is also called as read-only (select - database operation) method, and Bind is called as Read/Write (select, update, insert, delete - database operations) databinder method.

Get more details at MSDN explained very nicely.

Do not worry if you have deleted your emails using Del or Shift+Del (permanent delete) in outlook because it provides an option to recover deleted emails.

Go to Tools -> Recover Deleted Items which pops open a dialog where you can select the mails to recover.

SET ROWCOUNT causes SQL Server to stop processing the query after the specified number of rows are returned.

Once the ROWCOUNT is set then the following queries would return those many number of rows in the resultset irrespective of any filtering or conditions applied.

To turn off this option, set the ROWCOUNT to 0. This command can be executed by any
users. The user need not have any special permissions to execute this command.

Syntax:
SET ROWCOUNT <number> | <@number_var>

It is the best way to optimize a query, if we are aware of how many records we would
need at a time. For example, if you are performing custom paging for GridView in
asp.net 2.0, then you can set the query to return only the required number of rows as set in the PageSize property of the GridView.

Visit MSDN for more details with examples: MSDN

Chris Bryant introduces the new Microsoft Office 2010. Checkout the video for more details.

Look out for any USA jobs by visiting our job site at - USA Jobs.