ASP.NET Lab PDF

Preview

Summary

Download ASP.NET Lab PDF

Description

GOVERNMENT ARTS COLLEGE CHIDAMBARAM-608 102 Re-Accredited by NAAC with ‘B’ Grade (Affiliated to Thiruvalluvar University, Vellore)

ASP.NET LAB RECORD NOTE BOOK

PG DEPARTMENT OF COMPUTER SCIENCE 2019-2020

R.CHERAN [M.Sc Computer Science]

Page 1

About the Author Mr.cheran has a M.Sc. Computer Science study in Thiruvalluvar University.

R.CHERAN [M.Sc Computer Science]

Page 2

SYLLABUS ASP.NET Lab 1. Implement Validation Controls 2. Write a Program to implement ad rotator control 3. Write a Program to implement state management techniques 4. Write a Program to implement view State and Session State. 5. Write a Program to displaying data with the grid view 6. Write a Program to implement ASP.Net Server Side Controls. 7. Write a Program to implement ASP.Net Master Pages, Themes and Skins. 8. Write a Program working with forms using ASP.Net 9. Write a Program working with pages using ASP.Net. 10. Write a Program to access data sources through ADO.NET

R.CHERAN [M.Sc Computer Science]

Page 3

VALIDATION CONTROLS AIM: To create a website using validation controls with database. PROCEDURE: Step1: Open visual studio create new project with website. Step2: To add the required field control, range validator control, compare validator control, regular expression validator control form toolbox. Step3: To use validation control source code in Defualt.aspx.cs page. Step4: create table from Microsoft access database. Step5: connect to database in Microsoft access database. Step6: save the project (ctrl+s). Step7: Run the project (F5).

R.CHERAN [M.Sc Computer Science]

Page 4

DESIGN PAGE:

CODE PAGE: using System; using System.Collections.Generic; using System.Data; using System.Linq; using System.Data.OleDb; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Configuration; namespace ex1 { public partial class validation : System.Web.UI.Page { OleDbConnection con = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\Users\\ELCOT\\Documents\\Visual Studio 2010\\Projects\\ex1\\ex1\\msc.accdb"); OleDbCommand cmd = new OleDbCommand(); public string name; public string mailid; public string pass; public string repass; public string age; public string city; protected void Page_Load(object sender, EventArgs e) { } protected void Button1_Click(object sender, EventArgs e) R.CHERAN [M.Sc Computer Science]

Page 5

{ con.Open(); cmd.CommandText = "Insert into ex1 Values('" + txtname.Text + "','" + txtemail.Text + "','" + txtpass.Text + "','" + txtrepass.Text + "','" + txtFn.Text + "','" + ddlCity.Text + "')"; cmd.Connection = con; cmd.ExecuteNonQuery(); ScriptManager.RegisterClientScriptBlock(this, GetType(), "AlertMessager", "alert('Save Sucessfully')", true); con.Close(); } } }

OUTPUT:

R.CHERAN [M.Sc Computer Science]

Page 6

AD ROTATOR CONTROL AIM: To create a website using ad rotator control. PROCEDURE: Step1: Open visual studio create new project with website. Step2: To add the script manager, timer, ad rotator control form toolbox. Step3: To create a new folder and change a name. Step4: To insert in any some images for new folder. Step5: To use xml coding in xml file. Step6: save the project (ctrl + s). Step7: Run the project (F5).

R.CHERAN [M.Sc Computer Science]

Page 7

DESIGN PAGE:

SOURCE CODE:















R.CHERAN [M.Sc Computer Science]

Page 8





XML FILE:

~/IMG/1.jpg

First Picture

~/IMG/2.jpg

Second Picture

~/IMG/3.jpg

Third Picture

OUTPUT:

R.CHERAN [M.Sc Computer Science]

Page 9

STATE MANAGEMENT TECHNIQUES AIM: To create a website includes cookies state using state management techniques. PROCEDURE: Step1: Open visual studio create new project with Empty website. Step2: To add the required controls form toolbox. Step3: To add a Default.aspx form in project inserts textbox. Step4: To write a coding for Default.aspx.cs. Step5: save the project (ctrl + s). Step6: Run the project (F5).

R.CHERAN [M.Sc Computer Science]

Page 10

DESIGN PAGE:

CODE PAGE: using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; public partial class _Default : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { } protected void StoreButton_Click(object sender, EventArgs e) { HttpCookie usercookie = new HttpCookie("userdetail"); usercookie["name"] = NameTextBox.Text; usercookie["occupation"] = OccupationTextBox.Text; usercookie.Expires = DateTime.Now.AddDays(1); Response.Cookies.Add(usercookie); ResultLabel.Text = "Cookies are stored"; } R.CHERAN [M.Sc Computer Science]

Page 11

