insert data to database

[ChrisW67]

QTableView and QSqlTableModel or QSqlQueryModel.

[vanduongbk]

hello
how i can create many table in database ,sample as db1_table ,db2_table ....
and how i can write a insert function to each dbn_table
i use qtablewidget ,how when a record was insert to db ,it is also simultaneously display on qtablewidget
plz me ,thank

[vanduongbk]

hi ChrisW67
i have write a code in result form as below to display the data from a database but when compile ,it appear error:

C2248: 'QTableWidget::setModel' : cannot access private member declared in class 'QTableWidget'
see declaration of 'QTableWidget::setModel'
see declaration of 'QTableWidget'

QSqlQueryModel *model=new QSqlQueryModel;
    model->setQuery("SELECT start_time,description,finish_time FROM db_table");
    model->setHeaderData(0,Qt::Horizontal,tr("start_time"));
    model->setHeaderData(1,Qt::Horizontal,tr("description"));
    model->setHeaderData(1,Qt::Horizontal,tr("finish_time"));
 
    ui->tableWidget_1->setModel(model);
    ui->tableWidget_1->show();

QSqlQueryModel *model=new QSqlQueryModel;
    model->setQuery("SELECT start_time,description,finish_time FROM db_table");
    model->setHeaderData(0,Qt::Horizontal,tr("start_time"));
    model->setHeaderData(1,Qt::Horizontal,tr("description"));
    model->setHeaderData(1,Qt::Horizontal,tr("finish_time"));

    ui->tableWidget_1->setModel(model);
    ui->tableWidget_1->show();

To copy to clipboard, switch view to plain text mode 

[nix]

Because you want use QTableView instead of QTableWidget.

[vanduongbk]

hi nix
this mean that i can not use QTableWidget for display data ,only can use QTableView ?

[nix]

If you want use a table with a model use QTableView if you want to insert your data by yourself use QTableWidget. Read the doc about those two classes and about Model/View programming

[vanduongbk]

hi nix
how i can call data from database in mainform and display this database on result form

[nix]

Your code using a model was not so far try this
http://doc.qt.io/qt-4.8/qsqltablemodel.html/#details

[vanduongbk]

my problem is solve
thank you

[vanduongbk]

hello
i have record to database and display well on qtable
but i have a question how the lastest record data to database is the first display on table

[BalaQT]

Use order by clause

model->setQuery("SELECT start_time,description,finish_time FROM db_table [B]order by id desc[/B]");

model->setQuery("SELECT start_time,description,finish_time FROM db_table [B]order by id desc[/B]");

To copy to clipboard, switch view to plain text mode 

hope it helps,
bala

[vanduongbk]

thank you for your reply
i have question ,can you help me
i want to write a below code, but I do not know how to coding them,plz help me

............
if(warning == 0)
            {
                warning=1;
                start_time=getCurrentDateTime(); //i have write a function to get time and i call it here
                insert_to_db(start_time, "high value", "...");
                current_id= ???????
 
            }
 
        }
        else
        {
            if(warning==1)
            {
                warning=0;
                end_time=getCurrentDateTime();
                 update_to_db(end_time,current_id);//i want to update only update end time at above record where ID is ID at  insert_to_db(start_time, "high value", "...");
            }

............
if(warning == 0)
            {
                warning=1;
                start_time=getCurrentDateTime(); //i have write a function to get time and i call it here
                insert_to_db(start_time, "high value", "...");
                current_id= ???????

            }

        }
        else
        {
            if(warning==1)
            {
                warning=0;
                end_time=getCurrentDateTime();
                 update_to_db(end_time,current_id);//i want to update only update end time at above record where ID is ID at  insert_to_db(start_time, "high value", "...");
            }

To copy to clipboard, switch view to plain text mode 

and this is a update function that i write

void class::update_to_db(QString finish_time,int id)
{
    QSqlQuery query;
    query.prepare("update db_table set finish_time= :finish_time" "when id= :id");
    query.bindValue(":id",id);
    query.bindValue(":finish_time",finish_time);
    if(!query.exec())
    {
        throw QSqlError();
    }
}

void class::update_to_db(QString finish_time,int id)
{
    QSqlQuery query;
    query.prepare("update db_table set finish_time= :finish_time" "when id= :id");
    query.bindValue(":id",id);
    query.bindValue(":finish_time",finish_time);
    if(!query.exec())
    {
        throw QSqlError();
    }
}

To copy to clipboard, switch view to plain text mode