Qlistwidget with QSql

[damodharan]

Dear all,

any one knows how to compare the listwidget data with DB table.

[damodharan]

Dear All,

Any one have idea about how to compare the listwidget data with sql table

if any one needs clear i will put my same code

[divanov]

This question is too general and depends on what kind of data you have in the widget and in the database.

[damodharan]

Dear All


how to change the value in the DB table value once we
change the check box event in list widget


i have some list of data in listwidget.
chance second check box enable & three checkbox Disable

after i am calling this below function ?

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++;
}
}
}

[damodharan]

Dear all,

any one have idea about how to compare listwidet rows with table rows?

[damodharan]

Thx to all

problem sloved