String Objects are ok?

Try
                StoredProcName = dbName & ".dbo.usp_GetPrestigeCustomers"

                cmd = dbManager.GetStoredProcCommand(StoredProcName)
                cmd.CommandTimeout = 0


                dbManager.AddInParameter(cmd, "@DT_FROM", DbType.DateTime, IsNull(dr2.Item(1)))           ' Second Entry will be of first row
                dbManager.AddInParameter(cmd, "@DT_TO", DbType.DateTime, IsNull(dr1.Item(2)))             ' Third entry of the last row
                dbManager.AddInParameter(cmd, "@DT_TO_MONTH", DbType.DateTime, IsNull(dr2.Item(2)))       ' Third entry will be of first row

Should I be passing string objects or dates this query is running forever.
"02/01/2004 12:00AM" {String}
"02/28/2004 12:00AM" {String}
"05/29/2004 12:00AM" {String}

How should I change this?

mathieu_cuprykAsked:
Who is Participating?
 
dunglaConnect With a Mentor Commented:
Where do you want to pass these string objects to?
0
 
mathieu_cuprykAuthor Commented:
They are working.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.