UC知道VB程序设计中的数据库中问题
来源：百度知道 编辑：UC知道 时间：2024/05/11 15:31:35
我做了一个需要使用数据库的VB程序设计。但是数据库联接不上。那位高手，指导一下。
Imports System.Data
Public Class form1
Inherits System.Windows.Forms.Form
Dim xuehao As Long
Dim zongfen As Long
Dim shengao As Single
Dim taijie As Integer
Dim tizhong As Single
Dim woli As Single
Dim tiaoyuan As Single
Dim bimfen As Integer
Dim bim As Long
Dim dingwei As String
Dim xingbie As String
Dim fei As Long
.
.
.
.
.
Dim xiban As String
.
.
.
.
Dim oledbcmmycommand As New OleDb.OleDbCommand
oledbcmmycommand.CommandText = "insert into 十一1 (学号, 定位 ,性别 ,身高 ,体重 ,肺活量, 跳远 ,握力 ,台阶指数 ,总分 ,是否及格) values （'"&xuehao&"','"&dingwei&"','"&xingbie&"','"&shengao&"','"&t
Imports System.Data
Public Class form1
Inherits System.Windows.Forms.Form
Dim xuehao As Long
Dim zongfen As Long
Dim shengao As Single
Dim taijie As Integer
Dim tizhong As Single
Dim woli As Single
Dim tiaoyuan As Single
Dim bimfen As Integer
Dim bim As Long
Dim dingwei As String
Dim xingbie As String
Dim fei As Long
.
.
.
.
.
Dim xiban As String
.
.
.
.
Dim oledbcmmycommand As New OleDb.OleDbCommand
oledbcmmycommand.CommandText = "insert into 十一1 (学号, 定位 ,性别 ,身高 ,体重 ,肺活量, 跳远 ,握力 ,台阶指数 ,总分 ,是否及格) values （'"&xuehao&"','"&dingwei&"','"&xingbie&"','"&shengao&"','"&t
括号 要 半角的 & 前后要用空格分开 字段名之间最好不要有多余的空格
"insert into 十一1 (学号,定位,性别,身高,体重,肺活量,跳远,握力,台阶指数,总分,是否及格) values ('" & xuehao & "','" & dingwei & "','" & xingbie & "','" & shengao & "','" & tizhong & "','" & fei & "','" & tiaoyuan & "','" & woli & "','" & taijie & "','" & zongfei & "','" & flag & "')"
我建议你去用直接连接吧
建议楼主用下面的方法,可以剩去不少表点符号
insert into 十一1(学号,定位,性别,身高,体重,肺活量,跳远,握力,台阶指数,总分,是否及格) values(@xuehao,@,@,@,@,@,@,@,@,@,@)
sqlcom.Parameters.AddWithValue( "@xuehao",xuehao )
依此赋值
前面那个是参数，后面那个是参数的值