οκ, βάλε ένα label στην σελίδα σου και κοίτα τι έχω κάνει παρακάτω (αν και δεν είναι ο σωστός τρόπος) για να δούμε τι σου βγάζει ακριβώς
protected void button1_click(object sender, EventArgs e)
{
string connectionString = ConfigurationManager.ConnectionStrings["MyconsString"].ConnectionString;
string insertSql="Insert into Register (FisrtName,LastName,UserName,Password,Email,Phone,Address) values (@FirstName,@LastName,@UserName,@Password,@Email,@Phone,@Address)";
SqlConnection Con=new SqlConnection(connectionString );
SqlCommand cmd=new SqlCommand();
cmd.Connection=con;
cmd.CommandType=CommandType.Text;
cmd.CommandText=insertSql;
SqlParameter firstname=new SqlParameter ("@FirstName", SqlDbType.VarChar, 50);
firstname.Value =txtFirstName.Text.ToString();
cmd.Parameters.Add(firstname);
SqlParameter lastName=new SqlParameter ("@LastName", SqlDbType.VarChar, 50);
lastName.Value =txtLastName.Text.ToString();
cmd.Parameters.Add(lastName);
SqlParameter UserName=new SqlParameter ("@UserName", SqlDbType.VarChar, 50);
UserName.Value =txtUsername.Text.ToString();
cmd.Parameters.Add(UserName);
SqlParameter password=new SqlParameter ("@Password", SqlDbType.VarChar, 50);
password.Value =txtPwd.Text.ToString();
cmd.Parameters.Add(password);
SqlParameter Email=new SqlParameter ("@Email", SqlDbType.VarChar, 50);
Email.Value =txtEmailID.Text.ToString();
cmd.Parameters.Add(Email);
SqlParameter phone=new SqlParameter ("@Phone", SqlDbType.VarChar, 50);
phone.Value =txtPhone.Text.ToString();
cmd.Parameters.Add(phone);
SqlParameter address=new SqlParameter ("@Address", SqlDbType.VarChar, 50);
address.Value =txtAddress.Text.ToString();
cmd.Parameters.Add(address);
try
{
con.Open();
cmd.ExecuteNonQuery();
}
catch (SqlException ex)
{
Label1.Text = ex.StackTrace
}
catch (Exception ex)
{
Label1.Text =ex.StackTrace
}
}
Antonios Chatzipavlis