Trying to edit a DataRow

[Guest]

Can anyone tell me why I am getting this error?

Dim dr1 As DataRow = das2.Tables(0).Rows.Find("Baltimore")
dr1("[1]") = ascore

Try
dap2.Update(das2, "teamscores")
Catch
MsgBox(Err.Number)
MsgBox(Err.Description)
End Try

An unhandled exception of type 'System.FormatException' occurred in mscorlib.dll
Additional information: Input string was not in a correct format.

 

[William Ryan eMVP]

Is it throwing the exception on the dr1("[1]") line?

--
W.G. Ryan MVP Windows - Embedded

Have an opinion on the effectiveness of Microsoft Embedded newsgroups?
Let Microsoft know!
https://www.windowsembeddedeval.com/community/newsgroups

 

[Miha Markic [MVP C#]]

Hi Tom,

As Ryan asked - where the exception occurs?
If inside try/catch block then I would say your adapter is not well
configured.

 

[Miha Markic [MVP C#]]

Hi Tom,

Finds searches by primary key thus if your primary key isn't a string or
there is no pk at all you'll get an exception.
Since you are getting FormatException I guess your pk is not a string.
If you want to search by some other column, use DataView or DataTable.Select

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

It is throwing it at the Dim dr1 As DataRow =

das2.Tables(0).Rows.Find("Baltimore") statement.

Is it throwing the exception on the dr1("[1]") line?

--
W.G. Ryan MVP Windows - Embedded

Have an opinion on the effectiveness of Microsoft Embedded newsgroups?
Let Microsoft know!
https://www.windowsembeddedeval.com/community/newsgroups

Can anyone tell me why I am getting this error?

Dim dr1 As DataRow = das2.Tables(0).Rows.Find("Baltimore")
dr1("[1]") = ascore

Try
dap2.Update(das2, "teamscores")
Catch
MsgBox(Err.Number)
MsgBox(Err.Description)
End Try

An unhandled exception of type 'System.FormatException' occurred in mscorlib.dll
Additional information: Input string was not in a correct format.