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

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