how to select record in database

For all records from the database you can use

select * from table_name

for a specific column you can use

select clumn_name from table_name 

for a specific column in a specific condition you can use a 'where' clause

select Column_name from table_name where column_name=value

like below example

select name from Customer where ID='1234567890'

Hi,
Select Command:

Select * From table_name --select all data directly from the table
Select Column_name from table_name --select particular column from the table

Ref:
Try this article : Insert, Update, Delete, Display Data in MySQL Using C#

Select Column_Name From Table Name

If We Want All Filed display in Table Just Use Following Query

select * From Table_Name

Did you try this code? It uses Web Pages version of the code to select a record from the database.

Works fine in .cshtml files of ASP.NET

var db = Database.Open("database_name");
var record = db.Query("SELECT * FROM table_name WHERE column_name = @0", parameter);

Now wherever the value would be true, the result would be returned. A real example of this case is, WHERE UserId = @0", 20, to select the profile of user with UserId 20.