Re: Anyone know what this means? (Updating DataGridView)

On Jun 5, 5:40 pm, "PlatinumBay" <stevan...@xxxxxxxxxxxxxxxx> wrote:
Looch,

Which line is causing the problem? Can you provide a stack trace?

Go to the web.config and set TraceLevel to 4. Using the debug output
viewer and capture the trace output while reproing the problem and that will
spell out exactly what is going on.

Hope this helps,

Steve

"Looch" <lucianoj2...@xxxxxxxxx> wrote in message

news:1181076371.779961.99860@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx



Hi all,

Here's the code I'm using:

Dim sqlCnn As New SqlConnection(cnn)
Dim sqlCmd As New SqlCommand("Update AMS.dbo.Call_Log Set
Status = @status, UPSTrack = @ups where TicketNumberActual =
@ticketnumber", sqlCnn)
sqlCmd.Parameters.AddWithValue("@ticketnumber",
SqlDbType.BigInt.ToString())
sqlCmd.Parameters(0).Value =
dgConsumables.Columns("TicketNumberActual")
sqlCmd.Parameters.Add("@status", SqlDbType.NVarChar, 50)
sqlCmd.Parameters(1).Value = dgConsumables.Columns("Status")
sqlCmd.Parameters.Add("@ups", SqlDbType.NVarChar, 50)
sqlCmd.Parameters(2).Value = dgConsumables.Columns("UPSTrack")
sqlCnn.Open()
sqlCmd.ExecuteNonQuery()
sqlCnn.Close()

And I'm getting this error:

No mapping exists from object type
System.Windows.Forms.DataGridViewTextBoxColumn to a known managed
provider native type.

I think it has to do with not specifying the cell's value, but that's
just a guess.

Any idea what that means?

Thanks!- Hide quoted text -

- Show quoted text -


This is a straight vb app, no web.config (unless I'm seriously missing
something, in which I'm shutting off my pc for good :D). The
ExecuteNonQuery line is throwing the error.

.

Relevant Pages

  • Re: Anyone know what this means? (Updating DataGridView)
    ... Can you provide a stack trace? ... Go to the web.config and set TraceLevel to 4. ... Using the debug output ... provider native type. ...
    (microsoft.public.dotnet.languages.vb)
  • Empty stack trace/method call from nowhere?
    ... for debugging, in order to find out where a problematic call came from. ... the stack trace contains only the method with the debug output itself. ... Admittedly, this *is* an applet running in the Microsoft VM, but I find ...
    (comp.lang.java.programmer)