Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- protected void Button4_Click(object sender, EventArgs e)
- {//Uppdaterar fråga
- ListBox1.Items.Clear();
- SqlConnection con = new SqlConnection(conString);
- int tentaID = Convert.ToInt32(tbxTentamensID.Text);
- string fragenummer = tbxFragenr.Text;
- string fraga = tbxFraga.Text;
- con.Open();
- //Uppdaterar databasen
- SqlCommand upp = new SqlCommand("UPDATE FragaITenta SET Fraga= @fraga WHERE TentaID= @tentaID AND Fragenr = @fragenummer", con);
- int r = upp.ExecuteNonQuery();
- upp.Parameters.AddWithValue("@fraga", tbxFraga.Text);
- upp.Parameters.AddWithValue("@tentaID", Convert.ToInt32(tbxTentamensID.Text));
- upp.Parameters.AddWithValue("@fragenummer", tbxFragenr.Text);
- con.Close();
- Label5.Text = "Fråga nummer " + fragenummer + " är nu uppdaterad.";
- skrivaut();
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement