|
Hi.
I'm changing an existing C#/Compact framework 2.0 from using DataSets as the data storage (backed up by XML) to SQL Mobile 2005 (as an offline DB only). I'm doing this because after changing each position of the DataSet we were writing the XML to file system (just in case of a crash, low power, etc). That became very slow under Windows Mobile 5 (RAM -> ROM change).
So I've just finished rewriting the application so that it used SQL Mobile 2005. When only one entry in the DB changes its a lot faster. Great.
But when I delete all data from the DB or I want to insert all records into the DB it takes 1-2 minutes (about 200 entries). This just seems to be way too slow. That means that it can only write about 3 entries per second....that seems really slow.
The read performance is very good.
I'm using Microsoft SQL Server Mobile Edition 3.0.5206.0 from Visual Studio 2005. The performance is bad when running it inside the debugger and using the same code started directly on the PDA (without the VS 2005 debugger running).
I'm not sure how to export my tables as SQL code to code project. Any ideas? or what info can I share which could help anyone (who can help me )
Okay, so I ran a test with a Symbol MC70 (Intel XScale 624 Mhz processor). For 158 entries it took over 2 minutes to delete the DB (I delete each DataRow individually - is this why the delete takes so long?). The inserts took quite a while too, about 30 seconds).
Why are these values so long?
The DB Table has a primary key (4 columns) & the DB Table has a total of 40 columns.
Thanks
Martin
modified on Thursday, March 13, 2008 10:48 AM
|
|
|
|
|
The dirty secret of SQL Server CE performance is that it's best not to use SQL. For simple queries that only affect one table - and INSERT, UPDATE and DELETE only can affect one table - it's better to use a SqlCeResultSet and iterate through it manually.
See for example this article[^] on insert performance.
DoEvents: Generating unexpected recursion since 1991
|
|
|
|
|
Hi Mike.
Thanks for your answer.
I ran into this same article today by chance....and enjoyed what I read. It seems quite annoying that the SQL Server CE team haven't implemented UpdateBatchSize as SQL Anywhere from Sybase has. Still I'll have to live with it....
I guess I'll have a bit of a rewrite to do, so that this works. Still a 10x performance increase would be really great.
Thanks
Martin
|
|
|
|
|
heloo
can anyone plz help me out in writing a code in c# to create a databse in mobile application
iama a beginner
thx. in advance
bascially i got this but i getsa error in
"da.Fill(dt)"
stating that
the database table craeted in c:/ inside my project is not valid
i even started the ms avtive sync and emulator
plz help me out
public static string connectionString = "";
public static SqlCeConnection cn = null;
public static SqlCeDataAdapter da = null;
public static DataTable dt = new DataTable();
connectionString = "Data Source=c:\\My Documents\\Database.sdf" ;
cn = new SqlCeConnection(connectionString);
da = new SqlCeDataAdapter("SELECT * FROM Users", cn);
da.Fill(dt);
foreach (DataRow dr in dt.Rows)
{
listbox1.items.add(dr[0]); }
|
|
|
|
|
Try,
da.Fill(dt,"Users");
Just a thought.
Martin
|
|
|
|
|
Im developing an app on WIN CE using C#. i would love to use Pocket outlook, excel and word for the output reports but have no clue about how to do that in c#.
Does anyone know where i can find good example code?
Thanks
Woody
occasionally brillant most times just lost.
|
|
|
|
|
Hello Woody,
You can do this via the System.Diagnostics.Process class if you are using .NET CF 2.0. You can do this as follows:
using System.Diagnostics;
Process myProcess = new Process();
myProcess.StartInfo.FileName = @"\\My Documents\\Business\\Book1.XLS";
myProcess.StartInfo.Verb = "Open";
myProcess.Start()
This will launch the application associated with *.xls files ie Pocket Excel and open the specified file, alternatively you could also explicitly launch Pocket Excel by using similar code and requesting to launch the \Windows\pxl.exe executable.
Regards,
Dave
Dave Traister
Software Engineer
ComponentOne LLC
www.ComponentOne.com
|
|
|
|
|
|
hi
how can i change time & date in PPC using C# 2005 ?
thank for any help
|
|
|
|
|
I've only been able to manage that by using calls to the windows APIs which only work on some PDAs (on my development Dell X51V it works, on some Symbols it doesn't. I'm not sure why - no exception or anything, just the time doesn't change)
Hope that helps, but maybe someone knows a C# way of doing that.
Martin
[DllImport("coredll.dll")]
public extern static void GetSystemTime(ref SYSTEMTIME lpSystemTime);
[DllImport("coredll.dll")]
public extern static uint SetSystemTime(ref SYSTEMTIME lpSystemTime);
public struct SYSTEMTIME
{
public ushort wYear;
public ushort wMonth;
public ushort wDayOfWeek;
public ushort wDay;
public ushort wHour;
public ushort wMinute;
public ushort wSecond;
public ushort wMilliseconds;
}
public static void setSystemDate(DateTime newTime)
{
// Set the clock to this time
SYSTEMTIME st = new SYSTEMTIME();
st.wMilliseconds = (ushort)newTime.ToUniversalTime().Millisecond;
st.wSecond = (ushort)newTime.ToUniversalTime().Second;
st.wMinute = (ushort)newTime.ToUniversalTime().Minute;
st.wHour = (ushort)newTime.ToUniversalTime().Hour;
st.wDay = (ushort)newTime.ToUniversalTime().Day;
st.wMonth = (ushort)newTime.ToUniversalTime().Month;
st.wYear = (ushort)newTime.ToUniversalTime().Year;
//GetSystemTime(ref st);
//st.wHour = (ushort)(st.wHour + 1 % 24);
SetSystemTime(ref st);
}
|
|
|
|
|
helloo
can anyone plz. help me out in writng a code in c# to connect to database in mobile compact framework
basically iam a begginer in this field
thanks in advance
|
|
|
|
|
Try google?
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
|
Hi All,
I am trying to use the key combination to perform a specific task, at present I have developed a windows mobile/smartphone application, when I press key 5 it gives me some stored information into the textboxes.
I want to use the key combination # and 5 or create a short cut keys to get the information into the textboxes.
please, suggest me the way to do it.
Thanks in advance
modified on Tuesday, March 11, 2008 1:07 AM
|
|
|
|
|
I'm looking for someone or good resources to write my own application for the treo 600 and I need help getting started. I'm a C# programmer and have no experience with mobile devices.
Any advice will be helpful.
I'm listening but I only speak GEEK.
|
|
|
|
|
Hello,
I am creating a SIP client on my PDA, so the interface looks like a soft phone. However, I have just used the tools out of the tool box.
When I look at the other interfaces on other soft phones you can download, they have very nice skins (sjPhone, kapanga).
I am wondering is it possible to add controls that look like some of the SIP phones that you can download. These phones look like real phone.
Many thanks for any advice,
Steve
|
|
|
|
|
I am new to Mobile development. Now that that disclaimer is out of the way. I have a project that consists of a bar code device with windows CE on it. The client want a inventor software.
i am trying to write a program using .net compact framework VB.net. I am trying to write a program (for the device) that will connect to a sql database on the desktop. I have created a connection and dataset using the data source wizard. I am able to test it buy right clicking on data Adapter and view data and it successfully runs the fill query to get data.
But, when I try to fill the dataset in my code I get this message.
Specified SQL Server not found: LIT3\SQLEXPRESS
Does anyone know what I am doing wrong? Our goal is to send data back to desktop over RF realtime. Does anyone have any ideas?
|
|
|
|
|
Hi All,
I want to develop an application for the smartphone. When you run that application it should capture/gather own mobile number and then it should transfer the number to a textbox.
Has anyone got any suggestions and ideas. How can we do it using C#.NET and Windows Mobile 6 Professional?
Regards
Parasmani
|
|
|
|
|
|
Hi Himanshu,
Getting the owner information is not a problem, we can get it, if the user has entered the information in the "owner information".
How can we access the phone number from the smartphone if the user hasn't entered the information?
Thanks & Regards
|
|
|
|
|
i also getting same problem can anyone help me.
|
|
|
|
|
Hi All,
I want to develop an application for the smartphone. When you run that application it should show the details about the phone, whether the phone is GPS/GPRS enabled or not and if enabled then it should transfer the details to the textboxes.
Has anyone got any suggestions and ideas. How can we do it using C#.NET and Windows Mobile 6 Professional?
Regards
Parasmani
modified on Tuesday, March 4, 2008 6:26 AM
|
|
|
|
|
Answer is here[^]
Please post only one message for similar problems
Life was much simpler in 2002
|
|
|
|
|
Hi Hamanshu,
Thanks for your help.
I want to create an application in such a way that, it should ask me before sending the SMS, whether I want to send it through GPRS or through service provider(using simcard) and if I say through GPRS then it should send it through GPRS.
please suggest me how we can do it.
Thanks and Regards
|
|
|
|
|
Hi..
Is there any way that I can detect an available wireless connection and connect to it with c# .NET CF?
And are there any way I can tell my device to connect to an availble network, if the network code is typed in windows without the users notice?
My problem is that I want my device to reconnect automatically when an available connection is detected. If my device has been shut down for a couple of hours or have been without connection, I have to manually reconnect to the internet, which is not possible with my program, because it cannot be closed for security reasons..
Greetings from Haolan
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
