Home > DeveloperSection > Forums > How to read and compare data from an SQL Server Express database
john rob

Total Post:108

Points:756
Posted on    January-28-2014 12:12 AM

 C# C# 
Ratings:


 1 Reply(s)
 610  View(s)
Rate this:

I am trying to create a select statement in C# to check if the value inserted into a textbox (userName) is in an existing SQL database. I have a database called Employee containing a table called EVUSERS and it has a column called UName.

In my code I have a method which takes the value from a textbox called UserBox. I would like to know if there is a temporary table where the select is stored which I can compare the textbox value to.

Here is the code:

private void CheckLoginExist()

{

            String userName = UserBox.Text;

            string connectionString = @"Data Source=.\SQLEXPRESS;Database=Employee;Integrated Security=true";

            using (SqlConnection connection = new SqlConnection(connectionString))

            {

                using (SqlCommand command = connection.CreateCommand())

                {

                    command.CommandText = "SELECT UName FROM EVUSERS WHERE UName = @UName";

                    command.Parameters.AddWithValue("@UName", userName);

                    connection.Open();

                    command.ExecuteNonQuery();

                    connection.Close();

                }

            }

}



Pravesh Singh

Total Post:411

Points:2881
Posted on    January-28-2014 12:55 AM

Hi John,

You need ExecuteScalar, not ExecuteNonQuery

connection.Open();

var name = command.ExecuteScaclar().ToString();

connection.Close();

if (name != null) {

  MessageBox.Show("This name already exists");

  return;

}


Don't want to miss updates? Please click the below button!

Follow MindStick