How we work on N tire architecture in asp.net Please give me
Examle...
Answer Posted / sandeep singh shekhawat
Class Library:-
Person.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
namespace Info
{
public class Person
{
public Person()
{
}
public string FirstName { get; set; }
public string LastName { get; set; }
public string Age { get; set; }
}
}
connection.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;
namespace Info
{
public class connection
{
public SqlConnection conn;
public connection()
{
conn = new SqlConnection();
conn.ConnectionString = @"Data Source=.\SQLEXPRESS;AttachDbFilename=E:\WebSite2\App_Data\Database.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True";
}
}
}
Query.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;
namespace Info
{
public class Query
{
connection con = new connection();
SqlCommand cmd;
public Query()
{
}
public int insert(Person p)
{
if (con.conn.State == ConnectionState.Closed)
con.conn.Open();
cmd = new SqlCommand("Insertdata", con.conn);
cmd.CommandType = CommandType.StoredProcedure;
try
{
cmd.Parameters.AddWithValue("@FirstName", p.FirstName);
cmd.Parameters.AddWithValue("@LastName", p.LastName);
cmd.Parameters.AddWithValue("@Age", p.Age);
return cmd.ExecuteNonQuery();
}
catch
{
throw;
}
}
}
}
PersonDAL.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
namespace Info
{
public class PersonDAL
{
public PersonDAL()
{
}
public int insert(Person p)
{
Query q = new Query();
try
{
return q.insert(p);
}
catch
{
throw;
}
}
}
}
Storeprocedure
ALTER PROCEDURE Insertdata
(
@FirstName varchar(50),
@LastName varchar(50),
@Age int
)
AS
INSERT INTO person(Fname,Lname,Age) VALUES (@FirstName,@LastName,@Age)
RETURN
Web page:
Person.aspx.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using Info;
public partial class _Default : System.Web.UI.Page
{
Person p = new Person();
PersonDAL pd = new PersonDAL();
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
p.FirstName = TextBox1.Text;
p.LastName = TextBox2.Text;
p.Age = TextBox3.Text;
pd.insert(p);
}
}
Is This Answer Correct ? | 11 Yes | 1 No |
Post New Answer View All Answers
How to update and insert from datagridview at run time in excel database?
how to insert fname,lname,designation values into database while click on the submit button using windows authentication mode?
Give me some tips in c#?
How we work on N tire architecture in asp.net Please give me Examle...