|
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
|
|
|
|
|
Hello,
I am modifing an existing Win32 smart device VS 2005 using WM5 SDK. I am coming from C# smart devices. So have very limited experience in win32 smart device development.
Does anyone know how to create a new window and set this as the start-up window.
Anyone one has any links to add forms and controls that would be a good start. In C# this was easy as its all drag and drop.
Many thanks for any suggestions,
Steve
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
