Hi,
I modified your code try it now:
public void AddstudentDetails(int SystemID, string StudentNumber, string FirstName,string MiddleName,string LastName,string address, string contact,string Email)
{
SqlConnection con = new SqlConnection();
con.ConnectionString = ConfigurationManager.ConnectionStrings["smsysConnectionString"].ConnectionString;
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandText = "sp_AddStudentDetails";
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter parameterSystemID = new SqlParameter("@SystemId",SqlDbType.Int,4);
parameterSystemID.Value=SystemID;
cmd.Parameters.Add(parameterSystemID);
SqlParameter parameterStudentNumber = new SqlParameter("@StudentNumber", SqlDbType.VarChar, 50);
parameterStudentNumber.Value = StudentNumber;
cmd.Parameters.Add(parameterStudentNumber);
SqlParameter parameterFirstName = new SqlParameter("@FirstName", SqlDbType.VarChar, 50);
parameterFirstName.Value = FirstName;
cmd.Parameters.Add(parameterFirstName);
SqlParameter parameterMiddleName = new SqlParameter("@MiddleName", SqlDbType.VarChar, 50);
parameterMiddleName.Value = MiddleName;
cmd.Parameters.Add(parameterMiddleName);
SqlParameter parameterLastName = new SqlParameter("@LastName", SqlDbType.VarChar, 50);
parameterLastName.Value = LastName;
cmd.Parameters.Add(parameterLastName);
SqlParameter parameterAddress = new SqlParameter("@Addresss", SqlDbType.VarChar, 50);
parameterAddress.Value = address;
cmd.Parameters.Add(parameterAddress);
SqlParameter parameterContact = new SqlParameter("@Contact", SqlDbType.VarChar, 11);
parameterContact.Value = contact;
cmd.Parameters.Add(parameterContact);
SqlParameter parameterEmail = new SqlParameter("@Email", SqlDbType.VarChar,50);
parameterEmail.Value = Email;
cmd.Parameters.Add(parameterEmail);
try
{
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
catch (Exception ex)
{
}
}
I found a mistake here on this line
parameterLastName.Value = LastName;
what you have done is
parameterLastName.Value = parameterLastName;