SQL Server CE Database : Pda to desktop and back

dotnet framework

    Next

  • 1. get BlueTooth signal quality
    How can I get the BlueTooth signal quality in my C# Pocket ap when PPC connect to another BlueTooth devices?
  • 2. any music/midi library
    hi, is there any music/midi library available for c#? i want to input and play midi and chord stuff on pocketpc. thanks!
  • 3. SqlCeResultSet as DataSource?
    Hi All, After looking at the documentation on the SqlCeResultSet I was under the inpression that I could use this as a datasource for a list control such as a ComboBox. However it does not seem to be working for me. What I want to do is bind the ComboBox control such that I can set a DisplayMember and ValueMember. From what I have seen so far the only way I can currently do this is by using a DataSet which is more overhead than I want, especially when I have no need to update the DataSet. I could use a SqlCeDataReader, which would be fast, but I know of no way to set the ValueMember property of the items in the ComboBox using this method. Any thoughts?

SQL Server CE Database : Pda to desktop and back

Postby Victor » Thu, 07 Aug 2003 22:55:23 GMT

Is there anyway to create an SQL Server CE
Database on the pc desktop, 
and also a way of taking the SQL Server CE Database from the
pda to the desktop 
using a method other than replication??

Re: SQL Server CE Database : Pda to desktop and back

Postby Mark Reddick » Thu, 07 Aug 2003 23:31:23 GMT

You cannot create a CE database on the desktop. You can use RDA (Remote Data
Access) to keep a desktop SQL Server db in sync with a CE db. That is what
I'm doing. Here is what I did for my app:

1) Create the database I want on desktop SQL Server. Remember not to use
stored procs or views as they are not supported on SQLCE.

2) Add any initial data I want into the desktop SQL Server database.

3) In my PPC app, I then use SQLCE and do a CreateDatabase to create a
database on the PPC device.

4) I then use RDA and connect to my desktop database and pull all the tables
down to my SQLCE database.

5) I then reset my identity columns as they don't come down with RDA.

That's it. The app can then use the SQLCE database. You can then use RDA
again to push any changes made on the SQLCE db to your desktop DB. I do this
so that my desktop database remains my "master" db.

HTH,
Mark






Re: SQL Server CE Database : Pda to desktop and back

Postby LawX » Fri, 08 Aug 2003 16:54:13 GMT

so,

I'm interested in what you're saying about stored 
procedures on the desktop DB. Is it really impossible to 
use stored proc on the server even if my SqlCe doesn't try 
to use them. I mean, when doing the RDA, where is the prob 
with stored proc if RDA only copy tables to the SqlCe.

I'm quite a beginner in developping C# for mobile but I 
have a huge solution to make before soon. My databses on 
the server are already created and use stored procs. You 
make me nervous by telling me it won't work !! ;-)

