您可以只查询信息模式表以获取所需的信息:
public bool isValidField(string tableName, string columnName){ var tblQuery = "SELECt 1 FROM INFORMATION_SCHEMA.COLUMNS" + " WHERe TABLE_NAME = @tableName AND" + " COLUMN_NAME = @columnName"; SqlCeCommand cmd = objCon.CreateCommand(); cmd.CommandText = tblQuery; var tblNameParam = new SqlCeParameter( "@tableName", SqlDbType.NVarChar, 128); tblNameParam.Value = tableName cmd.Parameters.Add(tblNameParam); var colNameParam = new SqlCeParameter( "@columnName", SqlDbType.NVarChar, 128); colNameParam.Value = columnName cmd.Parameters.Add(colNameParam); object objvalid = cmd.ExecuteScalar(); // will return 1 or null return objvalid != null;}


