Asp Dot Net Presentation 6fp19

Label server Control: Is used to display the text int the browser. B’coz this is the server control u can dynamically alter the text from your server side code. Vb: Label1.text=“welcome to asp.net” C#: Label1.text=“welcome to asp.net”; We can also assign the hot key to the control. This causes the page to focus on a particular server control that u declaratively assign to a specific hot-keys. When working with the hot keys, be aware that not all the letters are available to use with the alt keys. IE already uses Alt + F,E,V,I,O,T,A,W and H. Name"> Set the property for the label control in the property window as below:

Text Box server control: •The control provides a textboxbox on the form that enables the end to input text. •We can map the textbox control to three different HTML elements used in the forms. •First, it can be used as a standard HTML textbox. •Second, the textbox can allow end to input their s into a forms. The is done by changing the textmode property to . •Third , the textbox can be used as a multitline textbox. When working with multiline be aware of the wrap property. When set to true the text is entered into text area wraps to the next lline if needed. When set to false, the end can type continuously in a single line until she presses the enter key.

Focus () method: The focus() method enables you to dynamicallty place the end ’s cursor in an appointed form element. protected void Page_Load(object sender, EventArgs e) { textbox1.focus(); }

Using AutoPostBack: Asp.NET pages work in an event-driven way. When an action on a web page triggers as event, server-side code is initiated. One of the more common events is an end clicking a button on the form. Using AutoCompleteType: One of the great capabilities for any web form is smart autocompletion. We have seen this when we visited a site for the first time. As we start filling information in a form, a drop down list appears below the textbox as we type, showing you a value that yo have typed in a previous form.

The textbox is having the AUTOCOMPLETE property, which enables you to apply the auto-completion feature to your own forms. You have to help the textboxes on your form to recognize the type of information that they should be looking for.

The Button server control: Buttons are generally used to submit forms. PROPERTY: CauseValidation Property: if you have more than one button on urweb page and you are working with the validation server server controls, you may not want to fire the validation for ech button on the form. Setting the causeValidation property to False is a way to use a button that will not fire the validation process.

CommandName property: When you have multiple Button controls on a Web page, use the CommandName property to specify or determine the command name associated with each Button control. You can set the CommandName property with any string that identifies the command to perform. You can then programmatically determine the command name of the Button control and perform the appropriate actions.

Design the web form with three buttons and set the property commandname for button1 as b1, button2 as b2 and button3 as b3



protected void Button_Command(Object sender, System.Web.UI.WebControls.CommandEventArgs e) { switch (e.CommandName) { case ("b1"): Response.Write("button1 clicked"); break; case ("b2"): Response.Write("button 2 clicked "); break; case ("b3"): Response.Write("button 3 clicked "); break; } }

Link button server control • Use the LinkButton control to create a hyperlink-style button on a Web Forms page. Specify the text to display in the LinkButton control by setting the Text property.

In the following example we declare one LinkButton control in an .aspx file. Use the LinkButton control if you want to link to another Web page when the control is clicked.

3

Hyperlink server control • Creates a link on the page that s can click to move to another page.

Place Holders • This control is intended to be used as a place holder when u add control to a web form at runtime.they don’t insert any HTML into a web page themselves, but u can add controls to them with their Controls.Add method.

public partial class _placeholder : System.Web.UI.Page { TextBox t1=new TextBox() ; TextBox t2 = new TextBox(); protected void Button1_Click(object sender, EventArgs e) { t1.Text = "textbox is in placeholder"; t2.Text = "textbox is in "; PlaceHolder1.Controls.Add(t1); 1.Controls.Add(t2); } }

File control • This control is intended to be used to the files from the client-side to the server-side. • While working with the File class one should always that it does not automatically save the files on the server-side. • To save files on the server-side you need to use saveas() method. • Before saving files with the saveAs() method, you must ensure that ASP.NET has write permissions on the specified directory, otherwise the operation will be failed.

Second example

