Cowboy
Fri Sep 22 08:36:49 CDT 2006
Pretty broad questions ...
"Jack" <Jack@discussions.microsoft.com> wrote in message
news:BCF64B40-D0B4-4E9B-901F-AC815CBA749B@microsoft.com...
> Hello All,
>
> Can anyone here suggest me some idea for my following queries?
>
> 1) How do I connect asp.net with oracle9i?
OracleDataSource object. Or, you can download ODP.NET from Oracle.
> 2) How can I generate a report using Crystal Report with asp.net based on
> certain user
> conditions?
>
You write a stored procedure in Oracle, set up your DataSource object with
the proper stored proc name and fill in the proper parameters. You then hook
the result set ot Crystal Reports.
If you want even more control, you have to set up your own connection,
command and parameter objects.
Most likely the Crystal documentation has a sample.
--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
http://gregorybeamer.spaces.live.com
*************************************************
Think outside of the box!
*************************************************