Posted on: 9/3/2012 3:29:30 AM | Views : 370

I am a newbie to 3 tier architecture and below is my DAL code
In my DAL
public static int Insert(string firstname, string lastname, DateTime dob, string gender,string email, string password) { // bool flag = false; SqlParameter pid; SqlParameter result; SqlConnection con = Generic.DBConnection.OpenConnection(); try { SqlCommand cmd1 = new SqlCommand("Insertreg", con); cmd1.CommandType = CommandType.StoredProcedure; cmd1.Parameters.AddWithValue("@FirstName", firstname); cmd1.Parameters.AddWithValue("@LastName", lastname); cmd1.Parameters.AddWithValue("@Dob", dob); cmd1.Parameters.AddWithValue("@Gender", gender); cmd1.Parameters.AddWithValue("@EmailId", email); cmd1.Parameters.AddWithValue("@Password", password); result = cmd1.Parameters.Add("@result", System.Data.SqlDb ...

Go to the complete details ...