[RESOLVED] Control Name

[INV-Predator]

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.

[BrailleSchool]

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.0

[BrailleSchool]

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.

[INV-Predator]

The how do you propose that i connect to my database.

[INV-Predator]

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?

[Joacim Andersson]

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.

[INV-Predator]

So what is the control i use for that (name)?

[mikee_phil]

adodc control microsoft ado data control can be used to connect to that database

[Joacim Andersson]

But beware that you have been adviced against using that with bound controls