I want to simple example about Data Grid..

  • Thread starter Thread starter nomenklatura
  • Start date Start date
N

nomenklatura

Hi,
I developed windows ce 2003 program with vb.net
But i couldn't use Data Grid in my project
I connect Sql Server Ce database..
I use listview, but it is take too many time when opening due to
loop(datareader)

I want to use data grid..
How can i?, i couldn't find any example about this topic.. examples always
about listview

Thanks your advance...



In additional ,this is sample code which i couldn't work: (about combobox)

Dim da As New System.Data.SqlServerCe.SqlCeDataAdapter

Dim ds As New System.Data.DataSet

dbLocal.ConnectionString = "c:\xxx.sdf"

dbLocal.Open()

strQuery = "SELECT * FROM TBL_" & strFirmaNo & "_CLCARD WHERE
DEFINITION_<>'' ORDER BY DEFINITION"

da.SelectCommand = New Data.SqlServerCe.SqlCeCommand(strQuery, dbLocal)

da.Fill(ds, "CARILER") 'error occured:An unhandled exception of type
'System.Data.SqlServerCe.SqlCeException' occurred in
System.Data.SqlServerCe.dll

Me.cmbCari.DataSource = ds

Me.cmbCari.DisplayMember = "DEFINITION_"

Me.cmbCari.ValueMember = "LOGICALREF"
 
I commented inline
nomenklatura said:
Hi,
I developed windows ce 2003 program with vb.net
But i couldn't use Data Grid in my project
I connect Sql Server Ce database..
I use listview, but it is take too many time when opening due to
loop(datareader)

I want to use data grid..
How can i?, i couldn't find any example about this topic.. examples always
about listview

Thanks your advance...



In additional ,this is sample code which i couldn't work: (about combobox)

Dim da As New System.Data.SqlServerCe.SqlCeDataAdapter

Dim ds As New System.Data.DataSet

dbLocal.ConnectionString = "c:\xxx.sdf"

dbLocal.Open()

strQuery = "SELECT * FROM TBL_" & strFirmaNo & "_CLCARD WHERE
DEFINITION_<>'' ORDER BY DEFINITION"

da.SelectCommand = New Data.SqlServerCe.SqlCeCommand(strQuery, dbLocal)

da.Fill(ds, "CARILER") 'error occured:An unhandled exception of type
Click to expand...

After this line, just set the datasource fo the datagrid...

myDataGrid.DataSource = ds.Tables["CARILER"];



Here are some links
http://samples.gotdotnet.com/quickstart/CompactFramework/doc/datagrid.aspx
http://samples.gotdotnet.com/quickstart/CompactFramework/doc/datagridediting
..aspx
http://samples.gotdotnet.com/quickstart/CompactFramework/doc/datagridediting
..aspx
 
Back
Top