Loading

use of unassigned local variable aGame

use of unassigned local variable aGame

Avuya Mxoli

15y2.8kVisual Basic .NET

Hi,
Can anyone see what is missing here?thanks

using (SqlConnection conn = new SqlConnection(ConnString))

{

SqlCommand cmd = new SqlCommand("GetGameForCountry", conn);

cmd.CommandType = CommandType.StoredProcedure;

cmd.Parameters.AddWithValue("@Country", match);

Game aGame;

try

{

conn.Open();

SqlDataReader reader = cmd.ExecuteReader();

while (reader.Read())

{

aGame = new Game(reader["ID"].ToString(), reader["Location"].ToString(), reader["DateTime"].ToString());

}

reader.Close();

}

catch

{

}

return aGame;

2 Replies

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

Prabhu Raja15y ago
Accepted answer
Hi, try this. (Untested)

using (SqlConnection conn = new SqlConnection(ConnString))
{
SqlCommand cmd = new SqlCommand("GetGameForCountry", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Country", match); // check match has assigned with value before used
Game aGame = null;
try
{
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();

while (reader.Read())
{
aGame = new Game(reader["ID"].ToString(), reader["Location"].ToString(), reader["DateTime"].ToString());
}
reader.Close();
}
catch
{

}
return aGame;
Tulasi15y ago
Hi Ncedisa Mxoli ,

Allocate memory for aGame while declaration ,
ex: Game agame=new Game();
(0r) Game agame=null;