how Data insert into SQLce from Windows Mobile 5.0 Pocket PC using C#

Question

0.00/5 (No votes)

See more:

Hi ,
i am new in windows mobile application using C#.
in my application i can read data from database SQLce.
but can't insert........
my code are bellow:-

C#

try
   {
    using (SqlCeConnection con = new SqlCeConnection(DBConn.connString))
     {
      con.Open();
      string SQL = "INSERT INTO USERINFO(UserID,Password,Name,Cell,Email,Status) VALUES ('"+txtUserID.Text+"','"+txtPassword.Text+"','"+txtName.Text+"','"+txtCellNo.Text+"','"+txtEmail.Text+"',0)";
     SqlCeCommand com = new SqlCeCommand(SQL, con);
     com.ExecuteNonQuery();
     MessageBox.Show("User Registration Successfull!");
     }
    }
   catch {
     MessageBox.Show("Registration Failed!");
   }

the code is execute.....
but data not inserted...
Details:----------
VS 2008
3.5 .NET framework
SQL CE
Windows XP SP2
Windows Mobile Application 5.0 Pocket PC

please help me.....

Posted 18-Oct-10 20:28pm

Syed Imran hossen

Add a Solution

Comments

dmageiras 19-Oct-10 2:42am

What is the exception message?

Syed Imran hossen 20-Oct-10 0:21am

message show :- User Registration Successfull!
but data not show in the table....

OriginalGriff 20-Oct-10 3:29am

"cant find data into table...."
How are you checking the table for data? What is your connection string?

Syed Imran hossen 20-Oct-10 4:39am

Connection String are:---
public static string connString = "Data Source =" +(System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase) + "\\ASoft.sdf;");
Actually i want to know at the time of inserting data....its insert into My project database or Mobile emulator database........
if Mobile emulator database...then how can i find this...

OriginalGriff 20-Oct-10 5:46am

"if Mobile emulator database...then how can i find this..."
Which DB did you think the Mobile Emulator was going to update? The one it knows about, or the one that could be on the moon for all it knows? It's a Pocket PC! It doesn't expect to be net connected all the time...

Syed Imran hossen 20-Oct-10 5:58am

after registration i can login using registration user...
but after emulator off....or program stop, i cant login.....
actually.........i want to know data insert into project database or other location...

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2010-10-18T23:15:00

Couple of things:
How do you know it did not work? Do you get the "Registration Failed!" message box? Or does it not appear in your database?

Several changes are needed here:
1) Don't do it this way. You are wide open to an SQL Injection attack, even by mistake. Instead, use SqlCeCommand.AddWithValue:

C#

using (SqlCeConnection con = new SqlCeConnection(DBConn.connString))
  {
  con.Open();
  string SQL = "INSERT INTO USERINFO (UserID,Password,Name,Cell,Email,Status)" +
               " VALUES (@ID, @PW, @NM, @CN, @EM, 0)";
  SqlCeCommand com = new SqlCeCommand(SQL, con);
  com.AddWithValue("@ID", txtUserID.Text);
  com.AddWithValue("@PW", txtPassword.Text);
  com.AddWithValue("@NM", txtName.Text);
  com.AddWithValue("@CN", txtCellNo.Text);
  com.AddWithValue("@EM", txtEmail.Text);
  com.ExecuteNonQuery();
  MessageBox.Show("User Registration Successfull!");
  }

2) Change your exception so that it catches and reports the problem:

C#

catch (Exception ex)
   {
   MessageBox.Show("Registration Failed!\n" + ex.ToString());
   }

That way at least it tells you you have a problem and give you information on what the problem is! (It is considered bad practice to use empty catch blocks)

The second change may give you enough info to solve the problem: It may be that the UserID already exists, or a similar problem.