Im building an application and I keep getting a syntax error. Can anyone spot it?
Private Sub btnSearch_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSearch.Click
ds = New DataSet
da = New MySqlDataAdapter("SELECT from cost where item='" & txtSItem.Text & "', world='" & txtSWorld.Text & "')'", sqlcon)
da.Fill(ds, "cost")
Call showData()
End Sub
Private Sub btnSearch_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSearch.Click
ds = New DataSet
da = New MySqlDataAdapter("SELECT from cost where item='" & txtSItem.Text & "', world='" & txtSWorld.Text & "')'", sqlcon)
da.Fill(ds, "cost")
Call showData()
End Sub