For loop using in conjunction with an sqlcommand

Question

i have an SProc which returns the avg of all columns between two times, ie 04:00 to 04:14. I want to have an option to return results for 24hr at that same interval (in this case the interval is 15mins. 04:14 - 04:00) So the results would look like the following:

00:00 - 00:14 = x.xxx

00:15 - 00:29 = x.xxx

....

im assuming i cant change the sqlcommand (specifically the parameters for the SProc) inside the using statement, and would need to put the for loop before, thus creating a new SqlCommand object each time?

    for(int i = x; .....)
    {
        using (SqlCommand cmd = new SqlCommand())
        {
        }
    }

Thanks

Kyle Trauberman · Accepted Answer · 2012-06-24 21:39:18Z

2

This is an okay way to do this, as long as you don't open a new connection each time. I'm not sure about the performance implications though.

answered Jun 24, 2012 at 21:39

Kyle Trauberman

25.7k13 gold badges88 silver badges124 bronze badges

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

Comments

loopedcode · Accepted Answer · 2012-06-25 03:26:17Z

0

If you really want to go with a for loop then you should do something like following:

using(SqlCommand cmd = new SqlCommand())
{
  //Setup the command object and connection.
  for(int i=0; i<....)
  {
    cmd.CommandText = "set your dynamic sql here based on current iteration";
    var reader = cmd.ExecuteReader();
    //Now read you rows
  }
}

I would do this within SQL in a stored proc and return all the rows for your time range data.

edited Jun 25, 2012 at 3:26

answered Jun 24, 2012 at 21:40

loopedcode

4,9131 gold badge24 silver badges22 bronze badges

2 Comments

loopedcode Over a year ago

Thanks for correcting. For some reason I always thought disposer on SqlCommand closes the connection.

Kyle Trauberman Over a year ago

The SqlConnection.Dispose method closes the connection, so you're partly right.

Collectives™ on Stack Overflow

For loop using in conjunction with an sqlcommand

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related