Question How to write SQL Statement?

[Adrian87]

how to use the SQL statement to retrieve from database, without using wizard, how?

 

[kulrom]

say that you want retrieve data from the table employees

Dim connection As New SqlConnection("connectionstring")
Dim command As SqlCommand = connection.CreateCommand
command.CommandText = "SELECT * FROM employees"
Dim table as New DataTable
connection.Open
table.Load(command.ExecuteReader(CommandBehavior.CloseConnection))
Me.GridView1.DataSource = table
Me.GridView1.DataBind