Member Avatar for manjusaharan

Hi all ,
i m using Ms-Access applicaion in c# bt getting error while using a datareader again after closing it.
here is the code.
can any one please help me??????????

if (sCl.Read())
{
if (!(sCl.GetValue(0) is DBNull)) code = sCl.GetInt32(0);
if (!(sCl.GetValue(1) is DBNull)) court = sCl.GetInt32(1);
if (!(sCl.GetValue(3) is DBNull)) party1 = sCl.GetInt32(3);
if (!(sCl.GetValue(4) is DBNull)) party2 = sCl.GetInt32(4);


url = "f:\\manju\\cl\\clsupr\\" + code + ".htm";
webProcFile.Navigate(url);
webProcFile.Show();
get.Connection = src;
get.CommandText = "select Code,Court from caselaw where ( Court > " + code1 + " AND Court < 21 AND ((Party1=" + party1 + " AND Party2=" + party2 + ") OR (Party1=" + party2 + " AND Party2=" + party1 + ")))";
if (stat.HasRows) stat.Close();
stat = get.ExecuteReader();


}
else
sCl.Close();
}

it is showing error in stat = get.ExecuteReader();
please help e in solving this problem.
Thanx in advance.

Edited by happygeek because: fixed formatting
  • 2 Contributors
  • 1 Reply
  • 109 Views
  • 10 Hours Discussion Span
  • Latest Post Latest Post by JerryShaw
Member Avatar for JerryShaw

Once the DataReader is closed, it is a null object. You need to reinitialize it as a new DataReader.
stat = new SqlDataReader();

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.