$(".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();
}
}