Question

这行代码SqlDataReader dr = cmd.ExecuteReader();有什么语法错误？总报错说等号附近有语法错误

全部代码为： using System; using System.Data; using System.Data.SqlClient; using System.Configuration; using System.Collections; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; public partial class Default6 : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { SqlConnection conn = new SqlConnection("server=localhost;database=bookshop;uid=sa;pwd=;"); SqlCommand cmd = new SqlCommand("select image,image_size from images where id=" + Request["id"], conn); conn.Open(); SqlDataReader dr = cmd.ExecuteReader(); if (dr.Read()) { Response.BinaryWrite((byte[])dr["image"]); } dr.Close(); conn.Close(); Response.End(); } }

Answer 1

请注意： 您的“image”字段是关键字。因此被SQL误解了语法错误、 【解决方案】——直接把image扔到方括号中去。 select [image]……