Breaking News: Grepper is joining You.com. Read the official announcement!

c# test if user exist or not

Mohamed Sami khiari answered on May 31, 2023 Popularity 1/10 Helpfulness 1/10

answer c# test if user exist or not

related c# test if user exist or not

c# test if user exist or not

Comment

string connectionString = "YourConnectionString";

        // Get the username and password from user input
        Console.WriteLine("Enter username:");
        string username = Console.ReadLine();

        Console.WriteLine("Enter password:");
        string password = Console.ReadLine();

        using (SqlConnection connection = new SqlConnection(connectionString))
        {
            try
            {
                // Open the database connection
                connection.Open();

                // Create a SQL command with parameters
                string query = "SELECT COUNT(*) FROM Users WHERE Username = @Username AND Password = @Password";
                using (SqlCommand command = new SqlCommand(query, connection))
                {
                    // Set the parameter values
                    command.Parameters.AddWithValue("@Username", username);
                    command.Parameters.AddWithValue("@Password", password);

                    // Execute the query and get the result
                    int count = (int)command.ExecuteScalar();

                    // Check if the login was successful
                    if (count > 0)
                    {
                        Console.WriteLine("Login successful!");
                    }
                    else
                    {
                        Console.WriteLine("Login failed. Invalid username or password.");
                    }
                }

                // Close the database connection
                connection.Close();
            }
            catch (Exception ex)
            {
                // Handle any exceptions that occur
                Console.WriteLine("An error occurred: " + ex.Message);
            }
        }

        Console.ReadLine();
    }
}

Popularity 1/10 Helpfulness 1/10 Language csharp

Source: Grepper

Tags: c#

Link to this answer
Share Copy Link

Contributed on May 31 2023

Mohamed Sami khiari

0 Answers Avg Quality 2/10

Closely Related Answers

c# test if user exist or not

Comment

SqlConnection sqlcon = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=d:\0mesdocuments\visual studio 2015\Projects\msk-store\msk-store\msk-store-db-Alpha.mdf;Integrated Security=True;Connect Timeout=30");


            string query = "Select * from Users Where us = '" + txtUsername1.Text.Trim() + "' AND ps = '" + txtPassword.Text.Trim() + "'";

            SqlDataAdapter sda = new SqlDataAdapter(query, sqlcon);
            //sqlcon.Open();
            //MessageBox.Show("Connection Open  !");

            DataTable dtbl = new DataTable();
            
            sda.Fill(dtbl);
            Console.WriteLine("hhhhh test");

            Console.WriteLine(dtbl);

            if (dtbl.Rows.Count == 1)
            {
                frmHome frm = new frmHome();
                this.Hide();
                frm.Show();
 
            }
            else
            {
                MessageBox.Show("Check your username and password");
            }

           
        }

Popularity 1/10 Helpfulness 1/10 Language csharp

Source: Grepper

Tags: c#

Link to this answer
Share Copy Link

Contributed on May 31 2023

Mohamed Sami khiari

0 Answers Avg Quality 2/10

c# test if user exist or not

Contents

More Related Answers

c# test if user exist or not

Closely Related Answers

c# test if user exist or not

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.