c# - "Cannot perform '=' operation on System.Int32 and System.String" while performing a search -


trying search through datalist, parameters being movie genres (loaded through database, no switch case) , name

protected void buttonfilter_click(object sender, eventargs e)     {         string filter = "";         int selectedcount = 0;         (int = 0; < this.checkboxlistgenres.items.count; i++)             if (this.checkboxlistgenres.items[i].selected)                 selectedcount++;         if (selectedcount > 0)         {             filter = "genreid=";             int n = 0; //used determine genre loop has arrived             (int = 0; < this.checkboxlistgenres.items.count; i++)             {                 if (this.checkboxlistgenres.items[i].selected)                 {                     if (n > 0 && n < selectedcount)                         filter += " , ";                     filter+="'*"+this.checkboxlistgenres.items[i].value.tostring()+"*'";                     n++;                  }             }              if (this.textboxmoviename.text!="")                 filter += " , moviename '*" + this.textboxmoviename.text + "*'";             datatable datatable = ((dataset)application["datasetmovies"]).tables[0];             dataview dataview = new dataview(datatable);             filter = convert.tostring(filter);             dataview.rowfilter = filter; //!getting error here!             this.datalistmovies.datasource = dataview;             this.datalistmovies.databind();         }     } 

tried debugging, string seems fine, tried using convert.tostring() on filter, make sure doesn't matter. help?

thanks in advance

this not compile time error runtime error.

well in database thing applying filter type of int32..

for example if have num , of int32 somthing below :-

dv.rowfilter = "num = '7097'" ////this have error 

it throw error because require :-

dv.rowfilter = "num = 7097" ////this correct 

so in case have genreid of int32 in code providing string against it.


Comments

Popular posts from this blog

Magento/PHP - Get phones on all members in a customer group -

php - .htaccess mod_rewrite for dynamic url which has domain names -

Website Login Issue developed in magento -