public DataSet BindGrid(Gridformsetup GP) { try { _cn.Open(); SqlCommand _cmd = new SqlCommand("Sp_Grid_Form_Master", _cn); _cmd.CommandType = CommandType.StoredProcedure; _cmd.Parameters.AddWithValue("@tablename", GP.tablename); _cmd.Parameters.AddWithValue("@Corporate", GP.Corporate); _cmd.Parameters.AddWithValue("@unit", GP.unit); _cmd.Parameters.AddWithValue("@userid", GP.userid); _cmd.Parameters.AddWithValue("@WhereClause", GP.WhereClause); _cmd.Parameters.AddWithValue("@Branch", GP.Branch); _cmd.Parameters.AddWithValue("@PageNo", GP.PageNo); _cmd.Parameters.AddWithValue("@RecordsPerPage", GP.RecordsPerPage); _cmd.Parameters.AddWithValue("@Formcode", GP.Formcode); _cmd.Parameters.AddWithValue("@Formtabcode", GP.Formtabcode); _cmd.Parameters.AddWithValue("@type", GP.type); _cmd.CommandType = CommandType.StoredProcedure; SqlDataAdapter _adp = new SqlDataAdapter(_cmd); DataSet _ds = new DataSet(); _adp.Fill(_ds); _adp.Dispose(); _cmd.Dispose(); return _ds; } catch (Exception ex) { throw ex; } finally { _cn.Close(); _cn.Dispose(); } }
public ActionResult BindGridViewColumn(Gridformsetup GP) { try { DataSet ds = _objDBViewSetup.BindGridColumn(GP); List<ColumnGridDisplay> items = new List<ColumnGridDisplay>(); if (ds.Tables[0].Rows.Count > 0) { ViewBag.fname = ds.Tables[0]; foreach (System.Data.DataRow dr in ViewBag.fname.Rows) { items.Add(new ColumnGridDisplay { RowNumber = dr["RowNumber"].ToString(), ColumnCaption = dr["ColumnCaption"].ToString(), ColumnName = dr["ColumnName"].ToString(), UpdateControl = dr["UpdateControl"].ToString(), srno = dr["Srno"].ToString(), }); } } var result = items; var rJson = Json(result, JsonRequestBehavior.AllowGet); rJson.MaxJsonLength = int.MaxValue; return rJson; } catch (Exception) { throw; } }
public ActionResult BindGridView(Gridformsetup GP) { try { DataSet ds = _objDBViewSetup.BindGrid(GP); List<GridViewsetup> items = new List<GridViewsetup>(); if (ds.Tables[0].Rows.Count > 0) { ViewBag.fname = ds.Tables[0]; foreach (System.Data.DataRow dr in ViewBag.fname.Rows) { items.Add(new GridViewsetup { RowNumber = dr["RowNumber"].ToString(), Corporate = dr["Corporate"].ToString(), Screen = dr["Screen"].ToString(), Module = dr["Module"].ToString(), FormName = dr["FormCode"].ToString(), Tab = dr["TabCode"].ToString(), View = dr["ViewName"].ToString(), srno = dr["Srno"].ToString(), }); } } var result = items; var rJson = Json(result, JsonRequestBehavior.AllowGet); rJson.MaxJsonLength = int.MaxValue; return rJson; } catch (Exception) { throw; } }