How to take input date from user in qdateedit and show database accordingly

shreesh

Also, I am trying to use checkboxes and radiobuttons. I can read the data from these and write some values into the database. But when I try to do the reverse, that is to read data back and accordingly check the radiobuttons I can do it.
@
if((string == "male"))
{
ui->radioButton_male->setChecked(1);
}
else
ui->radioButton_female->setChecked(1);
@

But the same is not happening in case of check boxes.

@
if(string == "male")
{
ui->checkBox_yoga->setChecked(1);
}
@

p3c0

Hi,

bq. Can you please tell me the code for displaying data in “dateedit” widget?

QDateEdit expects QDate. So convert the output string to QDate and the set using "setDate":http://qt-project.org/doc/qt-5/qdatetimeedit.html#date-prop

Please Rephrase the 2nd question. It's bit confusing to understand.

p3c0

Hi,

bq. Can you please tell me the code for displaying data in “dateedit” widget?

QDateEdit expects QDate. So convert the output string to QDate and the set using "setDate":http://qt-project.org/doc/qt-5/qdatetimeedit.html#date-prop

Please Rephrase the 2nd question. It's bit confusing to understand.

shreesh

Thank you for the reply on QDate.
Second question: My code accepts the value from radio-buttons and stores respective string values in database. And now I have another part of code, which reads the previously stored value and ticks the respective radio button. For this operation, the code I wrote is,

@
if((string == "male"))
{
ui->radioButton_male->setChecked(1);
}
else
ui->radioButton_female->setChecked(1);
@

Similar to radiobuttons, I want to use checkboxes. That is to read values from the database and check mark the respective checkboxes. The code for this I wrote is as below, but it is not checking though the query fetches the data.

@
if(string == "male")
{
ui->checkBox_male->setChecked(1);
}
else
{
ui->checkBox_female->setChecked(1);
}
@

shreesh

Thank you for the reply on QDate.
Second question: My code accepts the value from radio-buttons and stores respective string values in database. And now I have another part of code, which reads the previously stored value and ticks the respective radio button. For this operation, the code I wrote is,

@
if((string == "male"))
{
ui->radioButton_male->setChecked(1);
}
else
ui->radioButton_female->setChecked(1);
@

Similar to radiobuttons, I want to use checkboxes. That is to read values from the database and check mark the respective checkboxes. The code for this I wrote is as below, but it is not checking though the query fetches the data.

@
if(string == "male")
{
ui->checkBox_male->setChecked(1);
}
else
{
ui->checkBox_female->setChecked(1);
}
@

p3c0

Please use code tags '@@' to post code.
Try using boolean values instead of integer. But that shouldn't matter actually. I guess there should be some other problem.

p3c0

Please use code tags '@@' to post code.
Try using boolean values instead of integer. But that shouldn't matter actually. I guess there should be some other problem.

shreesh

Yes, I tried using boolean values too, problem still persists.
Thanks for the effort.

shreesh

Yes, I tried using boolean values too, problem still persists.
Thanks for the effort.

p3c0

Can you post other parts of the code in relevance to this problem ?

p3c0

Can you post other parts of the code in relevance to this problem ?

shreesh

I am sorry for the partial code. Below is my actual code.

@login_page conn;
QString fill = ui->tableView->model()->data(index).toString();

if(!conn.connopen())
{
qDebug()<<"Not connected";
return;
}

conn.connopen();
QSqlQuery * qry = new QSqlQuery();
QSqlQuery * qry1 = new QSqlQuery();
QSqlQuery * qry2 = new QSqlQuery();
QSqlQuery * qry3 = new QSqlQuery();
qry->prepare("select * from instructor where i_id='"+fill+"' or i_name='"+fill+"'");
qry1->prepare("select gender from instructor where i_id='"+fill+"' or i_name='"+fill+"'");

qry2->prepare("select dob from instructor where i_id='"+fill+"' or i_name='"+fill+"'");
qry3->prepare("select yoga,martial_arts,aerobics,zumba,general,swimming,cardio,studio_cycel from instructor where i_id='"+fill+"' or i_name='"+fill+"'");


