C#

#if WINDOWS_UWP
using Windows.Foundation;
#else
using System.Windows;
#endif

<a href="http://i.imgur.com/xvfaJP6.png">

I am new to the .NET environment and trying to write a simple MVC application to read student data and display it to the end user. I have connected to a database using SQLOLEDB, the code of which I have pasted below. The data obtained from the query was stored in a variable of the type DataTable. Now I want to see the content of the query result in the form of a JSON output for which I have a faintest idea that I have to create a new controller. But I am not able to proceed beyond this point. 

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data.SqlClient;
using System.Data;

namespace Database.model
{
public class student
{
    public int id { get; set; }
    public string name { get; set; }
    private string age { get; set; }

    public DataTable GETSQLServerData()
    {
        //Connect
        var _connectionobject = new SqlConnection();
        _connectionobject.ConnectionString = @"Provider=SQLOLEDB;Data Source=PHYSICS\SQLEXPRESS;Persist Security Info=true;Initial Catalog=master;Integrated Security=True; provider = SQLOLEDB;";
        _connectionobject.Open();
        //Command
        var _commandObject = new SqlCommand();
        _commandObject.CommandText = "select * from dbo.tblStudent";
        //Execute 
        _commandObject.ExecuteReader();
        //Data
        var _dataReader = _commandObject.ExecuteReader();

        DataTable obj2 = new DataTable();
        obj2.Load(_dataReader);
        _connectionobject.Close();
        return obj2;


    }

}}

<div class="form-group">
    <input type="file" class="btn btn-default btn-file" style="width:70%" id="file" name="file" />
    <input type="button" value="Upload" class="btn btn-primary uploadbtn" id="uploadimg" name="upladimage" />
    <img class="wait hide" id="wait" src="/Content/img/pleasewait .gif" />
    You can upload the only image file.
</div>

$("#imgurl").keyup(
                function () {
                    $("#pmainimg").attr("src", $("#imgurl").val());
                });
 //$('#file').on('change', function (e) {
        //    files= $(this).get(0).files[0];
        //    alert(files);
        //});

        $(document).on('click', '#uploadimg', function () {

            if (window.FormData !== undefined) {
                var fileUpload = $("#file").get(0);
                var files = fileUpload.files;
                // Create FormData object
                var fileData = new FormData();

                // Looping over all files and add it to FormData object


                // Adding one more key to FormData object
                if ($("#file").val()!='') {
                    fileData.append(files[0].name, files[0]);

                    $("#wait").removeClass("hide");
                    $("#wait").addClass("show");
                    $.ajax({
                        url: '/Member/UploadImage',
                        type: "POST",
                        contentType: false, // Not to set any content header
                        processData: false, // Not to process data
                        data: fileData,
                        success: function (result) {
                            if (result.indexOf("http") > -1) {
                                $("#imgurl").val(result);
                                $("#pmainimg").attr("src", $("#imgurl").val());
                                $("#wait").removeClass("show");
                                $("#wait").addClass("hide");
                            }
                            else {
                                debugger;

                                $("#errormsg").html("You can upload the only image file.");
                                $("#errormsg").css("display", "inline");
                                $("#errormsg").css("color", "red");

                                $("#wait").removeClass("show");
                                $("#wait").addClass("hide");
                            }
                            // alert(result);

                        },
                        error: function (err) {
                            alert("Image Not Supported");
                            $("#wait").removeClass("show");
                            $("#wait").addClass("hide");
                        }
                    });
                }
                else
                {
                    $("#errormsg").html("You have not specified a image file.");
                    $("#errormsg").css("display", "inline");
                    $("#errormsg").css("color", "red");
                    $("#wait").removeClass("show");
                    $("#wait").addClass("hide");

                }
            } else {
                alert("FormData is not supported.");
            }
        });