protected void RetrieveButton_Click(object sender, EventArgs e) { HttpCookie readcookie = Request.Cookies["userdetail"]; ResultLabel.Text = string.Format("Name: {0}, Occupation: {1}", readcookie["name"], readcookie["occupation"]); } }

OUTPUT:

R.CHERAN [M.Sc Computer Science]

Page 12

VIEW STATE

AIM: To create a website using view state. PROCEDURE: Step1: Open visual studio create new project with Empty website. Step2: To add the required controls form toolbox. Step3: To add a new web form and edit a design pages. Step4: To write a coding for Default.aspx.cs. Step5: save the project (ctrl + s). Step6: Run the project (F5).

R.CHERAN [M.Sc Computer Science]

Page 13

DESIGN PAGE:

CODE PAGE: using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; public partial class _Default : System.Web.UI.Page { public int counter { get { if (ViewState["pcounter"] != null) { return ((int)ViewState["pcounter"]); } else { return 0; } } set { ViewState["pcounter"] = value; } R.CHERAN [M.Sc Computer Science]

Page 14

} protected void Page_Load(object sender, EventArgs e) { } protected void btnIncrement_Click(object sender, EventArgs e) { lblCounter.Text = counter.ToString(); counter++; } }

OUTPUT:

R.CHERAN [M.Sc Computer Science]

Page 15

SESSION STATE

AIM: To create a website using session state. PROCEDURE: Step1: Open visual studio create new project with Empty website. Step2: To add the required controls form toolbox. Step3: To add a two web forms Default.aspx and success.aspx form in project. Step4: To write a coding for Default.aspx.cs and success.aspx. Step5: save the project (ctrl + s). Step6: Run the project (F5).

R.CHERAN [M.Sc Computer Science]

Page 16

DESIGN PAGE: CLIENT SIDE

SERVER SIDE

R.CHERAN [M.Sc Computer Science]

Page 17

CODE PAGE: Default.aspx: using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; public partial class _Default : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { } protected void Button1_Click1(object sender, EventArgs e) { Response.Redirect("~/Success.aspx?name=" + txtEmpName.Text + "&address=" + txtAddress.Text + "&phno=" + txtPhNo.Text + "&email=" + txtEmail.Text + ""); } }

Success.aspx: using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; public partial class Success : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { Label1.Text = Request.QueryString["name"]; Label2.Text = Request.QueryString["address"]; Label3.Text = Request.QueryString["phno"]; Label4.Text = Request.QueryString["email"]; } }

R.CHERAN [M.Sc Computer Science]

Page 18

OUTPUT:

R.CHERAN [M.Sc Computer Science]

Page 19

DATA GRID VIEW

AIM: To create a website display the data using grid view. PROCEDURE: Step1: Open visual studio create new project with website. Step2: To add the required controls form toolbox. Step3: To add a Default.aspx form project inserts textbox, label, and grid view. Step4: To write a coding for Default.aspx.cs. Step5: save the project (ctrl + s). Step6: Run the project (F5).

R.CHERAN [M.Sc Computer Science]

Page 20

DESIGN PAGE:

CODE PAGE: using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Data; using System.Data.OleDb; using System.Configuration; using System.Web.UI.WebControls; public partial class _Default : System.Web.UI.Page { OleDbConnection con = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\Users\\ELCOT\\Documents\\Visual Studio 2010\\WebSites\\gridview\\rock.accdb"); OleDbCommand cmd = new OleDbCommand(); public string name; public string fname; public string dob; public string age; public string mobileno; public string gender; protected void Page_Load(object sender, EventArgs e) R.CHERAN [M.Sc Computer Science]

Page 21

{ } protected void Button1_Click(object sender, EventArgs e) { con.Open(); cmd.CommandText = "insert into dept values('" + TextBox1.Text + "','" + TextBox2.Text + "','" + TextBox3.Text + "','" + TextBox4.Text+"','"+TextBox5.Text+"','"+DropDownList1.Text+"')"; cmd.Connection = con; cmd.ExecuteNonQuery(); ScriptManager.RegisterClientScriptBlock(this, GetType(), "AlertMessager", "alert('Save Sucessfully')", true); con.Close(); } protected void Button3_Click(object sender, EventArgs e) { con.Open(); cmd.CommandText = "select * from dept"; cmd.Connection = con; cmd.ExecuteNonQuery(); OleDbDataAdapter da = new OleDbDataAdapter(cmd); DataSet ds = new DataSet(); da.Fill(ds); GridView1.DataSource = ds; GridView1.DataBind(); con.Close(); } protected void Button4_Click(object sender, EventArgs e) { Response.Redirect(Request.Url.AbsoluteUri); } }

R.CHERAN [M.Sc Computer Science]

Page 22

OUTPUT:

R.CHERAN [M.Sc Computer Science]

Page 23

