Webdatagrid, Filtering and ObjectDatasource - Need URGENT help.

State Not Answered
Replies 7 replies
Subscribers 9 subscribers
Views 7196 views
Users 0 members are here

395

Webdatagrid, Filtering and ObjectDatasource - Need URGENT help.

Bebu posted over 12 years ago

I have a webdatagrid which gets bind by the select method of objectdatasource when I click the label.

My webdatagrid opens in a panel.

Look at the code below for the bind of grid.

ViewState["FromDay"] = FromDay;

ViewState["ToDay"] = ToDay;

gv.DataSourceID = objGV.ID;

gv.DataBind();

//get the total no of records gv.Behaviors.Paging.Enabled = false;

lblTotalCount.Text = HttpContext.Current.Session["TOTAL_CountROWS"].ToString();

// gv.Rows.Count.ToString();

gv.Behaviors.Paging.Enabled = true;

if (ViewState["LNK"] != null && ViewState["LNK"].ToString() == lnkbtn.ID)

{ row.Visible = !row.Visible; }

Now when I filter the webdatagrid and close the panel,and again click the label which binds the webdatagrid, the grid is not getting refreshed.

Please help.

I want to know how to refresh DatasourceID
gv.Behaviors.Filtering.ColumnFilters.Clear(); gv.Behaviors.Filtering.ColumnSettings.Clear(); gv.Behaviors.Filtering.ClearBehaviorColumnInfo();
These above clears the filters but still the grid is not refreshed.

37874

[Infragistics] Nikolay posted over 12 years ago

Hi Bebu,

I would suggest you to try calling the ApplyFilters method after clearing the column filters:

WebDataGrid1.Behaviors.Filtering.ApplyFilter();

This should remove the filtering and the grid should display the whole datasource.

Please let me know if this helps.
Cancel
Reply

Cancel
395

Bebu posted over 12 years ago in reply to [Infragistics] Nikolay

Hey thanks for the reply.

That worked..

I have one more issue,

var RowCount = $find("").get_rows().get_length();

document.getElementById("").innerText = RowCount;

I want to show the total rows count of webdatagrid.

But due to filtering that is not happening.

get_length() only gives the rows depending on page size.

Please help.

I am calling the above event
Cancel
Reply

Cancel
37874

[Infragistics] Nikolay posted over 12 years ago in reply to Bebu

Hi Bebu,

One possible approach would be to create additional property of the CustomAJAXResponse object of the grid for the number of rows in the datasource. Then in AjaxResponse client side event handler you could access this property to get the total number of rows:

protected void Page_Load(object sender, EventArgs e)

{

WebDataGrid1.CustomAJAXResponse.AdditionalProperties.Add("count", rowCount);

}

function AjaxResponseHandler(sender, args) {

var rowCount = args.get_gridResponseObject().AdditionalProperties.count;

}

Let me know if this helps.
Cancel
Reply

Cancel
37874

[Infragistics] Nikolay posted over 12 years ago in reply to [Infragistics] Nikolay

Hello Bebu,

If you have any other questions, please feel free to contact me.
Cancel
Reply

Cancel
395

Bebu posted over 12 years ago in reply to [Infragistics] Nikolay

Can you please explain in detail the code to get the rowcount. I tried to use this code but it is showing red line under rowcount in code behind. Please help and explain in detail so as to how to implement it and where.
Cancel
Reply

Cancel