{    
[UserLoginRequired]
    public class MemberController : ClickMSGController
    {
        public ActionResult CreateMessage()
        {
            return View();
        }

        public ExpandoObject CreateMessageObject(string ctatitle, string msgtitle, string msgbody, string imgurl,
            string linkurl, string linktxt, string reply1, string reply2, string msgname)
        {
            //Construct the JSON Object, from the inner levels towards the outer
            dynamic button1 = new ExpandoObject();
            button1.type = "web_url";
            button1.url = linkurl;
            button1.title = linktxt;

            dynamic button2 = new ExpandoObject();
            button2.type = "postback";
            button2.title = ctatitle;
            button2.payload = Guid.NewGuid().ToString();

            dynamic element = new ExpandoObject();
            element.title = msgtitle;
            element.image_url = imgurl;
            element.subtitle = msgbody;
            element.buttons = new List<object> { button1, button2 };

            dynamic payload = new ExpandoObject();
            payload.template_type = "generic";
            payload.elements = new List<object> { element };

            dynamic attachment = new ExpandoObject();
            attachment.type = "template";
            attachment.payload = payload;

            dynamic message = new ExpandoObject();
            message.attachment = attachment;

            dynamic fbmsg = new ExpandoObject();
            fbmsg.message = message;

            if (!string.IsNullOrEmpty(reply1) && !string.IsNullOrEmpty(reply2))
            {
                //Replies
                dynamic reply1obj = new ExpandoObject();
                reply1obj.content_type = "text";
                reply1obj.title = reply1;
                reply1obj.payload = reply1;

                dynamic reply2obj = new ExpandoObject();
                reply2obj.content_type = "text";
                reply2obj.title = reply2;
                reply2obj.payload = reply2;

                fbmsg.message.quick_replies = new List<object> { reply1obj, reply2obj };
            }

            return fbmsg;
        }

        public ActionResult GetJson(string ctatitle, string msgtitle, string msgbody, string imgurl,
            string linkurl, string linktxt, string reply1, string reply2, string msgname)
        {
            ExpandoObject msgObject = CreateMessageObject(ctatitle, msgtitle, msgbody, imgurl, linkurl, linktxt, reply1, reply2, msgname);

            if (Request.Form["savebtn"] == "Save & Get JSON")
            {
                AdManager.Ad ad = new AdManager.Ad();
                ad.AdName = msgname;
                ad.CallToAction = ctatitle;
                ad.Image_URL = imgurl;
                ad.LinkButtonText = linktxt;
                ad.LinkButtonURL = linkurl;
                ad.Reply1 = reply1;
                ad.Reply2 = reply2;
                ad.Subtitle = msgbody;
                ad.Title = msgtitle;
                ad.UserID = CurrentUser.ID;

                AdManager.AddAd(ad);
            }
            ViewBag.Json = Newtonsoft.Json.JsonConvert.SerializeObject(msgObject);

            return View("result");
        }

        public ActionResult Dashboard()
        {
            return View();
        }

        public ActionResult ManageMessages()
        {
            List<AdManager.Ad> ads  = AdManager.GetAdsForUser(CurrentUser.ID);
            ViewBag.Ads = ads;

            return View();
        }

        public ActionResult EditAd(int ad)
        {
            AdManager.Ad adv = AdManager.GetAd(ad);
            ViewBag.Ad = adv;

            return View();
        }

        [HttpPost]
        public ActionResult UpdateAd(string ctatitle, string msgtitle, string msgbody, string imgurl,
       string linkurl, string linktxt, string reply1, string reply2, string msgname,int adid)
        {
            ExpandoObject msgObject = CreateMessageObject(ctatitle, msgtitle, msgbody, imgurl, linkurl, linktxt, reply1, reply2, msgname);

            AdManager.Ad ad = new AdManager.Ad();
            ad.AdName = msgname;
            ad.CallToAction = ctatitle;
            ad.Image_URL = imgurl;
            ad.LinkButtonText = linktxt;
            ad.LinkButtonURL = linkurl;
            ad.Reply1 = reply1;
            ad.Reply2 = reply2;
            ad.Subtitle = msgbody;
            ad.Title = msgtitle;
            ad.UserID = CurrentUser.ID;
            ad.ID = adid;

            AdManager.UpdateAd(ad);

            ViewBag.Json = Newtonsoft.Json.JsonConvert.SerializeObject(msgObject);

            return View("result");
        }

        public ActionResult UpdateAd(int Ad)
        {
            ViewBag.Ad= AdManager.GetAd(Ad);
            return View();
        }

        public ActionResult Delete(int Ad)
        {
          
            ViewBag.DeletedAd = AdManager.DeleteAd(Ad);
            List<AdManager.Ad> ads = AdManager.GetAdsForUser(CurrentUser.ID);
            ViewBag.Ads = ads;
            return View("ManageMessages");
        }

        public ActionResult Settings()
        {
            return View();
        }

        public ActionResult Help()
        {
            return View();
        }
    }
}