protected void Page_Load(object sender, EventArgs e) { PeliId = (Int32)this.Session["peliid"]; current_username = Context.User.Identity.Name; TilausTietokanta til = new TilausTietokanta(); string connStr = WebConfigurationManager.ConnectionStrings["PelimaailmaConnectionString"] .ConnectionString; SqlConnection conn = new SqlConnection(connStr); string sqlQuery = "SELECT PeliId, Nimi, Vuosi, Alusta, Hinta FROM Pelit WHERE PeliId = @PeliId"; SqlCommand sqlCmd = new SqlCommand(sqlQuery, conn); sqlCmd.Parameters.AddWithValue("@PeliId", PeliId); try { conn.Open(); SqlDataReader reader = sqlCmd.ExecuteReader(); FormView1.DataSource = reader; FormView1.DataBind(); reader.Close(); } catch (SqlException ex) { throw new ApplicationException( "Error: Unable to connect to the database!"); } finally { conn.Close(); } }
protected void Page_Load(object sender, EventArgs e) { TuoteID = (Int32)this.Session["tuoteid"]; Nimi = (string)this.Session["nimi"]; Hinta = (double)this.Session["hinta"]; Veroprosentti = (double)this.Session["veroprosentti"]; Kategoria = (string)this.Session["kategoria"]; current_username = Context.User.Identity.Name; TilausTietokanta til = new TilausTietokanta(); String connStr = WebConfigurationManager.ConnectionStrings["KonekauppaConnectionString"].ConnectionString; SqlConnection conn = new SqlConnection(connStr); String sqlQuery = "SELECT t.TuoteID, t.Nimi, t.Hinta, t.Veroprosentti, k.KategoriaNimi as Kategoria FROM Tuote t JOIN Kategoria k ON k.KategoriaID = t.KategoriaID WHERE TuoteID = @TuoteID"; SqlCommand sqlCmd = new SqlCommand(sqlQuery, conn); sqlCmd.Parameters.AddWithValue("@TuoteID", TuoteID); try { conn.Open(); SqlDataReader reader = sqlCmd.ExecuteReader(); FormView1.DataSource = reader; FormView1.DataBind(); reader.Close(); } catch (SqlException ex) { throw new ApplicationException("Error: Unable create database connection!"); } finally { conn.Close(); } }