i am using query like below. I dont want to repeat contactno records. Only user with one phoneno should be shown.. i am using query like below but it is giving error like You tried to execute a query that does not include the specified expression 'cust_name' as part of an aggregate function.
new OleDbCommand("Select contactno,cust_name,gender,age,address,profession,nationality from table1 group by contactno", con);