Creating a table with grid view adding, editing and deleting data from the MS SQL server using Qt Creator

[SGaist]

Hi,

Do you mean a QTableView with a QSqlTableModel ?

[veera]

Yes using QTableview or QTablewidget with a QSqltableModel

[veera]

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#..........

[SGaist]

Do you mean something like this list in the QtSql module example page ?

[veera]

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 ......

[mrjj]

@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" :)

[veera]

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......

[SGaist]

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 ?

[veera]

@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.....

[SGaist]

Well that's where it's not clear, AFAIK QTableView + QSqlTableModel gives you the same thing as the GridView from C#.

[veera]

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

[mrjj]

Hi
Maybe you can show us a picture of a C# DataGridView ?
Like the one you want.

[veera]

https://www.google.co.in/search?q=data+grid+view+in+c%23&source=lnms&tbm=isch&sa=X&ved=0ahUKEwjL8JuevMbSAhUDLY8KHSuDDSgQ_AUIBygC&biw=1600&bih=747#imgrc=MYmPHqMg88TvcM:

[SGaist]

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.

[veera]

https://www.google.co.in/search?q=add+edit+delete+gridview,png&tbm=isch&imgil=B9sB6NLZD1_atM%253A%253BlilWqrUInGro4M%253Bhttp%25253A%25252F%25252Fasp.net-informations.com%25252Fgridview%25252Fgridview-operations.htm&source=iu&pf=m&fir=B9sB6NLZD1_atM%253A%252ClilWqrUInGro4M%252C_&usg=__jScs5ApNozfz1cVoi9aqyQJ64Ys%3D&biw=1467&bih=586&ved=0ahUKEwiYnLW84sbSAhVMuI8KHVDvAYIQyjcIJA&ei=R-a_WNjcMczwvgTQ3oeQCA#imgrc=B9sB6NLZD1_atM:

[mrjj]

@veera

Hi,
if you are asking how to insert buttons in the table then you are looking for a delegate

http://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-qtableview

If its not important that Add/Edit is on each row then some buttons to the side for add/delete is the fastest way.

[veera]

I want some examples how to do it using qt gui application...

[mrjj]

@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.

[veera]

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.......

[SGaist]

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.