Guest User

Untitled

a guest
Jun 19th, 2018
102
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.41 KB | None | 0 0
  1. [WebMethod]
  2. public void PostMessage(string Name, string Message) {
  3. var connectionString = ConfigurationManager.ConnectionStrings["connString"].ConnectionString;
  4. var sql = "INSERT INTO Chatt([Name], [Message], [Time]) VALUES(@Name, @Message, @Time);";
  5. var conn = new OleDbConnection(connectionString);
  6. var comm = new OleDbCommand(sql, conn);
  7. comm.Parameters.AddWithValue("@Name", Name);
  8. comm.Parameters.AddWithValue("@Message", Message);
  9. comm.Parameters.AddWithValue("@Time", DateTime.Now);
  10.  
  11. try
  12. {
  13. conn.Open();
  14. comm.ExecuteNonQuery();
  15. }
  16. catch (Exception e)
  17. {
  18. throw e;
  19. }
  20. finally
  21. {
  22. conn.Close();
  23. conn.Dispose();
  24. }
  25. }
  26.  
  27. //[WebMethod]
  28. //public XDocument GetMessages()
  29. //{
  30. // var connectionString = "Data Source=mtgoswebot.myftp.org;Initial Catalog=FlashChatt;User Id=su10;Password=su10;";
  31. // var sql = "SELECT TOP 100 [Name], [Message], [Time] FROM [FlashChatt];";
  32. // var conn = new OleDbConnection(connectionString);
  33. // var comm = new OleDbCommand(sql, conn);
  34.  
  35. // //var reader = new OleDbDataReader();
  36. // try
  37. // {
  38. // conn.Open();
  39. // }
  40. // catch (Exception)
  41. // {
  42.  
  43. // throw;
  44. // }
  45. //}
Add Comment
Please, Sign In to add comment