Filter Columns

headworth · January 6th, 2010, 09:32 AM

Can I have some help with this C#code

the problem is with "valueToUseAsAFilter" could advise what to use instead

Code:

bindingSource1.Filter = string.Format("MycolumnName = '{0}'", valueToUseAsAFilter);
            DataView Dv = new DataView(new_HomeDataSet.NHE, "EMPLOYEE_NAME", "column you will use to sort data", DataViewRowState.CurrentRows);

samjudson · January 6th, 2010, 09:37 AM

DO you get a specific exception? If so, telling what the actual 'problem' is would help rather than making us guess.

headworth · January 6th, 2010, 09:42 AM

Hi thank you for having a look
yes I get this error

Error 1 The name 'valueToUseAsAFilter' does not exist in the current context

samjudson · January 6th, 2010, 09:45 AM

So you don't have a variable called valueToUseAsAFilter? Well where are you storing the value you want to filter on?

headworth · January 6th, 2010, 10:03 AM

As i do not have varable i have changes valueToUseAsAFilter
to where the data source is = new_HomeDataSet
This is all my code hope you can help?

Code:

public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            this.tableAdapterManager1.Fill(this.new_HomeDataSet.NHE);
            
        }

        private void button1_Click(object sender, EventArgs e)
        {
            System.Data.OleDb.OleDbConnection dr;
            
            bindingSource1.Filter = string.Format("MycolumnName = '{0}'", new_HomeDataSet);
            DataView Dv = new DataView(new_HomeDataSet.NHE, "EMPLOYEE_NAME", "column you will use to sort data", DataViewRowState.CurrentRows);

System.NotImplementedException = System.NotImplementedException
The method or operation is not implemented.

samjudson · January 6th, 2010, 10:29 AM

No, that makes no sense. Which line are you getting the exception on? new_HomeDataSet is a DataSet object correct? How is passing that into String.Format going to produce a sensible value?

This code looks so bad I don't know where to start. Do you have a column in your data called 'MycolumnName'? What about the string "column you wioll use to sort data" = shouldn't that have been replaced by an actual column name?

Have you cut and paste this code from some web site? If so I suggest you go back to the web site and try and actually understand what the code is doing before trying to change it to work with your data.

January 7th, 2010, 02:20 AM

It wouldn't if you are working in filtered mode. You need to have all data displayed and then use filter again.
Where to Buy Lean Muscle X
Lean Muscle X