用的是access
dim mycon As New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("database\suznet.mdb"))
Dim intcounter As Integer = "0"
Dim strgongsidongtai As String = "insert into zxdt(title,authors,froms,text,addtime,grade)values(@title,@authors,@from,@text,@addtime,@grade)"
Dim mycmd As OleDb.OleDbCommand
mycon.open
mycmd = New OleDb.OleDbCommand(strgongsidongtai, mycon)
mycmd.Parameters.Add("@title", TextBox1.Text)
mycmd.Parameters.Add("@authors", Session("username"))
mycmd.Parameters.Add("@from", DropDownList1.SelectedItem.Value)
mycmd.Parameters.Add("@text", TextBox2.Text)
mycmd.Parameters.Add("@addtime", Now)
mycmd.Parameters.Add("@grade", intcounter)
mycmd.ExecuteNonQuery()
mycon.Close()
dim mycon As New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("database\suznet.mdb"))
Dim intcounter As Integer = "0"
Dim strgongsidongtai As String = "insert into zxdt(title,authors,froms,text,addtime,grade)values(@title,@authors,@from,@text,@addtime,@grade)"
Dim mycmd As OleDb.OleDbCommand
mycon.open
mycmd = New OleDb.OleDbCommand(strgongsidongtai, mycon)
mycmd.Parameters.Add("@title", TextBox1.Text)
mycmd.Parameters.Add("@authors", Session("username"))
mycmd.Parameters.Add("@from", DropDownList1.SelectedItem.Value)
mycmd.Parameters.Add("@text", TextBox2.Text)
mycmd.Parameters.Add("@addtime", Now)
mycmd.Parameters.Add("@grade", intcounter)
mycmd.ExecuteNonQuery()
mycon.Close()
解决方案 »
- 网页居中问题(我用绝对位置布局)
- update中的参数想用gridview中的下拉框的值。怎么实现?
- 师哥.师姐们......
- 怎么把服务器端写好的EXCEL模板文件下载到客户端打开?
- 在修改模式下修改数据后不会更新,非得刷新才可以
- 救命:关于页面刷新问题???
- 请问有谁知道如何把ASPX中的变量传给它包含的一个ASCX中??
- 关于链接问题 急急
- 如何设计在不同计算机上打印效果一致的水晶报表(编辑:海波.NET,更新:2003-10-22)
- 这是什么问题!读取SqlDataReader的问题!
- 继续弹出页面的问题!怎么才能实现点击datagrid中的一项,弹出没有地址栏,工具栏的页面??
- webform中能否提取出word中的图片并以其他格式(例如.gif)存放到数据库中
Dim strgongsidongtai As String = "insert into zxdt(title,authors,froms,[text],addtime,grade)values(@title,@authors,@from,@text,@addtime,@grade)"
SQL @
ACE ?
System.Data.OleDb.OleDbException: 操作必须使用一个可更新的查询。 at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(Int32 hr) at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) at System.Data.OleDb.OleDbCommand.ExecuteNonQuery() at suznet2.userfbwz.Button1_Click(Object sender, EventArgs e) in c:\inetpub\wwwroot\suznet2\userfbwz.aspx.vb:line 56 at System.Web.UI.WebControls.Button.OnClick(EventArgs e) at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) at System.Web.UI.Page.ProcessRequestMain()这是啥回事,从来没遇到过。