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.

login credentials are not displaying in database

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (2)