web.config里的:
<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<appSettings>
<add key="LawConnStr" value="server=localhost; database=jx; uid=sa; pwd=123456;">
</add>
</appSettings>
<system.web>页面代码:
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim conn As System.Data.SqlClient.SqlConnection = New System.Data.SqlClient.SqlConnection(ConfigurationSettings.AppSettings("LawConnStr")) Dim sqlstr As String
sqlstr = "insert into baojiadg(name,pho,addr,post,num,pei) values ('" & TextBox1.Text & "','" & TextBox2.Text & "','" & TextBox3.Text & "','" & TextBox4.Text & "','" & TextBox5.Text & "','" & TextBox6.Text & "')"
Cmd.CommandText = sqlstr
conn.Open()
Cmd.ExecuteNonQuery()
conn.Close()运行出现错误:
ExecuteNonQuery 需要打开的并且可用的连接。该连接的当前状态是 Closed。
说明: 执行当前 Web 请求期间,出现未处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中导致错误的出处的详细信息。 异常详细信息: System.InvalidOperationException: ExecuteNonQuery 需要打开的并且可用的连接。该连接的当前状态是 Closed。源错误: 行 90: Dim conn As System.Data.SqlClient.SqlConnection = New System.Data.SqlClient.SqlConnection(ConfigurationSettings.AppSettings("LawConnStr"))
行 91: conn.Open()
行 92: Cmd.ExecuteNonQuery()
行 93: conn.Close()
行 94: ' Response.Write("<script lang='javascript'>window.showModalDialog('index.aspx',window,'dialogHeight:720px;dialogWidth:1010px;center:Yes;Help:No;Hotkeys:Yes;Resizable:No;Scroll:auto;Status:no;');</script>")
源文件: D:\jxweb\baojia\zaixiandg.aspx.vb 行: 92 堆栈跟踪: [InvalidOperationException: ExecuteNonQuery 需要打开的并且可用的连接。该连接的当前状态是 Closed。]
System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean executing) +279
System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +90
baojia.zaixiandg.Button1_Click(Object sender, EventArgs e) in D:\jxweb\baojia\zaixiandg.aspx.vb:92
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
请问为什么会这样啊????
<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<appSettings>
<add key="LawConnStr" value="server=localhost; database=jx; uid=sa; pwd=123456;">
</add>
</appSettings>
<system.web>页面代码:
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim conn As System.Data.SqlClient.SqlConnection = New System.Data.SqlClient.SqlConnection(ConfigurationSettings.AppSettings("LawConnStr")) Dim sqlstr As String
sqlstr = "insert into baojiadg(name,pho,addr,post,num,pei) values ('" & TextBox1.Text & "','" & TextBox2.Text & "','" & TextBox3.Text & "','" & TextBox4.Text & "','" & TextBox5.Text & "','" & TextBox6.Text & "')"
Cmd.CommandText = sqlstr
conn.Open()
Cmd.ExecuteNonQuery()
conn.Close()运行出现错误:
ExecuteNonQuery 需要打开的并且可用的连接。该连接的当前状态是 Closed。
说明: 执行当前 Web 请求期间,出现未处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中导致错误的出处的详细信息。 异常详细信息: System.InvalidOperationException: ExecuteNonQuery 需要打开的并且可用的连接。该连接的当前状态是 Closed。源错误: 行 90: Dim conn As System.Data.SqlClient.SqlConnection = New System.Data.SqlClient.SqlConnection(ConfigurationSettings.AppSettings("LawConnStr"))
行 91: conn.Open()
行 92: Cmd.ExecuteNonQuery()
行 93: conn.Close()
行 94: ' Response.Write("<script lang='javascript'>window.showModalDialog('index.aspx',window,'dialogHeight:720px;dialogWidth:1010px;center:Yes;Help:No;Hotkeys:Yes;Resizable:No;Scroll:auto;Status:no;');</script>")
源文件: D:\jxweb\baojia\zaixiandg.aspx.vb 行: 92 堆栈跟踪: [InvalidOperationException: ExecuteNonQuery 需要打开的并且可用的连接。该连接的当前状态是 Closed。]
System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean executing) +279
System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +90
baojia.zaixiandg.Button1_Click(Object sender, EventArgs e) in D:\jxweb\baojia\zaixiandg.aspx.vb:92
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
请问为什么会这样啊????
解决方案 »
- 在asp.net中用<%=后台方法名()%>后台方法执行多次
- 项目。。聊天(点对点)。。。求个思路自己想不通
- 关于javascript的双击事件的使用
- asp.net简单的查询系统出错啊,数据库连接不上,希望各位帮忙啊!!!急
- 如何控制asp.net2.0的menu控件生成js脚本的位置?
- asp.net的问题。。大量散分求解啊~~
- 初学ASP.net的第十五个问题( 将添加写成一个共用的类灵活使用 ) 我的分数很少,还是想请教大虾门.
- 我的vs.net的工具箱被我搞坏了,怎么恢复????
- id 与 name 有何区别??
- 急呀!!!
- 急急急急急急急急急急急急急,怎样判断是哪个域名解析的?
- 如何在单独的*.cs文件中调用Session里的值?
try:
.....
Dim Cmd As New SqlCommand(sqlstr,conn)
conn.Open()
Cmd.ExecuteNonQuery()
conn.Close()