how to close a DR and then open it again for use

[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.

[JerryShaw]

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