help is needed in displaying different contents inside formview on linkbutton click
-
Hi all, iam not able to figure out what i have to do for displaying related record details inside formveiew on linkbutton click . i have added seperate linkbutton for each reservation and wants to display record details inside formview but problem is that only single record is displaying on all linkbutton clck i have seven records in table . here is my code
sqlcmd.CommandText = "Select Reserve_ID from Reservedvehicle"
sqlcmd.Connection = sqlconn
Dim sqlrdr As SqlDataReader = sqlcmd.ExecuteReader
While sqlrdr.Read()
Dim tblcell As TableCell = New TableCell()
Dim tblrow As TableRow = New TableRow()
Dim lnk As New LinkButton
lnk.Text = "click here for details "
lnk.CommandArgument = (sqlrdr("Reserve_ID"))
'add Click functionaliuty
AddHandler lnk.Command, AddressOf OnClickLink
tblcell.Controls.Add(lnk)
tblrow.Cells.Add(tblcell)
Table1.Rows.Add(tblrow)
End While
sqlrdr.Close()Here is event handler :
Protected Sub OnClickLink(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.CommandEventArgs)
Dim lnkbutton As linkbutton = sender
Dim param As String = e.CommandArgument
FormView1.Visible = True
Dim myConnection As New SqlConnection("Server=localhost;Database=Reservation;uid=sa;pwd=server")
Dim ad As New SqlDataAdapter("SELECT * FROM reservedvehicle ", myConnection)
Dim ds As New DataSet()
ad.Fill(ds)
FormView1.DataSource = ds
FormView1.DataBind()
End Subcan any body guide me what i have to do to reslove this issue . Best Regards Rameez
-
Hi all, iam not able to figure out what i have to do for displaying related record details inside formveiew on linkbutton click . i have added seperate linkbutton for each reservation and wants to display record details inside formview but problem is that only single record is displaying on all linkbutton clck i have seven records in table . here is my code
sqlcmd.CommandText = "Select Reserve_ID from Reservedvehicle"
sqlcmd.Connection = sqlconn
Dim sqlrdr As SqlDataReader = sqlcmd.ExecuteReader
While sqlrdr.Read()
Dim tblcell As TableCell = New TableCell()
Dim tblrow As TableRow = New TableRow()
Dim lnk As New LinkButton
lnk.Text = "click here for details "
lnk.CommandArgument = (sqlrdr("Reserve_ID"))
'add Click functionaliuty
AddHandler lnk.Command, AddressOf OnClickLink
tblcell.Controls.Add(lnk)
tblrow.Cells.Add(tblcell)
Table1.Rows.Add(tblrow)
End While
sqlrdr.Close()Here is event handler :
Protected Sub OnClickLink(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.CommandEventArgs)
Dim lnkbutton As linkbutton = sender
Dim param As String = e.CommandArgument
FormView1.Visible = True
Dim myConnection As New SqlConnection("Server=localhost;Database=Reservation;uid=sa;pwd=server")
Dim ad As New SqlDataAdapter("SELECT * FROM reservedvehicle ", myConnection)
Dim ds As New DataSet()
ad.Fill(ds)
FormView1.DataSource = ds
FormView1.DataBind()
End Subcan any body guide me what i have to do to reslove this issue . Best Regards Rameez
-
Hi all, iam not able to figure out what i have to do for displaying related record details inside formveiew on linkbutton click . i have added seperate linkbutton for each reservation and wants to display record details inside formview but problem is that only single record is displaying on all linkbutton clck i have seven records in table . here is my code
sqlcmd.CommandText = "Select Reserve_ID from Reservedvehicle"
sqlcmd.Connection = sqlconn
Dim sqlrdr As SqlDataReader = sqlcmd.ExecuteReader
While sqlrdr.Read()
Dim tblcell As TableCell = New TableCell()
Dim tblrow As TableRow = New TableRow()
Dim lnk As New LinkButton
lnk.Text = "click here for details "
lnk.CommandArgument = (sqlrdr("Reserve_ID"))
'add Click functionaliuty
AddHandler lnk.Command, AddressOf OnClickLink
tblcell.Controls.Add(lnk)
tblrow.Cells.Add(tblcell)
Table1.Rows.Add(tblrow)
End While
sqlrdr.Close()Here is event handler :
Protected Sub OnClickLink(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.CommandEventArgs)
Dim lnkbutton As linkbutton = sender
Dim param As String = e.CommandArgument
FormView1.Visible = True
Dim myConnection As New SqlConnection("Server=localhost;Database=Reservation;uid=sa;pwd=server")
Dim ad As New SqlDataAdapter("SELECT * FROM reservedvehicle ", myConnection)
Dim ds As New DataSet()
ad.Fill(ds)
FormView1.DataSource = ds
FormView1.DataBind()
End Subcan any body guide me what i have to do to reslove this issue . Best Regards Rameez
-
Hi all, iam not able to figure out what i have to do for displaying related record details inside formveiew on linkbutton click . i have added seperate linkbutton for each reservation and wants to display record details inside formview but problem is that only single record is displaying on all linkbutton clck i have seven records in table . here is my code
sqlcmd.CommandText = "Select Reserve_ID from Reservedvehicle"
sqlcmd.Connection = sqlconn
Dim sqlrdr As SqlDataReader = sqlcmd.ExecuteReader
While sqlrdr.Read()
Dim tblcell As TableCell = New TableCell()
Dim tblrow As TableRow = New TableRow()
Dim lnk As New LinkButton
lnk.Text = "click here for details "
lnk.CommandArgument = (sqlrdr("Reserve_ID"))
'add Click functionaliuty
AddHandler lnk.Command, AddressOf OnClickLink
tblcell.Controls.Add(lnk)
tblrow.Cells.Add(tblcell)
Table1.Rows.Add(tblrow)
End While
sqlrdr.Close()Here is event handler :
Protected Sub OnClickLink(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.CommandEventArgs)
Dim lnkbutton As linkbutton = sender
Dim param As String = e.CommandArgument
FormView1.Visible = True
Dim myConnection As New SqlConnection("Server=localhost;Database=Reservation;uid=sa;pwd=server")
Dim ad As New SqlDataAdapter("SELECT * FROM reservedvehicle ", myConnection)
Dim ds As New DataSet()
ad.Fill(ds)
FormView1.DataSource = ds
FormView1.DataBind()
End Subcan any body guide me what i have to do to reslove this issue . Best Regards Rameez
Hi, U hv properly coded but while retrieving data from Db to binding Formview u r not sending the Command Argument(Reserve_id) to Db.If u send that u can retrieve particular record based on reserve_id