thanks for explaining me in details how all that work.
bye
use RDA (Remote Data
db. That is what
Remember not to use
Server database.
CreateDatabase to create a
pull all the tables
down with RDA.
can then use RDA
desktop DB. I do this



from the

Re: SQL Server CE Database : Pda to desktop and back

Postby Mark Reddick » Fri, 08 Aug 2003 21:27:42 GMT

No no. Sorry to confuse you. You can use sp and views on the desktop
database. You just can't use them on the CE database (on the PDA). So, your
PDA app has to be able to work without relying on stored procs or views.











Re: SQL Server CE Database : Pda to desktop and back

Postby LawX » Fri, 08 Aug 2003 23:36:15 GMT

reat thanks for all that. I didn't ask for so much
examples but it's pleasant to feel helped.
Really thank you, RDA and SQL CE have never been so clear
to me.
LawX
and it should work.
PULL, I do that simply
the last value.
the identiy column
(maxValuePlusOne, 1)
them into the
sure when you do
that way it will
do the Push, it will
the host db outside
may update your
values each of
Windows app that writes
into a table that you
data back, you
identity column values as
the CE application
updating their local
have it's own "range"
the same identity
replication. I
involved and you may not
the
to
questions. I
and
then
using
on
(on
stored
impossible to
doesn't
SqlCe.
but I
databses on
You
work.
can
with a
come
You
your
Database

Re: SQL Server CE Database : Pda to desktop and back

Postby John Atkins » Sat, 09 Aug 2003 17:19:46 GMT

ould I jump in and ask a question about RDA? I've not used it yet but when
I read about it, I thought it was only for the desktop PC end. In other
words, I thought the PC had to make the connection to the PPC and then send
to or request data from the PPC.

Could you confirm that the PPC can also make the connection and be in
control?

Regards

John.

"Mark Reddick" < XXXX@XXXXX.COM > wrote in message
news:% XXXX@XXXXX.COM ...
work.
simply
column
will
outside
writes
you
as
local
"range"
not



Re: SQL Server CE Database : Pda to desktop and back

Postby LawX » Sat, 09 Aug 2003 18:45:36 GMT

s far as I know, only the PPC could use RDA. The device
has to be connected to the Internet and the server could
not know if it is or not. So, in my view, RDA is a way to
call synchronisation, but only the PPC can launch the
service.
Actually, I'm beginner in using C# and mobile devices. I'm
desesperatly trying to connect both PPC and Desktop and
that's not so easy. There are many parameters that come in
the process and, as i don't konw much about MS
environnement, it's hard for me to understand all.
But anyway, many people have been able to use RDA, I'm
sure it works perfectly, it just need a bit of practicing.
If anyone knows any good documentation about all that
stuff, i'll be pleased to be awared.

thanks.
used it yet but when
end. In other
PPC and then send
connection and be in
message
and it should
PULL, I do that
get the last value.
reset the identiy
(maxValuePlusOne, 1)
insert them into the
make sure when you do
so that way it will
do the Push, it
the host db
may update your
column values each of
Windows app that
into a table that
the data back, you
identity column values
the CE application
updating their
have it's own
the same identity
replication. I
involved and you may
desktop.
but the
seem to
questions. I
newsGroup
a
and
then
group
using
(beginner?)
views on
(on
stored
impossible to
doesn't
the
SqlCe.
but I
databses on
procs. You
work.
You can
with a
Server.
SQL
database
come
database. You
your
db.
Database

Re: SQL Server CE Database : Pda to desktop and back

Postby John Atkins » Sat, 09 Aug 2003 19:56:01 GMT

pologies to you and Mark. I was confusing RAPI with RDA. I thing RAPI can
only be controlled from a PC not a PPC but I could be wrong. RDA is complely
different.



Incidentally a book I can recommend is Microsoft .NET Compact Framework Core
Reference by Wigley and Wheelwright. It does contain a section on RDA.



Try saying Wigley Wheelwright a few times fast! :-)



John.


"LawX" < XXXX@XXXXX.COM > wrote in message
news:0a1101c35d91$d1b22520$ XXXX@XXXXX.COM ...



Similar Threads:

1.Accessing a sql server ce database on a PDA from a desktop applica

Hi, 

is there a possibility to access a sql server ce databse on a pocket pc 
through a desktop application (pda is connected via active sync). 
Applications developed
with .Net an Visual Basic

Cheers, Egils

2.sql server ce desktop database designer application

greetinns

does anyone know any visual desktop program that we can use to create 
databases and generate the SQL to use on a sql server ce to create the 
pocket database?

thanks

almeida

3.How to transfer SQL CE database (sdf) to SQL Server database (mdf)

Hello

I have SQL CE database (.sdf file) and want to transfer it
to MS SQL Server 2000 (.mdf file).

Is there any solution to do it in relatively simple way (without
creating database with corresponding tables on SQL Server 2000).

My setup is:
- SQL Server CE database with a number of tables
- SQL Server 2000 database without tables (empty)

With RDA it isn't possible, because it works according to
pull-push principe. 
With no tables in SQL Server 2000 one cannot do pull.

What about Merge Replication or any other solution?

My device is out of order, so any solution related to using
ActiveSync is not for me.

Thanks in advance.

Pavel.

4.problem connecting from desktop to sql mobile database on pda

hi there,

i cant get it to connect, i added the reference to 
System.Data.SQLServerCE.dll, and using the following code (IP is pinged and 
working okay)

------------
string DATABASE_CONN = "Data Source = \\\\192.168.1.107\\My 
Documents\\OrdersDB.sdf";
SqlCeConnection conn = new SqlCeConnection(DATABASE_CONN);
conn.Open();
------------

any help appreciated.
thanks,
Paul 


5.How to build SQL CE Database on desktop?

Hi, All,

How to build SQL CE Database on desktop?
e.g.
if I need build 10 different SQL CE databases
on desktop, is there any way to do it in batch?

Any ideas are welcome.

Thanks in advance.

-Hank


6. Reading a SQL Ce Database from a desktop machine

7. Database Migration From SQL Server8.0 to Sql server ce 2.1

8. Data Transfer from PDA to SQL without SQL CE



Return to dotnet framework

 

Who is online

Users browsing this forum: No registered users and 17 guest