Cannot perform '=' operation on System.String and System.Int32.

Question

I dont understand where this error is coming from, and why! basically I have a filtering by a certain piece of information in the database, below once I call the merge I get this error.
It only happens when im process a large amount of files in the database, but if I process to files in the database via data , and want to do a filter once it get to the merge it blows up,
I dont understand why

Cannot perform '=' operation on System.String and System.Int32.

   private void SetFilter()
        {
            Generic_DatatableBindingSource.Filter = TestOnly ? "IsTest = True" : "";
            if (tpmsn.Length > 0)
            {
                AddFilter("TestPositionMSN = " + tpmsn);
            }
            if (uutmsn.Length > 0)
            {
                AddFilter("UutMSN = " + uutmsn);
            }
        }

        private void AddFilter(string Filter)
        {
            if (Generic_DatatableBindingSource.Filter.Length == 0)
            {
                Generic_DatatableBindingSource.Filter = Filter;
            }
            else
            {
                Generic_DatatableBindingSource.Filter += " And " + Filter;
            }
        } // AddFilter(


       this.genericDataSet.Generic_Datatable.Merge(databaseDataSet.Test_Datatable);    it fails on this specific line

David Smith · Answer

I fix the filter problem it was truly a filter problem private void SetFilter() { Generic_DatatableBindingSource.Filter = TestOnly ? IsTest = True : ; if (tpmsn.Length > 0) { // AddFilter(TestPositionMSN =  + tpmsn); Incorrect AddFilter(TestPositionMSN = ' + tpmsn + '); Correct } if (uutmsn.Length > 0) { //AddFilter(UutMSN =  + uutmsn); Incorrect AddFilter(UutMSN = ' + uutmsn + '); Correct } }

Sam Hobbs · Answer

Are you sure that everything else is String? I think that IsTest is Boolean. Check to see what is correct syntax for Boolean literals.

Sam Hobbs · Answer

Okay well the  IsTest = True  is suspicious; we need to check if that is correct syntax.

David Smith · Answer

It hard to to determine I only get the error when I select the filter option and hit view report button to only view files or records related to the filter. So if I porcess over 15 files in the database and try to view the report  the error pops up  but i view all its fine. I search the tables I had in the dataset and all types match . the only System.Int32 is the ID or EventID which is correct. Everthing else is System.String So its hard to determine

Sam Hobbs · Answer

Look at the fields in genericDataSet.Generic_Datatable and in databaseDataSet.Test_Datatable; are you sure that the data types match? My guess is that you are using a string for a field in one table and int for the same field name in the other. I am not sure that Merge would give an error in that situation but if it does then that explains the error you are getting. If I am correct then the filter is not relevant to the problem.