index out of range exception??
index out of range exception??
error code:
if (!Convert.IsDBNull(reader["Name"]))
username = reader["Name"].ToString();
2. source 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.GetValue(2)))???????????????
username = reader.GetValue(2).ToString();
if (!Convert.IsDBNull(reader["password"]))
pwd = reader["password"].ToString();
}
reader.Close();
return exists;
}