title: Qt / QTableView / SQLite how to connect?
body: <p>This is my first time Qt programming. I am to make an address book on relational database to keep track of calls and events, related to persons and companies. A simple home-made sales tool. I am in great need of it.</p>
  
  <p>Using Qt Designer I have created a main window and placed a <code>QTableView</code> widget. Installed SQLite, created a database. Now I need to connect it to the <code>QTableView</code>. I spent several hours, and still couldn't do it. </p>
  
  <p>Can someone please help?</p>
  
  <p>Thanks!</p>
  
  <p>Some code:</p>
  
  <p><code>untitled9.pro</code>:</p>
  
  <pre><code>#-------------------------------------------------
  #
  # Project created by QtCreator 2012-10-26T14:35:12
  #
  #-------------------------------------------------
  
  QT       += core gui
  QT       += sql
  
  TARGET = untitled9
  TEMPLATE = app
  
  
  SOURCES += main.cpp\
          mainwindow.cpp
  
  HEADERS  += mainwindow.h
  
  FORMS    += mainwindow.ui
  </code></pre>
  
  <p><code>mainwindow.h</code>:</p>
  
  <pre><code>#ifndef MAINWINDOW_H
  #define MAINWINDOW_H
  
  #include &lt;QMainWindow&gt;
  
  namespace Ui {
  class MainWindow;
  }
  
  class MainWindow : public QMainWindow
  {
      Q_OBJECT
  
  public:
      explicit MainWindow(QWidget *parent = 0);
      ~MainWindow();
  
  private slots:
      void on_menu_exit_triggered();
  
  private:
      Ui::MainWindow *ui;
  };
  
  #endif // MAINWINDOW_H
  </code></pre>
  
  <p><code>main.cpp</code>:</p>
  
  <pre><code>#include &lt;QtGui/QApplication&gt;
  #include "mainwindow.h"
  #include &lt;QTableView&gt;
  
  int main(int argc, char *argv[])
  {
      QApplication a(argc, argv);
      MainWindow w;
  
      w.show();
  
      QTableView *tableView;
  
      return a.exec();
  }
  </code></pre>
  
  <p><code>mainwindow.cpp</code>:</p>
  
  <pre><code>#include "mainwindow.h"
  #include "ui_mainwindow.h"
  
  MainWindow::MainWindow(QWidget *parent) :
      QMainWindow(parent),
      ui(new Ui::MainWindow)
  {
      ui-&gt;setupUi(this);
  }
  
  MainWindow::~MainWindow()
  {
      delete ui;
  }
  
  void MainWindow::on_menu_exit_triggered()
  {
    QCoreApplication::quit ();
  }
  </code></pre>
  
  <p>And, there is also a long xml in mainwindow.ui. I'll post it here in case of need.</p>
  
  <p>Thanks!</p>