各位老师，我在遇到一个紧急的问题，请给我解决一下，谢谢

[studyaspnet]

.vb如下：
Imports System
Imports System.Data
Imports System.Data.OleDb
Imports System.Web.UI
Imports System.Web.UI.WebControls

Public Class mycodebehind:Inherits Page

public username as textbox
public userzy as DropDownList
public bmf as textbox
public ds_bmf as textbox
public xf as textbox
public ds_xf as textbox
public jcf as textbox
public ds_jcf as textbox
public bkf as textbox
public ds_bkf as textbox
public jsr as textbox
public bz as textbox
public lrdate as textbox







public Sub znsf_click(sender As System.Object,e As EventArgs)
Dim username1 As String = username.Text
Dim userzy1 As String = userzy.DataValueField
Dim bmf1 As String = bmf.Text
Dim ds_bmf1 As String = ds_bmf.Text
Dim xf1 As String = xf.Text
Dim ds_xf1 As String = ds_xf.Text
Dim jcf1 As String = jcf.Text
Dim ds_jcf1 As String = ds_jcf.Text
Dim bkf1 As String = bkf.Text
Dim ds_bkf1 As String = ds_bkf.Text
Dim jsr1 As String = jsr.Text
Dim bz1 As String = bz.Text
Dim lrdate1 As String = lrdate.Text





Dim strConnection As String = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=E:\cqaopeng\db\db.mdb"
'Dim strSQL As String = "insert into 'zn'('username','userzy','bmf','ds_bmf','xf','ds_xf','jcf','ds_jcf','bkf','ds_bkf','jsr','bz','lrdate')"+"values('" + username1 + "','" + userzy1 + "','" + bmf1 + "','" + ds_bmf1 + "','" + xf1 + "','" + ds_xf1 + "','" + jcf1 + "','" + ds_jcf1 + "','" + bkf1 + "','" + ds_bkf1 + "','" + jsr1 + "','" + bz1 + "','" + lrdate1 + "')"

Dim strSQL as string="insert into 'password'('username','password')"+"values('dfd','fdf')"

Dim objConnection As New OleDbConnection(strConnection)
Dim objCmd As New OleDbCommand(strSQL, objConnection)

objConnection.Open()

objCmd.ExecuteReader()






End Sub
End Class
显示的错误：
“/”应用程序中的服务器错误。
--------------------------------------------------------------------------------

查询语法错误。查询子句不完整。
说明: 执行当前 Web 请求期间，出现未处理的异常。请检查堆栈跟踪信息，以了解有关该错误以及代码中导致错误的出处的详细信息。

异常详细信息: System.Data.OleDb.OleDbException: 查询语法错误。查询子句不完整。

源错误:

执行当前 Web 请求期间生成了未处理的异常。可以使用下面的异常堆栈跟踪信息确定有关异常原因和发生位置的信息。

堆栈跟踪:


[OleDbException (0x80040e14): 查询语法错误。查询子句不完整。]
System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(Int32 hr) +41
System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) +174
System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) +92
System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) +65
System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) +112
System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior) +69
System.Data.OleDb.OleDbCommand.ExecuteReader() +7
mycodebehind.znsf_click(Object sender, EventArgs e) +263
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +57
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain() +1277




--------------------------------------------------------------------------------
版本信息: Microsoft .NET Framework 版本:1.1.4322.573; ASP.NET 版本:1.1.4322.573

[maobc]

response.wirte所有的sql语句看看

[wggwan]

你先向楼上说的那样，把SQL语句放在查询分析器中看看，有没有出错。这样容易知道错误。

[jevain]

看看SQL语句吧,八成是它的问题.

[vzxq]

objCmd.ExecuteReader()
这里有问题啊。同意笨笨兄的。
改为objCmd.ExecuteNonQuery();

[vzxq]

还有不要这样写程序，最好把这些东西写成存储过程。