ASPxGridView和Linq常用总结（2）

 实现目标：使用js、Linq和ASPxGridView实现增删改数据
 1、查询(点击grd，赋值text)

//cs后台

引用using System.Web.Script.Serialization;

protected void Page_Load(object sender, EventArgs e)
        {
            //if (Session["LoginUser"] == null)
            //{
            //    Response.Write("<script>top.window.location.href('../login.aspx')</script>");
            //}
            Ajax.Utility.RegisterTypeForAjax(typeof(Driver));//注册Ajax
        }

//js页面可以使用此方法

 [Ajax.AjaxMethod(Ajax.HttpSessionStateRequirement.Read)]
        public string GetTableByKey(int iCode)
        {
            Tb_Table objTable = linqDataSource.Tb_Table .SingleOrDefault(p => p.ID == iCode);
            JavaScriptSerializer jscvt = new JavaScriptSerializer();
            string jsonobjTable  = jscvt.Serialize(objTable );
            return jsonobjTable ;
        }

//js页面

function getQueryTable() {
    var sId = grdView.GetRowValues(grdView.GetFocusedRowIndex(), 'ID;Name', QueryTable);
}

function QueryTable(values) {
    var key = values[0];
    if (key != null) {
        var objTable= 后台页面.GetTableByKey(key);
        if (objTable.value != "null") {
            objTable = eval('(' + objTable.value + ')');

            txt_DriverName.SetText(objTable.DriverName);
            txt_DriverName.SetIsValid(1);
            dte_DriverlicenseDateB.SetText(objTable.DriverlicenseDateB);
                 }
          }
    else {
      
        btnEdit.SetEnabled(false);
        btnDelete.SetEnabled(false);