C# Forum

string query = "select OrderCode,OrderDesc,to_date(OrderDate,'dd-MON-YYYY') As "OrderDate" from tblOrder";

//getting Error to the above string how to add double quotation to my OrderDate string

while debuging the string must look like

select OrderCode,OrderDesc,to_date(OrderDate,'dd-MON-YYYY') As "OrderDate" from tblOrder

thanks

string query = "select OrderCode,OrderDesc,to_date(OrderDate,'dd-MON-YYYY') As \"OrderDate\" from tblOrder"; 

Lokeshbasana, please login to Mark As Answer, if this helps | Alert Moderator 

string query = "select OrderCode,OrderDesc,to_date(OrderDate,'dd-MON-YYYY') as [ OrderDate]  from tblOrder";

Lokeshbasana, please login to Mark As Answer, if this helps | Alert Moderator 

Lokeshbasana, please login to Mark As Answer, if this helps | Alert Moderator