N-tier | 3-Three | Architecture in asp.net with c# | sql server | insert | display.

3-Three | N-tier | Architecture in asp.net with c# | sql server | insert | display. 1->Application layer 2->Database Layer 3->Business layer 4->Entity Layer 1->Application layer Mark up code:-

code Behind/Application layer

using System;
using System.Data.SqlClient;

using asp.netconnectionwith_class.connection;
namespace asp.netconnectionwith_class
{ 
    public partial class _Default : System.Web.UI.Page
    {
         connection.business objBl = new connection.business();
        connection.entity ObjEl = new connection.entity();
protected void Page_Load(object sender, EventArgs e)
        {
            
        }
        protected void btninsert_Click1(object sender, EventArgs e)
        {
         
           int id = Convert.ToInt32(txtid.Text.Trim());
           string nm =Convert.ToString(txtname.Text.Trim());
             
            int i = 0;
            i = objBl.insertintotable(id,nm);
            if (i > 0)
            {
                Response.Write("value inserted succesfully");
            }
            else
            {
                Response.Write("Error in insertion");
            }


        }

        protected void btndisplay_Click(object sender, EventArgs e)
        {

            int i = 0;
            DataSet dt;
            dt =objBl.display();
            i = dt.Tables[0].Rows.Count;
            if (i > 0)
            {
                grdvw.DataSource = dt;
                grdvw.DataBind();
            }
            else
            {
                Response.Write("Error");
            }
          
        
        }
    }
}


business Layer


using System;
using System.Data;
using System.Configuration;
using System.Data.SqlClient;
using System.Web;

using asp.netconnectionwith_class;
using asp.netconnectionwith_class.connection;

namespace asp.netconnectionwith_class.connection
{
    
    public class business

    {
        connection.addconnection Objcon = new connection.addconnection();
       
        public DataSet  display()
        {
           
            SqlConnection con;
            con = Objcon.Dbconnection();  
            try
            {
                SqlCommand cmdin = new SqlCommand("dispvalue", con);
                cmdin.CommandType = CommandType.StoredProcedure;
                SqlDataAdapter dAd = new SqlDataAdapter(cmdin);
                DataSet dSet = new DataSet();
                con.Open();
                dAd.Fill(dSet);
                return dSet;//.Tables["stud_info"];when use datatable
            }
            catch
            {
                throw;
            }
            finally
            {
                con.Close();
            }

        }
                       
        public int insertintotable(int id , string nm)
        {
            SqlConnection str;
            str = Objcon.Dbconnection();  

            int i = 0;
            try
            {
                str.Open();
                SqlCommand insertcommend = new SqlCommand("insertintotable", str);
               insertcommend.CommandType = CommandType.StoredProcedure;
               insertcommend.Parameters.AddWithValue("@id",id);
                insertcommend.Parameters.AddWithValue("@stud_nm",nm);
              
              
                i = insertcommend.ExecuteNonQuery();
            }
            catch (Exception ex)
            {
                ex.Message.ToString();
            }
            finally
            {
                
                str.Close();
            }
            return i;
        }
    }
}


Entity layer

using System;
using System.Data;
using System.Web;


using asp.netconnectionwith_class;

namespace asp.netconnectionwith_class.connection
{
    public class entity
    {

       public int _id;
        public int id
        {
            get
            {

                return this._id;
            }
            set
            {
                this._id = value;
            }
        }
       public  string _nm;
        public string nm
        {
            get{return this._nm;}
            set{this._nm= value;
            }
        }
    }
}


DataBase Layer

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Data.SqlClient;

using System.Web.UI.WebControls.WebParts;


namespace asp.netconnectionwith_class.connection
{
  
    public class addconnection
    {
        public SqlConnection  Dbconnection()
        {
          
            SqlConnection con=new SqlConnection(ConfigurationManager.ConnectionStrings["stud"].ConnectionString);
            return con;
        }

       
    }
}

IF you are using entity layer then it will be ntier else three tier architecture for connectivity in asp.net programming with c#. for understanding three tier architecture you need to create .cs file or we can say create class file in simple asp.net page.

Share This