DataReader does not return all values in it..

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
Guest

DataReader does not return all values in it..

Post by Guest » Sat 11 Jun 2005 10:28

This is my code....
If i read records from datareader it only return first 6 records


string str = "Data Source=200.0.1.150;Database=cpms;User ID=rakesh;Password=rakesh";

MySQLConnection con = new MySqlConnection (str);

con.Open();

MySqlCommand cmdSelect1 = new MySqlCommand("Select LoginID,FirstExpStartDate,FirstExpEndDate, ,SecondExpEndDate,ThirdExpStartDate,ThirdExpEndDate from experiance where LoginID = '"+ user +"'",con);

dr = cmdSelect1.ExecuteReader ();

Serious

Post by Serious » Tue 14 Jun 2005 07:06

Trial version of the provider is limited by number of the returned table columns. MySQLDirect .NET trial version returns result set with maximum 6 columns. Extra select-list columns are truncated.

santanu

dataReader Problem

Post by santanu » Wed 06 Jul 2005 16:13

me too.Have U find any soln?

Serious

Post by Serious » Sun 10 Jul 2005 14:05

If you have this problem with standard or professional version, try to reinstall MySQLDirect .NET. Check before that MySQLDirect isn't installed and there are no CoreLab.MySql.dll, CoreLab.MySql.Addin.dll, CoreLab.MySql.Design.dll files in GAC.

Post Reply