Advertisement
Guest User

Untitled

a guest
Jun 16th, 2019
77
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.71 KB | None | 0 0
  1. using (var conn = new SqlConnection(Constants.LOCAL))
  2. {
  3. using (var cmd = new SqlCommand())
  4. {
  5. cmd.Connection = conn;
  6. cmd.CommandType = CommandType.Text;
  7. cmd.CommandText = Constants.QUERY_HTML;
  8.  
  9. conn.Open();
  10.  
  11. DataTable dt = new DataTable();
  12.  
  13. try
  14. {
  15. using (var reader = cmd.ExecuteReader())
  16. {
  17. dt.Load(reader);
  18. }
  19. }
  20. catch (Exception ex)
  21. {
  22. Console.WriteLine(ex.ToString());
  23. }
  24.  
  25. if (dt.Rows.Count > 0)
  26. {
  27. result.payload = dt;
  28. result.hasPayload = true;
  29. result.code = 200;
  30. }
  31.  
  32. return result;
  33. }
  34. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement