how to connect SQL CE database on PocketPC

  • Thread starter Thread starter Microsoft
  • Start date Start date
M

Microsoft

I have one SQL CE database (two tables : one has 100 records, another has
30,000+ records) on my PocketPC.
And I try a lot of ways to connect and query it.

What components I have to use?
What commands I have to use?
How can I query it?

Thank you so much for any help.

Regards,
(e-mail address removed)
 
Microsoft said:
I have one SQL CE database (two tables : one has 100 records, another has
30,000+ records) on my PocketPC.
And I try a lot of ways to connect and query it.

What components I have to use?
What commands I have to use?
How can I query it?
Click to expand...

Use SqlCeDataAdapter, SqlCeConnection, SqlCeCommand etc. The
documentation for each of them should provide you with enough
information to go from there, if you've got other ADO.NET experience -
if not, look through a "normal" (desktop) ADO.NET tutorial first.
 
Yes, I try it, but fail.

My code is like this :
Dim SqlConnection1 As New System.Data.SqlClient.SqlConnection

Dim SqlSelectCommand1 As New System.Data.SqlClient.SqlCommand

Dim SqlDataAdapter1 As New System.Data.SqlClient.SqlDataAdapter

Dim SqlDataSet1 As New System.Data.DataSet

SqlConnection1.ConnectionString = "data source=" &
openFileDialog1.FileName() & ";Password=abc;persist security
info=True;packet size=4096"

SqlDataAdapter1.SelectCommand = SqlSelectCommand1

SqlSelectCommand1.CommandText = "SELECT * from tblBook"

SqlSelectCommand1.Connection = SqlConnection1

SqlConnection1.Open()

SqlDataAdapter1.Fill(SqlDataSet1)

SqlDataAdapter1.TableMappings.Add("tblBook", "strBookFullThai")

SqlDataSet1.Tables("tblBook").Columns("strBookFullThai")
 
Microsoft said:
Yes, I try it, but fail.

My code is like this :
Click to expand...

Right, and what goes wrong? Bear in mind that when you fill a DataSet,
it will only create tables called Table, Table1, Table2 etc as far as I
know.
 
If you whant to use CsqlCE you need to use SQLCE objects like this:
if(System.IO.File.Exists(@"\My Documents\TestDB.sdf"))
{
SqlCeConnection oConn = new SqlCeConnection(@"Data Source=\My
Documents\TestDB.sdf");
SqlCeCommand sqlProd;

sqlProd = new SqlCeCommand("SELECT * from tblBook", oConn);

SqlCeDataAdapter daProduct = new SqlCeDataAdapter(sqlProd);
if (daProduct == null)
{
dtsProduct = new DataSet();
}
dtsProduct.Clear();
daProduct.Fill(dtsProduct,"tblBook");
DataGrid1.DataSource = dtsProduct.Tables["tblBook"];
}


____________________
Franky
(e-mail address removed)



Microsoft said:
Yes, I try it, but fail.

My code is like this :
Dim SqlConnection1 As New System.Data.SqlClient.SqlConnection

Dim SqlSelectCommand1 As New System.Data.SqlClient.SqlCommand

Dim SqlDataAdapter1 As New System.Data.SqlClient.SqlDataAdapter

Dim SqlDataSet1 As New System.Data.DataSet

SqlConnection1.ConnectionString = "data source=" &
openFileDialog1.FileName() & ";Password=abc;persist security
info=True;packet size=4096"

SqlDataAdapter1.SelectCommand = SqlSelectCommand1

SqlSelectCommand1.CommandText = "SELECT * from tblBook"

SqlSelectCommand1.Connection = SqlConnection1

SqlConnection1.Open()

SqlDataAdapter1.Fill(SqlDataSet1)

SqlDataAdapter1.TableMappings.Add("tblBook", "strBookFullThai")

SqlDataSet1.Tables("tblBook").Columns("strBookFullThai")
Click to expand...
 
You must use the classes from the System.Data.SqlServerCe
namespace (SqlCeEngine, SqlCeConnection, SqlCeDataAdapter,
SqlCeCommand etc.) not from the System.Data.SqlClient
namespace.
 
Franky said:
If you whant to use CsqlCE you need to use SQLCE objects like this:
Click to expand...

<snip>

Whoops - yes, having already pointed the OP to the SqlCe* classes, I
didn't notice that he then hadn't used them...
 
For example, to create a new SQL CE database, you use this
code (the new database will be created in the "Test.sdf"
file):

Dim connStr As String = "Data Source = Test.sdf; Password
= <password>"

Dim engine As New SqlCeEngine(connStr)
engine.CreateDatabase()
engine.Dispose()

To connect to this database use:

Dim conn As SqlCeConnection
conn = New SqlCeConnection(connStr)
conn.Open()
 
Back
Top