How to Append column name in SQL statement in .NET

[btozgurkoc]

Hi;
The problem is:

I get column name as a parameter . This parameter is "myColumnNa me".
Then I want to write such SQL statement :

"SELECT <myColumnName > FROM CUSTOMERS"

hovewer I dont know how to append myColumnName in sql statement..

Please help me.
Thanks in advance
Sincerly
Ozgur

[Sakalicek]

Expect that we have some input parameter string sColumnName.
So create the query string like this:

string sQuery = String.Format(" select \"{0}\" from customers;", sColumnName)

or like this:

string sQuery = "select \"" + sColumnName + "\" from customers;";


Is this what you asked?

Z.

Hi;
The problem is:

I get column name as a parameter . This parameter is "myColumnNa me".
Then I want to write such SQL statement :

"SELECT <myColumnName > FROM CUSTOMERS"

hovewer I dont know how to append myColumnName in sql statement..

Please help me.
Thanks in advance
Sincerly
Ozgur