getting an asp:textbox value to an sql parameter

[Chumley the Walrus]

I'm using this sql parameter:

MyCommand.Param eters("@Sport") .value = Server.HtmlEnco de(sport)

to get a value from a textbox control:

<asp:TextBox Name="sport" id="sport" runat="server"> </asp:TextBox>

but i cannot see why I get "Value of type
'System.Web.UI. WebControls.Tex tBox' cannot be converted to 'String'"
error when the value I'm passing is a string.

???
Chumley

[Sean Bright]

Try:

MyCommand.Param eters("@Sport") .value = Server.HtmlEnco de(sport.Text)
Chumley the Walrus wrote:

I'm using this sql parameter:

MyCommand.Param eters("@Sport") .value = Server.HtmlEnco de(sport)

to get a value from a textbox control:

<asp:TextBox Name="sport" id="sport" runat="server"> </asp:TextBox>

but i cannot see why I get "Value of type
'System.Web.UI. WebControls.Tex tBox' cannot be converted to 'String'"
error when the value I'm passing is a string.

???
Chumley

[Henry Johnson]

<<< but i cannot see why I get "Value of type
'System.Web.UI. WebControls.Tex tBox' cannot be converted to 'String'" error
when the value I'm passing is a string >>>
The reason you get this error is because in the .NET world, objects like
TextBoxes do not have default property values. In the VB6 world, textboxes
had a *default property* (which was text)... meaning that your syntax would
have worked... i.e., you simply specify the object (sport - which is a
textbox), and because you didn't specify the text property (sport.text), the
default property would be retrieved automatically for you. In other words,
VB6 allowed you to get away without specifying the .text property. .NET does
not allow for default properties... you must specify the .text property
explicitly (sport.Text)... and if you're using C#, be sure to get the case
right (sport.text would be different than sport.Text).

HTH

"Chumley the Walrus" <sp*******@yaho o.com> wrote in message
news:1e******** *************** ***@posting.goo gle.com...

I'm using this sql parameter:

MyCommand.Param eters("@Sport") .value = Server.HtmlEnco de(sport)

to get a value from a textbox control:

<asp:TextBox Name="sport" id="sport" runat="server"> </asp:TextBox>

but i cannot see why I get "Value of type
'System.Web.UI. WebControls.Tex tBox' cannot be converted to 'String'"
error when the value I'm passing is a string.

???
Chumley

[Cor Ligthert]

Hi Chumley,

Probably
MyCommand.Param eters("@Sport") .value = sport.text

(When you have added the parameter before to MyCommand, however I saw that
in another message. It is better to stay in the same thread by the way, than
people can see what you have done already)

I hope this helps?

Cor

[Chumley the Walrus]

> Probably

MyCommand.Param eters("@Sport") .value = sport.text

That again gives me an Object reference not set to an instance of an
object error.
Here is the subroutine I'm using with the click event and such (this
is part of a datagrid display, as for the BindGrid() reference). I'm
able to view the page that displays the datagrid and textboxes/button,
but get the error when i try to add something to the 'sport' and
'articleheader' textboxes:

Sub AddArticle_Clic k(Sender As Object, E As EventArgs)
If (Page.IsValid)

Dim DS As DataSet
Dim MyCommand As SqlCommand

Dim InsertCmd As String = "insert into tblArticles
(sport,articleh eader) values (@Sport, @articleheader) "

MyCommand.Param eters.Add(New SqlParameter("@ Sport",
SqlDbType.VarCh ar, 50))
MyCommand.Param eters("@Sport") .value = sport.Text

MyCommand.Param eters.Add(New SqlParameter("@ articleheader",
SqlDbType.nVarC har, 255))
MyCommand.Param eters("@article header").value =
articleheader.T ext

MyCommand.Conne ction.Open()

' testing from aspalliance stuff
myCommand.Execu teNonQuery()

MyCommand.Conne ction.Close()

End If

BindGrid()
End Sub