要通过递归的方式获得一条记录一级目录ID,但是总是返回 0(1——9为一级目录ID) 数据库:
NDF_ID NDF_Father NDF_Name
10 1 XXXX
11 2 XXXXX
12 1 XXXXXX
13 2 XXXXXXX
14 12 XXXXXXXX
程序: public int GetMyFather(int FID)
{
if (FID > 9) {
string SQL = "SELECT [NDF_Father] FROM [RC_NetDiskFiles] WHERE [NDF_ID]=" + FID;
_Db.inStrConn = _Conn.Rocco;
//_Db.ExecuteScalar(SQL)是返回一个NDF_Father字段值
GetMyFather(_Db.ExecuteScalar(SQL));
}
else {
return FID;
}
}求解
NDF_ID NDF_Father NDF_Name
10 1 XXXX
11 2 XXXXX
12 1 XXXXXX
13 2 XXXXXXX
14 12 XXXXXXXX
程序: public int GetMyFather(int FID)
{
if (FID > 9) {
string SQL = "SELECT [NDF_Father] FROM [RC_NetDiskFiles] WHERE [NDF_ID]=" + FID;
_Db.inStrConn = _Conn.Rocco;
//_Db.ExecuteScalar(SQL)是返回一个NDF_Father字段值
GetMyFather(_Db.ExecuteScalar(SQL));
}
else {
return FID;
}
}求解
建议将if (FID > 9)改为if (FID < 9)试试
在查询分析器执行看看是否有数据