Guest User

Untitled

a guest
Dec 12th, 2018
122
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.20 KB | None | 0 0
  1. $bdd= new PDO ("mysql:host=phpmyadmin.webserver.roc-teraa.nl;port=3306;dbname=wikiparks","$username", "$password");
  2.  
  3. private void btnToevoegen_Click(object sender, EventArgs e)
  4. {
  5. try
  6. {
  7. NameValueCollection ParkInfo = new NameValueCollection();
  8. ParkInfo.Add("ParkNaam", txbPretpark.Text);
  9. ParkInfo.Add("ParkLocatie", txbLocatiePretpark.Text);
  10. ParkInfo.Add("ParkOpeningsDagen", txbOpeningsDagen.Text);
  11. ParkInfo.Add("ParkOpeningsTijden", txbOpeningsTijden.Text);
  12. ParkInfo.Add("ParkPrijzen", txbPrijzenPretpark.Text);
  13. ParkInfo.Add("ParkLeeftijden", txbLeeftijdPretpark.Text);
  14. ParkInfo.Add("ParkTags", txbTags.Text);
  15. ParkInfo.Add("ParkBeschrijving", rtbBeschrijving.Text);
  16.  
  17. byte[] InsertPark = client.UploadValues("http://localhost:8080/WikiParks/index.php", "POST", ParkInfo);
  18. client.Headers.Add("Content-Type", "binary/octet-stream");
  19. }
  20. catch (Exception)
  21. {
  22. MessageBox.Show("Pretpak succesvol toegevoegd aan de Database");
  23. }
  24.  
  25.  
  26. }
  27.  
  28. PDO in dotNET
  29. [enter link description here][1]
  30. [1]: https://www.nuget.org/packages/SDO_dotNET/
  31.  
  32. The SDO_dotNET Class Library is a high level wrapper around the ODBC, OLEDB, SQLServer and SQLite.
  33.  
  34. Example:
  35. using SqlDB;
  36.  
  37. /******************************************************************
  38. Sql Server
  39. *******************************************************************/
  40.  
  41. string server = @"INSTANCESQLEXPRESS";
  42. string database = "DEMODB";
  43. string username = "sa";
  44. string password = "";
  45.  
  46. string connectionString = @"Data Source=" + server + ";Initial Catalog=" + database + "; Trusted_Connection=True;User ID=" + username + ";Password=" + password + "";
  47. SDO db_conn = new SDO(connectionString);
  48.  
  49. Console.WriteLine("isConnected: " + db_conn.isConnected());
  50. if (db_conn == null || !db_conn.isConnected())
  51. {
  52. Console.WriteLine("Connessione non valida.");
  53. return;
  54. }
  55.  
  56. string sql = "SELECT ID, Message FROM Logs ORDER BY IDLic;";
  57. DataTable dtLogs = db_conn.SelectTable(sql);
  58.  
  59. if (dtLogs == null || dtLogs.Rows.Count == 0)
  60. return;
  61.  
  62. // Loop with the foreach keyword.
  63. foreach (DataRow dr in dtLogs.Rows)
  64. {
  65. Console.WriteLine("Message: " + dr["Message"].ToString().Trim());
  66. }
  67.  
  68.  
  69.  
  70. /******************************************************************
  71. SQLite
  72. *******************************************************************/
  73.  
  74. string database = @"C:UsersUtentemydb.sqlite";
  75.  
  76. string connectionString = @"Data Source=" + database + "; Version=3; New=True; Compress=True;"; // local
  77. SDO db_conn = new SDO(connectionString);
  78.  
  79. Console.WriteLine("isConnected: " + db_conn.isConnected());
  80. if (db_conn == null || !db_conn.isConnected())
  81. {
  82. Console.WriteLine("Connessione non valida.");
  83. return;
  84. }
  85.  
  86. string sql = "SELECT firstname, surname FROM users ORDER BY firstname;";
  87. DataTable dtLogs = db_conn.SelectTable(sql);
  88.  
  89. if (dtLogs == null || dtLogs.Rows.Count == 0)
  90. return;
  91.  
  92. // Loop with the foreach keyword.
  93. foreach (DataRow dr in dtLogs.Rows)
  94. {
  95. Console.WriteLine("Name: " + dr["firstname"].ToString().Trim() + " " + dr["surname"].ToString().Trim());
  96. }
Add Comment
Please, Sign In to add comment