public void UpdateGridView()
{
try
{
conn.Open();
cmd = new SqlCommand(sqladd, conn);
cmd.Parameters.Add("@PokehunterID", SqlDbType.Int).Value = int.Parse(Session["PokehunterID"].ToString());
rdr = cmd.ExecuteReader();
GridViewCatch.DataSource = rdr;
GridViewCatch.DataBind();
}
catch (Exception ex)
{
LabelMessage.Text = ex.Message;
}
finally
{
if (rdr != null)
{
rdr.Close();
}
if (conn != null)
{
conn.Close();
}
}
try
{
conn.Open();
cmd = new SqlCommand("SELECT * FROM Pokemons", conn);
cmd.Parameters.Add("@PokehunterID", SqlDbType.Int).Value = int.Parse(Session["PokehunterID"].ToString());
rdr = cmd.ExecuteReader();
DropDownListPokemons.DataSource = rdr;
DropDownListPokemons.DataTextField = "PokemonName";
DropDownListPokemons.DataValueField = "PokemonNumber";
DropDownListPokemons.DataBind();
DropDownListPokemons.Items.Insert(0, "Select a Pokemon to catch");
}
catch (Exception ex)
{
LabelMessage.Text = ex.Message;
}
finally
{
if (rdr != null)
{
rdr.Close();
}
if (conn != null)
{
conn.Close();
}
}
}
private void UpdateGridView()
{
SqlConnection conn = new SqlConnection(@"data source = .\SQLEXPRESS; integrated security = true; database = Pokemons");
string sqlsel = "SELECT * FROM Pokemons";
try
{
da = new SqlDataAdapter();
da.SelectCommand = new SqlCommand(sqlsel, conn);
ds = new DataSet();
da.Fill(ds, "MyPokemons");
dt = ds.Tables["MyPokemons"];
GridViewDelete.DataSource = dt;
GridViewDelete.DataBind();
DropDownListPokemons.DataSource = dt;
DropDownListPokemons.DataTextField = "PokemonName";
DropDownListPokemons.DataValueField = "PokemonNumber";
DropDownListPokemons.DataBind();
DropDownListPokemons.Items.Insert(0, "Select pokémon to delete");
}
catch (Exception ex)
{
LabelMessage.Text = ex.Message;
}
finally
{
if (conn != null)
{
conn.Close();
}
}
}
