Problem with usage of multiple DataReaders in ASP.NET(C#)

Question

SqlConnection conn1 = new SqlConnection("Server=ILLUMINATI;" + "Database=DB;Integrated Security= true");

SqlCommand COMM = new SqlCommand("select Role from Login where User_Name='admin'", conn1);
conn1.Open();

SqlDataReader reader = COMM.ExecuteReader();
while (reader.Read())
{
    string s = reader["Role"].ToString();
}
reader.Close();
conn1.Close();

SqlConnection conn = new SqlConnection("Server=ILLUMINATI;" + "Database=DB;Integrated Security= true");
SqlCommand comm = new SqlCommand("Select * from FileUpload where UploadedBy='"+NAME+"'",conn);

try
{
    conn.Open();

    SqlDataReader rdr = comm.ExecuteReader();
    if (s.Equals("admin"))
    {
        GridView1.DataSource = rdr;
        GridView1.DataBind();
    }

    if(s.Equals("teacher"))
    {
         GridView2.DataSource = rdr;
         GridView2.DataBind();
    }

    rdr.Close();
    //reader.Close();
}
catch
{
    conn.Close();
}

I'm getting error in the below connection saying s does not exist in the current context. How to use the multiple datareaders please help me.

Muhammad Akhtar · Accepted Answer · 2011-06-08 06:00:27Z

2

Declare string s out of hte loop

  string s;
  while (reader.Read())
     {
         s = reader["Role"].ToString();
     }

answered Jun 8, 2011 at 6:00

Muhammad Akhtar

52.2k37 gold badges142 silver badges191 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Naresh Over a year ago

Thank you...Can I do it with in the same connection.

Muhammad Akhtar Over a year ago

Its String variable, if you assign value and you can retrieve in the scope of variable, it does't matter connection.

VMAtm · Accepted Answer · 2011-06-08 06:03:00Z

1

      SqlConnection conn1 = new SqlConnection("Server=ILLUMINATI;" + "Database=DB;Integrated Security= true");
      SqlCommand COMM = new SqlCommand("select Role from Login where User_Name='admin'", conn1);
      conn1.Open();
      SqlDataReader reader = COMM.ExecuteReader();
      string s = String.Empty;
      while (reader.Read())
          s = reader["Role"].ToString();

answered Jun 8, 2011 at 6:03

VMAtm

28.4k17 gold badges85 silver badges133 bronze badges

Collectives™ on Stack Overflow

Problem with usage of multiple DataReaders in ASP.NET(C#)

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related