Guest User

Untitled

a guest
Nov 15th, 2018
102
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.93 KB | None | 0 0
  1. public ActionResult myTable(int getID)
  2. {
  3. List<info> myList = new List<info>();
  4. string constr = ConfigurationManager.ConnectionStrings["ConString"].ConnectionString;
  5. using (MySqlConnection con = new MySqlConnection(constr))
  6. {
  7. string query = "SELECT name, age, address, status FROM Details WHERE id = "+ getID;
  8. using (MySqlCommand cmd = new MySqlCommand(query))
  9. {
  10. cmd.Connection = con;
  11. con.Open();
  12. using (MySqlDataReader sdr = cmd.ExecuteReader())
  13. {
  14. while (sdr.Read())
  15. {
  16. try
  17. {
  18. myList.Add(new info
  19. {
  20. name = sdr["name"].ToString(),
  21. age = sdr["age"].ToString(),
  22. address = sdr["address"].ToString(),
  23. status = sdr["status"].ToString(),
  24.  
  25. });
  26. }
  27. catch (Exception)
  28. {
  29. myList.Add(new info
  30. {
  31. name = ""
  32. age = ""
  33. address = ""
  34. status = ""
  35. });
  36. }
  37. }
  38. }
  39. con.Close();
  40. }
  41. }
  42.  
  43. return Json(myList, JsonRequestBehavior.AllowGet);
  44. }
  45.  
  46. function exportTable(){
  47. var getID = document.getElementById("id").value
  48.  
  49. $.ajax({
  50. url: '/Home/myTable',
  51. type: 'GET',
  52. data: {
  53. 'id': getID,
  54. },
  55.  
  56. success: function (data) {
  57. alert(data) //---> Build export logic here
  58.  
  59. },
  60. error: function (jqXhr, textStatus, errorThrown) {
  61. alert(errorThrown);
  62. }
  63. });
  64. }
Add Comment
Please, Sign In to add comment