为什么数据没有保存在sql数据库中 [英] why data not saved in sql database

问题描述

为什么当我将数据插入sql server ce数据库记录时未保存
我尝试此代码

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

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

推荐答案

查询中的问号可以是@picture.然后

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

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

删除您的try catch并获得手头的错误，如果尚未解决，请告诉我们.

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

您好，我仍然在等待您的答复
任何机构都可以帮助我....??

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

您的插入查询错误，因为您没有正确传递参数.请查看此链接，参数化查询示例 [ ^ ]

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

这篇关于为什么数据没有保存在sql数据库中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！