Question

执行到SqlDataReader myread=myCmd1.ExecuteReader(); 这句的时候出现d425b4426704c181c1515ba152' 语法错

代码段
protected void Button1_Click(object sender, EventArgs e)
{
string strConnection = "Server=LocalHost;Integrated Security=SSPI;Database=FrienDevLog";
myConn = new SqlConnection(strConnection);
string user;
user = Label2.Text;
myConn.Open();
string mySel = "SELECT Body from Log where UserId="+user+"";
SqlCommand myCmd1 = new SqlCommand(mySel, myConn);
SqlDataReader myread=myCmd1.ExecuteReader();
//Label3.Text = myread.GetString(1);
myConn.Close();
}

Answer 1

你这样写试试：
string mySel = string.Format("SELECT Body from Log where UserId='+user{0}+',Label2.Text");

Answer 2

string mySel = "SELECT Body from Log where UserId="+user+"";
改成
string mySel = "SELECT Body from Log where UserId='"+user+"'";

试试

Answer 3

是不是你的sql语句有语法错误