Specified cast is not valid error

[.Net Sports]

I have a datagrid script where I modify data in an sql dbase in
asp.net, when i hit the "update" button, I get a Specified cast is not
valid error on my 'descript' declaration, whereas 'descript' is a
multiline text box and a varchar datatype (everything else is either a
char or a datetime datatype). Am I assigning 'descript' a wrong
datatype? Tried making it a nvarchar, still get same result

''''''''''''''' ''''''''''''''' '

Sub MyDataGrid_Upda teCommand(s As Object, e As DataGridCommand EventArgs
)
Dim conn As SQLConnection
Dim MyCommand As SQLCommand
Dim strConn as string = "Server=sql.myd omain.com;Initi al
Catalog=mydb;Us er ID=DBxxx;Passwo rd=xxxxx;"
Dim company As textbox = E.Item.cells(2) .Controls(0)
Dim address As textbox = E.Item.cells(3) .Controls(0)
Dim city As textbox = E.Item.Cells(4) .Controls(0)
Dim state As textbox = E.Item.cells(5) .Controls(0)
Dim county As textbox = E.Item.cells(6) .Controls(0)
Dim zip As textbox = E.Item.cells(7) .Controls(0)
Dim phone As textbox = E.Item.cells(8) .Controls(0)
'''''' the following line declaring the descript var is the line of the
error
Dim descript As textbox = E.Item.cells(9) .Controls(0)
Dim web As textbox = E.Item.cells(10 ).Controls(0)
Dim email As textbox = E.Item.cells(11 ).Controls(0)
Dim datesold As textbox = E.Item.cells(12 ).Controls(0)
Dim dateexpire As textbox = E.Item.cells(13 ).Controls(0)

Dim strUpdateStmt As String
strUpdateStmt =" UPDATE CPAs SET" & _
" company = @company, address = @address, city = @city, state =
@state, " & _
"county = @county, zip = @zip, phone = @phone, descript =@
descript, " & _
"web = @web, email = @email, datesold = @datesold, dateexpire =
@dateexpire" & _
" WHERE cpaID = @cpaID"
conn = New SqlConnection(s trConn)
MyCommand = New SqlCommand(strU pdateStmt, conn)
MyCommand.Param eters.Add(New SqlParameter("@ company", company.text))
MyCommand.Param eters.Add(New SqlParameter("@ address", address.text))
MyCommand.Param eters.Add(New SqlParameter("@ city", city.text))
MyCommand.Param eters.Add(New SqlParameter("@ state", state.text))
MyCommand.Param eters.Add(New SqlParameter("@ county", county.text))
MyCommand.Param eters.Add(New SqlParameter("@ zip", zip.text))
MyCommand.Param eters.Add(New SqlParameter("@ phone", phone.text))
MyCommand.Param eters.Add(New SqlParameter("@ descript", descript.text))
MyCommand.Param eters.Add(New SqlParameter("@ web", web.text))
MyCommand.Param eters.Add(New SqlParameter("@ email", email.text))
MyCommand.Param eters.Add(New SqlParameter("@ datesold", datesold.text))
'', dateexpire =@dateexpire
MyCommand.Param eters.Add(New SqlParameter("@ dateexpire",
dateexpire.text ))

MyCommand.Param eters.Add(New SqlParameter("@ cpaID",
e.Item.Cells(1) .Text ))
conn.Open()
MyCommand.Execu teNonQuery()
MyDataGrid.Edit ItemIndex = -1
conn.close
BindData
End Sub

''''''''''''''' ''''''''''''''

netsports

[Cowboy \(Gregory A. Beamer\)]

How long is the text in the box? Is it constrained? If not you might have to
cast to a text type and give it a length which is long enough to hold the
amount of data that can be shoved into field. I also think there may be some
magic for a multi line text box, instead of placing the contents directly
into a parameter, try casting out as a string first and see if you get the
same issue.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
http://gregorybeamer.spaces.live.com

*************** *************** *************** ****
Think outside of the box!
*************** *************** *************** ****
".Net Sports" <ba********@cox .netwrote in message
news:11******** *************@m 73g2000cwd.goog legroups.com...

>I have a datagrid script where I modify data in an sql dbase in
asp.net, when i hit the "update" button, I get a Specified cast is not
valid error on my 'descript' declaration, whereas 'descript' is a
multiline text box and a varchar datatype (everything else is either a
char or a datetime datatype). Am I assigning 'descript' a wrong
datatype? Tried making it a nvarchar, still get same result

''''''''''''''' ''''''''''''''' '

Sub MyDataGrid_Upda teCommand(s As Object, e As DataGridCommand EventArgs
)
Dim conn As SQLConnection
Dim MyCommand As SQLCommand
Dim strConn as string = "Server=sql.myd omain.com;Initi al
Catalog=mydb;Us er ID=DBxxx;Passwo rd=xxxxx;"
Dim company As textbox = E.Item.cells(2) .Controls(0)
Dim address As textbox = E.Item.cells(3) .Controls(0)
Dim city As textbox = E.Item.Cells(4) .Controls(0)
Dim state As textbox = E.Item.cells(5) .Controls(0)
Dim county As textbox = E.Item.cells(6) .Controls(0)
Dim zip As textbox = E.Item.cells(7) .Controls(0)
Dim phone As textbox = E.Item.cells(8) .Controls(0)
'''''' the following line declaring the descript var is the line of the
error
Dim descript As textbox = E.Item.cells(9) .Controls(0)
Dim web As textbox = E.Item.cells(10 ).Controls(0)
Dim email As textbox = E.Item.cells(11 ).Controls(0)
Dim datesold As textbox = E.Item.cells(12 ).Controls(0)
Dim dateexpire As textbox = E.Item.cells(13 ).Controls(0)

Dim strUpdateStmt As String
strUpdateStmt =" UPDATE CPAs SET" & _
" company = @company, address = @address, city = @city, state =
@state, " & _
"county = @county, zip = @zip, phone = @phone, descript =@
descript, " & _
"web = @web, email = @email, datesold = @datesold, dateexpire =
@dateexpire" & _
" WHERE cpaID = @cpaID"
conn = New SqlConnection(s trConn)
MyCommand = New SqlCommand(strU pdateStmt, conn)
MyCommand.Param eters.Add(New SqlParameter("@ company", company.text))
MyCommand.Param eters.Add(New SqlParameter("@ address", address.text))
MyCommand.Param eters.Add(New SqlParameter("@ city", city.text))
MyCommand.Param eters.Add(New SqlParameter("@ state", state.text))
MyCommand.Param eters.Add(New SqlParameter("@ county", county.text))
MyCommand.Param eters.Add(New SqlParameter("@ zip", zip.text))
MyCommand.Param eters.Add(New SqlParameter("@ phone", phone.text))
MyCommand.Param eters.Add(New SqlParameter("@ descript", descript.text))
MyCommand.Param eters.Add(New SqlParameter("@ web", web.text))
MyCommand.Param eters.Add(New SqlParameter("@ email", email.text))
MyCommand.Param eters.Add(New SqlParameter("@ datesold", datesold.text))
'', dateexpire =@dateexpire
MyCommand.Param eters.Add(New SqlParameter("@ dateexpire",
dateexpire.text ))

MyCommand.Param eters.Add(New SqlParameter("@ cpaID",
e.Item.Cells(1) .Text ))
conn.Open()
MyCommand.Execu teNonQuery()
MyDataGrid.Edit ItemIndex = -1
conn.close
BindData
End Sub

''''''''''''''' ''''''''''''''

netsports