[求助]我的代码这样写有错吗 - 编程论坛

#2

bygg2007-04-25 17:26

你的另一个页面是怎么传过来的??

#3

airfei2007-04-25 17:58

回复：（airfei）[求助]我的代码这样写有错吗

protected void ImageButton2_Click(object sender, ImageClickEventArgs e)
{
string ImgPath = ((ImageButton)this.GridView3.Rows[0].FindControl("ImageButton2")).ImageUrl;
SqlConnection con = DB.CreateDB();
con.Open();
SqlCommand cmd = new SqlCommand("select ImgID from ImgNews2 where ImgPath ='"+ImgPath+"'", con);
string ImgID = Convert.ToString(cmd.ExecuteScalar());
Response.Redirect("ImgNews.aspx?ImgID='"+ImgID+"'");
}

#4

airfei2007-04-25 21:26

帮我看看,谢谢.

这是我传值的代码
protected void ImageButton2_Click(object sender, ImageClickEventArgs e)
{
string ImgPath = ((ImageButton)this.GridView3.Rows[0].FindControl("ImageButton2")).ImageUrl;
SqlConnection con = DB.CreateDB();
con.Open();
SqlCommand cmd = new SqlCommand("select ImgID from ImgNews2 where ImgPath ='"+ImgPath+"'", con);
string ImgID = Convert.ToString(cmd.ExecuteScalar());
Response.Redirect("ImgNews.aspx?ImgID='"+ImgID+"'");
}
错误是说:
SqlDataReader sdr = cmd.ExecuteReader();
第 1 行: '3' 附近有语法错误。

我调试的时候,
private void InitPage()
{
string ImgID = Request.QueryString["ImgID"].ToString();
//比如我取得的ImgID=1,如果在这里我用Response.Write(ImgID); 网页上就显示'1'
我想可能是这个1的问题,大家帮我看看是不是传值的问题.
我在SQL数据库中ImgID是int类型

#5

airfei2007-04-25 21:50

问题解决了,谢谢大家