checking if id and reg already exists

Hi Petro,

Try replacing your code with the below one:
----------------------------------------------
SqlConnection con = new SqlConnection("Data Source=GATE-PC\\SQLEXPRESS;Initial Catalog=dbProfile;Integrated Security=True");
con.Open();
SqlCommand cmdd = new SqlCommand("select * from Profile where user_Id = @userid AND RegNo = @reg", con);

cmdd.Parameters.AddWithValue("@userid",txtid.Text);
cmdd.Parameters.AddWithValue("@reg", txtregNo.Text);


SqlDataReader reader = cmdd.ExecuteReader();

if (reader.HasRows)
{
MessageBox("User Id/Registry Number already exists");
}


else
{
SqlConnection con = new SqlConnection("Data Source=GATE-PC\\SQLEXPRESS;Initial Catalog=dbProfile;Integrated Security=True");
SqlCommand cmd = new SqlCommand("qry", con);
cmd.CommandType = System.Data.CommandType.Text;

cmd.Parameters.AddWithValue("@id", txtid.Text);
cmd.Parameters.AddWithValue("@regno", txtregNo.Text);
cmd.Parameters.AddWithValue("@name", txtname.Text);

cmd.CommandType = System.Data.CommandType.StoredProcedure;
con.Open();
cmd.ExecuteNonQuery();
MessageBox("successfully saved!");

}
------------------------------------------------


Please mark it as answer if it helps.

Happy coding :)

Thanks.