public AdminInfo selectAdminByUserName(string userName)
{
DataTable dt = new DataTable();
string strSql = "sp_News_SelectAdminByUserName";
SqlParameter[] paras = new SqlParameter[]{
new SqlParameter("@UserName",SqlDbType.NVarChar,20)
};
paras[0].Value = userName;
dt = sqlhelper.ExecuteQuery(strSql, paras, CommandType.StoredProcedure);
AdminInfo adminInfo = new AdminInfo();
adminInfo.UserName = userName;
adminInfo.Pwd = dt.Rows[0]["Pwd"].ToString();
adminInfo.AdminName = dt.Rows[0]["AdminName"].ToString();
adminInfo.EMail = dt.Rows[0]["Email"].ToString();
adminInfo.CreatTime = Convert.ToDateTime(dt.Rows[0]["CreatTime"]);
adminInfo.LastLoginDate = Convert.ToDateTime(dt.Rows[0]["LastLoginDate"]);
return adminInfo;
}
不知道为啥我参数传进去了 单独执行存储过程也没问题
但是执行时总是报错 adminInfo.Pwd = dt.Rows[0]["Pwd"].ToString();在位置0处没有任何行!!
{
DataTable dt = new DataTable();
string strSql = "sp_News_SelectAdminByUserName";
SqlParameter[] paras = new SqlParameter[]{
new SqlParameter("@UserName",SqlDbType.NVarChar,20)
};
paras[0].Value = userName;
dt = sqlhelper.ExecuteQuery(strSql, paras, CommandType.StoredProcedure);
AdminInfo adminInfo = new AdminInfo();
adminInfo.UserName = userName;
adminInfo.Pwd = dt.Rows[0]["Pwd"].ToString();
adminInfo.AdminName = dt.Rows[0]["AdminName"].ToString();
adminInfo.EMail = dt.Rows[0]["Email"].ToString();
adminInfo.CreatTime = Convert.ToDateTime(dt.Rows[0]["CreatTime"]);
adminInfo.LastLoginDate = Convert.ToDateTime(dt.Rows[0]["LastLoginDate"]);
return adminInfo;
}
不知道为啥我参数传进去了 单独执行存储过程也没问题
但是执行时总是报错 adminInfo.Pwd = dt.Rows[0]["Pwd"].ToString();在位置0处没有任何行!!
加不加try catch都一样报错撒