SERVER SIDE COTROLS AIM: To create a website using server side controls. PROCEDURE: Step1: Open visual studio create new project with asp.net server control. Step2: To write a coding in servercontrol.aspx.cs. Step3: build the server control project. Then include for tool box tab. Step4: then next create new website project and add a web form. Step5: To drag and drop a server control in the web form. Step6: save the project (ctrl + s). Step7: Run the project (F5).

R.CHERAN [M.Sc Computer Science]

Page 24

DESIGN PAGE:

CODE PAGE: using System; using System.Collections.Generic; using System.ComponentModel; using System.Linq; using System.Text; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; namespace ServerControl { [DefaultProperty("Text")] [ToolboxData("")] public class ServerControl1 : CompositeControl { TextBox textbox; ImageButton imagebutton; Calendar calendar; protected override void CreateChildControls() { Controls.Clear(); textbox = new TextBox(); textbox.ID = "dataTexBox"; imagebutton = new ImageButton(); R.CHERAN [M.Sc Computer Science]

Page 25

imagebutton.ID = "ImageButton"; calendar = new Calendar(); calendar.ID = "Calendar"; this.Controls.Add(textbox); this.Controls.Add(imagebutton); this.Controls.Add(calendar); } public override void RenderControl(HtmlTextWriter writer) { textbox.RenderControl(writer); imagebutton.RenderControl(writer); calendar.RenderControl(writer); } } }

OUTPUT:

R.CHERAN [M.Sc Computer Science]

Page 26

MASTER PAGES, THEMES AND SKINS AIM: To create a website using master page includes themes and skins. PROCEDURE: Step1: Open visual studio create new project with websites. Step2: To write a coding in for master.site.cs. Step3: add a style sheet in the style folder. Step4: write a css coding for style sheet. Step5: To add a new web form connects a master page. Step6: save the project (ctrl + s). Step7: Run the project (F5).

R.CHERAN [M.Sc Computer Science]

Page 27

DESIGN PAGE:

SOURCE CODE:









R.CHERAN [M.Sc Computer Science]

Page 28

COMPUTER SCIENCE DEPARTMENT

welcome

MAIN CONTENT AREA



SIDEBAR

FOOTER



STYLE.CSS html { background-color:Black; } .header { padding:5px 10px; background:#300600; color:White; } .wrapper { width:850px; } h1 { margin:0; height:96px; } .nav { padding:5px 10px; background:#742500; color:Yellow; } .main { float:right; R.CHERAN [M.Sc Computer Science]

Page 29

width:600px; height:400px; padding:10px; background:#FFF594; } h2 { margin:0 0 1em; } .sidebar { float:left; width:200px; height:400px; padding:10px; background:#F5A100; } .footer { clear:both; padding:5px 10px; background:#BA4500; height:58px; } .footer p { margin:0; }

R.CHERAN [M.Sc Computer Science]

Page 30

OUTPUT:

R.CHERAN [M.Sc Computer Science]

Page 31

FORM USING ASP.NET AIM: To create a website form using asp.net. PROCEDURE: Step1: Open visual studio create new project with website. Step2: add a new web form and insert a textbox, label, and buttons. Step3: To write a code in Defualt.aspx.cs page. Step4: create table from Microsoft access database. Step5: connect to database in Microsoft access database. Step6: save the project (ctrl+s). Step7: Run the project (F5).

R.CHERAN [M.Sc Computer Science]

Page 32

DESIGN PAGE:

CODE PAGE: using System; using System.Collections.Generic; using System.Data; using System.Linq; using System.Text; using System.Data.OleDb; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Configuration; public partial class _Default : System.Web.UI.Page { OleDbConnection con = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\Users\\ELCOT\\Documents\\Visual Studio 2010\\WebSites\\form\\data.accdb"); OleDbCommand cmd = new OleDbCommand(); public string name; public string fname; R.CHERAN [M.Sc Computer Science]

Page 33

public string dob; public string age; public string uname; public string pass; public string cpass; protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { Calendar1.Visible = true; } } protected void Button1_Click(object sender, EventArgs e) { con.Open(); cmd.CommandText = "Insert into stud Values('" + t1.Text + "','" + t2.Text + "','" + t3.Text + "','" + t4.Text + "','" + t5.Text + "','" + t6.Text + "','" + t7.Text + "')"; cmd.Connection = con; cmd.ExecuteNonQuery(); ScriptManager.RegisterClientScriptBlock(this, GetType(), "AlertMessager", "alert('Save Sucessfully')", true); con.Close(); } protected void Button2_Click(object sender, EventArgs e) { t3.Text = Calendar1.SelectedDate.ToLongDateString(); Calendar1.Visible = false; } }

R.CHERAN [M.Sc Computer Science]

Page 34

OUTPUT:

R.CHERAN [M.Sc Computer Science]

Page 35...