| 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: | |
| Category: | Connector / NET | Severity: | S2 (Serious) |
| Version: | 3.0.1517.33524 | OS: | 2003 server |
| Assigned to: | Reggie Burnett | CPU Architecture: | Any |
[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.

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()