Overblog
Follow this blog Administration + Create my blog

Change the Background Row Color of the GridView control using MouseEvents without postback

August 25 2009 , Written by Balavardhan Reddy Published on #ASP.Net

Change the Background Row Color of the GridView control using MouseEvents without postback Change BackGround Color of a Row in Gridview when user moves mouse on a particular selecting Row, without postback. You need write the code in RowDataBound Event...

Read more

How to Access ViewState Across Pages

August 25 2009 , Written by Balavardhan Reddy Published on #ASP.Net

Access ViewState Across Pages We can access the viewstate variables across pages. This is possible when we use Cross Page Posting or Server.transfer to redirect the other pages Ex : Here I have created two aspx pages named: 1. First.aspx: This page sets...

Read more

Best Tips to write a Stored Procedure

August 11 2009 , Written by Balavardhan Reddy Published on #SQL Server2005

Good Tips to write stored procedure, to improve the performance. Below are the general rules to write good stored procedure. The sp_ prefix : Don't use the "sp_" prefix in a User created stored procedure name as the "sp_" prefix is reserved for system...

Read more

Published from Overblog

August 11 2009 , Written by Balavardhan Reddy

Read more

Save your SELECT query results in XML File or Text File.

August 6 2009 , Written by Balavardhan Reddy Published on #SQL Server2005

To save the result of your SELECT query to XML or a text file. Well use xp_cmdshell. xp_cmdshell is an extended stored procedure kept in the master database. It issues OS commands directly to the Windows command shell. You need to be a member of the sys_admin...

Read more

Compare data between two tables in SQL Server 2005

August 6 2009 , Written by Balavardhan Reddy Published on #SQL Server2005

Inorder to find the difference of two tables in schema and data betweeen Source and distination tables. we can use Tablediff in SQL Server 2005 You can run this utility from the command line or a batch file. Ex: if you have two Databases one for Production...

Read more

How to encrypt a stored procedure in SQL Server 2005

August 6 2009 , Written by Balavardhan Reddy Published on #SQL Server2005

Inorder to encrypt the text of stored procedures containing sensitive information, Sql Server provides WITH ENCRYPTION to encrypt the Stored Procedure. CREATE procedure [dbo].[SP_GET_Employee_Details_encrypt] WITH ENCRYPTION AS SELECT EMP_id,First_name,Last_name,Email_id...

Read more

How to check the active connections for each Database in SQL Server 2005

August 6 2009 , Written by Balavardhan Reddy Published on #SQL Server2005

We need to check the number of active connections for a Database on our server. We can get that details by using the following SQL script. This SQL script displays the DatabaseName, the number of connections and the login name : SELECT db_name(dbid) as...

Read more

Display Last Modified Stored Procedure using SQL Server 2005/2008

August 5 2009 , Written by Balavardhan Reddy Published on #SQL Server2005

To get a list of the Stored Procedure that were last modified, use this query SELECT TOP 10 modify_date,name FROM sys.procedures ORDER BY modify_date DESC --

Read more

Execute particular javascript method only once, while Page onLoad only in an ASP.NET

August 5 2009 , Written by Balavardhan Reddy Published on #ASP.Net

We can execute Javascript method only once while asp.net page Loading only. We can validate the Asp.Net page IsPostBack event in Javascript method. ASP.NET Master/Content Page scenario and have declared a javascript onload, then the script gets executed...

Read more
1 2 > >>