Click to See Complete Forum and Search --> : problem with DataGrid.DataBind()


Andrzej
August 31st, 2005, 08:47 AM
I have MySql data base. I prepared simple ASP.NET page to connect with mySql. I have some strange proble with fill DataGrid.

my MySQL table:

column1 name => id / Datatype => INTEGER
column2 name => date / Datatype => DATE
column3 name => time / Datatype => TIME
column4 name => value / Datatype => VARCHAR(45)

part of my code default.aspx.cs

MySqlDataAdapter dataAdapter = new MySqlDataAdapter (strQuery, strConnection);
DataSet ds = new DataSet();
dataAdapter.Fill(ds);
DataGrid1.DataSource = ds;
DataGrid1.DataBind();

as a result of my code on the web page I can see ONLY 3 COLUMNs
column1 name => id
column2 name => date
column3 name => value

Could anybody explain me what happen when I call

DataGrid1.DataBind();


Thank in advance