Welcome - Nagendra's Blog

Dhada Trailer First look

noreply@blogger.com (Nagendra Prasad) — Sat, 16 Jul 2011 12:11:00 +0000

CH.NagendraPrasad-FavSites

noreply@blogger.com (Nagendra Prasad) — Tue, 23 Jun 2009 10:37:00 +0000

CH.NagendraPrasad-FavSites

Shared via AddThis

Nagendra BlogSpot News – Subscribe to Feed in Email

noreply@blogger.com (Nagendra Prasad) — Tue, 16 Jun 2009 13:39:00 +0000

You can subscribe to chnagendra.blogspot.com Feed using Email.
Email will be delivered to your preferred email address when new post appears on chnagendra.blogspot.com

Subscribe to chnagendra BlogSpot Feed Through Email

Watch Sakshi Tv Online

noreply@blogger.com (Nagendra Prasad) — Mon, 13 Apr 2009 11:44:00 +0000

NewsGuruAlerts

noreply@blogger.com (Nagendra Prasad) — Thu, 26 Mar 2009 08:59:00 +0000

SMS alerts on Polictical News, Sports news, Entertainment ect.. by just clicking http://labs.google.co.in/smschannels/channel/NewsGuruAlerts

Created by Me.

ASP.NET Popular web sites link

noreply@blogger.com (Nagendra Prasad) — Tue, 23 Dec 2008 08:29:00 +0000

http://www.asp.net/community/websites/

.NET quickstart tutorial

noreply@blogger.com (Nagendra Prasad) — Mon, 22 Dec 2008 13:12:00 +0000

http://quickstarts.asp.net/QuickStartv20/default.aspx

.NET guided tour

noreply@blogger.com (Nagendra Prasad) — Mon, 22 Dec 2008 13:10:00 +0000

http://www.asp.net/guidedtour2/

ASP.NET documentation link

noreply@blogger.com (Nagendra Prasad) — Mon, 22 Dec 2008 10:24:00 +0000

http://msdn.microsoft.com/en-us/library/ms644563.aspx

What is difference between Test Methodology, Approach, and Strategy?

noreply@blogger.com (Nagendra Prasad) — Thu, 25 Sep 2008 08:54:00 +0000

Test plan specifies process and scheduling of an application.
Test lead prepares test plan document based on what to test, how to test, when to test, whom to test.
It contains test plan id, one or two lines about project, estimated project testing start date ,actual project testing start date, estimated project testing end date, actual project testing end date, selected test engineer names for the current project, training needs ,schedule, use of automation tools, risks and mitigations, selecting test cases for regression testing.

Test strategy are the approaching the testing process. It contains scope and objective of testing, budget issues, test matrix nothing but mapping between development stages and testing issues.Test deliverables, communication between testing and development team, communication between two consecutive jobs in testing team, risks and mitigations, handle change request, automation, test measurements and metrics.

Test methodology provides current project testing approach. This document is developed by PM. It contains test strategy. Type of the project, test matrix, determine project requirements, indentify scope of application, indentify tactical risks, finalize term matrix prepare system test plan and if required prepare module test plan.

Test strategy provides over all approach where as test methodology provides current project testing approach.

End to end testing is also called as Inter system testing. In this, test engineer validates whether our system co existence with the existing software’s or not.

Penetration testing is nothing but security testing. We test the application based on authorization, encryption and description.

Creating a stored procedure for Custom Paging with the ASP.NET DataGrid Control

noreply@blogger.com (Nagendra Prasad) — Wed, 09 Jul 2008 12:38:00 +0000

The DataGrid control is most flexible and robust data control offered b ASP.NET. It displays data from the database table, accommodates in-row editing and updating of displayed data, sorting of columns, and built-in paging.

The DataGrid built-in paging –> Storing the data source that is being displayed in the DataGrid. The data source must be retrieved in each post back, this obviously the least efficient approach.

The paging offered by the DataGrid control requires minimal coding. This code handles the page changing events, refreshes the data sources and binds the DataGrid to the DataSource again. The drawback is that it requires the entire data source be generated or retrieved in each postback. If data source contains 100 rows of data and the DataGrid will be displaying 10 rows at a time, the DataGrid will navigate through 10 pages of data. The paging requires the entire DataSource be present and CurrentPageIndex being set. If the CurrentPageIndex is set to 3, the DataGrid will display the rows 31 through 40 from the DataSource. Retrieving the complete DataSource incurs significant overhead in most cases.

Custom Paging provided by DataGrid gives the developer complete control over the paging behavior. Custom paging is enabled through the AllCustomPaging attribute being set to true. With Custom paging enabled, the entire data source is not required to be available to the DataGrid because developer controls the data that is being displayed. With this in mind, the most efficient method for implementing custom paging would be to only return the rows of data from the data source that are to be displayed on the currently displayed page. This can be accomplished best using a stored procedure.

