Database Testing

Download Report

Transcript Database Testing

.Net

• • • • • • • • • • • • • • • • •

Table of contents Introduction to VS 2005 Application and Page Frameworks GUI Controls Validation Server Controls

Working with Master Pages Themes & Skins Collections & Lists Data Binding Data Management with ADO.Net Working with XML Site Navigation Security State Management Caching Debugging & Error Handling File I/O & Streams Configurations Softsmith Infotech

Introduction to VS 2005

• Visual Studio 2005 is an IDE that is used to create ASPX pages (Web application) • Creation of web application also creates a set of files.

• Web application exists only in the location specified by IIS virtual folder.

• In a system, the web root folder is //localhost This is the virtual folder • The physical path for this virtual folder is \\inetpub\wwwroot Softsmith Infotech

What can you find in a VS

• We can see these windows when we open the Visual Studio – Property Window – Shows the properties of a control(Page or button or textbox) – Solution Explorer – Shows the files that a opened project has – Output Window – Shows the result of a compilation or execution of a program – Error List – Shows the compilation errors etc.

Softsmith Infotech

IIS – Internet Information Services

• IIS is a web server that comes along with .Net

• We can configure IIS using “inetmgr” • In the Start Menu, choose Run and type inetmgr. We will get a window that lists the websites present in the system.

• For creating a virtual directory, right click on the default website and select New -> Virtual Directory. – Give the alias name – Give the physical path – Give the access permissions and click finish.

Softsmith Infotech

ASP .Net

• Used to create web applications and web services that run under IIS • ASP.NET is a collection of .NET classes that collaborate to process an HTTP request and generate an HTTP response • Helps us in creating Dynamic Web pages – Dynamic web pages – Pages will be generated at the server based on the user’s request and then given back to the client (user) Softsmith Infotech

ASP .Net Framework

• ASP.NET is a managed server-side framework – For building applications based on HTTP, HTML, XML and SOAP – ASP.NET relies on IIS for an HTTP entry point • ASP.NET supports building HTML-based Web Applications – Based on ASP.NET pages, Web forms and server side controls • ASP.NET supports building Web Services – Based on Web service classes and WebMethods Softsmith Infotech

Life cycle of a web page

• Page_Init – This is called when page is initialized. We can declare some variables which need to be initialized before page is loaded • Page_Load – The server controls are loaded in the page .This event is called every time when page is loaded • Control_Event – This event is fired when control like button are clicked or changed • Page_Unload – This event occurs when a page is Unloaded from memory • Page_Dispose – This event occurs when a page is released from memory Softsmith Infotech

Life cycle of a web application

• The Life of web application begins when a user requests for a page through the browser (client) • When IIS receives request from client it calls ASP. NET worker process • The ASP.NET worker process loads the assembly • The executable creates an instance of web form • Generates the HTML page to respond to the request • Posts the response to browser and then it destroys the instance of the web form • Then browser receives the generated HTML Softsmith Infotech

Life cycle of a web application (Contd..)

• Client Performs tasks like button click • The page’s data is sent back to server • When server receives this page it creates new instance of web form • Processes the event occurred • Then again send back HTML and destroys the page • When user stops the web application for a period of time session ends Softsmith Infotech

ASP .Net Advantages

• Executable portion of a web application are compiled • Enriched tool support • Applications are based on CLR – Common Language Runtime • On the fly updates deployed without restarting server • Better session management • Integration with ADO.NET

• Built in features for caching • Create XML Web services • Browser-independent • Language-independent Softsmith Infotech

Application and Page Framework

Softsmith Infotech

ASP .Net Applications

• Each application is based on IIS virtual directory • Each application is contained within a physical directory • Each application runs in its own isolated AppDomain • Namespace must for this application is System.Web

Softsmith Infotech

ASP .Net Pages

• Code and Design are separated • Design file – ASPX file – Contains ASPX or HTML tags • Code file – called as code behind file • Has the programming logic • Programming language can be – C# – VB .Net

Softsmith Infotech

ASP .Net Pages (Contd..)

– ASPX Page has • – C# file will have • btnSubmit_Click() { ... } • The code behind page is inherited from

System.Web.UI.Page

class • The .aspx file containing the user interface is inherited from code behind class Softsmith Infotech

Files in a Web application Project

• AssemblyInfo.cs

– All the information about assembly including version, company name etc • Default.aspx

– The visual description of a Web form. • Default.aspx.cs

– The code behind that responds to events on the Web form • Default.aspx.resx

– XML resources used by web form • Global.asax – The global events that occur in web applications • Web.config

