Balavardhan Reddy Narani - List of last posts on balavardhanreddy.over-blog.com

1 2 3 next

ASP.NET (29/12/2011 posted in: ASP.Net )

ASP.NET ASP.NET, the next version of ASP, is a programming framework used to create enterprise-class Web Applications. These applications are accessble on a global basis leading to effecient ...
ASP.NET Important Topics (29/12/2011 posted in: ASP.Net )

1) Asp.net Page Life Cycle & Page Architecture. 2) Assemblies. 3) User Controls & Custom Controls. 4) Gridview Control. 5) Themes, Skins and Style Sheets. 6) Master Pages. 7) Site Maps. 8) State ...
FOR XML - SQL Server (09/06/2010 posted in: SQL Server2005 )

Introduction In Microsoft SQL Server 2000, we introduced the FOR XML clause to the SELECT statement. This clause provides the ability to aggregate the relational rowset returned by the SELECT ...
SQL Server Rank functions, RANK, NTILE, DENSE_RANK, ROW_NUMBER (20/04/2010 posted in: SQL Server2005 )

Transact-SQL provides the following ranking functions: -RANK -NTILE -DENSE_RANK -ROW_NUMBER Rank() - Applies to monotonically increasing number for each value in the set Row_Number() - simply ...
Time Delay to Execute a T-SQL Query (17/03/2010 posted in: SQL Server2005 )

A New feature in SQL Server is Time delay to execute a T-SQL Query SQL Server will wait for perticular time to excute the query. Ex : i) SELECT GETDATE() CurrentTime WAITFOR DELAY '00:00:20' ---- ...
Export Gridview data to Excel (18/02/2010 posted in: ASP.Net )

i) Get the Data from the Database and Bind it to the Gridview ii) Set Gridview Allowpaging property to "False" Write the below code to export the entire Gridview data to Excel sheet private void ...
Dotnet 3.5 New features (18/02/2010 posted in: ASP.Net )

New Improvements in Dotnet 3.5 and VS 2008: Below is the queck summary lis of sever of new improvements of Dotnet 3.5, there is lot of more thing, I haven't had chance to add them Multi Targetting ...
Defragmenting Indexes in SQL Server (05/02/2010 posted in: SQL Server2005 )

When data is inserted, deleted, or updated in a SQL Server tables, the indexes which are defined for that tables are automatically updated to reflect those changes. When these indexes are ...
Advanced Reporting with Matrix Control in SSRS (27/01/2010 posted in: SSRS )

Here I will show you how to get these custom aggregates on a matrix report and will cover a few interesting reporting techniques along the way Cells-by-Cells technique – This helps us achieve a ...
SSRS - Matrix Control (21/01/2010 posted in: SSRS )

In SQL Reporting Services, the Matrix control provides a crosstab view of data, similar in behavior to a PivotTable. Rows and columns will have intersecting points of data which is often useful in ...
Beginning SQL Server 2005 - First Sample SSRS (20/01/2010 posted in: SSRS )

The easiest way to create a report in Report Designer is to use the Report Wizard. Like all wizards, the Report Wizard walks you through the process in step-by-step fashion. You can make the ...
Beginning of Reporting Services 2005 (20/01/2010 posted in: SSRS )

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can be used to prepare and deliver a variety of interactive and printed reports. It is ...
Artcal about Mind & Soul (17/12/2009 posted in: Life )

Rain water is pure. When you place a vessel while it is raining, you can collect pure water. It is like distilled water. By drinking that water, you will not be troubled by any ailment. When the ...
Should we make SQL queries case sensitive? (08/12/2009 posted in: SQL Server2005 )

Should we make SQL queries case sensitive? Yes, we should. We have so many ways to get the data from the SqlServer with Case Sensitive. Ex : Create table mytab (id int, Name varchar(50)) Insert ...
Auto Complete TextBox with JQuery (26/11/2009 posted in: ASP.Net )

Please find the Auto Complete Text box sample with JQuery and ASP.Net http://files.myopera.com/Balu.narani/files/jqAutotext.rar
CASE Statement in Update Queries (07/09/2009 posted in: SQL Server2005 )

