Devart Forums

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?

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.

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