ali.m.a
پنج شنبه 03 مهر 1393, 11:43 صبح
با سلام
اساتید محترم لطفا راهنمایی بفرمایید که مشکل کد زیر چیه که خطای فوق رو میده
پیشاپیش ممنونم
Private Sub BtnEdit_Click(sender As Object, e As EventArgs) Handles BtnEdit.Click
Dim OledbConnection As New OleDbConnection(Class_Variables.StrConnection)
Dim cmd As New OleDbCommand
Dim SqlStr As String
SqlStr = String.Concat("INSERT INTO Tbl_Storage (RegFactDate, SanadNo, FactorNo, Factorer, Kala, Model, Tedad, Date1, Prise, Mem) VALUES", _
"('", TxtRegFactDate.Text, "',", TxtSanadNo.Text, ",", TxtFacorNo.Text, ",'", TxtFactorer.Text, "','", TxtKala.Text, "','", TxtModel.Text, "',", TxtTedad.Text, ",'", TxtDateIn.Text, "',", TxtPrise.Text, ",'", TxtMemo.Text, "')")
MsgBox(SqlStr.ToString)
cmd.CommandType = CommandType.Text
cmd.CommandText = SqlStr
cmd.Connection = OledbConnection
If OledbConnection.State <> ConnectionState.Open Then
OledbConnection.Open()
End If
cmd.ExecuteNonQuery()
End Sub
اساتید محترم لطفا راهنمایی بفرمایید که مشکل کد زیر چیه که خطای فوق رو میده
پیشاپیش ممنونم
Private Sub BtnEdit_Click(sender As Object, e As EventArgs) Handles BtnEdit.Click
Dim OledbConnection As New OleDbConnection(Class_Variables.StrConnection)
Dim cmd As New OleDbCommand
Dim SqlStr As String
SqlStr = String.Concat("INSERT INTO Tbl_Storage (RegFactDate, SanadNo, FactorNo, Factorer, Kala, Model, Tedad, Date1, Prise, Mem) VALUES", _
"('", TxtRegFactDate.Text, "',", TxtSanadNo.Text, ",", TxtFacorNo.Text, ",'", TxtFactorer.Text, "','", TxtKala.Text, "','", TxtModel.Text, "',", TxtTedad.Text, ",'", TxtDateIn.Text, "',", TxtPrise.Text, ",'", TxtMemo.Text, "')")
MsgBox(SqlStr.ToString)
cmd.CommandType = CommandType.Text
cmd.CommandText = SqlStr
cmd.Connection = OledbConnection
If OledbConnection.State <> ConnectionState.Open Then
OledbConnection.Open()
End If
cmd.ExecuteNonQuery()
End Sub