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
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