ayha1999
asked on
Data reader error
when I try to execute the following code I get an error; the sql command isworking fine.
System.IndexOutOfRangeExce ption: maxNumber
at line
newId = maxReader["maxNumber"].ToS tring();
SqlCommand cmd = new SqlCommand("SELECT MAX(CAST(SUBSTRING(wid, 4, len(wid)) as INT))+1 as newId from myTable", cn);
SqlDataReader Reader;
int newid;
if (!blnMatch)
{
cn.Open();
foreach (DataRow objDR in objDT.Rows)
{
Reader = cmd.ExecuteReader(CommandB ehavior.Cl oseConnect ion);
while (Reader.Read())
{
newId = maxReader["newId "].ToString();
}
Reader.Close();
cmdPart.Parameters["@newid "].Value = newId;
cmdPart.Parameters["@useri d"].Value = User.Identity.Name;
cmdPart.Parameters["@date" ].Value = DateTime.Now;
try
{
cn.Open();
cmd2.ExecuteNonQuery();
}
catch
{
}
pls help.
ayha
System.IndexOutOfRangeExce
at line
newId = maxReader["maxNumber"].ToS
SqlCommand cmd = new SqlCommand("SELECT MAX(CAST(SUBSTRING(wid, 4, len(wid)) as INT))+1 as newId from myTable", cn);
SqlDataReader Reader;
int newid;
if (!blnMatch)
{
cn.Open();
foreach (DataRow objDR in objDT.Rows)
{
Reader = cmd.ExecuteReader(CommandB
while (Reader.Read())
{
newId = maxReader["newId "].ToString();
}
Reader.Close();
cmdPart.Parameters["@newid
cmdPart.Parameters["@useri
cmdPart.Parameters["@date"
try
{
cn.Open();
cmd2.ExecuteNonQuery();
}
catch
{
}
pls help.
ayha
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
By the way what kind of Construct is maxReader["newId "]???
Is it an ArrayList object that stores Integer Values?? Or something else.. Please clear my doubts first..