if(qry->exec&#40;&#41; and qry1->exec(&#41; and qry2->exec(&#41; and qry3->exec(&#41;&#41;
{
    while(qry->next(&#41; and qry1->next(&#41; and qry2->next(&#41; and qry3->exec(&#41;&#41;
    {
      QString str = qry1->value(0&#41;.toString(&#41;;
      //QString y,ma,a,z,g,s,sc,c;
      QString y = qry3->value(0&#41;.toString(&#41;;
      QString ma = qry3->value(1&#41;.toString(&#41;;
      QString a = qry3->value(2&#41;.toString(&#41;;
      QString z = qry3->value(3).toString();
      QString g = qry3->value(4).toString();
      QString s = qry3->value(5).toString();
      QString c = qry3->value(6).toString();
      QString sc = qry3->value(7).toString();

      ui->txt_iid->setText(qry->value(0).toString());
      ui->txt_iname->setText(qry->value(1).toString());
      if((str == "male"))
      {
      ui->radioButton_male_2->setChecked(1);
      }
      else
      ui->radioButton_female_2->setChecked(1);

     

      if(y == "Yoga")
      {
          ui->checkBox_yoga->setChecked(1);
      }
      if(ma == "Martial arts")
      {
          ui->checkBox_ma->setChecked(1);
      }
      if((a == "Aerobics"))
      {
          ui->checkBox_a->setChecked(1);
      }
      if((z == "Zumba"))
      {
          ui->checkBox_z->setChecked(1);
      }
      if((g == "General"))
      {
          ui->checkBox_g->setChecked(1);
      }
      if((s == "Swimming"))
      {
          ui->checkBox_s->setChecked(1);
      }
      if((c == "Cardio"))
      {
          ui->checkBox_c->setChecked(1);
      }
      if((sc == "Studio cycle"))
      {
          ui->checkBox_sc->setChecked(1);
      }

      ui->txt_phone->setText(qry->value(12).toString());
      ui->txt_street->setText(qry->value(13).toString());
      ui->txt_apt->setText(qry->value(14).toString());
      ui->txt_city->setText(qry->value(15).toString());
      ui->txt_state->setText(qry->value(16).toString());
      ui->txt_zip->setText(qry->value(17).toString());

      conn.connclose();
    }

}
else
    QMessageBox::information(this,tr("Error"),tr("Error in diaplaying")); @

shreesh

I am sorry for the partial code. Below is my actual code.

@login_page conn;
QString fill = ui->tableView->model()->data(index).toString();

if(!conn.connopen())
{
qDebug()<<"Not connected";
return;
}

conn.connopen();
QSqlQuery * qry = new QSqlQuery();
QSqlQuery * qry1 = new QSqlQuery();
QSqlQuery * qry2 = new QSqlQuery();
QSqlQuery * qry3 = new QSqlQuery();
qry->prepare("select * from instructor where i_id='"+fill+"' or i_name='"+fill+"'");
qry1->prepare("select gender from instructor where i_id='"+fill+"' or i_name='"+fill+"'");

qry2->prepare("select dob from instructor where i_id='"+fill+"' or i_name='"+fill+"'");
qry3->prepare("select yoga,martial_arts,aerobics,zumba,general,swimming,cardio,studio_cycel from instructor where i_id='"+fill+"' or i_name='"+fill+"'");


if(qry->exec&#40;&#41; and qry1->exec(&#41; and qry2->exec(&#41; and qry3->exec(&#41;&#41;
{
    while(qry->next(&#41; and qry1->next(&#41; and qry2->next(&#41; and qry3->exec(&#41;&#41;
    {
      QString str = qry1->value(0&#41;.toString(&#41;;
      //QString y,ma,a,z,g,s,sc,c;
      QString y = qry3->value(0&#41;.toString(&#41;;
      QString ma = qry3->value(1&#41;.toString(&#41;;
      QString a = qry3->value(2&#41;.toString(&#41;;
      QString z = qry3->value(3).toString();
      QString g = qry3->value(4).toString();
      QString s = qry3->value(5).toString();
      QString c = qry3->value(6).toString();
      QString sc = qry3->value(7).toString();

      ui->txt_iid->setText(qry->value(0).toString());
      ui->txt_iname->setText(qry->value(1).toString());
      if((str == "male"))
      {
      ui->radioButton_male_2->setChecked(1);
      }
      else
      ui->radioButton_female_2->setChecked(1);

     

      if(y == "Yoga")
      {
          ui->checkBox_yoga->setChecked(1);
      }
      if(ma == "Martial arts")
      {
          ui->checkBox_ma->setChecked(1);
      }
      if((a == "Aerobics"))
      {
          ui->checkBox_a->setChecked(1);
      }
      if((z == "Zumba"))
      {
          ui->checkBox_z->setChecked(1);
      }
      if((g == "General"))
      {
          ui->checkBox_g->setChecked(1);
      }
      if((s == "Swimming"))
      {
          ui->checkBox_s->setChecked(1);
      }
      if((c == "Cardio"))
      {
          ui->checkBox_c->setChecked(1);
      }
      if((sc == "Studio cycle"))
      {
          ui->checkBox_sc->setChecked(1);
      }

      ui->txt_phone->setText(qry->value(12).toString());
      ui->txt_street->setText(qry->value(13).toString());
      ui->txt_apt->setText(qry->value(14).toString());
      ui->txt_city->setText(qry->value(15).toString());
      ui->txt_state->setText(qry->value(16).toString());
      ui->txt_zip->setText(qry->value(17).toString());

      conn.connclose();
    }

}
else
    QMessageBox::information(this,tr("Error"),tr("Error in diaplaying")); @

p3c0

Sorry but the code looks little bit weird. I think you must first rectify them:

No need to open the database twice.
Since you are fetching everything from the same table with same where clauses why unnecessarily complicate the code by firing 4 different queries.
Furthermore it complicates the if and while conditions.
Closing the connection in while loop would be a bad idea as it will close the database and the end of first iteration itself and thus affecting the remaining data if any.

p3c0

Sorry but the code looks little bit weird. I think you must first rectify them:

No need to open the database twice.
Since you are fetching everything from the same table with same where clauses why unnecessarily complicate the code by firing 4 different queries.
Furthermore it complicates the if and while conditions.
Closing the connection in while loop would be a bad idea as it will close the database and the end of first iteration itself and thus affecting the remaining data if any.

? This user is from outside of this forum

This post is deleted!

? This user is from outside of this forum

This post is deleted!