connecting asp.net with oracle9i

[Guest]

Hello All,

Can anyone here suggest me some idea for my following queries?

1) How do I connect asp.net with oracle9i?

2) How can I generate a report using Crystal Report with asp.net based on
certain user
conditions?

Thanks in advance
Jackfadd

 

[Cowboy \(Gregory A. Beamer\)]

Pretty broad questions ...

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!
*************************************************