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?