We can implement CASE statement in Update Queries. Instead of multiple update queries, you can implement multile condition by CASE statement to update a table or get the customized result. Ex : We ...
Change the Background Row Color of the GridView control using MouseEvents without postback (25/08/2009 posted in: 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 ...
How to Access ViewState Across Pages (25/08/2009 posted in: 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 ...
Best Tips to write a Stored Procedure (11/08/2009 posted in: 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 ...
(11/08/2009 )
Save your SELECT query results in XML File or Text File. (06/08/2009 posted in: 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 ...
Compare data between two tables in SQL Server 2005 (06/08/2009 posted in: 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 ...
How to encrypt a stored procedure in SQL Server 2005 (06/08/2009 posted in: 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 ...
How to check the active connections for each Database in SQL Server 2005 (06/08/2009 posted in: 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 ...
Display Last Modified Stored Procedure using SQL Server 2005/2008 (05/08/2009 posted in: 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 --
Execute particular javascript method only once, while Page onLoad only in an ASP.NET (05/08/2009 posted in: 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 ...
Display an Image or Custom message for EmptyData in an ASP.NET GridView (05/08/2009 posted in: ASP.Net )

Some times we will get Empty Dataset or Data table from the Database to bind the Gridview. At this point of time we can display Custom message or an Image in GridView . The GridView’s ...
Display Alert or Tooltip text On MouseOver In an ASP.NET GridView (05/08/2009 posted in: ASP.Net )

We can display a Alert message or Tool tip text in an ASP.NET GridView on MouseOver, to display these we needs to handle the RowDataBound event of GridView. The RowDataBound event is raised when a ...
Why should the wedding ring be worn on the fourth finger? (29/07/2009 posted in: Life )

There is a beautiful and convincing explanation given by the Chinese..... Thumb represents your Parents Second (Index) finger represents your Siblings Middle finger represents your-Self Fourth ...
Article on Sqlserver Indexes (27/07/2009 posted in: SQL Server2005 )

One of the most powerful way to get high performance in a SQL Server database is the index. Indexes speed up the your querying process by providing swift access to rows in the data tables, like ...
Custom Paging in SQLServer2005 and Dotnet Application (08/07/2009 posted in: SQL Server2005 )

Custom Paging in SQLServer2005 and Dotnet Application Subsets via SQL Server 2005 There are various techniques for handling this issue, but SQL Server 2005 introduced a new feature that changed ...
GOTO statement in C# (20/05/2009 posted in: ASP.Net )

GOTOThe goto statement transfers the program control directly to a labeled statement. It takes one of the following forms: goto identifier; goto case constant-expression; goto default; where: ...
Datetime Formates and Date time manipulations in SQL Server (19/05/2009 posted in: SQL Server2005 )

Different Datetime formates in sqlserver print getdate() -- May 19 2009 3:21AM print convert(varchar(max),getdate(),101) -- 05/19/2009 print convert(varchar(max),getdate(),102) -- 2009.05.19 print ...
Case Statement Tricks (10/04/2009 posted in: SQL Server2005 )

The CASE statement is a very flexible tool. Here are just a few of the tricks you can work with it. Item translation One of the simplest things you can do is to derive a columns contents based on ...
Concatenating Row Values in Transact-SQL (07/04/2009 posted in: SQL Server2005 )

Concatenating Row Values in Transact-SQL There are a number of solutions and considerable debate. How do you go about Concatenating Row values. By 'Concatenating row values' we mean this: You have ...
How to Insert Values into an Identity Column in SQL Server (01/04/2009 posted in: SQL Server2005 )

Identity columns are commonly used as primary keys in database tables. These columns automatically assign a value for each new row inserted. But what if you want to insert your own value into the ...
Regular Expression Validater for Number Format (25/03/2009 posted in: ASP.Net )

Regular Expression Validater for Number Format : Format Like 11,111,22,33333,1,2222 ^([1-9]{1}[0-9]{0,})+((,[1-9]{1}[0-9]{0,}){0,1})+[ ]{0,}$ Match : 11,22,3333,44,555 + Space at Last Position. ...
A Leader Should Know How to Manage Failure (25/03/2009 posted in: Life )

Former President of India APJ Abdul Kalam: 'A Leader Should Know How to Manage Failure' India Knowledge@Wharton: Could you give an example, from your own experience, of how leaders should manage ...
Lessons on Life (23/03/2009 posted in: Life )

Lessons on Life There was a man who had four sons. He wanted his sons to learn not to judge things too quickly. So he sent them each on a quest, in turn, to go and look at a pear tree that was a ...
The cracked water pot (23/03/2009 posted in: Life )

The cracked water pot A water bearer had two large pots, each hung on the ends of a pole which he carried across his shoulders. One of the pots had a crack in it while the other pot was perfect ...