nourooz
شنبه 21 دی 1392, 15:23 عصر
سلام چرا در کد زیر فقط میتوان عدد ثبت کرد و هنگام ثبت تکست خطا میده؟
Private Sub PictureBox6_Click(sender As Object, e As EventArgs) Handles PictureBox6.Click
Dim Con As New SQLiteConnection("data source=F:\db.db")
Dim cmd As New SQLiteCommand
Dim arr As New ArrayList()
arr.Add(TextBox1.Text)
cmd.CommandText = "insert into info(nam_kh)Values(@Field1)"
cmd.Parameters.Clear()
cmd.Parameters.Add("@Field1", SqlDbType.NVarChar).Value = arr(0).ToString()
cmd.Connection = Con
Con.Open()
cmd.ExecuteNonQuery()
Con.Close()
End Sub
Private Sub PictureBox6_Click(sender As Object, e As EventArgs) Handles PictureBox6.Click
Dim Con As New SQLiteConnection("data source=F:\db.db")
Dim cmd As New SQLiteCommand
Dim arr As New ArrayList()
arr.Add(TextBox1.Text)
cmd.CommandText = "insert into info(nam_kh)Values(@Field1)"
cmd.Parameters.Clear()
cmd.Parameters.Add("@Field1", SqlDbType.NVarChar).Value = arr(0).ToString()
cmd.Connection = Con
Con.Open()
cmd.ExecuteNonQuery()
Con.Close()
End Sub