[Qt-interest] QTableView: How can I get the data of selected row.

[Mhayk Whandson]

Hi all! I solved my problem but I don't know if it is the best form to
get a one value of column in one selected row. I have a hide column in
the grid called "id" and I would like to get this value, so the code
is following:

void group::deleteRowTable(void)
{
   QVariant variant
   QModelIndex index;
   int rownumber;
   QSqlQuery *query = new QSqlQuery;


   index = group_ui->tableView->currentIndex();
   rownumber = index.row();
   index = index.sibling(rownumber, 0); /* 0 is the code of id column */

   variant = index.data();

   query->prepare("delete from dsm_group where id = ?");

   query->addBindValue(variant.toString());
   query->exec();
   refrashTableView();
}

What are you think about this solution ?

best regards,

On Tue, May 12, 2009 at 3:14 PM, Mhayk Whandson <eu at mhayk.com.br> wrote:
> Hi all, I am tryng to get the datas of a one selected row. I would
> like to get all columns about this selected row. Example:
>
>  ____ _________________ __________
> | ID |       Name      |    Age   |
>  ---- ----------------- ----------
> | 1  |  Mhayk Whandson |    22    |
>  ---- ----------------- ----------
>
> So, I would like get all datas in these row(id, name, age). Could you help me ?
>
> Actually I just manage to get the selected column in the row:
>
> void group::deleteRowTable(void)
> {
>    QModelIndex index;
>    index = group_ui->tableView->currentIndex();
>
>    QVariant variant = index.data();
>    QSqlQuery *query = new QSqlQuery;
>
>    query->prepare("delete from dsm_group where description = ?");
>    /*QMessageBox::critical(0, tr("Message"),
>                          variant.toString(),
>                          QMessageBox::Cancel);*/
>    //query->bindValue(":desc", variant.toString());
>    query->addBindValue(variant.toString());
>    query->exec();
>    refrashTableView();
> }
>
> best regards,
>
> --
> Mhayk Whandson
> Linux User #413723
> E-mail: eu at mhayk.com.br
>



-- 
Mhayk Whandson
Linux User #413723
E-mail: eu at mhayk.com.br