0

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: fixed formatting

2
Contributors
1
Reply
2
Views
9 Years
Discussion Span
Last Post by JerryShaw
0

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

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.