login credentials are not displaying in database

Question

hello, after login code execute, there are message is showing ,but that data are not showing database . Please tell me what should i code for showing data in database. i am uploding my c# code

Sachin Singh · Answer

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" ); } }

Jignesh Kumar · Answer

Hi Meera, Please check loging method code and first check your connection string which database is pointed to code.