System.Exception: 将 varchar 值 '5,7,' 转换为数据类型为 int 的列时发生语法错误。怎么解决？
public void DeleteId(string MemberId)
{
string strSql = "delete Member where MemberId in ( ' " + MemberId + " ') ";
DbHelperSQL.ExecuteSql(strSql);
}


public static int ExecuteSql(string SQLString)
{
using (SqlConnection connection = new SqlConnection(connectionString))
{
using (SqlCommand cmd = new SqlCommand(SQLString, connection))
{
try
{
connection.Open();
int rows = cmd.ExecuteNonQuery();
return rows;
}
catch (System.Data.SqlClient.SqlException E)
{
connection.Close();
throw new Exception(E.Message);
}
}
}
}

[解决办法]
string strSql = "delete Member where MemberId in ( " + MemberId + ") ";
去掉单引号
[解决办法]
MemberId =MemberId .SubString(0,MemberId.Length-1);
string strSql = "delete Member where MemberId in ( ' " + MemberId + " ') ";
[解决办法]
你的原始 memberId 是什么样的
LZ 把信息给全啊
[解决办法]
老大
把尾巴上的,去了先
string strSql = "delete Member where MemberId in ( " + MemberId.TrimEnd( ', ') + ") ";