Mysql connection doesn't work with "using"

Question

I'm trying this

string query = "SELECT * FROM teams ORDER BY name";

using(MySqlConnection dbConn = new MySqlConnection(conn))
{
    MySqlCommand cmd = new MySqlCommand(query, dbConn);
    MySqlDataReader dataReader = cmd.ExecuteReader();

But it returns an error on MysqlCommand line, saying Connection must be valid and open. Anyone have an idea what am I doing wrong?

Error message is so clear IMO..

Soner Gönül
– Soner Gönül

2013-11-13 20:24:05 +00:00
Commented Nov 13, 2013 at 20:24 — Soner Gönül
– Soner Gönül, Commented Nov 13, 2013 at 20:24

Habib · Accepted Answer · 2013-11-13 20:20:49Z

10

You haven't open the connection in your code, You should call

dbConn.Open();

It has nothing to do with using statement.

string query = "SELECT * FROM teams ORDER BY name";
using(MySqlConnection dbConn = new MySqlConnection(conn))
{
    MySqlCommand cmd = new MySqlCommand(query, dbConn);
    dbConn.Open();//here **
    MySqlDataReader dataReader = cmd.ExecuteReader();

using statement only ensures that the your connection object will be disposed after the scope, it doesn't open the connection itself.

answered Nov 13, 2013 at 20:20

Habib

224k30 gold badges420 silver badges446 bronze badges

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

1 Comment

Brian Over a year ago

You should wrap the command object in a using too, Habib. +1 regardless.

Collectives™ on Stack Overflow

Mysql connection doesn't work with "using"

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related