[QTableView remove selected rows?

[veera]

I want to something this type of query
query->prepare("DELETE FROM Info WHERE ID = ?");
query->addBindValue(ID);
for deleting of entire row by selecting a particular row...........

[VRonin]

QSqlTableModel or QSqlRelationalTableModel does that for you if you can live with simple queries. if you have convoluted joins then you'll have to connect to the model rowsRemoved or rowsAboutToBeRemoved signal and prepare the query manually

[veera]

@VRonin
I am a beginner of MS SQL so please give me examples

[VRonin]

... it's included as part of Qt's examples: http://doc.qt.io/qt-5/qtsql-relationaltablemodel-example.html

[veera]

i go through the examples in that they creating QTableView *view = new QTableView; but i am designed in the UI drag and drop of Tableview and everything so.........

[VRonin]

There is absolutely no difference. The trag and drop in Qt Designer generates an xml file describing your interface then uic converts that xml into code basically identical to the one in the examples.

On top of this, your problem is not in the UI but in the model design so you should not really care about how the UI is created

[veera]

I go through those examples ,explaining the inserting data into the tableview but they did not explain the deleting particular row after selecting it........

[veera]

through out my project i am using this model
QSqlQueryModel *model = new QSqlQueryModel;
its happening by executing qurey by passing id via line edit but i am trying selecting entire row and pressing delete is not happening ......

[VRonin]

QSqlQueryModel is read only. you cannot delete, insert or change anything

[veera]

with this model only i am inserting and updating data into qtableview but delete is not happening ?,if u want i can share the code insert and updating data .......