62,046
社区成员
发帖
与我相关
我的任务
分享
string type = ((baseUser)(context.Session["UserInfo"])).userType;
string sql = "UPDATE @table SET @pwdName = @pwd WHERE @idName = @id";
string idName = "";
string pwdName = "";
if (type == "Student")
{
idName = "Stu_id";
pwdName = "Stu_pwd";
}
else if (type == "Teacher")
{
idName = "Tea_id";
pwdName = "Tea_pwd";
}
else if (type == "Admin_User")
{
idName = "User_id";
pwdName = "User_pwd";
}
SqlParameter[] para = new SqlParameter[5];
para[0] = new SqlParameter("@table", type);
para[1] = new SqlParameter("@pwdName", pwdName);
para[2] = new SqlParameter("@pwd", newPwd);
para[3] = new SqlParameter("@idname", idName);
para[4] = new SqlParameter("@id", ((baseUser)context.Session["UserInfo"]).userId);
ExecuteNoReader(sql, para);//<-------------------------这句,无返回,无异常,求解
public static void ExecuteNoReader(string queryString, SqlParameter[] cmdParms)
{
using (SqlConnection connection = new SqlConnection(CONN_STRING))
{
SqlCommand command = new SqlCommand(queryString, connection);
if (cmdParms != null)
{
foreach (SqlParameter parm in cmdParms)
command.Parameters.Add(parm);
}
command.CommandType = System.Data.CommandType.Text;
command.Connection.Open();
command.ExecuteNonQuery();
}
}
ExecuteNoReader(sql, para);//<-------------------------这句,无返回,无异常,求解
... //<---------------------------上面的ExecuteNoReader执行完后不会返回到这里