login credentials are not displaying in database

C# code for Registration

private Register_Click(EventArgs e){
Using(SqlConnection con = new SqlConnection("data source=.; database=Sample; integrated security=SSPI")){
SqlCommand cmd = new SqlCommand("Insert into table values (@UserName,@Password)", con);
cmd.Parameters.Add(@UserName, txtUserName.Text);
cmd.Parameters.Add(@Password, txtPassword.Text);
con.Open();
int result= cmd.ExecuteNonQuery();
if(result==1);
{
MessageBox.Show("User Created");
}
else
{
MessageBox.Show("Something went Wrong");
}
}
}

c# code for Login

private Login_Click(EventArgs e){
Using(SqlConnection con = new SqlConnection("data source=.; database=Sample; integrated security=SSPI")){
SqlCommand cmd = new SqlCommand("Select Password from table where userName==@UserName", con);
cmd.Parameters.AddWithValue(@UserName, txtUserName.Text);
con.Open();
string PasswordInDatabase= Convert.ToString(cmd.ExecuteScalar());
if(!String.IsNullOrEmpty(PasswordInDatabase) && (PasswordInDatabase==txtPassword.Text) )
{
MessageBox.Show("Login Successfully");
}
else
{
MessageBox.Show("Something went Wrong");
}
}

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jignesh Kumar5y ago
Hi Meera,

Please check loging method code and first check your connection string which database is pointed to code.
Sachin Singh5y ago
C# code for Registration
private Register_Click(EventArgs e){
Using(SqlConnection con = new SqlConnection("data source=.; database=Sample; integrated security=SSPI")){
SqlCommand cmd = new SqlCommand("Insert into table values (@UserName,@Password)", con);
cmd.Parameters.Add(@UserName, txtUserName.Text);
cmd.Parameters.Add(@Password, txtPassword.Text);
con.Open();
int result= cmd.ExecuteNonQuery();
if(result==1);
{
MessageBox.Show("User Created");
}
else
{

MessageBox.Show("Something went Wrong");
}
}
}
c# code for Login
private Login_Click(EventArgs e){
Using(SqlConnection con = new SqlConnection("data source=.; database=Sample; integrated security=SSPI")){
SqlCommand cmd = new SqlCommand("Select Password from table where userName==@UserName", con);
cmd.Parameters.AddWithValue(@UserName, txtUserName.Text);
con.Open();
string PasswordInDatabase= Convert.ToString(cmd.ExecuteScalar());
if(!String.IsNullOrEmpty(PasswordInDatabase) && (PasswordInDatabase==txtPassword.Text) )
{
  MessageBox.Show("Login Successfully");
}


else
{

MessageBox.Show("Something went Wrong");
}

}