title: SQLite SELECT from VB.Net application (Win32)
body: <p>I am trying to get a result from SQL database and keep it as a variable. But with my code (see below) it returns 0 (zero). Any ideas of what am i doing wrong?</p>
  
  <p>Thanks</p>
  
  <pre><code>Function getName(name As String)
      Dim SQLconnect As New SQLite.SQLiteConnection()
      Dim SQLcommand As SQLite.SQLiteCommand
  
      SQLconnect.ConnectionString = "Data Source=C:\tools\names.sqlite;"
      SQLconnect.Open()
  
      SQLcommand = SQLconnect.CreateCommand
  
      SQLcommand.CommandText = "SELECT * FROM names WHERE name = " &amp; name &amp; " LIMIT 1;"
      Dim sqlResponse As String = SQLcommand.ExecuteNonQuery()
  
  
  End Function
  </code></pre>
  
  <p>EDIT: I am using "return sqlResponse" for return</p>