Classes

1) First you need to make stored procedures. (To study just read Stored Procedures lesson).

2) Add folder in solution explorer naming app_code. And in this add ".cs" file as "Add new item" (by default class.cs).

The code in .cs file is this:

************************** Code in Class.cs ********************************

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Data.SqlClient;

using System.Data;

using System.Configuration;

/// Summary description for Class1

//public class Class1 {

// public Class1()

// { }}

namespace ns

{

public abstract class clscon

{

protected SqlConnection con=new SqlConnection(ConfigurationManager.ConnectionStrings["cn"].ConnectionString); // it must be //protected otherwise child class can not call it

public clscon() //To make a class from which provide connection to other classes.

{

con.ConnectionString=ConfigurationManager.ConnectionStrings["cn"].ConnectionString;

}

}

public class clsdeptprp //This defines all the cells in your database.

{

public Int32 deptid {get;set;} //"get" directly takes value from database.

public string deptnam { get;set;} //"set" returns that value after changes to database.

}

public class clsdept :clscon //for a particular table handle all the functions as save,delete,update

{ //etc.

public void SaveRec(clsdeptprp p)

{

if(con.State==ConnectionState.Closed) //here in intelligence shell con appear only when we define it protected in parent class

con.Open();

SqlCommand cmd= new SqlCommand("insdept",con);

cmd.CommandType= CommandType.StoredProcedure;

cmd.Parameters.Add("@deptid",SqlDbType.Int).Value= p.deptid;

cmd.Parameters.Add("@deptnam",SqlDbType.VarChar).Value=p.deptnam;

cmd.ExecuteNonQuery();

cmd.Dispose();

con.Close();

}

public void DelRec(clsdeptprp p) //to delete the data from the database

{

if(con.State==ConnectionState.Closed)

con.Open();

SqlCommand cmd=new SqlCommand("deldept",con);

cmd.CommandType =CommandType.StoredProcedure;

cmd.Parameters.Add("@deptid",SqlDbType.Int).Value=p.deptid;

cmd.ExecuteNonQuery();

cmd.Dispose();

con.Close();

}

public void UpdateRec(clsdeptprp p) //to update the data from the database

{

if(con.State==ConnectionState.Closed)

con.Open();

SqlCommand cmd=new SqlCommand("upddept",con);

cmd.CommandType= CommandType.StoredProcedure;

cmd.Parameters.Add("@deptnam",SqlDbType.VarChar).Value=p.deptnam;

cmd.Parameters.Add("@deptid",SqlDbType.Int ).Value=p.deptid;

cmd.ExecuteNonQuery();

cmd.Dispose();

con.Close();

}

public List DispRec (Int32 id) //to display the data from the database

{

if(con.State==ConnectionState.Closed)

con.Open();

SqlCommand cmd=new SqlCommand("dispdept",con);

cmd.CommandType= CommandType.StoredProcedure;

cmd.Parameters.Add("@deptid", SqlDbType.Int).Value = id;

SqlDataReader dr= cmd.ExecuteReader();

List obj=new List();

while(dr.Read())

{

clsdeptprp p =new clsdeptprp();

p.deptid=Convert.ToInt32(dr["deptid"]);

p.deptnam=dr["deptnam"].ToString();

obj.Add(p);

}

dr.Close();

cmd.Dispose();

con.Close();

return obj;

}

}

}

***********************************************************************************

3) Design of classes. To see HTML click here....

4)

************************** Code in default.aspx.cs *****************************

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Data.SqlClient;

using System.Data;

using System.Configuration;

public partial class dept_class : System.Web.UI.Page

{

ns.clsdept obj = new ns.clsdept();

ns.clsdeptprp objprp = new ns.clsdeptprp();

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

ListBox1.DataBind();

}

public void listbind() //make a function to bind the ListBox

{

ListBox1.DataBind();

}

public void clrclass() //function to clear all the fields.

{

Label1.Text = "";

Label2.Text = "";

}

protected void insert_Click(object sender, EventArgs e)

{

if (update2.Visible == true)

{

update2.Visible = false;

update.Visible = true;

}

TextBox1.Visible = true;

TextBox2.Visible = true;

Label1.Visible = false;

Label2.Visible = false;

insert.Visible = false;

insert2.Visible = true;

}

protected void delete_Click(object sender, EventArgs e)

{

objprp.deptid = Convert.ToInt32(Label1.Text);

obj.DelRec(objprp); //the obj pass value to DeleRec define in "Class.cs"

clrclass();

ListBox1.DataBind();

}

protected void update_Click(object sender, EventArgs e)

{

if (insert2.Visible == true)

{

insert2.Visible = false;

insert.Visible = true;

TextBox1.Visible = false;

Label1.Visible = true;

}

TextBox2.Visible = true;

Label2.Visible = false;

update.Visible = false;

update2.Visible = true;

}

protected void clear_Click(object sender, EventArgs e)

{

clrclass();

}

protected void ListBox1_SelectedIndexChanged(object sender, EventArgs e)

{

Label1.Visible = true;

Label2.Visible = true;

TextBox1.Visible = false;

TextBox2.Visible = false;

update2.Visible = false;

update.Visible = true;

insert2.Visible = false;

insert.Visible = true;

clrclass();

List p =obj.DispRec(Convert.ToInt32(ListBox1.SelectedValue));

Label1.Text = p[0].deptid.ToString();

Label2.Text = p[0].deptnam.ToString();

}

protected void insert2_Click(object sender, EventArgs e) //Event to insert value.

{

objprp.deptid = Convert.ToInt32(TextBox1.Text);

objprp.deptnam = TextBox2.Text;

obj.SaveRec(objprp);

clrclass();

ListBox1.DataBind();

TextBox1.Visible = false;

TextBox2.Visible = false;

insert2.Visible = false;

Label1.Visible = true;

Label2.Visible = true;

insert.Visible = true;

}

protected void update2_Click(object sender, EventArgs e)

{

objprp.deptid = Convert.ToInt32(TextBox1.Text);

objprp.deptnam = TextBox2.Text;

obj.UpdateRec(objprp); //the obj pass value to UpdRec define in "Class.cs"

clrclass();

ListBox1.DataBind();

TextBox2.Visible = false;

update2.Visible = false;

Label2.Visible = true;

update.Visible = true;

}

}

*********************** Web config file connection ************************

5) Running interface of Classes....