What are the advantages of using SQL stored procedures instead of adhoc SQL queries in an ASP.NET web application

Better Performance : As stored procedures are precompiled objects they execute faster than SQL queries. Every time we run a SQL query, the query has to be first compiled and then executed where as a stored procedure is already compiled. Hence executing stored procedures is much faster than executing SQL queries.
Better Security : For a given stored procedure you can specify who has the rights to execute. You cannot do the same for an SQL query. Writing the SQL statements inside our code is usually not a good idea. In this way you expose your database schema (design) in the code which may be changed. Hence most of the time programmers use stored procedures instead of plain SQL statements.
Reduced Network Traffic : Stored Procedures reside on the database server. If you have to execute a Stored Procedure from your ASP.NET web application, you just specify the name of the Stored Procedure. So over the network you just send the name of the Stored Procedure. With an SQL query you have to send all the SQL statements over the network to the database server which could lead to increased network traffic

Microsoft Chart Control Sys.WebForms.PageRequestManagerServerErrorException Errro

if you are using the Microsoft Chart control with in Update Panel sometimes its through the following exception
[Exception... "'Sys.WebForms.PageRequestManagerServerErrorException: Sys.WebForms.PageRequestManagerServerErrorException: Error executing child request for ChartImg.axd.' when calling method:

and controls not working properly,

you have to check the following details in your Web.config files
1.httpHandlers
remove name="ChartImageHandler"
add path="ChartImg.axd" verb="GET,HEAD,POST" type="System.Web.UI.DataVisualization.Charting.ChartHttpHandler, System.Web.DataVisualization, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" validate="false"/
httpHandlers

2.appSettings
add key="ChartImageHandler" value="Storage=file;Timeout=20;dir=your_sorage_here;"/
/appSettings

Pass Childwindow value to Parent Window

function setvalue() {
var txtvalue= document.getElementById("TextBox1").value;

window.opener.document.forms["form1"].elements["txttest"].value = txtvalue;//Parent Window Control ID
window.close();

// window.opener.document.forms["form1"].txttest.value=

}

Feature of VS.Net 2008

1.LINQ Support
2.Expression Blend Support
3.Windows Presentation Foundation
4.VS 2008 Multi-Targeting Support
5.AJAX support for ASP.NET
6.JavaScript Debugging Support
7.Nested Master Page Support
8.LINQ Intellisense and Javascript Intellisense support for silverlight applications
9.Organize Imports or Usings:
10.Intellisense Filtering:
11.Visual Studio 2008 Split View
12.In built Silverlight Library
13.Visual Studio LINQ Designer

GoogleAds sense Issue

The google Ads Script is not properly working when we using the Ajax Control toolkit and it's throw the following error

System.FormatException: String was not recognized as a valid DateTime

Ajax Atlas Date Parsing class Override the Google Ads Date Parse Class.Now we can solve the issue using the following snipset

  Date.__cyril_parse = Date.parse;
       Date.parse = function(s){
           try {
               return Date.__cyril_parse(s);
           } catch (e){
               var d = new Date(s);
               if (s) {
                   return s;
               } else {
                   throw e;
               }
           }

Click to see full details http://forums.asp.net/p/1055158/1501276.aspx
       }

My Sql Version Problem

When I am try to Installing the MySql 5.0 in Vista ,after finish the Installation I could not run the MySql Instance Config executable file and its throw the following message

“The Application has failed to start because its side-by-side configuration is incorrect. please see the application event log for more detail”.

After spent the time I got the fact of Issue which is MySQL Version problem. The MySql assembly manifest specifies that it requires the privilege ”as Administrator”.
The actual name is “requireAdministrator”.


I changed the privilege(Left side Tree 24--- 1--1033) and compile & save the file using the Resource Hacker. Now I can run the MySql Instance Config executable file.
Download the Resource Hacker http://www.angusj.com/resourcehacker/

How to redirect our Custom Error Page

In IIS 6 Select Your web site--> Go to Custom Error Tab --> Select Error Code -->Edit Property --> Set Your Error Page
In IIS 7 Select Your Web site --> Feature View --> Error Page --> Select Error Code –->Edit –->Set your Custom Error Page