CODEWITHSUNDEEP
c#.netmysqlsqlwinforms
βӔḺṪẶⱫŌŔ
βӔḺṪẶⱫŌŔ

Reputation: 1296

MySQL Returning Column Names instead of their Content

Okay, so in the past few weeks I've probably written about 40 select statements. So, I know how to do it. And I've just written another one, but this time I need to use ComboBox values to match against, and it keeps resulting in the names of the column (the right column, mind you), instead of what's inside the column.

string st = "SELECT '" + txtchange.Text + "' 
               FROM mysql_9269_dbase." + pages.Text + "";

MySql.Data.MySqlClient.MySqlCommand cd = new MySql.Data.MySqlClient.MySqlCommand(st, msc);
cd.CommandType = CommandType.Text;
MySql.Data.MySqlClient.MySqlDataReader msdr = cd.ExecuteReader();

while(msdr.Read())
{
   txt.Text = msdr[0].ToString();
}

Now, why is it returning the column name instead of the content of that column?

Upvotes: 0

Views: 981

Answers (2)

Subhash Lama
Subhash Lama

Reputation: 433

In sql you can do it like this.

string query = "Execute("+"'SELECT " + txtchange.Text + " FROM mysql_9269_dbase." + pages.Text + "')";

Upvotes: 1

tpdi
tpdi

Reputation: 35141

Lose the single quotes.

Change 

  "SELECT '" + txtchange.Text + "' "

to

  "SELECT " + txtchange.Text + " "

Upvotes: 6

Related Questions