Creating a table with grid view adding, editing and deleting data from the MS SQL server using Qt Creator
-
wrote on 7 Mar 2017, 05:15 last edited by
where i will get the examples of the Qt grid view adding ,editing and deleting data from the MS Sql server....... i am already done the adding and editing the data from the MS Sql server using Qtableview and QTablewidget now i am trying to do using grid view as similar as C#..........
-
Do you mean something like this list in the QtSql module example page ?
-
wrote on 7 Mar 2017, 09:14 last edited by
No ...i have seen this link already but i did not understand ...you guide me how should i start grid view on qt creator using MS sql server ......
-
No ...i have seen this link already but i did not understand ...you guide me how should i start grid view on qt creator using MS sql server ......
@veera
Hi
What is a Qt Grid View ?
Unlike QTableview and QTablewidget,
i do not know what class you mean when you say " Qt grid view" :) -
wrote on 7 Mar 2017, 09:42 last edited by
On the single window itself we can put add ,delete,edit the MS Sql table data using grid view as similar like C# they are using grid view for the same ...i am looking for the same thing need to implement......
-
Just to be sure we're on the same page, Qt Creator is an IDE, not a database editor so you are trying to build an database interface application, correct ?
-
Just to be sure we're on the same page, Qt Creator is an IDE, not a database editor so you are trying to build an database interface application, correct ?
wrote on 7 Mar 2017, 10:45 last edited by veera 3 Jul 2017, 11:25@SGaist
Yes I agreed but i am already implemented using QTableview for editing and deleting and adding data from the mssql server existing table same thing i need to grid view for editing and adding deleting data from MSSql server with QT interface..... -
Well that's where it's not clear, AFAIK QTableView + QSqlTableModel gives you the same thing as the GridView from C#.
-
Well that's where it's not clear, AFAIK QTableView + QSqlTableModel gives you the same thing as the GridView from C#.
-
@SGaist
How should i implement data grid view using QTableview + QSqlTableModle on Qt creator?
I want to create Qt program with similar layout as C# DataGridView,Can you please provide some example code?Hi
Maybe you can show us a picture of a C# DataGridView ?
Like the one you want. -
Then it's basically a QTableView with the alternatingRowColors property set to true and a couple of QLineEdits and QPushButtons. All in a mix of QHBoxLayout and QVBoxLayout.
-
wrote on 8 Mar 2017, 11:09 last edited by
-
Hi,
if you are asking how to insert buttons in the table then you are looking for a delegatehttp://doc.qt.io/qt-5/qtwidgets-itemviews-stardelegate-example.html
http://www.informit.com/articles/article.aspx?p=1405547&seqNum=4
http://stackoverflow.com/questions/11777637/adding-button-to-qtableviewIf its not important that Add/Edit is on each row then some buttons to the side for add/delete is the fastest way.
-
wrote on 8 Mar 2017, 13:14 last edited by
I want some examples how to do it using qt gui application...
-
Lifetime Qt Championwrote on 8 Mar 2017, 13:40 last edited by mrjj 3 Aug 2017, 13:40
@veera
That is how.
Use delegate if you want the buttons being part of each row.
The delegate is how u do it.It is not possible to do in Designer.
-
wrote on 13 Mar 2017, 09:37 last edited by
Hi All,
i am using qt creator for adding ,save and delete the data from table ,here i am using QtTableview and i am not able to delete the particular row using push button method on qt and mssql server....... -
What code are you using currently to modify the content of the database ?
Like stated before Qt Creator is just an IDE, you'll have to write a minimal amount of code to interact with your database.
-
What code are you using currently to modify the content of the database ?
Like stated before Qt Creator is just an IDE, you'll have to write a minimal amount of code to interact with your database.
wrote on 13 Mar 2017, 10:52 last edited by@SGaist
for inserting the data
query->prepare("INSERT INTO Entry2 (name,contact,lastname,id,emailid)" "VALUES(?,?,?,?,?)");
showing the data after editing
model->setQuery("SELECT *FROM Entry2");
ui->tableView->setModel(model);
for the same thing for deleting a particular row from the table? -
@SGaist
for inserting the data
query->prepare("INSERT INTO Entry2 (name,contact,lastname,id,emailid)" "VALUES(?,?,?,?,?)");
showing the data after editing
model->setQuery("SELECT *FROM Entry2");
ui->tableView->setModel(model);
for the same thing for deleting a particular row from the table?
13/29