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() + ",";
}
}