Dynamic FOrms

[BalaQT]

hi,
im new to QT programming,
i want to create DYANMIC form based on DATABASE
for ex:
sqlite table contains how many forms to create and size of the form
QT should connect sqlite table and it should create the forms

pls guide me

Bala

[wysota]

So what's the question?

[BalaQT]

wysota> Thnks for replying me
my question is :
i) how to create forms from QT by reading from SQLITE table

following is the code im using to show one window.

#include <QApplication>
 #include <QGridLayout>
 #include <QPushButton>
 #include <QTextBox>
 #include <QProcess>
 #include "Connection.h"
 #include <QtCore/QVariant>
 
 int main(int argc, char *argv[])
 {
        QApplication app(argc, argv);
        QWidget *win1 = new QWidget;
        QGridLayout *layout = new QGridLayout;
        QPushButton *ClickButton=new QPushButton("Click");
        QPushButton *CancelButton=new QPushButton("Cancel");
        QObject::connect(ClickButton,SIGNAL(clicked()),&app,SLOT(quit()));
        if(!createConnection())
                return 1;
        QSqlQuery q;
        q.exec("SELECT * FROM ConfigTable");
        q.next();
        win1->setWindowTitle("Window1");
        win1->setFixedHeight(q.value(2).toInt());
        win1->setFixedWidth(q.value(3).toInt());
        layout->addWidget(ClickButton,0,0);
        layout->addWidget(CancelButton,0,2);
        win1->setLayout(layout);
        win1->show();
        return app.exec();
}

#include <QApplication>
 #include <QGridLayout>
 #include <QPushButton>
 #include <QTextBox>
 #include <QProcess>
 #include "Connection.h"
 #include <QtCore/QVariant>

 int main(int argc, char *argv[])
 {
        QApplication app(argc, argv);
        QWidget *win1 = new QWidget;
        QGridLayout *layout = new QGridLayout;
        QPushButton *ClickButton=new QPushButton("Click");
        QPushButton *CancelButton=new QPushButton("Cancel");
        QObject::connect(ClickButton,SIGNAL(clicked()),&app,SLOT(quit()));
        if(!createConnection())
                return 1;
        QSqlQuery q;
        q.exec("SELECT * FROM ConfigTable");
        q.next();
        win1->setWindowTitle("Window1");
        win1->setFixedHeight(q.value(2).toInt());
        win1->setFixedWidth(q.value(3).toInt());
        layout->addWidget(ClickButton,0,0);
        layout->addWidget(CancelButton,0,2);
        win1->setLayout(layout);
        win1->show();
        return app.exec();
}

To copy to clipboard, switch view to plain text mode 

How to create more than one windows, if the ConfigTable contain 2 or more records?

Thnks
Bala

[wysota]

I don't see a problem... just use a for() loop and in each iteration create a widget, fill it with child widgets and show it. Alternatively you can use QUiLoader if you can afford storing ui files in the database.

[BalaQT]

Sir, thnks for the reply,
i got the logic. but dont know how to do it in QT coding. pls provide me source code with for loop to create child widgets

Thnks
Bala

[wysota]

How can I provide code if I don't know what the database holds?

[BalaQT]

Table Details
Database : SQLITE
Table Name : ConfigTable
Fields :
FormId Numeric
FormName Text
FormHeight Numeric
FormWidth Numeric

ConfigTable location : E:\Bala\Ramana\DynamicForm\DynaBase

connection.h

#ifndef CONNECTION_H
#define CONNECTION_H
 
#include <QMessageBox>
#include <QSqlDatabase>
#include <QSqlError>
#include <QSqlQuery>
 
static bool createConnection()
{
    QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
    //db.setDatabaseName(":memory:");
    //db.setDatabaseName("e:/BALA/hirola");
    db.setDatabaseName("e:/BALA/Ramana/DynamicForm/DynaBase");
    if (!db.open()) {
        QMessageBox::critical(0, qApp->tr("Cannot open database"),
            qApp->tr("Unable to establish a database connection.\n"
                     "This example needs SQLite support. Please read "
                     "the Qt SQL driver documentation for information how "
                     "to build it.\n\n"
                     "Click Cancel to exit."), QMessageBox::Cancel);
        return false;
    }
 
 
    return true;
}
#endif

#ifndef CONNECTION_H
#define CONNECTION_H

#include <QMessageBox>
#include <QSqlDatabase>
#include <QSqlError>
#include <QSqlQuery>

