What is the name that I will see in Visual Basic components for connecting to a database (MySQL) ADODB or something, I can find ADODC.
Printable View
What is the name that I will see in Visual Basic components for connecting to a database (MySQL) ADODB or something, I can find ADODC.
Add a reference (project > references) for Microsoft ActiveX Data Objects 2.0Quote:
Originally Posted by INV-Predator
then you can use ADO through code to connect to the MySQL DB. many threads on the forum for this. i would recommend you do not bind controls to a database because this is evil and can cause many problems later down the road.
The how do you propose that i connect to my database.
Btw BrailleSchool, that is not what i want to do.
I need to use the DB to import data at certain times.
-Runtime (Load Registered Channels [which are managed by a class] and load their info)
-NewUser (Authentification, Ban List Check)
-UserInfoChange (Update)
Just to name a few.
So what is the control that just let's you connect to a database, then read and write data?
ADO is the way to go. What BrailleSchool was talking about was bound controls. That is when you use a data control to connect to a database and then use other controls (like textboxes) and bind them to the data control so they will automatically display a field from the database.
I wouldn't call bound controls for "evil" but it's usually better to write the display code yourself especially if you want to do something more then simply displaying simple data.
So what is the control i use for that (name)?
adodc control microsoft ado data control can be used to connect to that database
But beware that you have been adviced against using that with bound controls :)