Changing connection data depending on which button is pressed.

hai guyes,
I am trouble in visual basic. Please help me.

My trouble is, I made two databases in two directories. eg. D:\student.mdb and E:\Student.mdb. Now I have a listbox in visual form and select 1, 2 and If I click 1 I want to connect my databases in D:\Student.mdb and If I click 2, I Want to connect E:\Student.mdb. How can this possible. And I have a command button on vb form Proceed. When I click proceed I want to connect my adodc to the respective database.

Can anyone help me.

Joosa K.

Oct 15 '07 #1

Subscribe Post Reply

1072

debasisdas

8,127

Expert 4TB

Use different connection strings on user inputs .Use listindex of the selected item to change connection string at runtime.

Use separate connection objects for both the connections.

Oct 15 '07 #2

pbmods

5,821

Expert 4TB

Heya, Joosa. Welcome to TSDN!

Changed thread title to better describe the problem (did you know that threads whose titles do not follow the Posting Guidelines actually get FEWER responses?).

I'm going to go ahead and move this thread to the VB forum, where our resident Experts will be better able to help you out.

Oct 16 '07 #3

Similar topics

Access 97 Data entry form questions

by: Iain Miller | last post by:

Struggling a bit here & would be grateful for any help. I have a table which has a list of people in it. Each person has a unique ID automatically allocated by Access but also belongs to one of 5...

Microsoft Access / VBA

changing a form to a subform (VB problems)

by: Max Harvey | last post by:

Hi, I made up a nice little form which had its own sub form in it. I made a litle VB code so that when I pressed a button it would move form the form (frmConference) to the subform...

Microsoft Access / VBA

Data Cleaning

by: Santosh | last post by:

Since I just started my new work, I have inherited a MS Access database which has nearly 13000 records in a single table. Now, my mandate is to clean the database and maybe split the table into...

Microsoft Access / VBA

Changing connection string at runtime from login form

by: Tim Nelson | last post by:

I am building a data bound application for SQL server which all the forms I use sqlconnections generated by VS. I want to have a login form that changes the connection depending upon login...

C# / C Sharp

Problems while exporting data using pipe symbols

by: mark.heyden | last post by:

Hi Frends, I am facing problems while trying to export data into pipe format. In fact I am fetching records from mysql database and then trying to create a text file ( using pipe as delimeter) ,...

PHP

database connection loss

by: Martin B | last post by:

Hallo! I'm working with C# .NET 2.0, implementing Client/Server Applications which are connecting via Network to SQL-Server or Oracle Databases. To stay independent from the underlaying Database...

C# / C Sharp

Changing a hidden field

by: sheldonlg | last post by:

I have what is probably a very simple question, but I am VERY new to javascript. Here is what I want to accomplish. I have a text box called zp. I also have a hidden field called frm. There is...

Javascript

Changing button preferences after beeing pressed

by: thomas.lidebrandt | last post by:

Hello I'm using wxPython to consruct a GUI and want to change a button label and event handler to change after the button have been pressed. The only thing I can think of is a global variable...

Python

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing