How to show all record from database using c#

Question

i have use following qyery but when i click on button it return only one row from database i need to returns all row which contain [e-mail] any one can help
"select * from DBname where email = "[e-mail]"

Answer 1

The where clause selects a single record or more if more records have the same e-mail.

You need
"select e-mail from DBname"

To select the columnname and all the records

Answer 2

i use the exact syntax you have in my code, to return all matching rows. if you are passing to something that cant handle more than one result, you will only get one result.
also, watch for typos. if your query contains a typo, it wont complain.

i dont have experience with sql, but rather sqlite.

can you give more detail on your example code?

i use:
"SELECT * FROM DBname WHERE ColumnName = '" + StringVar + "'";
and it works for me. i pass the result to a datatable.