你的执行语句呢?
如果只是执行一条SQL语句,那就用SqlCommand,不必用SqlDataAdapter:
<script language="VB" runat="server">
Sub ValidateBtn_Click(sender As Object, e As EventArgs)
If (Page.IsValid) Then
Dim MyConnection As SQLConnection
Dim MyCommand As SqlCommand
MyConnection=New SQLConnection(ConfigurationSettings.AppSettings("ConnectionString"))
MyCommand=New SqlCommand("insert tbl_news(title,memo,subKind) values('"&request.form("txtTitle")&"','"&request.form("txtMemo")&"','1')",MyConnection)
MyCommand.ExecuteNonQuery()
response.write("<br><center>添加成功!!</center><br><a href='javascript:history.go(-1);</a>")
response.end
End If
End Sub
</script>
如果只是执行一条SQL语句,那就用SqlCommand,不必用SqlDataAdapter:
<script language="VB" runat="server">
Sub ValidateBtn_Click(sender As Object, e As EventArgs)
If (Page.IsValid) Then
Dim MyConnection As SQLConnection
Dim MyCommand As SqlCommand
MyConnection=New SQLConnection(ConfigurationSettings.AppSettings("ConnectionString"))
MyCommand=New SqlCommand("insert tbl_news(title,memo,subKind) values('"&request.form("txtTitle")&"','"&request.form("txtMemo")&"','1')",MyConnection)
MyCommand.ExecuteNonQuery()
response.write("<br><center>添加成功!!</center><br><a href='javascript:history.go(-1);</a>")
response.end
End If
End Sub
</script>
解决方案 »
- 用过PageStatePersister保存viewstate的进来看看
- c#的序列化
- 使用FileUpLoad控件.如果文件超过一定大小.是不是就会出错
- 用户注册时的问题
- 请教,怎样给动态生成的模板列绑定数据,谢谢!!!!!
- 弹出窗口的问题
- 到底错在什么地方啊?拜托大家帮帮忙,谢谢
- datalist的OnSelectedIndexChanged无效/
- 再次发贴!!!!!!!请高手指教!!!!!异常详细信息: CrystalDecisions.CrystalReports.Engine.LogOnException: 登录失败。
- 如何让控件失去焦点?
- 这一句到底错在哪里啊?快救命啊!
- 大家看看微软网站是不是被人黑了!!!!!
如果是server control 应该用txtMemo.Text而不是request()
直接用sqlcommand执行就可以了
如果你需要用到撤销操作,就必须用sqldataadapter
Compiler Error Message: BC30456: 'update' is not a member of 'System.Data.SqlClient.SqlCommand'.to jackyhx(飞不动的侠)
是提供给用户输入数据的
MyCommand.ExecuteNonQuery()
MyCommand.connection.open()
谢谢各位!!