MySQL and Visual Basic .Net

I am having problems connecting my database through Visual Basic. I want to
be able to fill a data set and display the data in combo boxes. For example I
have a database named 'RFI' and I want the names of Project Managers from the
'ProjectManagers' table to be placed in the combo box. Please help me someone.


--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org

RE: MySQL and Visual Basic .Net

NOTE: Make sure you out the Microsoft.Data.Odbc.dll in
your Bin folder.

http://www.asp.net/Tutorials/quickstart.aspx

(for above link click on "Server Side Data Access"

http://longhorn.msdn.microsoft.com/lhsdk/ndp/daconsampleread ingobjectdatafromadonetdatareader.aspx

Some code I did for my own site using the above info
as a template
*****************************************


<%@ Page Language="VB" %>
<%@ Import namespace = "Microsoft.Data.Odbc" %>
<%@ Import namespace = "System.Data" %>
<%@ Assembly Name="Microsoft.Data.Odbc" %>










__________________________________
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org

Re: MySQL and Visual Basic .Net

dear Michel

you posted an example of vb.net with mysql the other day...and it worked..i
was so pleased!

I cannot seem to get it to work with other examples....do you have any other
working vb.net code that uses"system.data.oledb" instead of the

<%@ Import namespace = "Microsoft.Data.Odbc" %>
<%@ Import namespace = "System.Data" %>
<%@ Assembly Name="Microsoft.Data.Odbc" %>

because the one i was using (the tutorial) has code like this

<%@ Page Language="VB" debug="true"%>
<%@ Import namespace = "System.Data" %>
<%@ Import namespace = "System.Data.OleDB" %>



and it just isn't working =( the provider is wrong i know that but i dont
know what the .net provider is

would you be able to help with this please?

thanks heaps
gavin


--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org