Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Gabber gabber = new Gabber();
- 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");
- public static SqlCommand cmd;
- public static SqlDataReader reader;
- public void getGabberInfo()
- {
- con.Close();
- con.Open();
- cmd = new SqlCommand("SELECT * FROM Gabbers", con);
- reader = cmd.ExecuteReader();
- while (reader.Read())
- {
- foreach (Object ob in reader)
- {
- Console.WriteLine("id = " + reader[0]);
- Console.WriteLine("Naam = " + reader[1]);
- }
- }
- con.Close();
- }
- //deze functie zorgt er voor dat een gabber word aangemaakt in de database
- public int saveGabber(string _naam)
- {
- Int32 id = 0;
- con.Close();
- con.Open();
- cmd = new SqlCommand("INSERT INTO gabbers([Name], [A.hakken], [T.hakken], [Today]) values(@gabberName, 0, 0, @today) SELECT CAST(scope_identity() AS int)", con);
- cmd.Parameters.AddWithValue("@gabberName", _naam);
- cmd.Parameters.AddWithValue("@today", DateTime.Today);
- id = (Int32)cmd.ExecuteScalar();
- con.Close();
- return id;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement