user3196511 user3196511 - 3 months ago 35
ASP.NET (C#) Question

DataView.RowFilter in DataTable does not return filtered records

I have a DataTable dt, in which 1200 records are coming.
Below is the code:

DataTable dt = new DataTable();
dt = GetAccCode(c);


Now, using DataView I want to filter the record of dt, based on 1 column.
Below is the code:

EDITED

DataView dv = new DataView(dt);
dv.RowFilter = "AccountDescription LIKE '" + e.Text + "' " ;
dv.RowFilter = "Isnull(AccountDescription,'NULL') <> 'NULL'";

//dv.RowStateFilter = DataViewRowState.ModifiedCurrent;
if (dv.Count > 0)
{
dt = dv.ToTable();
}


Full Code:

C# CODE:

private const int ItemsPerRequest = 50;

private static string GetStatusMessage(int offset, int total)
{
if (total <= 0)
return "No matches";

return String.Format("Items <b>1</b>-<b>{0}</b> out of <b>{1}</b>", offset, total);
}

public DataTable GetTable()
{
// columns.
DataTable table = new DataTable();
table.Columns.Add("AccountCodeID", typeof(Guid));
table.Columns.Add("AccountDescription", typeof(string));
// DataRows.
table.Rows.Add(Guid.NewGuid(), "9830.58578 Furniture&Food counter ");
table.Rows.Add(Guid.NewGuid(), "09.323232 New-release add ons");
table.Rows.Add(Guid.NewGuid(), "84.238799 G&D - Depot from Outerjoin");
table.Rows.Add(Guid.NewGuid(), "141.44445043-Random&Access-Memory hydero 048kkjug ");
table.Rows.Add(Guid.NewGuid(), "142.85223 Account's hyqure");
table.Rows.Add(Guid.NewGuid(), "324.989384934 F&D Admin-Dept Working ");
table.Rows.Add(Guid.NewGuid(), "77.234434 Unique's Question why not's so");
return table;
}

protected void ddlAccountCode_ItemsRequested(object sender, RadComboBoxItemsRequestedEventArgs e)
{
string c = ddlCompany.SelectedValue.ToString();

DataTable dt = GetTable();
DataView dv = new DataView(dt);
string searchParamText = e.Text;
dv.RowFilter = string.Format("AccountDescription LIKE '%{0}%'", searchParamText);
//dv.RowStateFilter = DataViewRowState.ModifiedCurrent;

int a = dv.Count;
if (dv.Count > 0)
{
dt = dv.ToTable();
}

RadComboBox combo = (RadComboBox)sender;

int itemOffset = e.NumberOfItems;
int endOffset = Math.Min(itemOffset + ItemsPerRequest, dt.Rows.Count);
e.EndOfItems = endOffset == dt.Rows.Count;

for (int i = itemOffset; i < endOffset; i++)
{
combo.Items.Add(new RadComboBoxItem(dt.Rows[i]["AccountDescription"].ToString(), dt.Rows[i]["AccountDescription"].ToString()));
}

e.Message = GetStatusMessage(endOffset, dt.Rows.Count);
}


HTML Code:

<EditItemTemplate>
<asp:Label ID="lblAcCode2" runat="server" Text='<%# Eval("AccountCode") + " - " + Eval("AccountDescription")%>' Visible="false">
</asp:Label>

<telerik:RadComboBox ID="ddlAccountCode" runat="server" Height="200" Width="240" DropDownWidth="310" HighlightTemplatedItems="true" CausesValidation="true" OnItemsRequested="ddlAccountCode_ItemsRequested" ItemsPerRequest="10" EnableLoadOnDemand="True" ShowMoreResultsBox="true" EnableVirtualScrolling="true" Filter="Contains" AppendDataBoundItems="true" DataTextField="AccountDescription" DataValueField="AccountCodeID">
</telerik:RadComboBox>

</EditItemTemplate>


But everytime dt returns all 1200 records not the filtered record.

Requirement: When I click on RadComboBox, it goes into
_ItemRequested
event. I want that when I search any record in RadComboBox, and if the record is there in DataTable then it shall goto
GetStatusMessage
ELSE part, or if the searched record is not there in DataTable then it shall goto
GetStatusMessage
IF part.

To get the searched record of RadComboBox from DataTable, I am using DataView.RowFilter method but everytime when I type any text in RadCombo, it never return the searched value and always show DataView.Count =0

Please reply how to solve this issue. I am stuck from 2 days in it.

Answer

I was using below code before but it was not working. Now it suddenly started working:

        DataTable dt = GetAccCode(c);
        DataView dv = new DataView(dt);
        string txt = e.Text;
        dv.RowFilter = string.Format("AccountDescription LIKE '%{0}%'", txt);       
        int a = dv.Count;
        if (dv.Count > 0)
        {
            dt = dv.ToTable();
        }

Problem resolved. Thank you for the help @Mohit Shrivastava