Put this code try{..}catch(System.Data.SqlClient.SqlException sqlEx)
{
MessageBox.Show(sqlEx.Message+"\r\n"+sqlEx.StackTrace);
}
And Post that complete message here. So it would help us in pin pointing exactly where it is failing.

I found a resolution to this. I did a DB backup and restored the DB to another instance of the DB. Repointed my app to the new DB and all works well. I'm not sure why the old DB had an issue but I will try to use the catch and post the error message for you soon.
THANKS

Here is the error msg:
Invalid length parameter passed to the substring function.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, TdsParserState state)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, TdsParserState state)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
at System.Data.SqlClient.TdsParser.Run(RunBehavior run, SqlCommand cmdHandler, SqlDataReader dataStream)
at System.Data.SqlClient.SqlDataReader.get_HasMoreResults()
at System.Data.SqlClient.SqlDataReader.NextResult()
at System.Data.Common.DbDataAdapter.FillNextResult(IDataReader dataReader)
at System.Data.Common.DbDataAdapter.FillFromReader(Object data, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
at System.Data.Common.DbDataAdapter.Fill(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
at RandomIE.Form1.button1_Click(Object sender, EventArgs e) in c:\randomie\form1.cs:line 149

Congrats for gettting the thing back to normal. Thanks for posting the SQL Exception Stack Trace here. I wanted to clarify myself that your code is not making any call to Substring method, reason behind this is I have seen similar kind of problem sometime back. One of my friend was developing Web methods for some of the stored procs in his project. He also actually created a new instance of the datbase and all went well. That time we ran the SqlProfiler too, to check where the problem went wrong. But we missed that, and he was in a hurry, and his project was ending. So we missed opportunity to fully diagnose it. :-)