BAL & DAL

Hi Suhesh

1st u have to create a folder in the name of DAL


2nd to create in the name of BAL

3rd u have to design a page

DAL code


using System;
using System.Data;
using System.Configuration;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;


///

/// Summary description for DAL
///

public class DAL
{

    string s = ConfigurationManager.AppSettings["ss"].ToString();
    SqlConnection con = new SqlConnection();
    SqlCommand cmd = new SqlCommand();
    SqlDataAdapter da = new SqlDataAdapter();
    DataSet ds = new DataSet();




    public DAL()
    {
        //
        // TODO: Add constructor logic here
        //
    }

    public int inset(string FName, string Age, string Resume)
    {
        con = new SqlConnection(s);
        con.Open();
        try
        {
           string qr="insert into thretier(FName,Age,Resume) values ('" + FName + "','" + Age + "','" + Resume + "')";
           cmd = new SqlCommand(qr,con);
            return cmd.ExecuteNonQuery();

        }
        catch {

            throw;
        }
            finally
        {

            cmd.Dispose();
            con.Dispose();
        con.Close();
       
       
        }
   
   
    }




    public DataTable  selcc()
    {
        con = new SqlConnection(s);
            con.Open();
        try
        {
            string qry="select * from thretier";
            cmd=new SqlCommand(qry,con);
            SqlDataAdapter da=new SqlDataAdapter(cmd);
            DataTable dt=new DataTable();
            da.Fill(dt);
            return dt;

           
        }
        catch(Exception)
        {
       
        throw;
       
        }
        finally
        {
       
         cmd.Dispose();
            con.Dispose();
        con.Close();
       
        }







   
   
    }
   
   
   
    }
























BAL code
using System;
using System.Data;
using System.Configuration;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;

///

/// Summary description for BAL
///

public class BAL
{


    DAL  ash=new DAL();
    public BAL()
    {
        //
        // TODO: Add constructor logic here
        //
    }




    public int inset(string FName, string Age, string Resume)
    {
        try
        {
            return ash.inset(FName, Age, Resume);
        }
        catch
        {

            throw;

        }
        finally
        {
            ash = null;
       
        }


    }

    public DataTable getdaa()
    {
        try
        {
            return ash.selcc();

        }
        catch
        {
            throw;

        }
        finally
        {
              
        }
    }

}







3rd design


<%@ Page Language="C#" AutoEventWireup="true"  CodeFile="Default.aspx.cs" Inherits="_Default" %>







   
   


   

   

   
       
           
               
               
           
           
               
               
           
           
               
               
           
           
               
               
           
           
          
           
               
               
           
           
               
               
           
           
               
               
           
           
               
               
           
           
               
               
           
       
   
   

   

code


using System;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;

public partial class _Default : System.Web.UI.Page
{
    BAL selv = new BAL();
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            aggg();
        }
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        aggg();

      



        string Filena = System.IO.Path.GetFileName(FileUpload1.PostedFile.FileName.ToString());
        string save = Server.MapPath("Resume") + "\\" + Filena;
        if (FileUpload1.PostedFile != null)
        {
            FileUpload1.PostedFile.SaveAs(save);
        }


        string FName = txname.Text;
        string Age = tage.Text;
        string Resume = Filena.ToString();
        int dash;
        dash=selv.inset(FName,Age,Resume);







    }

    private void aggg()
    {
        ListItem li = new ListItem();
        li.Text = "Select";
        li.Value = "0";
        ddag.Items.Add(li.ToString());
        for (int i = 0; i <= 100; i++)
        {
            ddag.Items.Add(Convert.ToString(i));
        }

   
    }










}

go through this link ..

http://www.c-sharpcorner.com/uploadfile/hgvyas123/3-tier-architecture/


http://www.dotnetfunda.com/articles/article71.aspx