TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Mark Fenech
NA
82
69.2k
Connection must be valid and open
Oct 18 2012 7:26 PM
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<Bet> 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<Bet> bets = new List<Bet>();
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
<asp:GridView ID="gvBets" runat="server">
<Columns>
<asp:BoundField DataField="date" HeaderText="Date" />
<asp:BoundField DataField="details" HeaderText="Details" />
<asp:BoundField DataField="odds" HeaderText="Odds" />
<asp:BoundField DataField="stake" HeaderText="Stake" />
<asp:BoundField DataField="result" HeaderText="Result" />
</Columns>
</asp:GridView>
Hope you can help me tnx :D
Reply
Answers (
2
)
How to add random with an int
Can save images to a structured text file C# ?