title: Visual Studio 2013 fill DataGrid
body: <p>I'm trying to read data from a SQLite database. Then I'd like to fill it into my DataGrid, but the following code doesn't work (<strong>dataUrl is the DataGrid-Object</strong>):</p>
  
  <pre><code>    string sql = "SELECT rowid, url FROM urls WHERE url LIKE '%@search%'";
      SQLiteConnection myConnection = new SQLiteConnection(@"Data Source=C:\URL Store\URL Store\bin\Release\urlStore.sqlite;Version=3;Password=*censored*;");
      SQLiteCommand command = new SQLiteCommand(sql, myConnection);
      command.Parameters.AddWithValue("@search", txtSearch.Text);
      myConnection.Open();
      command.ExecuteNonQuery();
      SQLiteDataAdapter adapter = new SQLiteDataAdapter(command);
      DataSet set = new DataSet();
      try
      {
          //            
          //ESPECIALLY THIS PART IS IMPORTANT TO ME
          //
          adapter.Fill(set);
          DataTable table = set.Tables[0];
          dataUrl.DataContext = table;
      }
      catch (Exception ex)
      {
          MessageBox.Show("Error loading data!");
      }
  </code></pre>
  
  <p>It does't even throw an exception.</p>