Creating the Stored Procedure
A stored procedure is the best suited solution because it will be processed by SQL Server with only the results of the stored procedure being returned. Decreasing the amount of data passed back will significantly improve the performance of any data call. Additionally, the first time that a stored procedure is executed, SQL Server creates an execution plan for the stored procedure and caches it so that future calls to the stored procedure are much faster. The stored procedure created is shown below.

Create Procedure dbo.sqlj_GetClientsByPage

-- Declare parameters.
@CurrentPage As tinyint, @PageSize As tinyint, @TotalRecords As int OUTPUT
As

-- Turn off count return.
Set NoCount On

-- Declare variables.
Declare @FirstRec int
Declare @LastRec int

-- Initialize variables.
Set @FirstRec = (@CurrentPage - 1) * @PageSize
Set @LastRec = (@CurrentPage * @PageSize + 1)

-- Create a temp table to hold the current page of data
-- Add an ID column to count the records
Create Table #TempTable (ClientId int IDENTITY PRIMARY KEY, Name varchar(50), Balance smallmoney)

--Fill the temp table with the reminders
Insert Into #TempTable (Name, Balance)
Select Name As Name, Balance As Balance From Clients Order By Name

--Select one page of data based on the record numbers above
Select ClientId, Name, Balance From #TempTable Where ClientId > @FirstRec And ClientId < @LastRec --Return the total number of records available as an output parameter Select @TotalRecords = Count(*) From Clients The stored procedure above accepts a parameter that designates the currently displayed page in the DataGrid as well as the capacity of rows to display on each page. It returns the total number of rows that is found. A temporary table is created and populated with all client rows. A second query then pulls the correct range of rows out of the data in the temporary table. Using the Stored Procedure with a DataGrid Control

You can ask SQL Server questions and find answers from expers

noreply@blogger.com (Nagendra Prasad) — Fri, 04 Jul 2008 12:27:00 +0000

http://sqlserverpedia.com/blog/

Free Telugu movies download

noreply@blogger.com (Nagendra Prasad) — Wed, 11 Jun 2008 14:09:00 +0000

http://moviestelugu.tk/

Articles of ASP.NET, VB.NET, JAVASCRIPT

noreply@blogger.com (Nagendra Prasad) — Thu, 29 May 2008 08:21:00 +0000

http://www.programmersheaven.com/

Training outlines of ASP.NET, VB.NET, C#, AJAX, SQL SERVER, Share Point, Silverlight

noreply@blogger.com (Nagendra Prasad) — Thu, 29 May 2008 08:21:00 +0000

http://www.accelebrate.com/

Learning Tutorial For VB.NET

noreply@blogger.com (Nagendra Prasad) — Thu, 29 May 2008 08:20:00 +0000

http://www.programmersheaven.com/2/VB-NET-School

Good Articles of AJAX, Visual Studio.NET, Reporting Services, SQL server

noreply@blogger.com (Nagendra Prasad) — Thu, 29 May 2008 08:19:00 +0000

http://www.c-sharpcorner.com/

SQL Server Reporting Services - Report Server, Report Designer, Report Builder, and other reporting-related discussions.

noreply@blogger.com (Nagendra Prasad) — Thu, 29 May 2008 08:16:00 +0000

http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=82&SiteID=1

Reporting services forum

noreply@blogger.com (Nagendra Prasad) — Tue, 20 May 2008 05:55:00 +0000

http://blogs.msdn.com/jgalla/

Download Free EBooks

noreply@blogger.com (Nagendra Prasad) — Fri, 16 May 2008 07:56:00 +0000

http://www.ebooksgo.blogspot.com/

Tutorials and Videos to help you learn ASP.NET 2.0

noreply@blogger.com (Nagendra Prasad) — Sat, 10 May 2008 07:36:00 +0000

Tutorials and Videos to help you learn ASP.NET 2.0

http://www.asp.net/learn/

Google Map API control for ASP.NET

noreply@blogger.com (Nagendra Prasad) — Fri, 09 May 2008 12:25:00 +0000

Google has given really good exaples how to use that. However, everything is done using javascript.

http://be.sys-con.com/read/171162_1.htm

Dotnet 3.0 Training Material

noreply@blogger.com (Nagendra Prasad) — Fri, 09 May 2008 12:14:00 +0000

Below is the link to learn DOT NET 3.0 which allows to download PPT files
http://www.dotnet-university.com/coursematerials.aspx

Moving value from one list box to other list box using javascript

noreply@blogger.com (Nagendra Prasad) — Fri, 09 May 2008 05:56:00 +0000

Recently i found good article on Moving values from one listbox to another listbox. Here is the link.

10 Ways to Learn New Things in Development

noreply@blogger.com (Nagendra Prasad) — Tue, 22 Apr 2008 10:27:00 +0000

http://www.philosophicalgeek.com/2008/04/01/10-ways-to-learn-new-things-in-development/