why data not saved in sql database

Question

0.00/5 (No votes)

See more:

why when i insert data into sql server ce database record not saved
i try this code

VB

Dim ds As New AppDatabase1DataSet
        Dim da As New SqlCeDataAdapter(cmd.CommandText, cn)
        da.Fill(ds, "h_DB")
        If Me.BindingContext(ds, "h_DB").Count = 0 Then
            MessageBox.Show("not empty قاعدة البيانات")
        End If

        If 1 Then
            Try


                cmd.CommandText = "insert into sign_normal_DB (word_A,picture,type,type_name) values ('" & TextBox1.Text & " ' ,? , ' " & TextBox3.Text & " ', ' " & TextBox2.Text & " ' )"
                Dim param As SqlCeParameter = cmd.Parameters.Add("picture", SqlDbType.Image)
                param.Value = imageData
                cmd.ExecuteNonQuery()
                MessageBox.Show("تمت الإضافة بنجاح")
            Catch sqex As SqlCeException
                MessageBox.Show(sqex.ToString(), "فشلت العملية على قاعدة البيانات")
            End Try
            fs.Close()

            'cmd.CommandText = "commit"
            ' cmd.ExecuteNonQuery()
            cn.Close()
            'clear window
            TextBox1.Text = ""
            TextBox2.Text = ""
            TextBox3.Text = ""
            PictureBox1.Image = Nothing

        Else

            MessageBox.Show("الكلمة موجودة بإمكانك تعديلها من قسم تعديل قاعدة البيانات ")
        End If

Posted 16-Apr-11 9:29am

hind_F

Updated 16-Apr-11 15:44pm

Albin Abel

v2

Add a Solution

Comments

Fabio V Silva 16-Apr-11 17:27pm

Do you get any error at all?

Albin Abel 18-Apr-11 6:58am

Hi debug and see is the flow travels in the right path. By the way what you are having in imageData.

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)

Albin Abel · Answer 1 · 2011-04-16T15:57:00

Solution 1

The question mark at your query can be @picture. Then

VB

Dim param As SqlCeParameter = new SqlCeParameter("@picture", SqlDbType.Image)
param.Value = imageData
cmd.Parameters.Add(param);
cmd.ExecuteNonQuery()

Remove your try catch and get get error on hand, let us know your error if not solved.

Posted 16-Apr-11 15:57pm

Albin Abel

Comments

Prerak Patel 18-Apr-11 4:48am

OP:i try this but i dont have any exception
and still dont save data

hind_F · Answer 2 · 2011-04-18T11:16:00

Solution 3

hi i still waiting your answer
any body can help me pleas....??

Posted 18-Apr-11 11:16am

hind_F

Simon_Whale · Answer 3 · 2011-04-18T11:50:00

Solution 4

your insert query is wrong your not passing the parameters correctly. Have a look at this link, Parameterised queries examples[^]

Posted 18-Apr-11 11:50am

Simon_Whale

hind_F · Answer 4 · 2011-04-19T06:15:00

i edit my query like this
cmd.CommandText = "insert into sign_normal_DB (word_A,picture,type,type_name) values ('" & TextBox1.Text & " ' ,@ItmPic , ' " & TextBox3.Text & " ', ' " & TextBox2.Text & " ' )"
Dim param As SqlParameter = cmd.Parameters.Add("@ItmPic", SqlDbType.Image)
param.Value = imageData
cmd.ExecuteNonQuery()
'dr = cmd.ExecuteReader
MessageBox.Show("data inserted successfully")
Catch sqex As SqlCeException
MessageBox.Show(sqex.ToString(), "فشلت العملية على قاعدة البيانات")
End Try

i see message data inserted successfully
but when i close emulator and see the table , the table dont include new data (why???)

is there any instruction can i do ? please