InsertRow

[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 ?

[SGaist]

What names do you want there ?

[Duy Khang]

@SGaist hi, how can I insert a row after the current row, assuming we don't have any rows at first, I use QSqlTableModel.

[SGaist]

The same as usual.

As for setting the header data, it's shown in the QSqlTableModel documentation.

[Duy Khang]

yes, i have done it and then how can I insert a row after the current row, assuming we don't have any rows at first, I use QSqlTableModel.