static bool createConnection()
{
    QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
    //db.setDatabaseName(":memory:");
    //db.setDatabaseName("e:/BALA/hirola");
    db.setDatabaseName("e:/BALA/Ramana/DynamicForm/DynaBase");
    if (!db.open()) {
        QMessageBox::critical(0, qApp->tr("Cannot open database"),
            qApp->tr("Unable to establish a database connection.\n"
                     "This example needs SQLite support. Please read "
                     "the Qt SQL driver documentation for information how "
                     "to build it.\n\n"
                     "Click Cancel to exit."), QMessageBox::Cancel);
        return false;
    }


    return true;
}
#endif

To copy to clipboard, switch view to plain text mode 

DynamicTable.Cpp

#include <QApplication>
 #include <QGridLayout>
 #include <QPushButton> 
 #include <QProcess>
 #include "Connection.h"
 #include <QtCore/QVariant>
 
 
 int main(int argc, char *argv[])
 {
        QApplication app(argc, argv);
        QWidget *win1 = new QWidget;        
        QGridLayout *layout = new QGridLayout;
        QPushButton *ClickButton=new QPushButton("Click");
        QPushButton *CancelButton=new QPushButton("Cancel");
        QObject::connect(ClickButton,SIGNAL(clicked()),&app,SLOT(quit()));
        if(!createConnection())
                return 1;
        QSqlQuery q;
        q.exec("SELECT * FROM ConfigTable");
        QString salary;
        q.next();
        win1->setWindowTitle("Window1");
        win1->setFixedHeight(q.value(2).toInt()); //FormHeight
        win1->setFixedWidth(q.value(3).toInt()); //FormWidth
        layout->addWidget(ClickButton,0,0);
        layout->addWidget(CancelButton,0,2);
        win1->setLayout(layout);        
        win1->show();
        return app.exec();
}

#include <QApplication>
 #include <QGridLayout>
 #include <QPushButton> 
 #include <QProcess>
 #include "Connection.h"
 #include <QtCore/QVariant>


 int main(int argc, char *argv[])
 {
        QApplication app(argc, argv);
        QWidget *win1 = new QWidget;        
        QGridLayout *layout = new QGridLayout;
        QPushButton *ClickButton=new QPushButton("Click");
        QPushButton *CancelButton=new QPushButton("Cancel");
        QObject::connect(ClickButton,SIGNAL(clicked()),&app,SLOT(quit()));
        if(!createConnection())
                return 1;
        QSqlQuery q;
        q.exec("SELECT * FROM ConfigTable");
        QString salary;
        q.next();
        win1->setWindowTitle("Window1");
        win1->setFixedHeight(q.value(2).toInt()); //FormHeight
        win1->setFixedWidth(q.value(3).toInt()); //FormWidth
        layout->addWidget(ClickButton,0,0);
        layout->addWidget(CancelButton,0,2);
        win1->setLayout(layout);        
        win1->show();
        return app.exec();
}

To copy to clipboard, switch view to plain text mode 

This is working fine for ONE ROW, ONE WINDOW.
how to create n windows, if n rows are in configtable.

Thnks
Bala

[wysota]

while(q.next()){
  QWidget *w = new QWidget;
  w->setWindowTitle(...);
  w->setWFixedHeight(q.value(2).toInt());
  ...
  w->show();
}

while(q.next()){
  QWidget *w = new QWidget;
  w->setWindowTitle(...);
  w->setWFixedHeight(q.value(2).toInt());
  ...
  w->show();
}

To copy to clipboard, switch view to plain text mode 

[BalaQT]

Thnks wysota
it solved my problem.
im new to QT. I understand SIMPLE OR BASIC means not easy untill u familiar with it.
i love QT.but im a beginner. so pls consider me,even if i ask any dumb questions.

i)what is the command for position the forms (LEFT AND TOP)?

Thnks
Bala

[numbat]

w->move(x, y);

w->move(x, y);

To copy to clipboard, switch view to plain text mode 

[BalaQT]

thanks wysota

its working fine, but i have more doubts in this

how can i access the created window's widgets?
for ex:
a form displayed with 2 line edits in it.
createLineedit is the function im using to create a lineedit.

createLineedit() will be called 2 times to create 2 lineedits;

hw can i access the values in it, when i press one pushbutton

the follwing code called frm main.cpp
createLineedit("id")
createLineedit("name");

How to take the values TYPED in id,name line edit ,when the user press Savepushbutton?

pls guide me