public Career getCareerEdit(int id)
{
Career career = new Career();
//open database connection
SqlConnection con = DatabaseConnection("open");
SqlCommand sqlCommand;
sqlCommand = new SqlCommand("readCareerEdit", con);
sqlCommand.Parameters.AddWithValue("@id", id);
sqlCommand.CommandType = System.Data.CommandType.StoredProcedure;
SqlDataReader reader = sqlCommand.ExecuteReader();
if (reader.Read())
{
career.Id = reader.GetInt32(reader.GetOrdinal("id"));
career.Name = reader.GetString(reader.GetOrdinal("name"));
career.Description = reader.GetString(reader.GetOrdinal("description"));
career.Code = reader.GetString(reader.GetOrdinal("code"));
}
sqlCommand.Dispose();
DatabaseConnection("close");
return career;
}
protected void gvResults_RowCommand(object sender,
GridViewCommandEventArgs e)
{
if (e.CommandName == "Edit")
{
// Retrieve the row index stored in the
// CommandArgument property.
int index = Convert.ToInt32(e.CommandArgument);
int i = (int)GridView1.DataKeys[index].Value;
career = dataCareer.getCareerEdit(i);
Session["careerEdit"] = career;
Response.Redirect("/updateCareer.aspx");
}
}
