Filtering DataTable Problem

Question

0.00/5 (No votes)

See more:

Hi I'm developing a page which when loads is populated with a grid view which contains data. Along with this the user is presented with drop down list to be able to filter the data. Below is an example of some code.

protected void ddlSite_SelectedIndexChanged(object sender, EventArgs e)
        {
            DataTable dtWorksOrderSummary = new DataTable();
            ReportBC reportBC = new ReportBC();

            DataSet ds = new DataSet();

            ds = reportBC.GetWorksOrderSummary(AccountID.Value);
            dtWorksOrderSummary = ds.Tables[0];
           
            gvWorksOrderSummary.DataSource = dtWorksOrderSummary.Select("Site=" + ddlSite.SelectedItem.Text);
            gvWorksOrderSummary.DataBind();
        }

On page load the data returned from ReportBC is used as a data source for the grid view. I have been told that to be able to filter the data it would be simpler to use a data table, then bind the data table to the grid view.
When I try to run the code I get this error "Syntax error: Missing operand after 'Oxford' operator."
Not sure if I have explained this very clearly, but can anyone explain this error or point me in the right direction on how I can achieve my goal.

Thanks

Posted 19-Jul-13 5:26am

RhysBush

Add a Solution

Comments

ZurdoDev 19-Jul-13 12:07pm

So, where is the code that gives that error?

RhysBush 23-Jul-13 4:15am

Was getting the error on the line
gvWorksOrderSummary.DataSource = dtWorksOrderSummary.Select("Site=" + ddlSite.SelectedItem.Text);
But I've played around with it and its working now.
Thanks guys

ZurdoDev 23-Jul-13 7:37am

You were missing single quotes around the value. Good to hear it is working now.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

User 8696850 · Answer 1 · 2013-07-19T07:28:00

Solution 1

try this to filter the data in the datagridview :

C#

protected void ddlSite_SelectedIndexChanged(object sender, EventArgs e)
        {
try{
  (dataGridView1.DataSource as DataTable).DefaultView.RowFilter = string.Format("column name that you need to filter = {0}"+ddlSite.Text);
}
catch{}
}

Posted 19-Jul-13 7:28am

User 8696850

Updated 19-Jul-13 7:29am

v2

Dave963 · Answer 2 · 2013-07-19T10:53:00

Solution 2

Just remember to put your data binding code in the page load method in a...

if(!Page.IsPostback)
{
//DataBinding code
}

To prevent your changes in the selectedindexchanged method from being over written

Posted 19-Jul-13 10:53am

Dave963