ORACLE SQL statement in C# !! ??

[Naif_Prof]

Dears I need to write the following ORACLE SQL statement in C# in page of ASP as string Select emp_name as “employees Name” , emp_Add as “address” , dept as “department” From test.emp_tab ; Im using as to rename the column name in datagrid Any one help me to write it by C# as string Notes we in oracle to rename column name we have to use “ ” same as in defining string in C# Thanks

[Akhilesh Yadav]

try this string SqlQry; SqlQry = "Select emp_name as ""employees Name"" , emp_Add as ""address"" , dept as ""department"" From test.emp_tab";

Regards, Akhilesh Yadav

[Naif_Prof]

Dear Akhilesh Yadav its not working by after a lot of time the correct syntax is SqlQry = "Select emp_name as \"employees Name\" , emp_Add as \"address\" , dept as \"department\" From test.emp_tab"; so we use \ to cancel meaning of “ in string thanks