question:
index out of range exception??error code : if (!Convert.IsDBNull(reader["Name"]))
username = reader["Name"].ToString();
sources code: public bool LoginUser(string username,string pwd)
{
bool exists = false;
SqlParameter[] parms = new SqlParameter[2];
parms[0] = new SqlParameter("@name", SqlDbType.NVarChar, 100);
parms[1] = new SqlParameter("@password", SqlDbType.NVarChar, 100);
parms[0].Value = username;
parms[1].Value = pwd;
SqlDataReader reader = DbTools.ExecuteReader("LoginUserProce", parms); if (reader.Read())
{
exists = true;
if (!Convert.IsDBNull(reader["name"]))
username = reader["name"].ToString();
if (!Convert.IsDBNull(reader["password"]))
pwd = reader["password"].ToString();
}
reader.Close();
return exists;
}
index out of range exception??error code : if (!Convert.IsDBNull(reader["Name"]))
username = reader["Name"].ToString();
sources code: public bool LoginUser(string username,string pwd)
{
bool exists = false;
SqlParameter[] parms = new SqlParameter[2];
parms[0] = new SqlParameter("@name", SqlDbType.NVarChar, 100);
parms[1] = new SqlParameter("@password", SqlDbType.NVarChar, 100);
parms[0].Value = username;
parms[1].Value = pwd;
SqlDataReader reader = DbTools.ExecuteReader("LoginUserProce", parms); if (reader.Read())
{
exists = true;
if (!Convert.IsDBNull(reader["name"]))
username = reader["name"].ToString();
if (!Convert.IsDBNull(reader["password"]))
pwd = reader["password"].ToString();
}
reader.Close();
return exists;
}
看看你 看看你返回的数据把