hi all, i m working on a component for MIS department. i need that when i run my component it should ask for: from where u want to retrieve ur data i.e. from Oracle/SQL Server/MS-Access. when i select one of these options for ex. if i select Oracle or SQL Server it should prompt for login and password. and if i select Access it should prompt for path. After making the connection to the database i need to create templates for reporting. Any idea how to do that. plz help me. its urgent
Gaurav arora 0 Junior Poster in Training
sknake 1,622 Senior Poster Featured Poster
That isn't an easy task... Have you checked out existing report writers? I see a lot of people here using Crystal Reports. I use XtraReports by developer express: http://www.devexpress.com
Beyond that you will need to handle building the connection strings for OleDb, ODBC, SQL Native, and Oracle.
Here the ADODB connection wizard dialog. You can invoke this at runtime to save you the time of writing a screen: http://www.tech-archive.net/Archive/DotNet/microsoft.public.dotnet.framework.adonet/2007-01/msg00172.html
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.