Insert Query is not working in SQL

Question

0.00/5 (No votes)

See more:

.NET2.0

Hi all,

I am trying to insert data onto .sdf database. But the data is not showing in database file.

here is the code i am using

string cmdtext = ("Data Source=" + (System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase)) + "\\MaximoLocalDB.sdf;Password=<>;Persist Security Info=False;");

            SqlCeConnection con = new SqlCeConnection(cmdtext);
            SqlCeCommand cmd = new SqlCeCommand("insert into cftmob(cft,dsc,transid,transseq) values('"+textBox1.Text+"','"+textBox2.Text+"',106,1)",con);
            con.Open();
            cmd.ExecuteNonQuery();
            con.Close();

Any one know about this issue? help me.

Thanks,
Balu

Posted 14-Dec-11 19:31pm

Balu199

Updated 14-Dec-11 22:03pm

v3

Add a Solution

4 solutions

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)

Suresh Suthar · Answer 1 · 2011-12-14T19:53:00

Solution 1

Where is INTO in Insert Command.

Posted 14-Dec-11 19:53pm

Suresh Suthar

Updated 14-Dec-11 21:08pm

v2

Comments

Balu199 15-Dec-11 4:05am

It's an posting mistake.Into is not the right answer.

It's Compact database error.

Suresh Suthar 15-Dec-11 4:30am

What error its showing?

koolprasad2003 · Answer 2 · 2011-12-14T21:10:00

Solution 2

There is syntatical mistake in SQlQuery. you have not put INTO in it. here is corrected Query.

C#

insert into cftmob(cft,dsc,transid,transseq) values('"+textBox1.Text+"','"+textBox2.Text+"',106,1);

Posted 14-Dec-11 21:10pm

koolprasad2003

Updated 14-Dec-11 21:11pm

v2

Sarvesh Kumar Gupta · Answer 3 · 2011-12-15T00:46:00

Solution 3

Please notice that there is used into in query.

Posted 15-Dec-11 0:46am

Sarvesh Kumar Gupta

RempoRaaj · Answer 4 · 2011-12-15T00:55:00

Solution 4

may be you have an error in the cmdstring check it out..

Posted 15-Dec-11 0:55am

RempoRaaj

Updated 15-Dec-11 0:57am

v2