TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Prabhu Basoor
NA
11
0
Crystal Report DBTable property error
May 4 2010 5:58 AM
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.
Reply
Answers (
0
)
groupheader in datareport
Page break option for crystal report