Error: Incorrect Syntax near 'last_name'

Question

For the life of me I cannot figure out what is wrong with my basic testing code. Here is what I have.

SqlDataReader rdr = null;

SqlConnection con = null;

SqlCommand cmd = null;

string txtLastName = TextBox1.Text;

try

{

string ConnectionString = "server=DEL-CD212; uid=sa;" +

"pwd=graver; database=Test;";

con= new SqlConnection(ConnectionString);

con.Open();

string CommandText = "SELECT last_name, first_name" + "FROM try" + "WHERE last_name=;" + txtLastName;

cmd = new SqlCommand(CommandText);

cmd.Connection = con;

rdr = cmd.ExecuteReader();

while(rdr.Read())

{

ListBox1.Items.Add(rdr["last_name"].ToString() + ", " + rdr["first_name"].ToString());

}

catch(Exception ex)

{

ListBox1.Items.Add(ex.Message);

}

finally

{

if(rdr !=null)

rdr.Close();

if(con.State == ConnectionState.Open)

con.Close();

}

Any help would be greatly appreciated.

Michelle · Answer

Thanks. I realized my mistake myself and was about to delete the thread.

Mahesh Chand · Answer

Your SQL query is incorrect. There must be space between all syntaxes and all string type variables must have single quotes around them. Try this: SELECT last_name first_name  +  FROM try WHERE last_name= '  + txtLastName +  ' ;