I still have to same problem, is it the way I'm accessing my database or is it the ExecuteReader() method?

Index out of bound.

Hey guys below is a block of code I'm using to get data from my DataBase using a DataReader but after running the code the DataReader is empty tell what I'm I doing wrong. I'm using Microsoft.Practices.EnterpriseLibrary.Data to access my Database

Database dbuser = DatabaseFactory.CreateDatabase("Portal");

DbCommand cmd = dbuser.GetStoredProcCommand("GetPassword");
DbCommand cmdUpdate = dbuser.GetStoredProcCommand("UpdateLastActivityByEmail");

dbuser.AddInParameter(cmd, "Email", DbType.String, username);
dbuser.AddInParameter(cmd, "Password", DbType.String, EncryptData(password));

dbuser.AddInParameter(cmdUpdate, "Email", DbType.String, username);
dbuser.AddInParameter(cmdUpdate, "lastActivityDate", DbType.DateTime, DateTime.Now);

string pwd = "";
SqlDataReader dbrUsers = null;
dbrUsers = (SqlDataReader)dbuser.ExecuteReader(cmd);

try
{

    if (dbrUsers.RecordsAffected > 0)
        {
            dbrUsers.Read();
            pwd = dbrUsers.GetString(0);
        }
  }

catch(Exception e)
{
}

Please Help!

Index out of bound.

Hi, Anyone out there who can help me I have to implement a Custom MembershipProvider but my problem is our database Schema is totally different from one of the many examples and the which default. One other thing I just need to know is if I implement the Custom Membershoip Provider do I have to declare the methods like GetUser() the way it is and with the same parameters? Guys please help I'm tired of cracking my head. And ooh, here is the table I'll be using: [UserID] [int] IDENTITY(1,1) NOT NULL, [Name] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [Password] [nvarchar](64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Email] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [Company] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Tel] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Fax] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [PosAddr1] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [PosAddr2] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [PosAddr3] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [PosCode] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [PhysAddr1] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [PhysAddr2] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Town] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [DateStamp] [datetime] NULL CONSTRAINT [DF_Users_DateStamp] DEFAULT (getdate()), [LastPasswordChange] [datetime] NULL CONSTRAINT [DF_Users_LastPasswordChange] DEFAULT getdate()), [PasswordPeriod] [int] NULL CONSTRAINT [DF_Users_PasswordPeriod] DEFAULT (0), [Question] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Answer] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [lastActivityDate] [datetime] NULL, Please HELP!:confused: