Xml manipulation in ASP.NET using C#

HI guys,
While working with Xml using C# ,yesterday i found it very simple. We can easily create, modify and delete nodes in Xml files. So its not a bif deal to work with it. So i simply give you an example od working with Xml file which is consumed by a web service and displaying records from Xml into a GridView in asp.net page. Following is the sample.

How to improve code performance using jQuery

Hi guys,
In this article i am enlisting some of the very important points which every developer need to consider while working with jQuery to enhance the performance of code . Examples would be generating very long tables with a lot of rows using AJAX to get JSON data. Or iterating through a long (very long) list of data, etc.

How to improve performance of web application or portal

In this article i will explain some of the points that all developers must be familiar. Whenever we are planning to develop a web application or web portal we must know these point so that performance of our application is good. So following are the considerable points:--

• Turn off Tracing unless until required

Tracing is one of the wonderful features which enables us to track the application's trace and the sequences. However, again it is useful only for developers and you can set this to "false" unless you require to monitor the trace logging.

How to improve performance of Database Operations in application

 Hello Guys.

                   Today I am going to explain some tips that I have realized to improve the performance of web application or portal in context of database operation. We all know that without any database no dynamic website/application or portal can function.  So it’s very important for us to effectively work with database. Following are some of the points which we need to consider while designing and developing our application so that its performance is always better. And we wouldn’t have to worry after the application development that how to optimize this application as its performance is very poor with respect to others.

Dynamic SQL Statement in SQL Server

Dynamic SQL:

• 
  

  A dynamic sql statement is a set of sql statements which are constructed at execution time.

  
  


• 
  

  We may have to face certain condition in our application development where we might have to retrieve records from different table based on different conditions then in that scenario we do use dynamic SQL.

  
  


• 
  

  These dynamic Sql statement doesn’t parsed at compile time so it may introduce security vulnerabilities in our databse so we should try to avoid using dynamic sql as much as possible.

  
  


• 
  

  There are two ways to execute a dynamic sql statement in sql server:-

  
  

sp_executesql
EXECUTE()

• 
  

  Although these two methods produces same results but there might be certain scenario where it may produce different results.

  
  

Following is little description about the above two methods:

1.       sp_executesql :-

• 
  

  It is a system stored procedure.

  
  


• 
  

  It allows parameters to be passed IN or OUT of the dynamic sql statement.

  
  


• 
  

  It is less susceptible to SQL Injection.

  
  


• 
  

  Higher chance for sql string to remain in cache which results better performance when the same sql statement is executed.

  
  


• 
  

  Clean code hence easier to read and maintain.

  
  


• 
  

  Support parameter substitution hence more preferable than EXECUTE command.

  
  


• 
  

  Syntax:-

  
  

                       sp_executesql [@sqlstmt ],[ @ParameterDefinitionList],[ @ParameterValueList ]

2.       EXECUTE():-

• 
  

  When we use this command the parameters should be converted to characters.

  
  


• 
  

  Syntax:-

  
  

EXECUTE (@sqlStmt)

Example:-

Create procedure sp_GetSalesHistory

(

                @WhereClouse nvarchar(2000)=NULL,

                @TotalRowsReturned  INT OPUTPUT

)

AS

BEGIN

                DECLARE @SelectStmt         nvarchar(),

                DECLARE @FullStmt             nvarchar(),

                DECLARE @ParameterList   nvarchar()

                SET @ ParameterList   = ’@TotalRowsReturned  INT  OUTPUT ’

SET @ SelectStmt       =  ‘SELECT @ TotalRowsReturned   = COUNT(*) FROM SalesHistory’

SET @ FullStmt           = @ SelectStmt     + ISNULL(@WhereClouse,’ ’)

PRINT @ FullStmt

EXECUTE sp_executesql @ FullStmt           ,@ ParameterList   ,@ TotalRowsReturned  =@ TotalRowsReturned  OUTPUT

END