Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- [WebMethod]
- public void PostMessage(string Name, string Message) {
- var connectionString = ConfigurationManager.ConnectionStrings["connString"].ConnectionString;
- var sql = "INSERT INTO Chatt([Name], [Message], [Time]) VALUES(@Name, @Message, @Time);";
- var conn = new OleDbConnection(connectionString);
- var comm = new OleDbCommand(sql, conn);
- comm.Parameters.AddWithValue("@Name", Name);
- comm.Parameters.AddWithValue("@Message", Message);
- comm.Parameters.AddWithValue("@Time", DateTime.Now);
- try
- {
- conn.Open();
- comm.ExecuteNonQuery();
- }
- catch (Exception e)
- {
- throw e;
- }
- finally
- {
- conn.Close();
- conn.Dispose();
- }
- }
- //[WebMethod]
- //public XDocument GetMessages()
- //{
- // var connectionString = "Data Source=mtgoswebot.myftp.org;Initial Catalog=FlashChatt;User Id=su10;Password=su10;";
- // var sql = "SELECT TOP 100 [Name], [Message], [Time] FROM [FlashChatt];";
- // var conn = new OleDbConnection(connectionString);
- // var comm = new OleDbCommand(sql, conn);
- // //var reader = new OleDbDataReader();
- // try
- // {
- // conn.Open();
- // }
- // catch (Exception)
- // {
- // throw;
- // }
- //}
Add Comment
Please, Sign In to add comment