Advertisement
Guest User

Untitled

a guest
May 22nd, 2015
221
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C# 0.90 KB | None | 0 0
  1. protected void Button4_Click(object sender, EventArgs e)
  2.     {//Uppdaterar fråga
  3.         ListBox1.Items.Clear();
  4.         SqlConnection con = new SqlConnection(conString);
  5.  
  6.         int tentaID = Convert.ToInt32(tbxTentamensID.Text);
  7.         string fragenummer = tbxFragenr.Text;
  8.         string fraga = tbxFraga.Text;
  9.  
  10.         con.Open();
  11.  
  12.         //Uppdaterar databasen
  13.         SqlCommand upp = new SqlCommand("UPDATE FragaITenta SET Fraga= @fraga WHERE TentaID= @tentaID AND Fragenr = @fragenummer", con);
  14.         int r = upp.ExecuteNonQuery();
  15.  
  16.         upp.Parameters.AddWithValue("@fraga", tbxFraga.Text);
  17.         upp.Parameters.AddWithValue("@tentaID", Convert.ToInt32(tbxTentamensID.Text));
  18.         upp.Parameters.AddWithValue("@fragenummer", tbxFragenr.Text);
  19.  
  20.         con.Close();
  21.  
  22.         Label5.Text = "Fråga nummer " + fragenummer + " är nu uppdaterad.";
  23.  
  24.         skrivaut();
  25.     }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement