Bug #5914 Cannot bind to a Datagrid using MySQLDriverCS.MySQLDataReader
Submitted: 6 Oct 2004 0:42 Modified: 31 Jan 2005 21:19
Reporter: henry eli Email Updates:
Status: Not a Bug Impact on me:
None 
Category:Connector / NET Severity:S2 (Serious)
Version:3.0.1517.33524 OS:2003 server
Assigned to: Reggie Burnett CPU Architecture:Any

[6 Oct 2004 0:42] henry eli
Description:
When I use the MySQLdatareader it will not allow me to bind to a datagrid using asp.net 

the specific error is :

"A valid data source must implement either IListSource or IEnumerable."

How to repeat:
VB.NET for ASP.net

Function MySQLDataReader(ByVal sSQL As String) As MySQLDriverCS.MySQLDataReader
        Dim Cs As MySQLDriverCS.MySQLConnectionString
        Dim mysqlConn As New MySQLDriverCS.MySQLConnection
        Dim Result As MySQLDriverCS.MySQLDataReader
        Try
            Cs = New MySQLDriverCS.MySQLConnectionString("localhost", "bina", "bina", "bina1")
            mysqlConn.ConnectionString = Cs.AsString
            mysqlConn.Open()

            Dim MysqlCommand As New MySQLDriverCS.MySQLCommand(sSQL, mysqlConn)
            Result = MysqlCommand.ExecuteReader()
            Return Result
        Catch
            'DEBUG CODE
            Debug.Write(Err.Description)
        End Try
    End Function

+++++ on a form load with a datagrid add this code to the form load

 Dim sSQL As String
        Dim DataClass As New HMFMySQLData
        Dim DR As New Data.DataSet
        sSQL = "Select * From contact"
        'DR = DataClass.MySQLDataReader(sSQL)
        DGRID.DataSource = DataClass.MySQLDataReader(sSQL)
        DGRID.Contacts.DataBind()
[6 Oct 2004 14:18] Puiu Hrenciuc
As far as I know MySQLDriverCS has nothing to do with Connector.NET

Post your bug here :

http://sourceforge.net/projects/mysqldrivercs/
[9 Oct 2004 13:39] Reggie Burnett
MySQLDriverCS is not developed by MySQL and has nothing to do with MySQL Connector/net.