0
Answer

Crystal Report DBTable property error

Ask a question
Prabhu Basoor

Prabhu Basoor

14y
2.7k
1
Hello,

I'm converting VB6 to VB.NET all your help/advice is needed. I want to use DBTable.ConnectionProperties("User ID") in VB.NET. Please see below colored text.

'Set connection properties for each of the table 
'DSN and Database property not changed so don't need to set them
For i = 1 To crxReport.Database.Tables.Count
'Get the table
DBTable = crxReport.Database.Tables(i)

'Set the userID property
'UPGRADE_WARNING: Couldn't resolve default property of object DBTable.ConnectionProperties(). Click for more: 'ms-help:/037B2"'
DBTable.ConnectionProperties("User ID") = Trim(objUser.UserID)

'Set the Password property
'UPGRADE_WARNING: Couldn't resolve default property of object DBTable.ConnectionProperties(). Click for more: 'ms-help://MB2"'
DBTable.ConnectionProperties("Password") = Trim(objUser.UserPassword)

'Reset the table name(ie. remove Machine and Library name from SQLQueryString
DBTable.Location = DBTable.Location
Next i

Thanks in advance.