protected void btnSubmit_Click(object sender, EventArgs e){ SqlConnection conNwind; SqlCommand cmdSelect, cmdInsert; SqlDataReader dtrUser; string connStr = ConfigurationManager.ConnectionStrings["ConnectionNWind"].ConnectionString; conNwind = new SqlConnection(connStr); conNwind.Open(); string select = "Select * from UserRegistration where UserName=@UN AND Email=@Email"; cmdSelect = new SqlCommand(select, conNwind); cmdSelect.Parameters.AddWithValue("@UN", txtUN.Text); cmdSelect.Parameters.AddWithValue("@Email", txtEmail.Text); dtrUser = cmdSelect.ExecuteReader(); if (dtrUser.Read()) { if (Username != "") { Label1.Text = "UserName already exists"; } else if (Email != "") { Label1.Text = "Email already exist!"; } else { dtrUser.Close(); string strInsert = "Insert into UserRegistration(FirstName,LastName,UserName,Password,Gender,Address,Email) values(@FN,@LN,@UN,@Pass,@Gender,@Add,@Email)"; cmdInsert = new SqlCommand(strInsert, conNwind); cmdInsert.Parameters.AddWithValue("@FN", txtFN.Text); cmdInsert.Parameters.AddWithValue("@LN", txtLN.Text); cmdInsert.Parameters.AddWithValue("@UN", txtUN.Text); cmdInsert.Parameters.AddWithValue("@Pass", txtPass.Text); cmdInsert.Parameters.AddWithValue("@Gender", rdlGender.SelectedItem.ToString()); cmdInsert.Parameters.AddWithValue("@Add", txtAdd.Text); cmdInsert.Parameters.AddWithValue("@Email", txtEmail.Text); int intAdd = cmdInsert.ExecuteNonQuery(); if (intAdd != 0) Label1.Text = "User Registration successful,you can now <a href='UserLogin.aspx'>Login</a>"; else Label1.Text = "Record not added into database!"; } } else conNwind.Close();}
I want to check the record weather its exits in the database(which is the username and the email address) before user insert, but i have a problem which highlighted in yellow color which shown above.