How to databind to a mysql database in vs2005 using basic/ or c#

[garyusenet]

Hello,

I know how to create a mysql database and open it in code.

I don't know how to databind to it.

i have a simple form with 5 controls text controls. I want to enter
text into the controls, and write this text to a corresponding column
in the mysql database.

how do i do this please?

Thanks,
Gary.

[Ignacio Machin \( .NET/ C# MVP \)]

Hi,

You bind your controls to an IList , this interface is implemented by
DataSet , so one solution is fill your dataset ( by using DataAdapter.Fil l )
and then just bind it to your control.
Another possibility is using the DataReader , if you are just displaying the
info and do not need to keep it in memory just the IDataReader
implementation, just remember to close it after you are done with it.
--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

<ga********@myw ay.com> wrote in message
news:11******** **************@ z34g2000cwc.goo glegroups.com.. .

Hello,

I know how to create a mysql database and open it in code.

I don't know how to databind to it.

i have a simple form with 5 controls text controls. I want to enter
text into the controls, and write this text to a corresponding column
in the mysql database.

how do i do this please?

Thanks,
Gary.