*
Check the red marked code karthikeya.
OleDbDataReader ExecuteReader(string** ReaderQuery)*
*{*
*cmd =*
*new OleDbCommand**(ReaderQuery, conn);*
*conn.Open();*
*dr = cmd.ExecuteReader(*
*CommandBehavior**.CloseConnection);*
*
*
*// Try this one Karthik*
*
*
*return dr;*
*then close connection;
*
**
*conn.Close();*
*return** dr;*
On Sat, Jan 2, 2010 at 7:31 AM, Karthikeyan R <[email protected]> wrote:
> Hi,
>
> I am getting *"Invalid attempt to Read when reader is closed"* error in
> one of my pages.I have used the following method in my class file,
>
> public
> class ExecuteQuery
>
> {
>
> OleDbConnection conn;
>
> OleDbCommand cmd;
>
> DataTable dt;
>
> OleDbDataAdapter da;
>
> OleDbDataReader dr;
>
>
>
> public ExecuteQuery()
>
> {
>
> conn =
> new OleDbConnection();
>
> conn.ConnectionString =
> DBConnection.GetConnectionString();
>
> }
>
> *public*
> * OleDbDataReader ExecuteReader(string** ReaderQuery)*
>
> *{ *
>
> *cmd = *
> *new OleDbCommand**(ReaderQuery, conn); *
>
> *conn.Open();*
>
> *dr = cmd.ExecuteReader(*
> *CommandBehavior**.CloseConnection); *
>
> *conn.Close();*
>
> *return** dr;*
>
> *}*
> }
>
> In the aspx.cs file I have used the following code,
>
>
> private void ddlfill()
>
> {
>
> try
>
> {
>
> ddlquestion.Items.Add(
> "");
>
> ddlquestion.SelectedIndex = 0;
>
> string query = "select Hint_Question from Tbl_Hintquestion order by
> Hint_No ASC";
>
> bool abc = EQuery.ExecuteReader(query).Read();
>
> while (abc == true)
>
> {
>
> ddlquestion.Items.Add(dr[
> "Hint_Question"].ToString());
>
> abc = EQuery.ExecuteReader(query).Read();
>
> }
>
> }
>
> catch (Exception EXE)
>
> {
>
> Alert.Show(EXE.Message);
>
> }
>
> }
> Can some one help me out to solve this problem?
> --
> Thanks & Regards,
> Karthikeyan
>
--
Thanks,
Sushma
Email: [email protected]
