Problem in getting value from textbox & radiobuttonlist to a valua

[velu]

Problem in getting value from textbox & radiobuttonlist to a valuable inside
a datagid.

I want to insert a record into a table thru datagrid. Here is the code (see
below)

Private Sub DataGrid1_ItemC ommand(ByVal source As Object, ByVal e As
System.Web.UI.W ebControls.Data GridCommandEven tArgs ) Handles
DataGrid1.ItemC ommand

Select Case e.CommandName

Case "rate_it"

If ((e.Item.ItemTy pe <> ListItemType.He ader) And (e.Item.ItemTyp e <>
ListItemType.Fo oter)) Then

DocumentID = Convert.ToInt32 (e.Item.Cells(7 ).Text)

Dim UserIP As String
UserIP = CStr(Request.Us erHostAddress)

Dim comments As String
Dim TB As TextBox
TB = CType(e.Item.Fi ndControl("Test Box1"), TextBox)
comments = TB.Text >>>>>>>>>>>>>>> >>>>>>>>>>>> Object reference not set to
an instance of an object. !!!!!!!!!!!!!!! !!!!!!!!!!!here is where I get
error!!!!!!!!!! !!!!!!!!!!!!!!! !!!!!
Description: An unhandled exception occurred during the execution of the
current web request. Please review

Dim rate As String

Dim RBL As New RadioButtonList
RBL = CType(e.Item.Fi ndControl("Radi oButtonList1"), RadioButtonList )
rate = Request.Form("R adioButtonList1 ")

