There is a problem with escaping column names. If I want to make the column name in Russian, then in the query I have to enclose this name in quotes. And how to do it in c #? This is what I did:

OracleDataAdapter da = new OracleDataAdapter("select brigade_number as '" + "Номер бригады" + "', count(status) as '" + "Задач выполнено" + "' from task_execution join brigade on task_execution.brigade_id = brigade.brigade_id where status = 'Выполнено' group by brigade_number having count(*)>0", con); Но в итоге это даёт только название в апострофах. А нужны кавычки. Пробовал по 2 апострофа сделать но это тоже не даёт положительного результата. Подскажите пожалуйста как это нужно сделать. Спасибо заранее.
  • OracleDataAdapter da = new OracleDataAdapter ("select brigade_number as" "Brigade number" ", count (status) as" "Tasks completed" "from task_execution join brigade on task_execution.brigade_id = brigade.brigade_id where status = 'Done by count (*)> 0 ", con); Try this ... - Rostyslav Kuzmovych
  • 3
    And you cannot accidentally screen " using backslash "select 1 as \"Номер бригады\"" in C #. Well or yes, double the quotes - Mike
  • one
    it is possible and specially :) - Rostyslav Kuzmovych
  • And Google on request "C # string" gives a link where it is all explained msdn.microsoft.com/ru-ru/library/ms228362.aspx - Mike
  • 2
    And why are the columns in Russian? bad idea, imho. - 0xdb

0