MySqlDataAdapter is not populating more than 6 columns

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

MySqlDataAdapter is not populating more than 6 columns

Post by Shivani matta » Thu 17 Feb 2005 19:24

This is my code-

foreach (DataRow dr in dt.Rows)
{
string prodId;
prodId = dr[0].ToString();
query= "SELECT a.datetime,a.buildnumber, a.bvtresult , a.urltofile , hid, a.distcode, type";
query= query + " FROM nuke_dailybuilds as a, nuke_bvtresults as b WHERE a.bid = b.bid and ";
query= query + " a.product_id = "+ prodId.ToString() +" ORDER BY a.bid DESC limit 1;";
adapter = new MySqlDataAdapter(query, conn) ;
adapter.Fill(ds1,"nuke_dailybuilds");
dt1= ds1.Tables[0];
Response.Write(dt1.Rows[0][6]);
Response.Write(dt1.Rows[0][5]);


Here it does not recognize the 7th column- dt1.Rows[0][6] . However if I change its order and make it the 6th column, it shows it without problem. This implies it is not reading the 7th column. Is there a limitation for the no of columns that it can read?

Serious

Post by Serious » Fri 18 Feb 2005 13:56

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.

Shivani Mata

Post by Shivani Mata » Fri 18 Feb 2005 21:12

oleg542 wrote: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.

Thanks for the reply

Post Reply