ACCESS的数据操作问题!!!急等谢谢帮忙
ACCESS数据库已经连接成功
//我自己定义的函数,用来判断入库的东西在物品总表里是否已经存在
Function DataCheck(ByVal inputId As String, ByVal inputName As String, ByVal inputClass As String, ByVal inputSize As String) As Boolean
Dim aCon As New OleDbConnection("provider=microsoft.jet.oledb.4.0;data source=" & Application.StartupPath & "\ku.mdb")
Dim aCom As New OleDbCommand
aCom.CommandText = "Select count(*) From ku Where id='" & inputId & "' AND name = '" & inputName & "' AND class = '" & inputClass & "' AND size = '" & inputSize & "'"
aCom.Connection = aCon
aCom.ExecuteScalar()
'如果返回0表示此物品bu存在
If aCom.ExecuteScalar = 0 Then
Return True
Else
Return False
End If
End Function
//不存在就往总表插入,存在就更新数目和总价
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
If aCon.State = ConnectionState.Closed Then aCon.Open()
'定?一个字符串?量
Dim rukuSQL As String
Dim rukudate1 As String
Dim kuInsertSQL As String
Dim kuUpdateSQL As String
Dim sl As Integer
Dim zj As Double
zj = CDbl(TextBox7.Text)
sl = CInt(TextBox5.Text)
rukudate1 = TextBox8.Text
rukudate1 &= "/"
rukudate1 &= ComboBox1.Text
rukudate1 &= "/"
rukudate1 &= ComboBox2.Text
'?于字符型字段要加?引号
rukuSQL = "Insert Into ruku([id],[name],[class],[size],[num],[price],[amount],[rukudate]) values ('" & TextBox1.Text & "','" & TextBox2.Text & "','" & TextBox3.Text & "','" & TextBox4.Text & "','" & TextBox5.Text & "','" & TextBox6.Text & "','" & TextBox7.Text & "','" & rukudate1 & "')"
kuInsertSQL = "Insert Into ku([id],[name],[class],[size],[num],[price],[amount],[rukudate]) values ('" & TextBox1.Text & "','" & TextBox2.Text & "','" & TextBox3.Text & "','" & TextBox4.Text & "','" & TextBox5.Text & "','" & TextBox6.Text & "','" & TextBox7.Text & "','" & rukudate1 & "')"
kuUpdateSQL = "Update ku set num = num + sl,amount = amount + zj where ku.id = '" & TextBox1.Text & "' AND ku.name = '" & TextBox2.Text & "' AND ku.class = '" & TextBox3.Text & "' AND ku.size = '" & TextBox4.Text & "'"
If DataCheck(TextBox1.Text, TextBox2.Text, TextBox3.Text, TextBox4.Text) = True Then
aCom.CommandText = kuInsertSQL
aCom.Connection = aCon
aCom.ExecuteNonQuery()
Else
aCom.CommandText = kuUpdateSQL
aCom.Connection = aCon
aCom.ExecuteNonQuery()
End If
aCom.CommandText = rukuSQL
aCom.Connection = aCon
aCom.ExecuteNonQuery()
aCon.Close()
End Sub
程序运行以后aCom.ExecuteScalar()这句话报错,不知道是不是SQL语句的错误造成的,我觉的函数的传递没问题,希望大家帮我看下什么原因???????????谢谢
//我自己定义的函数,用来判断入库的东西在物品总表里是否已经存在
Function DataCheck(ByVal inputId As String, ByVal inputName As String, ByVal inputClass As String, ByVal inputSize As String) As Boolean
Dim aCon As New OleDbConnection("provider=microsoft.jet.oledb.4.0;data source=" & Application.StartupPath & "\ku.mdb")
Dim aCom As New OleDbCommand
aCom.CommandText = "Select count(*) From ku Where id='" & inputId & "' AND name = '" & inputName & "' AND class = '" & inputClass & "' AND size = '" & inputSize & "'"
aCom.Connection = aCon
aCom.ExecuteScalar()
'如果返回0表示此物品bu存在
If aCom.ExecuteScalar = 0 Then
Return True
Else
Return False
End If
End Function
//不存在就往总表插入,存在就更新数目和总价
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
If aCon.State = ConnectionState.Closed Then aCon.Open()
'定?一个字符串?量
Dim rukuSQL As String
Dim rukudate1 As String
Dim kuInsertSQL As String
Dim kuUpdateSQL As String
Dim sl As Integer
Dim zj As Double
zj = CDbl(TextBox7.Text)
sl = CInt(TextBox5.Text)
rukudate1 = TextBox8.Text
rukudate1 &= "/"
rukudate1 &= ComboBox1.Text
rukudate1 &= "/"
rukudate1 &= ComboBox2.Text
'?于字符型字段要加?引号
rukuSQL = "Insert Into ruku([id],[name],[class],[size],[num],[price],[amount],[rukudate]) values ('" & TextBox1.Text & "','" & TextBox2.Text & "','" & TextBox3.Text & "','" & TextBox4.Text & "','" & TextBox5.Text & "','" & TextBox6.Text & "','" & TextBox7.Text & "','" & rukudate1 & "')"
kuInsertSQL = "Insert Into ku([id],[name],[class],[size],[num],[price],[amount],[rukudate]) values ('" & TextBox1.Text & "','" & TextBox2.Text & "','" & TextBox3.Text & "','" & TextBox4.Text & "','" & TextBox5.Text & "','" & TextBox6.Text & "','" & TextBox7.Text & "','" & rukudate1 & "')"
kuUpdateSQL = "Update ku set num = num + sl,amount = amount + zj where ku.id = '" & TextBox1.Text & "' AND ku.name = '" & TextBox2.Text & "' AND ku.class = '" & TextBox3.Text & "' AND ku.size = '" & TextBox4.Text & "'"
If DataCheck(TextBox1.Text, TextBox2.Text, TextBox3.Text, TextBox4.Text) = True Then
aCom.CommandText = kuInsertSQL
aCom.Connection = aCon
aCom.ExecuteNonQuery()
Else
aCom.CommandText = kuUpdateSQL
aCom.Connection = aCon
aCom.ExecuteNonQuery()
End If
aCom.CommandText = rukuSQL
aCom.Connection = aCon
aCom.ExecuteNonQuery()
aCon.Close()
End Sub
程序运行以后aCom.ExecuteScalar()这句话报错,不知道是不是SQL语句的错误造成的,我觉的函数的传递没问题,希望大家帮我看下什么原因???????????谢谢
...全文
相关推荐
access数据操作
增加、删除、修改数据,vc代码编制。没有打印及打印预览功能。请有兴趣及高手完善。
SQL数据操作类和ACCESS数据操作类
SQL数据操作类和ACCESS数据操作类,请勿下载,如要下载,请向本人索要密码!!
asp.net(C#) Access 数据操作类
代码如下:using System; using System.Configuration; using System.Data; using System.Data.OleDb; using System.Xml; using System.Collections; namespace Website.Command { /// /// WSplus 的摘要说明。 /// public class AccessClass : System.Web.UI.Page { private static OleDbConnection sconn = nul
两个简单的数据操作实例C#+Access
内容索引:C#源码,数据库应用,数据库,DataGrid 两个简单的数据操作实例C#+Access,一个是与查询操作有关,另一个是与DataGrid有关,这些都是入门级选手喜欢查阅的程序,一步一步来,你也会成为C#编程高手。注:本程序的数据库路径有问题,请修改为相对路径就能加载数据库了。
C#+aCCESS数据操作
网上找的C#+aCCESS数据操作.有增加删除修改查找


