Friday 26 April 2013

pass array in ajax and get in asp.net webmethod

     $(".SaveDataArray").live("click", function () {


                var mydata = new Array();
                mydata.push({ "name": "tablename", "value": "pranay" });



                $.ajax({
                    type: "GET",
                    url: "Default.aspx/Arraysave",
                    data: mydata,
                    contentType: "application/json;charset=utf-8",
                    dataType: "json",
                    success: function (value) {
                    },
                    error: function () {
                    }
                });
            });


        });






using System;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Web.Script.Serialization;
using System.Web.Script.Services;
using System.Web.Services;


public partial class _Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        //FssSqlDB objdb = new FssSqlDB();
       // DataTable objdt = new DataTable();
      //  objdt = objdb.GetData("select * from user_mas");
     
        bindGrid();

     
    }


    public void bindGrid()
    {
        REGISTRATIONDataContext objDB = new REGISTRATIONDataContext();
        var listuser = (from p in objDB.REGISTRATIONs
                       select p).ToArray();
     
        if (listuser != null)
        {
            if (GridViewSortDirection == SortDirection.Ascending)
            {
                GridView1.DataSource = listuser.OrderBy(x => x.GetType().GetProperty(GridViewSortExpression).GetValue(x, null)).ToList();
            }
            else
            {
                GridView1.DataSource = listuser.OrderByDescending(x => x.GetType().GetProperty(GridViewSortExpression).GetValue(x, null)).ToList();
            };
        }
        else
        {
            GridView1.DataSource = null;
        }
        //GridView1.DataSource = listuser;
        GridView1.DataBind();
    }

    [System.Web.Script.Services.ScriptMethod(ResponseFormat=ResponseFormat.Json)]
    [WebMethod]
    public static string getdata()
    {
        return "pranay soni";
    }

 


        [System.Web.Script.Services.ScriptMethod(ResponseFormat = ResponseFormat.Json,UseHttpGet=true)]
    [WebMethod]
     public static string Arraysave()
     {
         REGISTRATIONDataContext objDB = new REGISTRATIONDataContext();
         REGISTRATION objreg = new REGISTRATION();

         string sd = HttpContext.Current.Request["tablename"].ToString();
       
         return "Save Data";
     }


    [System.Web.Script.Services.ScriptMethod(ResponseFormat = ResponseFormat.Json,UseHttpGet=true)]
    [WebMethod(EnableSession= true)]
    public static string my()
    {
        return "df";
    }



    [System.Web.Script.Services.ScriptMethod(ResponseFormat = ResponseFormat.Json)]
    [WebMethod]
     public static string savedata(string txtName,string txtAddress,string txtAge)
     {
         REGISTRATIONDataContext objDB = new REGISTRATIONDataContext();
         REGISTRATION objreg = new REGISTRATION();
         objreg.NAME = txtName;
         objreg.ADDRESS = txtAddress;
         objreg.AGE = Convert.ToInt32(txtAge);
         objDB.REGISTRATIONs.InsertOnSubmit(objreg);
         objDB.SubmitChanges();
         return "Save Data";
     }

    [System.Web.Script.Services.ScriptMethod(ResponseFormat = ResponseFormat.Json)]
    [WebMethod(EnableSession=true)]
 
    public static string Update(string txtName, string txtAddress, string txtAge,string ID)
    {
        REGISTRATIONDataContext objDB = new REGISTRATIONDataContext();
        //REGISTRATION objreg = new REGISTRATION();
        var updated = (from p in objDB.REGISTRATIONs
                       where p.ID == Convert.ToInt32(ID)
                       select p).SingleOrDefault();
   

        updated.NAME = txtName;
        updated.ADDRESS = txtAddress;
        updated.AGE = Convert.ToInt32(txtAge);
        objDB.SubmitChanges();
        return "update";
    }


    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        string id =  Convert.ToString(GridView1.DataKeys[e.RowIndex].Value);

        REGISTRATIONDataContext objDB = new REGISTRATIONDataContext();
        REGISTRATION objReg = new REGISTRATION();
        var Deletselected = (from p in objDB.REGISTRATIONs
                             where p.ID == Convert.ToInt64(id)
                             select p).SingleOrDefault();
        objDB.REGISTRATIONs.DeleteOnSubmit(Deletselected);
        objDB.SubmitChanges();
        bindGrid();
    }
    protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        GridView1.PageIndex = e.NewPageIndex;
        bindGrid();
    }

    public string GridViewSortExpression
    {
        get
        {
          return ViewState["GridViewSortExpression"] == null ? "NAME":ViewState["GridViewSortExpression"] as string;    
        }
        set
        {
            ViewState["GridViewSortExpression"] = value;
        }
    }

    public SortDirection GridViewSortDirection
    {
        get
        {
            if (ViewState["sortDirection"] == null)
                ViewState["sortDirection"] = SortDirection.Ascending;
            return (SortDirection)ViewState["sortDirection"];
        }
        set {
            ViewState["sortDirection"] = value;
        }
    }

 
    protected void GridView1_Sorting(object sender, GridViewSortEventArgs e)
    {

        GridViewSortExpression = e.SortExpression;
        if (GridViewSortDirection == SortDirection.Ascending)
        {
            GridViewSortDirection = SortDirection.Descending;
        }
        else
        {
            GridViewSortDirection = SortDirection.Ascending;
        };
        bindGrid();
    }
    protected void LinkBtnSelect_Click(object sender, EventArgs e)
    {

    }
    protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
    {
        Int32 SrNo = Convert.ToInt32(GridView1.DataKeys[e.NewEditIndex].Value);
        REGISTRATIONDataContext objDB = new REGISTRATIONDataContext();
        REGISTRATION objreg = new REGISTRATION();

        var selected = (from p in objDB.REGISTRATIONs
                        where p.ID == SrNo
                        select p).SingleOrDefault();
        txtAddress.Value = selected.ADDRESS;
        txtAge.Value = selected.AGE.ToString();
        txtName.Value = selected.NAME;
        id.Value = selected.ID.ToString();
        btnRegis.Value = "Update";
    }

 

    protected void Button2_Click1(object sender, EventArgs e)
    {
     
        GridViewRow gvrow = (GridViewRow)(sender as Control).Parent.Parent;
        int index = gvrow.RowIndex;
        string df = GridView1.DataKeys[index]["ID"].ToString();
    }
}


No comments:

Post a Comment