How to executequery while reading data from another sql query in c#?

Question

I want to ExecuteQuery() while reading data from another resultset of ExecuteQuery.

SqlCommand cmd1 = new SqlCommand("pgwp_teamtypeselect", con);
cmd1.CommandType = CommandType.StoredProcedure;

rdr = cmd1.ExecuteReader();

string ehtml = null;
string tipi = null;
int che = 0;

while (rdr.Read())
{
    SqlCommand cmd2 = new SqlCommand("pgwp_goalselect", con);
    cmd2.CommandType = CommandType.StoredProcedure;

    rdr2 = cmd2.ExecuteReader();

    while (rdr2.Read())
    {
        do something.....
    }
}

Are you getting an exception or do you want a better way of doing it? — user5089754
– user5089754, Commented Jul 9, 2015 at 16:56
It seems your inner while (rdr.Read()) must be while (rdr2.Read()) — Claudio Redi
– Claudio Redi, Commented Jul 9, 2015 at 16:58
I am trying to get data with query while in the loop of reading data from another query — Irakli Shalamberidze
– Irakli Shalamberidze, Commented Jul 9, 2015 at 16:59
what is the problem are you getting any error or you want some other way to do it ? — Pranay Rana
– Pranay Rana, Commented Jul 9, 2015 at 17:00
I am new to c# querys to sql , I think I have a wrong logic of code — Irakli Shalamberidze
– Irakli Shalamberidze, Commented Jul 9, 2015 at 17:01

Pranay Rana · Accepted Answer · 2015-07-09 17:42:12Z

1

There is nothing wrong in executing query with in query but I suggest do it making use of using as in below example , So that object get dispose once execution finish

using(var command = new SqlCommand("pgwp_teamtypeselect", connection))
{
  command.CommandType = CommandType.StoredProcedure;
  using(var dataReader = command.ExecuteReader())
  {
    while (dataReader.Read()) 
    {
          using(var command1 = new SqlCommand("pgwp_goalselect",  
                       connection))
           {
             command1.CommandType = CommandType.StoredProcedure;

             using(var dataReader2 =command1.ExecuteReader())
             {
             }
           }
    }
}

}

You should also add this in your connection string MultipleActiveResultSets=True"

string connectionString = @"Data Source=GTL-263\SQLEXPRESS;Initial Catalog=master;Integrated Security=SSPI;MultipleActiveResultSets=True";

you can read this :Multiple Active Result Sets (MARS - ADO.NET 2.0) things you are doing is correct.

edited Jul 9, 2015 at 17:42

answered Jul 9, 2015 at 17:12

Pranay Rana

177k37 gold badges244 silver badges266 bronze badges

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

3 Comments

Irakli Shalamberidze Over a year ago

where do I write this? - cmd1.CommandType = CommandType.StoredProcedure;

Pranay Rana Over a year ago

@IrakliShalamberidze - just before exeucting ..I just want to say you whatever written by you is ok just wrap the thing in using {} you can also visit link and follow the code it is also ok

Pranay Rana Over a year ago

@IrakliShalamberidze - weldome check updated answer and dont forget to mark it as accpeted if it works for you

Collectives™ on Stack Overflow

How to executequery while reading data from another sql query in c#?

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related