connecting asp.net with oracle9i

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Pretty broad questions ...

Jack said:
Hello All,

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

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

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?
Click to expand...

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