i got error in this code is invallide colums name but i chek all colums name are right in data base so what i change in this code???
(Answering in your terms now, forget our suggestions[^])
Based on what you say, your query just asks for one column. So, based on error, look for 2 things:
1. You have a column named 'cat' in your table 'data1'
2. Make sure your query formed is correct and fetches data if you paste it in your SQL directly. For now, I see an issue already pointed earlier, based on names 'up' is a string and the way you pass it to SQL is an int datatype. You need to put single quotes around the value passed for supplier . Correct it to:
GridView1.DataSource = obj.selectmultiple("select distinct cat from data1 where supplier='"+up+"'")
Now, don't repost again. Verify 1 & 2, share your result to move ahead.