Dear All
Here is my snippet code
can any one help me how to change the value in the DB table once we
change the check box in list widget
i have some list of data in listwidget.
ii chance second check box enable & three checkbox Disable
after i am calling this below function ?
void FC::Config()
{
if (QMessageBox::Ok == messageBox
->question
(this,
"QDelete",
"Config update?",
{
TInt NCounts = ui.listWidget->count();
TBuf<100> CCounts;
CCounts.AppendNum(NCounts);
int i;
int j =1;
for(i=0; i<NCounts; i++)
{
if(ui.listWidget->item(i)->checkState() == Qt::Checked)
{
bool ret;
ret
= query.
prepare(QString("UPDATE Table SET Enable = :Enable, Disable = :Disable where id = %1").
arg(j
));
if(ret)
{
//query.bindValue(":Enable", );
//query.bindValue(":Disable", );
ret = query.exec();
}
}
else
{
bool ret;
ret
= query.
prepare(QString("UPDATE Table SET Enable = :Enable, Disable = :Disable where id = %1").
arg(j
));
if(ret)
{
//query.bindValue(":Enable", );
//query.bindValue(":Disable", );
ret = query.exec();
}
}
j++;
}
}
}
void FC::Config()
{
messageBox = new QMessageBox(this);
if (QMessageBox::Ok == messageBox->question(this, "QDelete", "Config update?",
QMessageBox::Ok | QMessageBox::Cancel))
{
TInt NCounts = ui.listWidget->count();
TBuf<100> CCounts;
CCounts.AppendNum(NCounts);
int i;
int j =1;
for(i=0; i<NCounts; i++)
{
if(ui.listWidget->item(i)->checkState() == Qt::Checked)
{
bool ret;
QSqlQuery query;
ret = query.prepare(QString("UPDATE Table SET Enable = :Enable, Disable = :Disable where id = %1").arg(j));
if(ret)
{
//query.bindValue(":Enable", );
//query.bindValue(":Disable", );
ret = query.exec();
}
}
else
{
QSqlQuery query;
bool ret;
ret = query.prepare(QString("UPDATE Table SET Enable = :Enable, Disable = :Disable where id = %1").arg(j));
if(ret)
{
//query.bindValue(":Enable", );
//query.bindValue(":Disable", );
ret = query.exec();
}
}
j++;
}
}
}
To copy to clipboard, switch view to plain text mode
Bookmarks