Database Connectivity Error....
-
I am doing a windows application.. I was working well with it and suddenly a form shows error... i am using stored procedures to insert and retrieve data ...and it seems that the stored procedure is correct.. in C#.net code**
command.ExecuteNonQuery();
the error handler points to this and puts error "Failed to convert parameter value from a String to a Int32."**
SAJAN A PILLAI C#.NET Programmer TELESOFT INDIA PVT LTD... BANGALORE
-
I am doing a windows application.. I was working well with it and suddenly a form shows error... i am using stored procedures to insert and retrieve data ...and it seems that the stored procedure is correct.. in C#.net code**
command.ExecuteNonQuery();
the error handler points to this and puts error "Failed to convert parameter value from a String to a Int32."**
SAJAN A PILLAI C#.NET Programmer TELESOFT INDIA PVT LTD... BANGALORE
sajan ss wrote:
"Failed to convert parameter value from a String to a Int32."
sajan ss, This error says that you mistakenly provide String instead of int to stored procedure. Could you give us more code for analyze. I want to get the listing where you are filling the stored procedure parameters and signature of calling stored procedure.
-
I am doing a windows application.. I was working well with it and suddenly a form shows error... i am using stored procedures to insert and retrieve data ...and it seems that the stored procedure is correct.. in C#.net code**
command.ExecuteNonQuery();
the error handler points to this and puts error "Failed to convert parameter value from a String to a Int32."**
SAJAN A PILLAI C#.NET Programmer TELESOFT INDIA PVT LTD... BANGALORE
There's not much you're showing from your code, but if you're sure the error is fired exactly from that line, then double check your stored procedure parameter values and make sure the types are matching. Cheers,
Smile: A curve that can set a lot of things straight! (\ /) (O.o) (><)
-
There's not much you're showing from your code, but if you're sure the error is fired exactly from that line, then double check your stored procedure parameter values and make sure the types are matching. Cheers,
Smile: A curve that can set a lot of things straight! (\ /) (O.o) (><)
thanks for that information.... type mismatched ... i made it correct.....
SAJAN A PILLAI C#.NET Programmer TELESOFT INDIA PVT LTD... BANGALORE