Dim conPubs As SqlConnection
Dim cmdIns As SqlCommand
conPubs = New SqlConnection(" server=BGLAMDJV ELU;Database=Pu bs;Integrated
security=sspi")
cmdIns = New SqlCommand("INS ERT INTO tbl_rating (rating, ip, documentID,
usercomment) VALUES (" & rate & " ,'" & UserIP & "'," & DocumentID & ",'" &
comments & "');", conPubs)
conPubs.Open()
cmdIns.ExecuteR eader()
conPubs.Close()

End If

End Select

Pls help me I have been working for more than 5 days

Thx
Jk

[Karl Seguin]

The error seems straighforward. There is no TextBox1 for that item...
Check out what e.Item.ItemType is when you get that error...I bet it isn't
what you expect....maybe something like PageTemplate or soemthing...try
changing your if statement to

if (e.Item.ItemTyp e == ListItemType.It em || e.Item.ItemType ==
ListITemType.Al ternateItem)

if that doens't work, like I said, it seem slike something wrong w/your
html..

Karl

--
MY ASP.Net tutorials
http://www.openmymind.net/
"velu" <ve**@discussio ns.microsoft.co m> wrote in message
news:2A******** *************** ***********@mic rosoft.com...

Problem in getting value from textbox & radiobuttonlist to a valuable
inside
a datagid.

I want to insert a record into a table thru datagrid. Here is the code
(see
below)

Private Sub DataGrid1_ItemC ommand(ByVal source As Object, ByVal e As
System.Web.UI.W ebControls.Data GridCommandEven tArgs ) Handles
DataGrid1.ItemC ommand

Select Case e.CommandName

Case "rate_it"

If ((e.Item.ItemTy pe <> ListItemType.He ader) And (e.Item.ItemTyp e <>
ListItemType.Fo oter)) Then

DocumentID = Convert.ToInt32 (e.Item.Cells(7 ).Text)

Dim UserIP As String
UserIP = CStr(Request.Us erHostAddress)

Dim comments As String
Dim TB As TextBox
TB = CType(e.Item.Fi ndControl("Test Box1"), TextBox)
comments = TB.Text >>>>>>>>>>>>>>> >>>>>>>>>>>> Object reference not set to
an instance of an object. !!!!!!!!!!!!!!! !!!!!!!!!!!here is where I get
error!!!!!!!!!! !!!!!!!!!!!!!!! !!!!!
Description: An unhandled exception occurred during the execution of the
current web request. Please review

Dim rate As String

Dim RBL As New RadioButtonList
RBL = CType(e.Item.Fi ndControl("Radi oButtonList1"), RadioButtonList )
rate = Request.Form("R adioButtonList1 ")

Dim conPubs As SqlConnection
Dim cmdIns As SqlCommand
conPubs = New SqlConnection(" server=BGLAMDJV ELU;Database=Pu bs;Integrated
security=sspi")
cmdIns = New SqlCommand("INS ERT INTO tbl_rating (rating, ip, documentID,
usercomment) VALUES (" & rate & " ,'" & UserIP & "'," & DocumentID & ",'"
&
comments & "');", conPubs)
conPubs.Open()
cmdIns.ExecuteR eader()
conPubs.Close()

End If

End Select

Pls help me I have been working for more than 5 days

Thx
Jk

[velu]

ya i did try to change the if statment but no use. i dont see anything wrong
in the HTML part.

in fact i get value for UserIP and rate DocumentID. some how i need to store
the rate and Comments....

any thoughs ?

"Karl Seguin" wrote:

The error seems straighforward. There is no TextBox1 for that item...
Check out what e.Item.ItemType is when you get that error...I bet it isn't
what you expect....maybe something like PageTemplate or soemthing...try
changing your if statement to

if (e.Item.ItemTyp e == ListItemType.It em || e.Item.ItemType ==
ListITemType.Al ternateItem)

if that doens't work, like I said, it seem slike something wrong w/your
html..

Karl

--
MY ASP.Net tutorials
http://www.openmymind.net/
"velu" <ve**@discussio ns.microsoft.co m> wrote in message
news:2A******** *************** ***********@mic rosoft.com...

Problem in getting value from textbox & radiobuttonlist to a valuable
inside
a datagid.

I want to insert a record into a table thru datagrid. Here is the code
(see
below)

Private Sub DataGrid1_ItemC ommand(ByVal source As Object, ByVal e As
System.Web.UI.W ebControls.Data GridCommandEven tArgs ) Handles
DataGrid1.ItemC ommand

Select Case e.CommandName

Case "rate_it"

If ((e.Item.ItemTy pe <> ListItemType.He ader) And (e.Item.ItemTyp e <>
ListItemType.Fo oter)) Then

DocumentID = Convert.ToInt32 (e.Item.Cells(7 ).Text)

Dim UserIP As String
UserIP = CStr(Request.Us erHostAddress)

Dim comments As String
Dim TB As TextBox
TB = CType(e.Item.Fi ndControl("Test Box1"), TextBox)
comments = TB.Text >>>>>>>>>>>>>>> >>>>>>>>>>>> Object reference not set to
an instance of an object. !!!!!!!!!!!!!!! !!!!!!!!!!!here is where I get
error!!!!!!!!!! !!!!!!!!!!!!!!! !!!!!
Description: An unhandled exception occurred during the execution of the
current web request. Please review

Dim rate As String

Dim RBL As New RadioButtonList
RBL = CType(e.Item.Fi ndControl("Radi oButtonList1"), RadioButtonList )
rate = Request.Form("R adioButtonList1 ")

Dim conPubs As SqlConnection
Dim cmdIns As SqlCommand
conPubs = New SqlConnection(" server=BGLAMDJV ELU;Database=Pu bs;Integrated
security=sspi")
cmdIns = New SqlCommand("INS ERT INTO tbl_rating (rating, ip, documentID,
usercomment) VALUES (" & rate & " ,'" & UserIP & "'," & DocumentID & ",'"
&
comments & "');", conPubs)
conPubs.Open()
cmdIns.ExecuteR eader()
conPubs.Close()

End If

End Select

Pls help me I have been working for more than 5 days

Thx
Jk

[Karl Seguin]

It is possible that TestBox1 is embedded within another control, in this
case you'd need to do
e.Item.FindCont rol("parentCont rol').FindContr ol("TestBox1")

Karl

--
MY ASP.Net tutorials
http://www.openmymind.net/
"velu" <ve**@discussio ns.microsoft.co m> wrote in message
news:D8******** *************** ***********@mic rosoft.com...

ya i did try to change the if statment but no use. i dont see anything
wrong
in the HTML part.

in fact i get value for UserIP and rate DocumentID. some how i need to
store
the rate and Comments....

any thoughs ?

"Karl Seguin" wrote:

The error seems straighforward. There is no TextBox1 for that item...
Check out what e.Item.ItemType is when you get that error...I bet it
isn't
what you expect....maybe something like PageTemplate or soemthing...try
changing your if statement to

if (e.Item.ItemTyp e == ListItemType.It em || e.Item.ItemType ==
ListITemType.Al ternateItem)

if that doens't work, like I said, it seem slike something wrong w/your
html..

Karl

--
MY ASP.Net tutorials
http://www.openmymind.net/
"velu" <ve**@discussio ns.microsoft.co m> wrote in message
news:2A******** *************** ***********@mic rosoft.com...

> Problem in getting value from textbox & radiobuttonlist to a valuable
> inside
> a datagid.
>
> I want to insert a record into a table thru datagrid. Here is the code
> (see
> below)
>
> Private Sub DataGrid1_ItemC ommand(ByVal source As Object, ByVal e As
> System.Web.UI.W ebControls.Data GridCommandEven tArgs ) Handles
> DataGrid1.ItemC ommand
>
> Select Case e.CommandName
>
> Case "rate_it"
>
> If ((e.Item.ItemTy pe <> ListItemType.He ader) And (e.Item.ItemTyp e <>
> ListItemType.Fo oter)) Then
>
> DocumentID = Convert.ToInt32 (e.Item.Cells(7 ).Text)
>
>
>
> Dim UserIP As String
> UserIP = CStr(Request.Us erHostAddress)
>
> Dim comments As String
> Dim TB As TextBox
> TB = CType(e.Item.Fi ndControl("Test Box1"), TextBox)
> comments = TB.Text >>>>>>>>>>>>>>> >>>>>>>>>>>> Object reference not set
> to
> an instance of an object. !!!!!!!!!!!!!!! !!!!!!!!!!!here is where I get
> error!!!!!!!!!! !!!!!!!!!!!!!!! !!!!!
> Description: An unhandled exception occurred during the execution of
> the
> current web request. Please review
>
> Dim rate As String
>
> Dim RBL As New RadioButtonList
> RBL = CType(e.Item.Fi ndControl("Radi oButtonList1"), RadioButtonList )
> rate = Request.Form("R adioButtonList1 ")
>
> Dim conPubs As SqlConnection
> Dim cmdIns As SqlCommand
> conPubs = New
> SqlConnection(" server=BGLAMDJV ELU;Database=Pu bs;Integrated
> security=sspi")
> cmdIns = New SqlCommand("INS ERT INTO tbl_rating (rating, ip,
> documentID,
> usercomment) VALUES (" & rate & " ,'" & UserIP & "'," & DocumentID &
> ",'"
> &
> comments & "');", conPubs)
> conPubs.Open()
> cmdIns.ExecuteR eader()
> conPubs.Close()
>
> End If
>
> End Select
>
> Pls help me I have been working for more than 5 days
>
> Thx
> Jk
>

[velu]

Yes i did try that

e.Item.FindCont rol("panel1").F indControl("Tes tBox1") still i get "0"

I wonder we are somewere near. :-(

"Karl Seguin" wrote:

It is possible that TestBox1 is embedded within another control, in this
case you'd need to do
e.Item.FindCont rol("parentCont rol').FindContr ol("TestBox1")

Karl

--
MY ASP.Net tutorials
http://www.openmymind.net/
"velu" <ve**@discussio ns.microsoft.co m> wrote in message
news:D8******** *************** ***********@mic rosoft.com...

ya i did try to change the if statment but no use. i dont see anything
wrong
in the HTML part.

in fact i get value for UserIP and rate DocumentID. some how i need to
store
the rate and Comments....

any thoughs ?

"Karl Seguin" wrote:

The error seems straighforward. There is no TextBox1 for that item...
Check out what e.Item.ItemType is when you get that error...I bet it
isn't
what you expect....maybe something like PageTemplate or soemthing...try
changing your if statement to

if (e.Item.ItemTyp e == ListItemType.It em || e.Item.ItemType ==
ListITemType.Al ternateItem)

if that doens't work, like I said, it seem slike something wrong w/your
html..

Karl

--
MY ASP.Net tutorials
http://www.openmymind.net/
"velu" <ve**@discussio ns.microsoft.co m> wrote in message
news:2A******** *************** ***********@mic rosoft.com...
> Problem in getting value from textbox & radiobuttonlist to a valuable
> inside
> a datagid.
>
> I want to insert a record into a table thru datagrid. Here is the code
> (see
> below)
>
> Private Sub DataGrid1_ItemC ommand(ByVal source As Object, ByVal e As
> System.Web.UI.W ebControls.Data GridCommandEven tArgs ) Handles
> DataGrid1.ItemC ommand
>
> Select Case e.CommandName
>
> Case "rate_it"
>
> If ((e.Item.ItemTy pe <> ListItemType.He ader) And (e.Item.ItemTyp e <>
> ListItemType.Fo oter)) Then
>
> DocumentID = Convert.ToInt32 (e.Item.Cells(7 ).Text)
>
>
>
> Dim UserIP As String
> UserIP = CStr(Request.Us erHostAddress)
>
> Dim comments As String
> Dim TB As TextBox
> TB = CType(e.Item.Fi ndControl("Test Box1"), TextBox)
> comments = TB.Text >>>>>>>>>>>>>>> >>>>>>>>>>>> Object reference not set
> to
> an instance of an object. !!!!!!!!!!!!!!! !!!!!!!!!!!here is where I get
> error!!!!!!!!!! !!!!!!!!!!!!!!! !!!!!
> Description: An unhandled exception occurred during the execution of
> the
> current web request. Please review
>
> Dim rate As String
>
> Dim RBL As New RadioButtonList
> RBL = CType(e.Item.Fi ndControl("Radi oButtonList1"), RadioButtonList )
> rate = Request.Form("R adioButtonList1 ")
>
> Dim conPubs As SqlConnection
> Dim cmdIns As SqlCommand
> conPubs = New
> SqlConnection(" server=BGLAMDJV ELU;Database=Pu bs;Integrated
> security=sspi")
> cmdIns = New SqlCommand("INS ERT INTO tbl_rating (rating, ip,
> documentID,
> usercomment) VALUES (" & rate & " ,'" & UserIP & "'," & DocumentID &
> ",'"
> &
> comments & "');", conPubs)
> conPubs.Open()
> cmdIns.ExecuteR eader()
> conPubs.Close()
>
> End If
>
> End Select
>
> Pls help me I have been working for more than 5 days
>
> Thx
> Jk
>

[Karl Seguin]

You might need to start debugging your code, simplifying your html and stuff
:)

Karl

--
MY ASP.Net tutorials
http://www.openmymind.net/
"velu" <ve**@discussio ns.microsoft.co m> wrote in message
news:82******** *************** ***********@mic rosoft.com...

Yes i did try that

e.Item.FindCont rol("panel1").F indControl("Tes tBox1") still i get "0"

I wonder we are somewere near. :-(

"Karl Seguin" wrote:

It is possible that TestBox1 is embedded within another control, in this
case you'd need to do
e.Item.FindCont rol("parentCont rol').FindContr ol("TestBox1")

Karl

--
MY ASP.Net tutorials
http://www.openmymind.net/
"velu" <ve**@discussio ns.microsoft.co m> wrote in message
news:D8******** *************** ***********@mic rosoft.com...

> ya i did try to change the if statment but no use. i dont see anything
> wrong
> in the HTML part.
>
> in fact i get value for UserIP and rate DocumentID. some how i need to
> store
> the rate and Comments....
>
> any thoughs ?
>
> "Karl Seguin" wrote:
>
>> The error seems straighforward. There is no TextBox1 for that item...
>> Check out what e.Item.ItemType is when you get that error...I bet it
>> isn't
>> what you expect....maybe something like PageTemplate or
>> soemthing...try
>> changing your if statement to
>>
>> if (e.Item.ItemTyp e == ListItemType.It em || e.Item.ItemType ==
>> ListITemType.Al ternateItem)
>>
>> if that doens't work, like I said, it seem slike something wrong
>> w/your
>> html..
>>
>> Karl
>>
>> --
>> MY ASP.Net tutorials
>> http://www.openmymind.net/
>> "velu" <ve**@discussio ns.microsoft.co m> wrote in message
>> news:2A******** *************** ***********@mic rosoft.com...
>> > Problem in getting value from textbox & radiobuttonlist to a
>> > valuable
>> > inside
>> > a datagid.
>> >
>> > I want to insert a record into a table thru datagrid. Here is the
>> > code
>> > (see
>> > below)
>> >
>> > Private Sub DataGrid1_ItemC ommand(ByVal source As Object, ByVal e As
>> > System.Web.UI.W ebControls.Data GridCommandEven tArgs ) Handles
>> > DataGrid1.ItemC ommand
>> >
>> > Select Case e.CommandName
>> >
>> > Case "rate_it"
>> >
>> > If ((e.Item.ItemTy pe <> ListItemType.He ader) And (e.Item.ItemTyp e <>
>> > ListItemType.Fo oter)) Then
>> >
>> > DocumentID = Convert.ToInt32 (e.Item.Cells(7 ).Text)
>> >
>> >
>> >
>> > Dim UserIP As String
>> > UserIP = CStr(Request.Us erHostAddress)
>> >
>> > Dim comments As String
>> > Dim TB As TextBox
>> > TB = CType(e.Item.Fi ndControl("Test Box1"), TextBox)
>> > comments = TB.Text >>>>>>>>>>>>>>> >>>>>>>>>>>> Object reference not
>> > set
>> > to
>> > an instance of an object. !!!!!!!!!!!!!!! !!!!!!!!!!!here is where I
>> > get
>> > error!!!!!!!!!! !!!!!!!!!!!!!!! !!!!!
>> > Description: An unhandled exception occurred during the execution of
>> > the
>> > current web request. Please review
>> >
>> > Dim rate As String
>> >
>> > Dim RBL As New RadioButtonList
>> > RBL = CType(e.Item.Fi ndControl("Radi oButtonList1"), RadioButtonList )
>> > rate = Request.Form("R adioButtonList1 ")
>> >
>> > Dim conPubs As SqlConnection
>> > Dim cmdIns As SqlCommand
>> > conPubs = New
>> > SqlConnection(" server=BGLAMDJV ELU;Database=Pu bs;Integrated
>> > security=sspi")
>> > cmdIns = New SqlCommand("INS ERT INTO tbl_rating (rating, ip,
>> > documentID,
>> > usercomment) VALUES (" & rate & " ,'" & UserIP & "'," & DocumentID &
>> > ",'"
>> > &
>> > comments & "');", conPubs)
>> > conPubs.Open()
>> > cmdIns.ExecuteR eader()
>> > conPubs.Close()
>> >
>> > End If
>> >
>> > End Select
>> >
>> > Pls help me I have been working for more than 5 days
>> >
>> > Thx
>> > Jk
>> >
>>
>>
>>