Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public ActionResult myTable(int getID)
- {
- List<info> myList = new List<info>();
- string constr = ConfigurationManager.ConnectionStrings["ConString"].ConnectionString;
- using (MySqlConnection con = new MySqlConnection(constr))
- {
- string query = "SELECT name, age, address, status FROM Details WHERE id = "+ getID;
- using (MySqlCommand cmd = new MySqlCommand(query))
- {
- cmd.Connection = con;
- con.Open();
- using (MySqlDataReader sdr = cmd.ExecuteReader())
- {
- while (sdr.Read())
- {
- try
- {
- myList.Add(new info
- {
- name = sdr["name"].ToString(),
- age = sdr["age"].ToString(),
- address = sdr["address"].ToString(),
- status = sdr["status"].ToString(),
- });
- }
- catch (Exception)
- {
- myList.Add(new info
- {
- name = ""
- age = ""
- address = ""
- status = ""
- });
- }
- }
- }
- con.Close();
- }
- }
- return Json(myList, JsonRequestBehavior.AllowGet);
- }
- function exportTable(){
- var getID = document.getElementById("id").value
- $.ajax({
- url: '/Home/myTable',
- type: 'GET',
- data: {
- 'id': getID,
- },
- success: function (data) {
- alert(data) //---> Build export logic here
- },
- error: function (jqXhr, textStatus, errorThrown) {
- alert(errorThrown);
- }
- });
- }
Add Comment
Please, Sign In to add comment