– Configuration contents like authentication mode, error files etc.

Softsmith Infotech

GUI Controls Softsmith Infotech

Server Control

System. Object System.Web.UI System.Web.UI.Control System.Web.UI.Web Controls System.Web.UI.HTMLControls Softsmith Infotech

Web Controls

System.Object

System.Web.UI.Control

WebControl ListBox CheckBoxList ...

ListControl ...

Softsmith Infotech

Table Button TextBox

Postback event

• These events cause the web page to be sent back to the server for immediate processing • When page is posted back ,the Page_Init, Page _Load events are handled • The page is submitted back and renders a new version of itself back to the user Softsmith Infotech

Validation Controls

• ASP .Net provides 5 validation controls that are used to check the validity of data entered by the user in the server controls on the web page.

• Client side validation is also possible through a Jscript library WebUIValidation.js

– Required field validator – Regular expression validator – Compare validator – Range validator – Custom validator – Validation summary Softsmith Infotech

Required Field Validator

• To check whether a control contains data • Properties: – ControlToValidate – ErrorMessage – Text • Method: – Validate Softsmith Infotech

Regular Expression Validator

• To check whether the entered data matches a specific format • Properties – ControlToValidate – ValidationExpression – ErrorMessage • Method – Validate Softsmith Infotech

Compare Validator

• To compare values entered in two controls • Properties: – ControlToCompare – ControlToValidate – ErrorMessage – ValueToCompare • Method: – Validate Softsmith Infotech

Range Validator

• To compare whether the entered value is between two specified values • Properties: – ControlToValidate – ErrorMessage – Type – MaximumValue – MinimumValue • Method: – Validate Softsmith Infotech

Custom Validator

• To Check the validity of an entered item using a client-side script or a server-side code, or both • Properties: – ControlToValidate – ErrorMessage • Events: – ServerValidate • Method: – OnServerValidate – Validate Softsmith Infotech

Validation Summary

• To Display validation errors in a central location or display a general validation error description • Properties: – HeadText – ShowMessageBox – ShowSummary Softsmith Infotech

User Controls

• We can create our own controls in addition to HTML and Web controls • User controls offer you an easy way to partition and reuse common user interface (UI) functionality across your ASP.NET Web applications • User controls are not compiled until run time • You can simply drag and drop them on the page and start using them • To create a user control: – Add a new item ( select user control as a template) and give it a name – Heading.ascx

– The following description can be seen in HTML view

<%@Control Language="c#" AutoEventWireup="false" Codebehind="Heading.ascx.cs“>

Softsmith Infotech

Using a User Control

• To use a user control, just drag the ascx file from the solution explorer and drop it on the design area of the aspx page • Or give like this in the html view of the aspx page –

In the head portion

– •

< %@Register TagPrefix="uc1" TagName="Heading" src="Heading.ascx"% > In the body portion

Softsmith Infotech

Calendar Control

• • • The Calendar Web server control displays a traditional one-month calendar on your Web Forms pages Few properties: – SelectedDate – SelectedDates – BackColor Few methods: – AddDays() – AddMonths() – AddYears() – GetMonth() – GetYear() – GetDayOfWeek() – IsLeapYear() Softsmith Infotech

DateTime

• DateTime is a static class. Members can be accessed via DateTime.Now and so on.

• The DateTime value type represents dates and times with values ranging from 12:00:00 midnight, January 1, 0001 Common Era to 11:59:59 P.M., December 31, 9999 C.E.

• Few properties: – Today – Now – Date • Few Methods: – AddDays() – AddMonths() – Compare() – ToLongDateString() – ToShortDateString() Softsmith Infotech

DataGrid Control

• Full-featured list output • Default is to show all columns – Can specify a subset of columns to display • Provides templates – Standard – Custom • Provides paging • Provides data updates Softsmith Infotech

Repeater Control

• Provides simple output of list of items • Templates provide the visual form • It iterates over the bound data • Display format of data is managed • Does not support paging • Provides templates for separators • Does not provide data updates Softsmith Infotech

Standard templates for Repeater controls – HeaderTemplate • Rendered before all data bound rows – ItemTemplate • Rendered for each row in the data source – AlternatingItemTemplate • Rendered for every other row – SeparatorTemplate • Rendered between each row – FooterTemplate • Rendered after all data bound rows Softsmith Infotech

Binding data

• To bind embedded controls to the data source of the container control –

DataBinder.Eval()

method is used • Syntax –

<%#DataBinder.Eval(Container.DataItem,“D ataFieldname")%>

– Container represents the container for data items – DataFieldname represents the name of data item field Softsmith Infotech