Parameters to Views in Oracle from C# OLEDB Connection.

Question

0.00/5 (No votes)

See more:

Hi,
I have created an view In oracle which has a date Range in where claus.

SQL

Create view my_View as select a,b,c from XYZ,BYZ where XYZ.a=BYZ.b and XYZ.date_J between '1-apr-2011' and '21-may-2011'

(Dates are hardcoded)

I am using this view from c#. I dont want to use direct Query in c#.

I want to pass the date range from Windows Forms to View for the Report.

Can you help?

Thanx in advance! :)

Prathamesh

Posted 24-Sep-11 17:46pm

prathameshpitale

Updated 25-Sep-11 0:11am

walterhevedeich

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Mehdi Gholam · Answer 1 · 2011-09-24T20:10:00

Solution 1

Put a date column in your view and query the view like normal adding a where clause for your date.

Posted 24-Sep-11 20:10pm

Mehdi Gholam

Comments

prathameshpitale 25-Sep-11 6:02am

Thanx.. But i have some used a very complex query. it has Group by Clauses.
Is there any other way?

Mehdi Gholam 25-Sep-11 6:10am

It makes no difference you can insert a where clause anywhere in your query to filter the results.

prathameshpitale 25-Sep-11 9:05am

Ok. Thank you.

prathameshpitale 26-Sep-11 4:10am

Hi Mehdi Gholam.
I tried Your Suggestion. But I cannot Take Date column in My View as I am using Group Clause and Union ALl Clause in My Query.
Do you know any other way to use Substitution Variables for Date range in Query.