Advertisement
M0n5t3r

Mijn dataclass

Jan 18th, 2018
97
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C# 1.51 KB | None | 0 0
  1. Gabber gabber = new Gabber();
  2.  
  3.         public static SqlConnection con = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename='C:\Users\Decaf\Documents\Fontys Hoogenschool ICT\2e Traject\FUN\inleveren\De app\Hakken_database\hakken_app_database.mdf';Integrated Security=True");
  4.         public static SqlCommand cmd;
  5.         public static SqlDataReader reader;
  6.        
  7.         public void getGabberInfo()
  8.         {
  9.             con.Close();
  10.             con.Open();
  11.             cmd = new SqlCommand("SELECT * FROM Gabbers", con);
  12.             reader = cmd.ExecuteReader();
  13.             while (reader.Read())
  14.             {
  15.                 foreach (Object ob in reader)
  16.                 {
  17.                     Console.WriteLine("id = " + reader[0]);
  18.                     Console.WriteLine("Naam = " + reader[1]);
  19.                 }
  20.             }
  21.             con.Close();
  22.         }
  23.  
  24.         //deze functie zorgt er voor dat een gabber word aangemaakt in de database
  25.         public int saveGabber(string _naam)
  26.         {
  27.             Int32 id = 0;
  28.             con.Close();
  29.             con.Open();
  30.             cmd = new SqlCommand("INSERT INTO gabbers([Name], [A.hakken], [T.hakken], [Today]) values(@gabberName, 0, 0, @today) SELECT CAST(scope_identity() AS int)", con);
  31.             cmd.Parameters.AddWithValue("@gabberName", _naam);
  32.             cmd.Parameters.AddWithValue("@today", DateTime.Today);
  33.             id = (Int32)cmd.ExecuteScalar();
  34.             con.Close();
  35.             return id;
  36.         }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement