Visual Studio 2008 and .NET 2.0

HI.Friends Recently I m Working With Visual Studio 2008 and .Net 3.5 But I found that VS2008 can also Be used With .Net 2.0 and it Is more Powerful in some areas where VS2005 has poor functionality.So

So why use VS 2008 if you aren't using the new .NET 3.5 features?

1. JavaScript intellisense
2. Much richer JavaScript debugging
3. Nested ASP.NET master page support at design-time
4. Rich CSS editing and layout support within the WYSIWYG designer
5. Split-view designer support for having both source and design views open on a page at the same time
6. A much faster ASP.NET page designer - with dramatic perf improvements in view-switches between source/design mode
7. Automated .SQL script generation and hosting deployment support for databases on remote servers

Overview to Reverse Ajax

An introduction to Reverse Ajax Despite all the hype, Ajax cannot get real time information directly from the server. If some information arrives after the user has loaded a page they will never see it, unless they refresh the page. We could easily solve this problem in the traditional way, by having a having a little bit of Javascript in the webpage that automatically refreshes the page every few seconds. But refreshing an entire page every few seconds is overkill. If the millions of users of a large site were to refresh every few seconds it would increase the bandwidth dramatically. The effect on the servers would be similar to a DOS attack! We really just need the small piece of real time data to be updated on the browser as soon as it arrives in the server. The simplest way would be to have the server tell all the browsers that the data has been updated. But as we discussed in the introduction to Ajax, servers cannot initiate contact with browsers. Hence we need a solution which gets around this problem. Reverse Ajax allows servers to push content out to browsers immediately it becomes available

SQL Server Case Sensitive or case insensitive Quries

When we need That Comparison in SQL server should be Case Sensitive or Case Insensitive Regardless Database is configured or Not for Case Sensitivity We can Write Such Queries Using Following Syntax.

By default queries behave as per Database configured.

(1)Default Query:

SELECT * FROM Members WHERE Email = ‘mailto:dhameliyaharesh@gmail.com%27

(2)Case Sensitive Query:

SELECT * FROM Members WHERE Email = ‘mailto:dhameliyaharesh@gmail.com%27 COLLATE SQL_Latin1_General_CP1_CS_AS

Above query will matches dhameliyaharesh@gmail.com And Not Matches DHAMELIYAHARESH@GMAIL.COM

(3)Case Insensitive Query:

SELECT * FROM Members WHERE Email = ‘mailto:dhameliyaharesh@gmail.com%27 COLLATE SQL_Latin1_General_CP1_CI_AS

Above query will matches dhameliyaharesh@gmail.com as well as DHAMELIYAHARESH@GMAIL.COM