use gridview row control in sqldatasource insert command

Question

I am trying to use a label from another row in the gridview and insert it in a table when the user clicks the button which is in its own column.

my problem is that i cant get bookno which finds the label set to the @bookno in my sqldatasource

Protected Sub Button2_Click(ByVal sender As Object, ByVal e As System.EventArgs)
        Dim selectedRow As Button = DirectCast(sender, Button)



        Dim bookno As Label = CType(selectedRow.FindControl("label1"), Label)
        Dim why As TextBox = CType(selectedRow.FindControl("textbox2"), TextBox)
        Dim yesint As Integer = 1
        Dim sql As SqlDataSource = CType(selectedRow.FindControl("sqldatasource4"), SqlDataSource)
        sql.InsertParameters.Add(bookno.Text, 0)


        sql.Insert()

    End Sub

Are you getting any errors? And what does bookno.Text contains? Is it the parametername or the value? — gbs
– gbs, Commented May 18, 2011 at 19:35

Bala R · Accepted Answer · 2011-05-18 19:41:15Z

1

Try

Dim bookno As Label = CType(selectedRow.Parent.FindControl("label1"), Label)

and see if you get a valid control for bookno. If it works, do the same for other FindControl() calls.

answered May 18, 2011 at 19:41

Bala R

109k23 gold badges203 silver badges212 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

HELP_ME Over a year ago

what i did was just copied the sqldatasource into the booking template field set the label1 as the parameter control and just copied back the datasource to my outher templatefield and it worked great

Collectives™ on Stack Overflow

use gridview row control in sqldatasource insert command

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related