<script language="C#" type="text/C#" runat="server">
private void page_load(object sender, EventArgs e)
{
string Userid = Request.QueryString["userid"];
string filename = Request.QueryString["Filename"];
string ConnSql = System.Configuration.ConfigurationManager.AppSettings["SqlConnection"];
SqlConnection conn = new SqlConnection(ConnSql);
string sql = "select img2 from hls where userid='" + Userid + "'";
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
string newimg2 = "test_a.jpg";
sql = "update hls set img2='" + newimg2 + "' where userid='" + Userid + "'";
cmd = new SqlCommand(sql, conn);
cmd.ExecuteNonQuery();
}
dr.Close();
}
</script>异常详细信息: System.InvalidOperationException: 已有打开的与此命令相关联的 DataReader,必须首先将它关闭。源错误:
行 24: sql = "update hls set img2='" + newimg2 + "' where userid='" + Userid + "'";
行 25: cmd = new SqlCommand(sql, conn);
行 26: cmd.ExecuteNonQuery(); --------------------->出错行
行 27: }
行 28: }难道必须先把dr关闭了重新打开才可以继续操作数据库吗?
private void page_load(object sender, EventArgs e)
{
string Userid = Request.QueryString["userid"];
string filename = Request.QueryString["Filename"];
string ConnSql = System.Configuration.ConfigurationManager.AppSettings["SqlConnection"];
SqlConnection conn = new SqlConnection(ConnSql);
string sql = "select img2 from hls where userid='" + Userid + "'";
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
string newimg2 = "test_a.jpg";
sql = "update hls set img2='" + newimg2 + "' where userid='" + Userid + "'";
cmd = new SqlCommand(sql, conn);
cmd.ExecuteNonQuery();
}
dr.Close();
}
</script>异常详细信息: System.InvalidOperationException: 已有打开的与此命令相关联的 DataReader,必须首先将它关闭。源错误:
行 24: sql = "update hls set img2='" + newimg2 + "' where userid='" + Userid + "'";
行 25: cmd = new SqlCommand(sql, conn);
行 26: cmd.ExecuteNonQuery(); --------------------->出错行
行 27: }
行 28: }难道必须先把dr关闭了重新打开才可以继续操作数据库吗?
解决方案 »
- ul与li放在div中,div加滚动条,用css控制键盘在li上的移动的颜色.但div的滚动条,不会跟着动,怎么控制div的滚动条?
- 如何列出FTP服务器上的某个目录的内容
- 运行错误
- 如何根据页面地址后面的参数来处理session
- 有网友说技术区无法平均给分,要求我把以前的自动给分器推出新版的。发帖看看新版技术区给分机制
- 求助!! ManagementScope
- 如果要学lucene.net的话应该首先具有哪些知识啊
- 抽象类与接口有什么区别呢?如何简单的理解呀?
- 异常:从客户端(FileContent="...ault" %> <!DOCTYPE HTML PUBLI...")中检测到有潜在危险的 Request.Form 值。
- 我给一个网站实现发邮件,发群组邮件有别的什么技术吗?
- 一个关于Web.config的问题,高手进
- 有关OleDbDataReader取值的问题 !!!
if (!this.IsPostBack){}
private void page_load(object sender, EventArgs e)
{
string Userid = Request.QueryString["userid"];
string filename = Request.QueryString["Filename"];
string ConnSql = System.Configuration.ConfigurationManager.AppSettings["SqlConnection"];
SqlConnection conn = new SqlConnection(ConnSql);
string sql = "select img2 from hls where userid='" + Userid + "'";
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
dr.Close();
string newimg2 = "test_a.jpg";
sql = "update hls set img2='" + newimg2 + "' where userid='" + Userid + "'";
cmd = new SqlCommand(sql, conn);
cmd.ExecuteNonQuery();
}
else
dr.Close();
}
这样试试
{
conn.Close();
……
conn.Open();
……
}
加上这句就可以了,原因是连接已经占用,没有关闭就再次使用
新定义个COMMAND
随便给大家看看我的新站,别骂我啊 http://www.seeis.cn
sql = "update hls set img2='" + newimg2 + "' where userid=" + Userid ;
id是int吧
{
string Userid = Request.QueryString["userid"];
string filename = Request.QueryString["Filename"];
string ConnSql = System.Configuration.ConfigurationManager.AppSettings["SqlConnection"];
SqlConnection conn = new SqlConnection(ConnSql);
string sql = "select img2 from hls where userid='" + Userid + "'";
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
dr.Close();
string newimg2 = "test_a.jpg";
sql = "update hls set img2='" + newimg2 + "' where userid='" + Userid + "'";
cmd = new SqlCommand(sql, conn);
cmd.ExecuteNonQuery();
}
} //看看应该可以