Connection must be valid and open

Hi, I am using a method which get me a list of items from database. I already used the connection to insert data to database and works fine, but when displaying data in gridview an exception pops up. Below you can find the method used, the code for binding data to gridview and the asp for the gridview. Hope you can help. Thanks

Method to retreive data

ublic List getBets()

{

MySqlCommand cmd = Connection.CreateCommand();

cmd = new MySqlCommand("SELECT * FROM bets ORDER BY date");

try

{

if (this.Connection.State == ConnectionState.Closed)

this.Connection.Open();

MySqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);

List bets = new List();

while (dr.Read())

{

Bet myBet = new Bet();

myBet = FillBetfromRow(dr);

bets.Add(myBet);

}

return bets;

}

catch (MySqlException ex)

{

throw ex;

}

finally

{

if (Connection.State == ConnectionState.Open)

Connection.Close();

}

Binding data to gridview

gvBets.DataSource = new BetManagement().getBets();

gvBets.DataBind();

asp code for gridview

Hope you can help me tnx :D

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

darma teja14y ago
Try this one: ublic List getBets() { this.Connection.Open(); MySqlCommand cmd = Connection.CreateCommand(); cmd = new MySqlCommand("SELECT * FROM bets ORDER BY date"); try {
0
Ehtesham14y ago
Can you tell what is that exception?
0