protected void Button1_Click(object sender, EventArgs e) { if (File1.HasFile ) try { File1.SaveAs ("C:\\s\\" + File1.FileName); Label1.Text ="file name :" + File1.PostedFile.FileName + "
"+ File1.PostedFile.ContentLength +"kb
"+"Content type :" + File1.PostedFile.ContentType ; } catch (Exception ex) { Label1.Text ="error--->" + ex.Message.ToString(); } else { Label1.Text ="u have not specified file" ; } }

Image Control They just display an image in a web page. To associate an image with an IMAGE control, u just assign the image url to the image control. U can set the image width and height with the witdth and height property. Image1.imageurl=“~/imagename.gif”;

IMAGE BUTTON • You can use image button controls to display images that can also handle click events. This is particularly useful if u want to create image maps- those clickable images that initiate various actions depending on where you click them.

IMAGE MAPS • ImageMap control. This control enables you to create an image that has individual regions that s can click; these regions are referred to as hot spots. Each of these hot spots can be a separate hyperlink or can raise a postback event. •

The following code example shows how to respond to a click in an ImageMap control. The page contains an ImageMap control with four rectangular hot spots. Each hot spot's PostBackValue property is set to a unique value. The code in the handler checks for each value and displays an appropriate response

.

Drop down list server control: •

• •

The DropDownList Web server control allows s to select one or more items from a predefined list. It differs from the ListBox Web server control in that the list of items remains hidden until s click the drop-down button. In addition, the DropDownList control differs from the ListBox control in that it does not multi-selection mode. To work with items programmatically, you work with the Items collection of the DropDownList control. Items is a standard collection, and you can add item objects to it, delete items, clear the collection, and so on. The currently selected item is available in the DropDownList control's SelectedItem property.

• DropDownList Events • The DropDownList control raises an event — SelectedIndexChanged — when s select an item. By default, this event does not cause the page to be posted to the server, but you can cause the control to force an immediate post by setting the AutoPostBack property to true.

Dynamically generating a dropdownlist control from an array protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e) { string[] cararr = new string[4] { "ford", "indica", "maruti", "BMW" }; string[] airarr = new string[3] { "deccan", "air india", "indigo" }; string[] trainarr = new string[4] { "satapdi", "congo", "ap", "rajdhni" }; if (DropDownList1.SelectedValue == "car") { ListBox1.DataSource = cararr; } else if(DropDownList1.SelectedValue == "airplane") { ListBox1.DataSource = airarr; } else { ListBox1.DataSource = trainarr; } ListBox1.DataBind (); } protected void Button4_Click(object sender, EventArgs e) { Response.Write("

u selected " + DropDownList1.SelectedValue.ToString() + ":" + ListBox1.SelectedValue.ToString() + ""); }

ListBox • The ListBox Web server control displays a list of items from which we can make a selection. In this example we declare one ListBox control, and one Label control in an .aspx file. Then we create an event handler for the SelectedIndexChanged event which displays some text and the selected item, in a Label control. We can select one or more items from the list of items displayed.

• In this example we declare one ListBox control, and one Label control in an .aspx file. Then we create an event handler for the SelectedIndexChanged event which displays some text and the selected item, in a Label control.

protected void ListBox1_SelectedIndexChanged(object sender, EventArgs e) { //for single selection list Label1.Text = ListBox1.SelectedItem.Text.ToString(); } protected void ListBox2_SelectedIndexChanged(object sender, EventArgs e) { int i; for (i = 0; i <= ListBox2.Items.Count - 1; i++) { if (ListBox2.Items[i].Selected) Label2.Text += ListBox2.Items[i].Text.ToString() + " "; } }

Calendar server control • The Calendar control presents s with a calendar. It also offers date-picking functionality. After you add a Calendar control, it displays a month of dates at a time. In addition, it shows the week preceding and the week following the month. Therefore, a total of six weeks appears at once.

• To set the selected date, use the SelectedDate property in the Properties window. By default, the SelectedDate property is the date on the server. Use the VisibleDate property to determine what month appears on the calendar. The can move from month to month, changing the visible date without affecting the current date.

Selecting a single day in the calendar control protected void Calendar1_SelectionChanged(object sender, EventArgs e) { Response.Write("u selected:" + Calendar1.SelectedDate.ToShortDateString()); }

Day,week or month selections • By default, the calendar control enables you to make single day selections. U can use the selectionmode property to change this behaviour to allow ur s to make week or month selection.

Working with date ranges protected void Calendar1_SelectionChanged(object sender, EventArgs e) { Response.Write("u selected:" + Calendar1.SelectedDate.ToShortDateString()+"

"); for (int i = 0; i < Calendar1.SelectedDates.Count; i++) { Label1.Text += Calendar1.SelectedDates[i].ToShortDateString() + "
"; } }

The following sample demonstrates mode selection with a Calendar control. In this example we declare one Calendar control, and one DropDownList control in an .aspx file. Then we create an event handler for the SelectedIndexChanged event which displays SelectionMode Style in a Calendar control.

•

You can make appointment-style calendars by adding content in the OnDayRender event. Two of the arguments for OnDayRender are the Day that is being rendered and its Cell object. Custom text can be added to the cell for a particular day by adding it as a LiteralControl to the Cell object's Controls collection, as shown in the following example.

Changing style and behavior of calendar • The calendar control includes an event called dayRender that allows you to control how a single date or all the dates in the calendar are rendered.

protected void Calendar1_DayRender(object sender, DayRenderEventArgs e) { e.Cell.VerticalAlign = VerticalAlign.Top ; if (e.Day.DayNumberText == "1" &&

e.Day.IsSelected && e.Day .Date.Month.ToString ()=="8")

{ e.Cell.Controls.Add(new LiteralControl("

grioup meeting

")); e.Cell.BorderColor = System.Drawing.Color.Black; e.Cell.BorderWidth = 1; e.Cell.BorderStyle = BorderStyle.Solid; e.Cell.BackColor = System.Drawing.Color.LightGray; } }

BulletedList You can also determine the style used for displaying the Bulleted list. The Bulleted List control can be constructed of any number of < asp:ListItem > controls or can be data-bound to a data source of some kind andpopulated based upon the contents retrieved. Below listing shows simple Bulleted list In this example we declare one BulletedList control, and one DropDownList control in an .aspx file. Then we create an event handler for the SelectedIndexChanged event which displays Bullet Style in a BulletedList control.

Multiview and view server control • The MultiView control acts as a container for groups of View controls. Each View control in turn contains child controls such as buttons and text boxes. Your application can programmatically display a specific View control to the client based on criteria such as identity, preferences, or information that is ed in a query string parameter. • The multiview and view server control work together to give you the capability to turn on/off sections of ASP.NET page. Turning sections on and off , which means activating and deactivating a series of view control with multiview control

Example -1:Working with the multiview and view control

This example shows three views expressed int the multiview control. Each view is constructed with an
Each of the buttons in the multiview control triggers the nextview method. Nextview simply adds one of the activeviewindex value,thereby showing the nexti in the series until the last view is shown. public void nextview(object sender, EventArgs e) { MultiView1.ActiveViewIndex += 1; } The previousview method(UDF) substract one from the activeviewindex value, thereby showing the previous view in the view series. public void prevview(object sender, EventArgs e) { MultiView1.ActiveViewIndex -= 1; }

Another option is to spice up the multiview control by adding a step counter that displays to a label control) which step in the series the end is currently performing. In the Page_PreRender event, we c an write the code for it. protected void Page_PreRender(object sender, EventArgs e) { Label1.Text = "step :" + (MultiView1.ActiveViewIndex + 1).ToString() + "of " + MultiView1.Views.Count.ToString(); }

Example 2

Wizard server control The Wizard control enable you to build ASP.NET Web pages that present s with multi-step procedures.

In this , three steps are defined with the control. The element itself contains a couple of important attributes. The first is DisplaySideBar. It is set to true by default-meaning that a side navigation system in the displayed control enables the end to quickly navigate to other steps in the process. The ActiveStepIndex attribute of the wizard control defines the first wizrd step, it is set to -0

Examining the AllowReturn Attribute: Another interesting attribute of the wizard control is the AllowRetun attribute. By setting this attribute on one of the wizard steps to False , you can remove the capability for end to go back to this step after they have viewed it. this is second step

StepType Attribute: Another interesting attribute is steptype. The steptype attribute defines the structure of the buttons used on ther steps. By default , the wizard control places only a next button on the first step. It understands that you donot need the previous button here. It also knows to use a next and previous button on the middle step, and it uses previous and finish buttons o the last step. By default the steptype attribute is set to Auto, meaning that the wizard control determines the placement of buttons.

In addition to Auto, steptype value options include Start,step,finish and complete. Start means that the step defined only NEXT button. A value of step means that wizard step has NEXT and PREVIOUS buttons. Finish means that the step includes PREVIOUS and FINISH button. Complete enables you to give some final message to the end who is working through the step of wizard control. When you run this wizard control , u still see only the first three steps I the side navigation because the last step has a steptype set to complete, it does not appear in the side navigation list. When the clicks the Finish button in step3, the last step-is shown and no buttons appear with it

Utilizing wizard control events: The wizard control event exposes events for each of the possible steps that an end might take when working with the control.

EVENT

DESCRIPTION

ActiveStepChanged :

The ActiveStepChanged event is raised when the current step that is displayed in the Wizard control changes.

protected void Wizard1_ActiveStepChanged(object sender, EventArgs e) { Wizard1.HeaderText = "You are currently on " +Wizard1.ActiveStep.Title; }

EVENT

DESCRIPTION

CancelButtonClick :The CancelButtonClick event is raised when the Cancel button on the Wizard control is clicked.

protected void Wizard1_CancelButtonClick(object sender, EventArgs e) { Response.Redirect("default3.aspx"); }

FinishButtonClick :

The FinishButtonClick event is raised when the Finish button the Wizard control is clicked.

protected void Wizard1_FinishButtonClick1(object sender, WizardNavigationEventArgs e) {

Response.Write("clicked finish");

}

EVENT

DESCRIPTION

NextButtonClick :

The NextButtonClick event is raised when the Next button on the Wizard control is clicked.

protected void Wizard1_NextButtonClick(object sender, WizardNavigationEventArgs e) { // When the Next button is clicked, increase the Wizard1.BorderWidth by 5. Wizard1.BorderWidth = Unit.Pixel((int)(Wizard1.BorderWidth.Value + 5)); }

PreviousButtonClick :

The PreviousButtonClick event is raised when the prervious button on the Wizard control is clicked.

protected void Wizard1_PreviousButtonClick(object sender, WizardNavigationEventArgs e) { // When the previous button is clicked, decrease the Wizard1.BorderWidth by 2. Wizard1.BorderWidth = Unit.Pixel((int)(Wizard1.BorderWidth.Value + 2)); }

EVENT

DESCRIPTION

SideBarButtonClick:

The SideBarButtonClick event is raised when a button on the sidebar area is clicked.

Using wizard control to show form elements: Design the form like below:

<WizardSteps>



protected void wizardstep3_Activate(object sender, EventArgs e) { Label5.Text = "firstname:" + TextBox1.Text.ToString() + "
" + "last name:" + TextBox2.Text.ToString() + "
" + "email:" + TextBox3.Text.ToString(); }

ASP.NET Validation Server Controls: An important aspect of creating ASP.NET Web pages for input is to be able to check that the information s enter is valid. ASP.NET provides a set of validation controls that provide an easy-to-use but powerful way to check for errors and, if necessary, display messages to the . Type of validation

Control to use

Description

Required entry

RequiredFieldValidator

Ensures that the does not skip an entry.

Comparison to a value

CompareValidatorCompares a 's entry against a constant value, against the value of another control (using a comparison operator such as less than, equal, or greater than), or for a specific data type.

Range checking

RangeValidator

Checks that a 's entry is between specified lower and upper boundaries. You can check ranges within pairs of numbers, alphabetic characters, and dates.

Pattern matching

RegularExpression

Checks that the entry matches a pattern defined by a regular expression. This type of validation enables you to check for predictable sequences of characters, such as those in e-mail addresses, telephone numbers, postal codes, and so on.

-defined

CustomValidator

Checks the 's entry using validation logic that you write yourself. This type of validation enables you to check for values derived at

run time. You can attach more than one validation control to an input control. For example, you might specify that a control is required and that it also contains a specific range of values. A related control, the ValidationSummary control, does not perform validation, but is often used in conjunction with other validation controls to display the error messages from all the validation controls on the page together.

ControlToValidate :The programmatic ID of the input control that the validation control will evaluate. If this is not a legitimate ID, an exception is thrown. ErrorMessage:The error message to display in the ValidationSummary control if validation fails. If the Text property of the validation control is not set, this text is also displayed in the validation control when validation fails. The ErrorMessage property is commonly used to provide different messages for the validation control and the ValidationSummary control. IsValid:Indicates whether the input control specified by the ControlToValidate property is determined to be valid. SetFocusOnError:Indicates whether focus is set to the control specified by the ControlToValidate property when validation fails. Text:When set, this message is displayed in the validation control when validation fails. If this property is not set, the text specified in the ErrorMessage property is displayed in the control. ValidationGroup:Specifies the name of the validation group to which this validation control belongs.

Controls • control: is used to create the logon page for a web application.

• View control: provides a way of altering the appearance of the page whether the is logged in or not.. The view control has the built in functionality to authenticate the current ’s status and their roles. If found authenticated it displays the appropriate information to that .

status control • This control provides the with so that they know whether they have ed to to the site. It can also display the “” and “ status” as link button.

Name Control • Is responsible for displaying the name of the presently authenticated . It uses page..identity to return the value for the ’s name.

recovery • Is used to retrieve or reset the of the .

Using Control • Place a control the form. Now click the glyph at the top right corner of the control to display its smart tag and select ister website option. • Click the “Security” tab and then click the “use the security setup wizard to set up the security step by step” link. • We want out website to authenticate s who are trying to access it from internet. So select “from the internet” radio button

The next step is to add and their info you want the to be authenticated against. If the tries to access your site, his name and and othe info will be matched against the ’s info you had added here and. -Add as many as u want to add, but do that the you mention for these s must have one numberic character,one special character and rest of the string must not be the name.

• Now we’ll create roles out of the awe just created and then assign the permissions to those roles. • Click the next button to complete the process. • TIP: all the information regarding s and permissions that u create using the wizard goes into a database file called ASPNETDB.MDF,. Which u can find in the App_Data folder present under the application folder.

• Place the control on the form and name this form as “.aspx” and add another web form called “welcome.aspx” to the project and place a label control-Name control and Status on this page • Set the DestinationPageUrl proeprty of the Control on .aspx to welcome.aspx. • Set the Action property of the Status control on the welcome.aspx to RedirectToPage.

Grid view

Working with database • GridView Control: is a successor to the datagrid control existing in the previous versions of asp.net. • DetailsView Control: Displays the record of only a single data row from the underlying datasource. It can also be used for editing,deleting and inserting the record. It’s often displayd in the master/client scenario where u need to specify the details of any sel3ected record from a DatagridView or any similar bound control

Master/client example using gridview and detailview • Place gridview and detail view control on the form. Let assume that gridview datasource is Sqldatasource1 and detailview datasource is Sqldatasource2. • Switch to the source code and type the following lines in place where the tags for sqldatasource2(for detailview ) is there.

• Master/client

Need to code in the default.aspx page " ProviderName="<%$ ConnectionStrings:ConnectionString3.ProviderName %>" SelectCommand='SELECT * FROM "EMP"' FilterExpression ="empno='{0}'">

Binding Standard Control • Listbox,dropdownbox,checkedlistbox here are used to demo binding standard control. As we know that we can bind these control with datasouce. • Place these control on the form. • Place sqldatasource1 control from the data tab on to the form.

• click the smart tag of listbox and select choose datasource.from the wizard select the sqldatasouce1 from select a datasource. • Select the datafield and datafield value to be displayed for the listbox. • Follow the same steps for thedropdown and the checked list box.

Using DataReader • You can use datareader to access data, not just dataset. The ADO.NET DataReader can be used to retrieve a read-only, and forward-only streams of data. This can increase application performance both by retrieving data as soon as it is available, and (by default) storing only one row at a time in memory, thus reducng system overhead. As the query executes, the result are returned, and stored in the netword buffer on the client, until you request them using the read method of the datareader.

• Place a gridview control on the form. • Default.aspx.cs using System.Data.OleDb; public partial class datareader_gridvew : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { OleDbConnection cn; cn = new OleDbConnection("provider=msdaora;data source=oracie; id=scott;=tiger"); OleDbCommand cmd; cmd = new OleDbCommand("select * from emp", cn); cn.Open(); OleDbDataReader dr; dr = cmd.ExecuteReader(); GridView1.DataSource = dr; GridView1.DataBind(); dr.Close(); } }

FormView Control • The formview control is a functionality – rich control that allows you to edit,delete,and inser records with very little or almost no code.it displays thesingle record from the underlying data source and allows s to specify the defined templates.

• Place Formview control on the form. Set the Defaultmode property to insert or edit as per requirement. Below is the formview with defaultmode-insert

Open the source code and add following lines of code for insertion of new record. " ProviderName="<% $ConnectionStrings:ConnectionString3.ProviderName %>" SelectCommand='SELECT * FROM "STUD"' InsertCommand ='INSERT INTO STUD VALUES(:NM,:BDT,:PHNO)' OnInserted="SqlDataSource1_Inserted">

LINQ

Querying with LINQ .NET 3.5 introduces a new technology called Language

Integrated

Query or LINQ. LINQ is designed to fill the gap that existes

between traditional .NET languages, which offer strong typing and full object oriented development, and query languages such as SQL, with syntax for query operations. With introduction of LINQ into .NET, query becomes a first class concept in .NET, whether object ,XML or data queries. LINQ includes three basic types of queries, LINQ to Objects, LINQ to XML(or XLINQ) and LINQ TO SQL(or DLINQ)

LINQ to objetcs: The first and most basic flavour of LINQ is LINQ to objects. It enables you to perorm complex query opertions against any enumerable object

Where

select

4 1

TRADITIONLA QUERY METHODS: c#: public class Movie { public string fnm { get; set; } public string lnm { get; set; } }

NOTE: class is generated under app_code folder

Keep the gridview control on the web fom and write the code for default.aspx.cs using System.Collections.Generic;

public partial class _Default : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { var movies = getmovies(); this.GridView1.DataSource = movies; this.GridView1.DataBind(); }

public List<Movie> getmovies() { return new List<Movie> { new Movie {fnm ="nutan",lnm="gupta"}, new Movie {fnm ="shekhar",lnm="lad"}, new Movie {fnm ="anil",lnm="kapoor"}, new Movie {fnm ="rajesh",lnm="khanna"}, new Movie {fnm ="reena",lnm="roy"}, }; }

Replacing traditional queries with LINQ LINQ is an extension to .NET , and because of this , is isolated in its own set of assemblies . The base LINQ functionality is located in the new System.core.dll assembly. Additionally, by default , projects in VS2008 include a reference to this assembly so when starting new Asp.NET web projetcs, LINQ should be readily available to you. protected void Page_Load(object sender, EventArgs e) { //creating query with LINQ Var movies=getmovies(); var qry = from m in movies select m; this.GridView2.DataSource = qry; this.GridView2.DataBind(); }

If we deconstruct the code sample, there are three basic actions happening. First , the code uses the GetMovies() method to obtain the generic List<movie> collection.

Next , the code uses a very simple LINQ query to select all of the Movie objects from the generic movies collection. Notice that this specific LINQ query utilizes new language keyword like from and select in the query statement.

The query also defines a new variable m . This variable defines in two ways in the query. First, by defining it in the from statement from m, we are telling LINQ to make m represents the individual collection item, which in this case is a movie object. The second use of m in the query is in the select statement. Using m in the select statement tells LINQ to output a projection that matches the structure of m. in this case that means LINQ creates a projection that matches the movie object structure.

Creating a custom projection with LINQ

We can also create our own custom projection by explicitly defining the fields we wanted return from the query using the new keywod along with the select operator. //creating custom projection with LINQ Var movies=getmovies(); var qry1 = from m in movies select new{m.fnm ,….,…}; this.GridView3.DataSource = qry1; this.GridView3.DataBind(); Note: will display only selected fields

Creating a custom projection field names We can also create our own custom projection by explicitly defining the fields we wanted return from the query using the new keywod along with the select operator. //creating custom projection with LINQ Var movies=getmovies(); var qry1 = from m in movies select new{FirstName=m.fnm }; this.GridView3.DataSource = qry1; this.GridView3.DataBind(); Note: will display only selected fields with column name

Controlling data ordering using LINQ LINQ also includes the ability to order the results using the order by statement. As with SQL, u can choose to order the results in either ascending or descending order. Place gridview conntrol thhe form. protected void Page_Load(object sender, EventArgs e) { //controlling data ordering using linq var movies = getmovies(); var qry=from m in movies orderby m.lnm descending select new{first_name=m.fnm ,last_name=m.lnm }; GridView1.DataSource =qry; GridView1.DataBind(); }

public List<Movie> getmovies() { return new List<Movie> { new Movie {fnm ="anil",lnm ="lad"}, new Movie {fnm ="bhavna",lnm ="reddy"}, new Movie {fnm ="anu",lnm ="lad"}, new Movie {fnm ="chetan",lnm ="reddy"}, new Movie {fnm ="babita",lnm ="bhaskar"} }; }

Query filters

LINQ also s adding qury filters using a familiar SQL-Like WHERE syntax Place grid view control on the form protected void Page_Load(object sender, EventArgs e) { //adding a filter to the linq query var movies = getmovies(); var qry=from m in movies where

m.lnm =="reddy" && m.fnm

=="chetan"

select m; GridView1.DataSource =qry; GridView1.DataBind();

} public List<Movie> getmovies() { return new List<Movie> { new Movie {fnm ="anil",lnm ="lad"}, new Movie {fnm ="bhavna",lnm ="reddy"}, new Movie {fnm ="anu",lnm ="lad"}, new Movie {fnm ="chetan",lnm ="reddy"}, new Movie {fnm ="babita",lnm ="bhaskar"}

Data grouping

LINQ also greatly simplifies grouping data againusing SQL-LIKE group syntax. protected void Page_Load(object sender, EventArgs e) { //grouping data usinglinq query var emp = getemp(); var qry = from m in emp

group m by m.desg into g select new { desg = g.Key, count = g.Count() }; GridView1.DataSource = qry; GridView1.DataBind(); } public List<emp> getemp() { return new List<emp> { new emp{nm ="blake",sal =5000,comm =56, desg ="mkt"}, new emp{nm ="smith",sal =4500,comm =100, desg ="clerk"}, new emp{nm ="john",sal =6000,comm =1056, desg ="sales"}, new emp{nm ="killer",sal =85000,comm =500, desg ="sales"},

LINQ to XML The second flavour of linq is called LINQ to XML(or XLINQ). As the name implies, LINQ to XML enaqbles you to use the same basic LINQ syntax to query XML documents. First thing to create a xml file

<emp1> <empdata> smith <sal>2345 <desig>clerk <empdata> blake <sal>4500 <desig>mgr <empdata> killer <sal>3500 <desig>mkt

protected void Page_Load(object sender, EventArgs e) { var qry = from m in XElement.Load(MapPath("XMLFile.xml")).Elements("empdata") select m; GridView1.DataSource = qry; GridView1.DataBind(); } } NOTE: notice that the fields included in the resultset of the query don’t really show the node data as u might have expected, with each child node as a separate field in thhe gridview. This is becoz query used in the listing returns a collection of generic Xelement objects, not emp objects as u might have expected.

Mapping XML elements using LINQ

protected void Page_Load(object sender, EventArgs e) { var qry = from m in XElement.Load(MapPath("XMLFile.xml")).Elements("empda select new { nm = (string)m.Element("nm"), sal = (int)m.Element("sal"), desig = (string)m.Element("desig") }; GridView1.DataSource = qry; GridView1.DataBind(); }

LINQ TO SQL LINQ to SQL is the last form of LINQ in the release of >NET . LINQ to SQL , as the name implies, enables you to quickly and easily query SQL-BASED data sources, such as SQL SERVER 2005. LINQ TO SQL also includes a basic Object-Relation (O/R) mapper directly in visual studio. The o/r mapper enables u to quicly map sql-based data sources to CLR objects that u can then use LINQ to query. It is the easiest way to get the linq-to SQL The o/r mapper is used by adding the new linq to sql classes file to ur web application. After clciking the add new item - select sql-to class—ok button to add the file to ur project. Once the file is open vs automatically opens its linq to sql design surface.

Querying data from linq to sql protected void Page_Load(object sender, EventArgs e) { empdataDataContext dc = new empdataDataContext(); var qry = from m in dc.emptables select m; GridView1.DataSource = qry; GridView1.DataBind(); } }

Grouping linq to sql data empDataContext dc = new empDataContext(); var qry = from m in dc.Products group m by m.SupplierID into g select new { id = g.Key, count = g.Count() }; this.GridView1.DataSource = qry; this.GridView1.DataBind();

HTML CONTROLS • CLIEND AND SERVER HTML CONTROLS: there are two ways to work with these control- to the client browser(HTML CLIENT CONTROLS) and in the server(HTML server controls). • In the client you must use a scripting language, such as javascript.

• You can make these control to run at server and so handle them with visual basic or c#code., but they only very limited events that can be handled on the server-typically ,just an event named ServerClick or ServerChange

<script language="javascript"> function showmsg() { alert("clicled"); }