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);

}
}

How to update and insert from datagridview at run time in excel database?

2765

Give me some tips in c#?

2164

How we work on N tire architecture in asp.net Please give me Examle...

16592

how to insert fname,lname,designation values into database while click on the submit button using windows authentication mode?

2199