asp.net MVC在细节视图上使用字符串id

Question

请帮我找出代码中的错误

public ActionResult Details(string id){String connectionString = ConfigurationManager.ConnectionStrings["SAPB1"].ConnectionString;SqlConnection conn = new SqlConnection(connectionString);String sql = "Select a.[CardCode] As CCODE;[CardName] As Name from ocrd a where a. cardcode = "+身份证;SqlCommand cmd = new SqlCommand(sql, conn);

BPModel BP = new BPModel();
using (conn)
{
conn.Open();

if (string.IsNullOrEmpty(id))
{

}
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
BP.CCODE = rdr["CCODE"].ToString();
BP.Name = rdr["Name"].ToString();
}


}
return View(BP);
}

Answer 1

您需要在单引号(')内包装您的id值。试试如下:

String sql = "Select a.[CardCode] As CCODE,a.[CardName] As Name from ocrd a where a.CardCode = '" + id + "'";