Is there any way to convert the TASK_RTF_NOTES to readable format ?

[Dennis]

Hello :

We have customized a form to show all the tasks exceed the start time
or end time.Now

the executives want us to add a column that shows the reason why the task
exceeds. I have

found the help in the PJDB.htm as following . Is there any version that can
be used in C# .NET?

By the way, is there any way to open the project professional 2003 using C#
..NET?

Thanks & Regards,


Dennis


Dim cn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim sql As String, rtf As String, cnString

'Open the MSP_TASKS table to look for TASK_RTF_NOTES
cnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=c:\temp\XXXX.mpd"
sql = "select PROJ_ID, TASK_UID, TASK_RTF_NOTES " & _
"from MSP_TASKS " & _
"where TASK_RTF_NOTES is not null"
cn.Open cnString
rs.Open sql, cn

With rs
Do While Not .EOF
rtf = StrConv(.Fields("TASK_RTF_NOTES"), vbUnicode) ' Put binary
column data into text string
Debug.Print rtf
.MoveNext
Loop
.Close
End With