public void dtbindpending(DevExpress.Web.ASPxGridView gridpending) { DataTable dt = conn.GetDataTable(sqlpending2, null, dbtimeout); DataView dv = new DataView(dt); dv.Sort = sqlsortby; gridpending.DataSource = dv; gridpending.DataBind(); }
private void gridbind_lending(DevExpress.Web.ASPxGridView Grid, string category) { string key = reffnumber.Text; object[] par = new object[] { key, category }; DataTable dt = conn.GetDataTable(Q_VW_LENDING, par, dbtimeout); Grid.DataSource = dt; Grid.DataBind(); }
protected void LoadDxGrid(DevExpress.Web.ASPxGridView g, DataTable dt) { //// extract the current grouping //string currentGroupBy = g.GroupBy; g.DataSource = dt; //// resetting the GroupBy //g.GroupBy = currentGroupBy; // rebinding the Grid g.DataBind(); }
public void dtbindpending(DevExpress.Web.ASPxGridView gridpending) { DataTable dt = conn.GetDataTable(sqlpending2, null, dbtimeout); DataView dv = new DataView(dt); dv.Sort = sqlsortby; gridpending.DataSource = dv; gridpending.DataBind(); hALL.Value = ""; for (int i = 0; i < dt.Rows.Count; i++) { hALL.Value += dt.Rows[i]["__KEY"].ToString() + ","; } }