datagrid

[Nathan Franklin]

hey everyone

i was wandering if you could help me. i am trying to decide whether to use
the datagrid or not in my mobile device app.

is it fast enough? what is its memory consumption like? i dont want to
overload my app!

i am reading from an sqlce database, could someone maybe provide me some
sort of reference, either sample code or a website where i could get some
examples of how to integrate the datagrid and sql server ce to display my
select sql statement. currently i am using SqlCeCommand and SqlCeReader

thanks heaps for your help

cheers

nath

 

[Guest]

Nathan,

I just posted this to another question thread, but this code is very similar
to what we do with the datagrid and SQLCE.

DataTable dt = new DataTable();
SqlCeCommand sqlCeCommand = sqlCeConnection.CreateCommand();
sqlCeCommand.CommandText = "Select * from blah";
SqlCeDataAdapter SqlCeDA = new SqlCeDataAdapter(sqlCeCommand);
SqlCeDA.Fill(dt);
SqlCeDA.Dispose();
sqlCeCommand.Dispose();
yourDataGrid.DataSource = dt;

HTH,
John

 

[Sampathd]

Hi,

It's more or less as same as you would bind data in a desktop application.
Just use teh appropriate commands etc in the CF version such as
SqlCeDataReader instead of SqlDataReader.

Cheers,
Sampath.