3 Tier Architecture

Question

Hai..Good evening Frnds... I need 3-tier architecture & N-tier Architecture best examples and how we use in our projects... plz help me.... Thanks in Advance Dudes :)

Sandeep Singh Shekhawat · Answer

Three tier example http://www.dotnetfunda.com/articles/article71.aspx

Chintan Rathod · Answer

Following are some links where examples are resides in. 3 tier architecture http://www.aspdotnet-suresh.com/2010/05/introduction-to-3-tier-architecture-in_17.html http://www.c-sharpcorner.com/uploadfile/paulabraham/building3tierapppa11282005053625am/building3tierapppa.aspx http://www.dotnetfunda.com/articles/article71.aspx N tier architecture http://www.codeproject.com/Articles/434282/A-N-Tier-Architecture-Sample-with-ASP-NET-MVC3-WCF http://msmvps.com/blogs/williamryan/archive/2008/05/16/doing-tiers-with-wcf.aspx http://www.codeproject.com/Articles/32237/N-Tier-development-with-ASP-NET-MVC-WCF-and-LINQ

Anurag Sarkar · Answer

https://www.youtube.com/watch?v=wd7azrCmtSM Check out this video this will help you a lot there are series you have to watch it all if you want to implement 3 tier . Thanks

selvi subramanian · Answer

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(FNameAgeResume) values (' + FName + '' + Age + '' + Resume + '); cmd = new SqlCommand(qrcon); 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(qrycon); 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 DEMO .style1 { width: 100%; } .style2 { width: 556px; }                   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(FNameAgeResume); } private void aggg() { ListItem li = new ListItem(); li.Text = Select; li.Value = 0; ddag.Items.Add(li.ToString()); for (int i = 0; i { ddag.Items.Add(Convert.ToString(i)); } } }

Lalit Raghuvanshi · Answer

Reffer to the links: Setup 3 tier architecture project in asp.net C# Create 3 tier application in Asp.Net C# to Inserteditupdatebind and delete data