为什么我的DBGGrid,取不出来数据,请高手看一下我的代码!谢谢先
try
{
TDataSet *pDS;
queryString =" select * from lendbooktmp ";
queryString += "where read_id =";
queryString += Edit1->Text;
queryString += " and book_id =" ;
queryString += Edit2->Text;
DataModule1->lendbooktmpADOQuery->SQL->Clear();
DataModule1->lendbooktmpADOQuery->SQL->Add(queryString);
DataModule1->lendbooktmpADOQuery->Open();
pDS = DBGrid1->DataSource->DataSet;
pDS->First();
queryString = "insert into history values\( ";
queryString +="\'";
queryString +=Edit1->Text; //read_id
queryString +="\'";
queryString +="\,";
queryString +=" \'";
queryString +=pDS->FieldByName("read_id")->AsString; //read_name
queryString +="\'";
queryString +="\,";
queryString +=" \'";
queryString +=pDS->FieldByName("book_id")->AsString; //book_id
queryString +="\'";
queryString +="\,";
queryString +=" \'";
queryString +=pDS->FieldByName("book_name")->AsString; //book_name
queryString +="\'";
queryString +="\,";
queryString +=" \'";
queryString +=pDS->FieldByName("leadtime")->AsString;//借书时间
queryString +="\'";
queryString +="\,";
queryString +=" \'"; //还书时间
queryString +=DateTimePicker1->DateTime;
queryString +="\'";
queryString +="\,";
queryString +=" \'归还\'";
queryString +="\)";
DataModule1->hisADOQuery->SQL->Clear();
DataModule1->hisADOQuery->SQL->Add(queryString);
Edit3->Text =queryString;
DataModule1->hisADOQuery->ExecSQL();
}
catch( EDBEngineError &E)
{
MessageBox(NULL, "用户名错误或口令错误!", "错误", MB_OK);
}
程序运行后Edit3->Text,显示DBGGrid没有取到任何数据。
实际上有一条记录,并且DBGGrid也能将这条记录显示出来,但为什么取不出来?
我这样用FieldByName有问题吗?