i'm not big in vb, but the datasource should be some sort of collection not a string. therefore, you need to execute your strSQL and put it into a collection of some type... then you'll probably need to bind the collection to the control depending on what you want to do...
Protected Sub Page_Load(ByVal sender As Object, _
ByVal e As System.EventArgs) Handles Me.Load
If Not Page.IsPostBack Then
'Start by determining the connection string value
Dim connString As String = _
ConfigurationManager.ConnectionStrings(connStringName).ConnectionString
'Create a SqlConnection instance
Using myConnection As New SqlConnection(connString)
'Specify the SQL query
Const sql As String = "SELECT * FROM Customers"
'Create a SqlCommand instance
Dim myCommand As New SqlCommand(sql, myConnection)
'Get back a DataSet
Dim myDataSet As New DataSet
'Create a SqlDataAdapter instance
Dim myAdapter As New SqlDataAdapter(myCommand)
myAdapter.Fill(myDataSet)
'Bind the DataSet to the GridView
gvCustomers.DataSource = myDataSet
gvCustomers.DataBind()
'Close the connection
myConnection.Close()
End Using
End If
End Sub
i also agree with the other commenter about your SQL... LIKE 'Damage' means exactly like 'Damage' without wilcards (% for SQL, * for Access)