Feb 13, 2009 09:52 AM|olaamigos|LINK
Thank you hans and Mike for replying,
Instead of using the StrComp for concatenating in the SQL string, I use the parameterized queries and the ExecuteScalar() for returning an object. I works great and return the count but up until it reads the last 9 rows in the table, I fails at the connection.open();
for "Unspecified Error". I added the try and catch in the method to see if it returns a specific error, but no specific error displays, just "Unspecified Error". Any ideas why? Thank you so much for your help.
myConnection.Open(); //Unspecified error
myCommand.CommandType = System.Data.
retVal = err.Message.ToString();