C# MySQL Query in DataReader loop query

Question

I have a method in C# which should get some data from mysql and then insert this data in another table.
The problem is that no matter what I try i get another datareader is open.
I tried using the using statement, but with no success, maybe I do it wrong.
How to do that?

public void MethodName(List<string> objects)
{
    foreach(string Object in objects){
        SQLActions.Initialize();
        SQLActions.SQL_Open();
        MySqlDataReader queryData = SQLActions.SQL_Query("SELECT...query...");

        MySqlDataReader objectsData = SQLActions.SQL_Query("Another select....");
        SQLActions.SQL_NonQuery("Insert...");
        while(queryData.Read()){
            SQLActions.SQL_NonQuery("Another Insert...");
        }
        SQLActions.SQL_Close();
    }
}

Some code would be very helpful.

Levi Botelho
– Levi Botelho

2013-05-27 07:16:38 +00:00
Commented May 27, 2013 at 7:16 — Levi Botelho
– Levi Botelho, Commented May 27, 2013 at 7:16
Mention your code here.

Jibran Khan
– Jibran Khan

2013-05-27 07:16:44 +00:00
Commented May 27, 2013 at 7:16 — Jibran Khan
– Jibran Khan, Commented May 27, 2013 at 7:16

Community · Accepted Answer · 2017-05-23 10:27:18Z

2

You are probably using the same connection for the DataReader and the ExecuteNonQuery. This is not supported, according to MSDN: http://msdn.microsoft.com/en-us/library/haa3afyz(v=vs.80).aspx

Check this:

C# mySQL There is already an open DataReader associated

From Microsoft:

You should always call the Close method when you have finished using the DataReader object.

edited May 23, 2017 at 10:27

CommunityBot

11 silver badge

answered May 27, 2013 at 7:18

Carlos Landeras

11.1k11 gold badges60 silver badges84 bronze badges

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

2 Comments

Paul Reed Over a year ago

I cheched that before and I'm not sure if this will help. I want to insert when the reading process is going. I will not be able to read if I close the connection.

Paul Reed Over a year ago

Can I use two parallel connections?

Collectives™ on Stack Overflow

C# MySQL Query in DataReader loop query

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related