Hi all,

I thought I would help out on a Error that comes up for a lot of people when
calling
a stored procedure from your application using sqlcommand object and
passing parameters.

this error comes up in VB.NET

"first chance exception of type 'System.Data.SqlClient.SqlException'
occurred in system.data.dll"

this took me awhile but figured it out.

Make sure in the stored procedure you declare the
variable like this for variables that might not have any data: Make it equal
nothing or null
@mainnotes TEXT = '', or @mainnotes TEXT = null

This fixed my problem, and I'm sure there are more solutions but, I hope
this helps.

The error could also come up if SQL permissions are not correct.

Gerry

A question about closing the SqlDataReader
Can't find stored procedure
Excel and ADO.NET
return OleDbDataReader from static function
ado.net create a table