SQL 小问题！！！
我已经知道数据库表名，想通过表名想通过表名获得该表的字段数、字段名称、字段类型
到程序变量，如何处理？？？？（我访问数据库用的是ADO）望能给具体方法！！谢谢！！
问题点数：50、回复次数：2Top
1 楼dyw（旺仔）回复于 2002-04-30 10:49:00 得分 30
printf("\nThe Fields collection accessed by name...\n");
pRst->MoveFirst();
for (iIndex = 0; iIndex <= 8; iIndex++)
{
intLineCnt++;
if (intLineCnt%15 == 0)
{
printf("\nPress any key to continue...\n");
getch();
}
pFld = pRst->Fields->GetItem(Column[iIndex]);
printf("Field name = '%s', ",(LPCSTR)pFld->GetName());
_variant_t FldVal = pFld->GetValue();
// Because Value is the default property of a
// Property object,the use of the actual keyword
// here is optional.
switch(FldVal.vt)
{
case (VT_BOOL):
if(FldVal.boolVal)
{
printf("Value = 'True'");
}
else
{
printf("Value = 'False'");
}
printf("\n");
break;
case (VT_BSTR):
printf("Value = '%s'",
(LPCSTR)(_bstr_t)FldVal.bstrVal);
printf("\n");
break;
case (VT_I4):
printf("Value = '%s'",(LPCSTR)FldVal.iVal);
printf("\n");
break;
case (VT_EMPTY):
printf("Value = '%s'",(LPCSTR)FldVal.lVal);
printf("\n");
break;
default:
break;
}
}
// Clean up objects before exit.
pRst->Close();
Top
2 楼dyw（旺仔）回复于 2002-04-30 10:51:30 得分 20
１）取得字段名
pFld = pRst->Fields->GetItem(Column[iIndex]);
printf("Field name = '%s', ",(LPCSTR)pFld->GetName());
２）用pFld可取得其他信息。
Top
