Insert data in database using 3 Tier Architecture .
In this article i am explaining you how to insert record in database using 3-Tier Architecture.You can create separate project for Business and data access layer or also can keep in App_code folder.
This is aspx.cs code.Here code communicate through Business Layer.
protected void btnSubmit_Click(object sender, EventArgs e)
    {  
        objClientCls.ClName = txtCoName.Text;
        objClientCls.AddLine1 = txtAddLine1.Text;
        objClientCls.AddLine2 = txtAddLine2.Text;        
        try
        {            
            if (objClientCls.ClId == 0)
            {                            
                string Msg = objClBLL.InsertClMaster(objClientCls);
                lblMessage.Text = Msg;
                Clear();
            }            
        }
        catch (Exception ex)
        {
            lblMessage.Text = ex.Message;
        }
        finally
        {
            objClBLL = null;
        }        
    }
    
    Business Layer Code
    
    public string InsertClMaster(ClMasterCls objClMasterCls)
        {
            try
            {
                return objClMasterDAL.Insert(objClMasterCls);
            }
            catch
            {
                throw;
            }
            finally
            {
                objClMasterDAL = null;
            }
    }
    
    Data Acess layer code
    public string Insert(ClMasterCls objClMasterCls)
        {            
            try
            {
                conn.Open();
                string CreateMsg = Convert.ToString(SqlHelper.ExecuteScalar(conn, "usp_InsertClMaster", objClMasterCls.ClId, objClMasterCls.ClName, objClMasterCls.AddLine1
                    , objClMasterCls.AddLine2));
                return Msg;
            }
            catch
            {
                throw;
            }
            finally
            {
                conn.Close();
            }
    }
Thanks & Regards
Santosh Singh






0 comments:
Post a Comment