var CellNo = $("#CellNo").val();
        var Designation = $("#designation_select_box").val();
        var Center = $("#center_select_box").val();

Dynamic div 

<script>

    $(document).ready(function () {

        var $sourceFields = $("#sourceFields");

        var $destinationFields = $("#destinationFields");

        var $chooser = $("#fieldChooser").fieldChooser(sourceFields, destinationFields);

       $.getJSON("Home/ItemDetails",

       function (json) {

           var res;

           var ItemDiv = $("#sourceFields");

           //Append each row to html table  

        for (var i = 0; i < json.length; i++) {

           

            //"<div>"

            //$('#sourceFields').html(json[i].item);

            //ItemDiv = "<div>" + json[i].item + "</div>";

            //$("<div/>").appendTo("div#ItemDiv");

            $("<div>" + json[i].item + "</div>").appendTo("#sourceFields");

            //ItemDiv.html('');

            //ItemDiv.html(json[i].item);

           // alert(ItemDiv);

        //    alert(ItemDiv);

        ////tr = $('<tr/>');

        //tr.append("<td>" + json[i].Id + "</td>");

        //tr.append("<td>" + json[i].Name + "</td>");

        //tr.append("<td>" + json[i].City + "</td>");

        //tr.append("<td>" + json[i].Address + "</td>");

        //$('table').append(tr);

    }

});

       $('#btnSave').click(function () {

       });

    });

    //function SaveItems() {

    //    alert('1');

    //    var ItemDiv2 = $("#destinationFields");

    //    //Append each row to html table  

    //    alert(ItemDiv.length);

    //}

</script>

<div id="fieldChooser" tabindex="1">

    <div id="sourceFields">

        

   

    

    

        @*<div>Item1</div>

        <div>Item2</div>

        <div>Item3</div>

        <div>Item4</div>

        <div>Item5</div>

        <div>Item6</div>

        <div>Item7</div>

        <div>Item8</div>*@

    </div>

    <div id="destinationFields">

    </div>

    <input type="button" value="Submit" id="btnSave" />

    @*<input type="button" value="Submit" onclick="SaveItems();" id="btnSave" />*@

</div>

/////////////////////////////////////////////

[HttpGet]

        public JsonResult ItemDetails()

        {

            List<ItemModel> ObjEmp = new List<ItemModel>()  

        {  

            new ItemModel  

            {  

                item = "Test1"  

            },  

            new ItemModel  

            {  

                item = "Test2"  

            },

             new ItemModel  

            {  

                item = "Test3"  

            },  

            new ItemModel  

            {  

                item = "Test4"  

            }  

        };

            

            return Json(ObjEmp, JsonRequestBehavior.AllowGet);

        }

//

Procedure Example

CREATE Procedure [dbo].[ECS_GetProductList_SP]
as
Select distinct SLS_PackageDetail_TB.Price,SLS_PackageDetail_TB.Price as [TotalAmount],SLS_PackageDetail_TB.Quantity,SLS_PackageDetail_TB.Product_Id ,
ORA_Products_TB.name,SLS_B_TaxPercentage_TB.TaxPercentage
Into #TemMyProductList
From SLS_PackageDetail_TB 
INNER JOIN ORA_Products_TB on SLS_PackageDetail_TB.Product_Id = ORA_Products_TB.Id 
Inner Join SLS_B_TaxDetail_TB On ORA_Products_TB.ID=SLS_B_TaxDetail_TB.Product_Id
Inner Join SLS_B_TaxPercentage_TB on SLS_B_TaxDetail_TB.Tax_ID=SLS_B_TaxPercentage_TB.id
where  SLS_PackageDetail_TB.Active='y' and
SLS_PackageDetail_TB.Active='Y' AND SLS_B_TaxDetail_TB.Active='y' AND ORA_Products_TB.Active='y'
order by ORA_Products_TB.name,SLS_PackageDetail_TB.Quantity asc
Select ROW_NUMBER() over (ORDER BY name) AS ID,* From #TemMyProductList

Drop Table #TemMyProductList

............

CREATE Procedure [dbo].[Ecs_ChangePinCode_Sp]

(@NicNo varchar(25),@ContactNumber varchar(15),

@OldPinCode varchar(6),@NewPincode varchar(6))

as

If Exists (Select sct.NIC_No,scnt.ContactNumber From SLS_ContactNumbers_TB scnt Inner Join SLS_Contact_TB sct on scnt.Contact_Id=sct.Id 

   where sct.NIC_No=@NicNo and scnt.ContactNumber=@ContactNumber and scnt.Pincode=@OldPinCode)

   Begin

   Update SLS_ContactNumbers_TB Set PinCode=@NewPincode where ContactNumber=@ContactNumber

   Select 1 as [Status],'Pincode Has been Changed'  as [Message]

   End

   Else

   Begin

   Select 0 as [Status],'Provide valid CellNo/Nic/OldPin' as [Message]

   End