Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- protected override void OnStart(string[] args)
- {
- EventLog.WriteEntry(ServiceName + " started");
- PageLoadTimer.Enabled = true;
- using(var conn = new SqlConnection("Data Source=DESKTOP-300NQR3\SQLEXPRESS;Initial Catalog=MyDb;Integrated Security=True"))
- {
- string q = "INSERT INTO [dbo].[PageDocument] (Html, PageType, DateAdded, DateProcessed) VALUES ('<p>Hi!</p>', 0, GETDATE(), NULL)";
- using(var comm = new SqlCommand(q, conn))
- {
- conn.Open();
- comm.ExecuteNonQuery();
- conn.Close();
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement