ADO.Net Error "Input string was not in a correct format"

Hi,

I am trying to update a db using the dataadapter, three command objects
(insert,update...) and a dataset (MS SQL Server). I create my command
objects via stored procedures which works fine. However when I call
dataAdapter.Update(dataSet, tableName); it throws the "Input string was not
in a correct format" and I have no idea why. Can someone help me?

Thanks

William
Wed Apr 28 13:04:02 CDT 2004

I can't tell from here. Have you set your commandtype to CommandType
StoredProcedure? have you used "@" symbols for your params?

Could you post the code where you create the UpdateCommand (not the stored
proc although it would help, but the part where you add parameters. Also,
can you post the code right before this exception
"Daniel" <danny@noemail.com> wrote in message
news:Oxo00WULEHA.1388@TK2MSFTNGP09.phx.gbl...
> Hi,
>
> I am trying to update a db using the dataadapter, three command objects
> (insert,update...) and a dataset (MS SQL Server). I create my command
> objects via stored procedures which works fine. However when I call
> dataAdapter.Update(dataSet, tableName); it throws the "Input string was
not
> in a correct format" and I have no idea why. Can someone help me?
>
> Thanks
>
>

Daniel
Wed Apr 28 14:39:27 CDT 2004

I figured it out, the problem was the table name (order details) had a space
between the two words. Once I change that, it worked.

Thanks

"William Ryan eMVP" <dotnetguru@comcast.nospam.net> wrote in message
news:OiWjSqULEHA.3052@TK2MSFTNGP12.phx.gbl...
> I can't tell from here. Have you set your commandtype to CommandType
> StoredProcedure? have you used "@" symbols for your params?
>
> Could you post the code where you create the UpdateCommand (not the stored
> proc although it would help, but the part where you add parameters. Also,
> can you post the code right before this exception
> "Daniel" <danny@noemail.com> wrote in message
> news:Oxo00WULEHA.1388@TK2MSFTNGP09.phx.gbl...
> > Hi,
> >
> > I am trying to update a db using the dataadapter, three command objects
> > (insert,update...) and a dataset (MS SQL Server). I create my command
> > objects via stored procedures which works fine. However when I call
> > dataAdapter.Update(dataSet, tableName); it throws the "Input string was
> not
> > in a correct format" and I have no idea why. Can someone help me?
> >
> > Thanks
> >
> >
>
>

William
Wed Apr 28 14:53:45 CDT 2004

Good to hear ;-)
"Daniel" <danny@noemail.com> wrote in message
news:ug3gQkVLEHA.1472@TK2MSFTNGP12.phx.gbl...
> I figured it out, the problem was the table name (order details) had a
space
> between the two words. Once I change that, it worked.
>
> Thanks
>
> "William Ryan eMVP" <dotnetguru@comcast.nospam.net> wrote in message
> news:OiWjSqULEHA.3052@TK2MSFTNGP12.phx.gbl...
> > I can't tell from here. Have you set your commandtype to CommandType
> > StoredProcedure? have you used "@" symbols for your params?
> >
> > Could you post the code where you create the UpdateCommand (not the
stored
> > proc although it would help, but the part where you add parameters.
Also,
> > can you post the code right before this exception
> > "Daniel" <danny@noemail.com> wrote in message
> > news:Oxo00WULEHA.1388@TK2MSFTNGP09.phx.gbl...
> > > Hi,
> > >
> > > I am trying to update a db using the dataadapter, three command
objects
> > > (insert,update...) and a dataset (MS SQL Server). I create my command
> > > objects via stored procedures which works fine. However when I call
> > > dataAdapter.Update(dataSet, tableName); it throws the "Input string
was
> > not
> > > in a correct format" and I have no idea why. Can someone help me?
> > >
> > > Thanks
> > >
> > >
> >
> >
>
>