Saturday, July 16, 2011
Tuesday, June 23, 2009
CH.NagendraPrasad-FavSites
CH.NagendraPrasad-FavSites
Shared via AddThis
Posted by Nagendra Prasad at 6/23/2009 03:37:00 AM 0 comments
Tuesday, June 16, 2009
Nagendra BlogSpot News – Subscribe to Feed in Email
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
Posted by Nagendra Prasad at 6/16/2009 06:39:00 AM 0 comments
Monday, April 13, 2009
Thursday, March 26, 2009
NewsGuruAlerts
SMS alerts on Polictical News, Sports news, Entertainment ect.. by just clicking http://labs.google.co.in/smschannels/channel/NewsGuruAlerts
Created by Me.
Posted by Nagendra Prasad at 3/26/2009 01:59:00 AM 1 comments
Tuesday, December 23, 2008
Monday, December 22, 2008
.NET quickstart tutorial
http://quickstarts.asp.net/QuickStartv20/default.aspx
Posted by Nagendra Prasad at 12/22/2008 05:12:00 AM 0 comments
Labels: .NET
.NET guided tour
http://www.asp.net/guidedtour2/
Posted by Nagendra Prasad at 12/22/2008 05:10:00 AM 0 comments
Labels: .NET
ASP.NET documentation link
http://msdn.microsoft.com/en-us/library/ms644563.aspx
Posted by Nagendra Prasad at 12/22/2008 02:24:00 AM 0 comments
Labels: .NET
Thursday, September 25, 2008
What is difference between Test Methodology, Approach, and Strategy?
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.
Posted by Nagendra Prasad at 9/25/2008 01:54:00 AM 0 comments
Labels: Testing
Wednesday, July 9, 2008
Creating a stored procedure for Custom Paging with the ASP.NET DataGrid Control
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
Posted by Nagendra Prasad at 7/09/2008 05:38:00 AM 0 comments
Labels: SQL Server
Friday, July 4, 2008
You can ask SQL Server questions and find answers from expers
Posted by Nagendra Prasad at 7/04/2008 05:27:00 AM 0 comments
Labels: SQL Server
Wednesday, June 11, 2008
Free Telugu movies download
http://moviestelugu.tk/
Posted by Nagendra Prasad at 6/11/2008 07:09:00 AM 1 comments
Labels: Telugu
Thursday, May 29, 2008
Articles of ASP.NET, VB.NET, JAVASCRIPT
http://www.programmersheaven.com/
Posted by Nagendra Prasad at 5/29/2008 01:21:00 AM 0 comments
Labels: .NET
Training outlines of ASP.NET, VB.NET, C#, AJAX, SQL SERVER, Share Point, Silverlight
http://www.accelebrate.com/
Posted by Nagendra Prasad at 5/29/2008 01:21:00 AM 0 comments
Labels: Training outlines
Learning Tutorial For VB.NET
http://www.programmersheaven.com/2/VB-NET-School
Posted by Nagendra Prasad at 5/29/2008 01:20:00 AM 0 comments
Labels: .NET
Good Articles of AJAX, Visual Studio.NET, Reporting Services, SQL server
http://www.c-sharpcorner.com/
Posted by Nagendra Prasad at 5/29/2008 01:19:00 AM 0 comments
Labels: .NET
SQL Server Reporting Services - Report Server, Report Designer, Report Builder, and other reporting-related discussions.
http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=82&SiteID=1
Posted by Nagendra Prasad at 5/29/2008 01:16:00 AM 0 comments
Labels: Reporting Service
Monday, May 19, 2008
Reporting services forum
http://blogs.msdn.com/jgalla/
Posted by Nagendra Prasad at 5/19/2008 10:55:00 PM 0 comments
Labels: Reporting Service
Friday, May 16, 2008
Download Free EBooks
http://www.ebooksgo.blogspot.com/
Posted by Nagendra Prasad at 5/16/2008 12:56:00 AM 0 comments
Labels: EBooks
Saturday, May 10, 2008
Tutorials and Videos to help you learn ASP.NET 2.0
Tutorials and Videos to help you learn ASP.NET 2.0
http://www.asp.net/learn/
Posted by Nagendra Prasad at 5/10/2008 12:36:00 AM 0 comments
Labels: .NET
Friday, May 9, 2008
Google Map API control for ASP.NET
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
Posted by Nagendra Prasad at 5/09/2008 05:25:00 AM 0 comments
Labels: .NET
Dotnet 3.0 Training Material
Below is the link to learn DOT NET 3.0 which allows to download PPT files
http://www.dotnet-university.com/coursematerials.aspx
Posted by Nagendra Prasad at 5/09/2008 05:14:00 AM 0 comments
Labels: .NET
Thursday, May 8, 2008
Moving value from one list box to other list box using javascript
Recently i found good article on Moving values from one listbox to another listbox. Here is the link.
Posted by Nagendra Prasad at 5/08/2008 10:56:00 PM 0 comments
Labels: javascript