InsertRow

[SGaist]

Hi,

What kind of model are you using ?

[Duy Khang]

i'm using tableView
i used ui->tableView->model()->insertRow(0), but it does not work !

[JonB]

@Duy-Khang
@SGaist asked you what model you are using. Not the QTableView. What is your ui->tableView->model()? Because insertRow(0) inserts a row into the model, and if you say "but it does not work !" then you have an issue in your model. Perhaps because you have your own model and have not implemented inserting rows correctly/at all?

[Duy Khang]

i don't know what is model and you can show me how to insert a new row and add data to every cell of new row ? I just want this but i don't know how to do it.

[JonB]

@Duy-Khang
Nobody can without knowing what model you are using. Only you know that, and you really should know what your model is. Have you tried reading the Model/View Tutorial?

[Duy Khang]

this is my tableView and i want when users click "Đăng Kí"''s pushButton, it will insert a new row

[SGaist]

We all understood what you want to do.

What we are asking you is what type of model is set on that QTableView ?

QSqlTableModel ?
QSqlQueryModel ?
QStandardItemModel ?
Custom QAbstractTableModel based model ?
Other ? (to be defined)

[Duy Khang]

it is QSqlQueryModel.

[JonB]

@Duy-Khang
At last! A QSqlQueryModel is for querying SQL, it does not allow insertions, because it does not know where to insert any rows. It sounds like you should switch to a QSqlTableModel for inserts etc.? I assume the rows you show are all in one table, which is where you want to insert/update/delete rows.

[Duy Khang]

oh,I don't know that before and how to insert new row if i use QSqlTableModel ?

[JonB]

@Duy-Khang
The code you showed would work if the model is a QSqlTableModel instead of a QSqlQueryModel, and you have specified the table. You can search https://doc.qt.io/qt-5/qsqltablemodel.html and https://doc.qt.io/qt-5/qsqltablemodel-members.html for insertRow and see what you come across. There is also QSqlTableModel::insertRecord() etc. if you prefer a record-based interface to a row-based interface, that is a matter of preference.

BTW you don't need to worry about/implement the beginInsertRows() etc. you asked about if you use a QSqlTableModel, its implementation handles that for you.

[Duy Khang]

and QSqlTableModel can not setQuery() how to do this ?

[JonB]

@Duy-Khang
Please read the documentation rather than asking each time. It is beneficial to you to understand, not just be told. There is even an example at https://doc.qt.io/qt-5/qsqltablemodel.html#details.

[Duy Khang]

Thank you very much

[Duy Khang]

@JonB

do you know how to disable or turn off the these indexs in this picture ?

[Christian Ehrlicher]

@Duy-Khang said in InsertRow:

do you know how to disable or turn off the these indexs in this picture ?

Hide the horizontal and vertical header.

[JonB]

@Duy-Khang
If that column is in the table but you don't want to show it, use void QTableView::hideColumn(int column) to suppress it in your view.

Oh, I misunderstood what you were wanting to hide in your picture! I thought you meant the first column!

In which case it's the horizontal header as @Christian-Ehrlicher has pointed you to.

[Duy Khang]

@Christian-Ehrlicher thank you.

[Duy Khang]

@JonB yes, thank you, it works

[Duy Khang]

@JonB hi,

how can i change the name of column in picture ?