How to send a parameter(field of a table) into select sql statement

[roxanna_]

Hi all,
I want to create a function in c# which receives a paramater (name of a field from a table in oracle)
The function will have to return the distinct values of the specific field.I don't know how to insert the parameter into the
select distinct(parameter) from table sql statement
I hope that you understood me.
Thank you.

[Ketsuekiame]

Are you forming the SQL statement in the code or on the database server as a stored procedure?

[roxanna_]

Yes, i form the SQL statement in the code as the CommandText of an OleDbCommand that I use with a DataReader.

[Ketsuekiame]

Ok, in that case you can use String.Format() to build the query string.

myCommand.CommandText = String.Format("SELECT DISTINCT({0}) FROM TheTable", theFieldName);

You can use parameters, but this is by far the quickest and simplest way.

[roxanna_]

Thank you!This solved my problem.