我要疯了,大伙帮我看看问题到底出在哪里?
一个vb.net的插入语句,每次都是出现:INSERT INTO 语句的语法错误。我实在找不出问题出在什么地方,请各位ggjjddmm们帮帮我吧!我真的被它搞得头大了,要疯了!!
'定义函数
Sub ExecuteSQL(Sql As String)
Dim myCmd As OleDbCommand
myCmd = New OleDbCommand(Sql,myConn)
myConn.Open()
myCmd.ExecuteNonQuery()
myConn.Close()
End sub
'
Sub Page_Load(sender As Object, e As EventArgs)
Dim strConn As String
strConn = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source="&server.mappath("/qkglxt/data/data.mdb")
myConn = New OledbConnection(strConn)
if not page.ispostback then
Sql = "SELECT HTLBID, HTLB FROM tblgjlb ORDER BY HTLBID"
dlHTLB.DataTextField="HTLB"
dlHTLB.DataValueField="HTLBID"
dlHTLB.DataSource = GetDataView(Sql,"HTLB")
dlHTLB.DataBind()
Sql = "SELECT z_id, zhichen FROM tblzhichen ORDER BY zhichen"
EZHIWU.DataTextField="z_id"
EZHIWU.DataValueField="zhichen"
EZHIWU.DataSource = GetDataView(Sql,"z_id")
EZHIWU.DataBind()
end if
End Sub
'确定
sub check_user(sender as object,e as eventargs)
Dim okSql as String
oksql = "INSERT INTO expert(e_name,e_pass,e_realm,e_zhiwu,e_tal,e_email,e_unit,e-add,contents,e_remarks) VALUES( "
oksql = oksql & ENAME.text & "','"
oksql = oksql & EPASS.text & "','"
oksql = oksql & dlHTLB.SelectedItem.Value & "','"
oksql= oksql & EZHIWU.SelectedItem.Value & "','"
oksql = oksql & ETALL.text & "','"
oksql = oksql & EEMAIL.text & "','"
oksql = oksql & EUNIT.text & "','"
oksql = oksql & EADD.text & "','"
oksql = oksql & CONTENTS.text & "','"
okSql = okSql & " ')"
ExecuteSQL(okSql)
me.Response.Redirect("main.aspx")
end sub