CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2009
    Posts
    15

    Write Oracle SQL in .net C#

    I have a query works really good in oracle but I need to know how to write in C#.
    Pl. help me

    SELECT DISTINCT source_year, can
    FROM hits_vw
    where source_year between 2005 and 2007
    Order by source_year Desc

  2. #2
    Join Date
    Nov 2007
    Location
    .NET 3.5 / VS2008 Developer
    Posts
    624

    Re: Write Oracle SQL in .net C#

    you write it the exact same way.

    Code:
    string sql = "SELECT DISTINCT source_year, can FROM hits_vw WHERE source_year between 2005 and 2007 ORDER BY source_year DESC";
    as you can see, I did not change anything.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  





Click Here to Expand Forum to Full Width

Featured