|
|
-
|
|
In ASP.NET 3.5, for listview control, its required to specify Layout template. In layout template, we will define the template style of the root control. This is an additional step as for gridview control, its not required to specify layout template.
...
|
|
-
|
|
Charts are very much useful to visually present the data. In Reporting applications these are very much useful to present huge amount of data.
Before ASP.NET 4.0, to show Chart control in web page, users often resorted to Microsoft OWC chart control or...
|
|
-
|
|
In ASP.NET 4.0, Menu control has been improved in few areas.
1. **Rendering Mode:** Before ASP.NET 4.0, Menu control is rendered in the form of a table. Its difficult to apply CSS styling to table as it has child tags like "tr","td" etc and also its no...
|
|
-
|
|
ASP.NET 4.0 proves few SEO improvements, which will be very useful to improve website search rank.
1. Adding MetaDescription,MetaKeywords to Page properties
2. Response.RedirectPermanent Method
**1. Adding MetaDescription,MetaKeywords to Page properti...
|
|
-
|
|
In general, to show the details of a customer, we will use the URL like below.
showCustomer.aspx?Name=Alex
Search Engines can't read the query string part and this will affects in page ranking. By using URL routing, we can change the URL like belo...
|
|
-
|
|
SQL Server 2008 provides a very useful feature for DBA, to monitor the Database resources such as I/O,CPU,Processed running,Resource Waits etc.
In SSMS, in standard toolbar, click on Activity Monitor icon, which opens Activity Monitor for you.
![alt t...
|
|
-
|
|
Until SQL Server 2005, If we write complex queries/stored procedures, Its very difficult to debug these stored procedures. Developers used to depends on "print" statements. SQL Server 2008 introduced debugging feature, using which we can analyze complex...
|
|
-
|
|
In SQL Server 2005, while writing query, we need to remember object names. If we didn't remember object name, we need to go to object explorer and need to find the object names. With SQL Server 2008, we can use intellisense, which greatly helps while wr...
|
|
-
|
|
In general indexes contains all the table rows. However, In few scenarios, in multiple queries we might be using same condition and operates on same set of rows. Consider the Sales data, often we will interact with data of current year only. In that cas...
|
|
-
|
|
Row value constructor is a ANSI SQL Feature, which is introduced in Microsoft SQL Server 2008. Currently SQL Server will support this feature in the form of an values clause. To construct a table by using set of row value expressions by using single DML...
|
|