LinkButton in a datagrid???

[Tim::..]

Can someone tell me how I do a response.redire ct using a linkbutton in a
datagrid!

I want to use the record id in a database to send a querystring to an HTML
editor so that users are able to edit a particular page they have chosen from
a datagrid!

EG: If a user clicks the linkbutton in a datagrid it takes you to a page
with the following url...

.../editor.aspx?id= 23

Would appritiate any help!

Thanks

[Ken Cox [Microsoft MVP]]

Hi Tim,

Here's the idea. Let us know if it helps?

Ken
Microsoft MVP [ASP.NET]
Toronto
Private Sub Page_Load _
(ByVal sender As System.Object, _
ByVal e As System.EventArg s) Handles MyBase.Load
If Not IsPostBack Then
DataGrid1.DataS ource = CreateDataSourc e()
DataGrid1.DataB ind()
End If
End Sub

Private Sub DataGrid1_ItemC ommand _
(ByVal source As Object, _
ByVal e As System.Web.UI.W ebControls.Data GridCommandEven tArgs) _
Handles DataGrid1.ItemC ommand
' Check for the right link button
If e.CommandName = "Select" Then
' Build the redirection URL
Response.Redire ct("othersite.a spx?id=" & e.CommandArgume nt)
End If
End Sub

Function CreateDataSourc e() As DataTable
'ProductId
'DownloadURL()
'title()
Dim dt As New DataTable
Dim dr As DataRow
dt.Columns.Add( New DataColumn _
("ProductId" , GetType(Int32)) )
dt.Columns.Add( New DataColumn _
("DownloadUR L", GetType(String) ))
dt.Columns.Add( New DataColumn _
("title", GetType(String) ))
Dim i As Integer
For i = 0 To 8
dr = dt.NewRow()
dr(0) = i
dr(1) = "URL " + i.ToString()
dr(2) = "Item " + i.ToString()
dt.Rows.Add(dr)
Next i
Return dt
End Function 'CreateDataSour ce

<form id="Form1" method="post" runat="server">
<asp:DataGrid id="DataGrid1" runat="server">
<Columns>
<asp:BoundColum n DataField="Prod uctId"
Visible="False" ></asp:BoundColumn >
<asp:BoundColum n DataField="Down loadURL"
Visible="False" ></asp:BoundColumn >
<asp:TemplateCo lumn>
<ItemTemplate >
<asp:LinkButt on ID="lnkArticle "
CommandArgument ='<%#DataBinder .Eval(Container , "DataItem.Produ ctId")%>'
Runat="server" Text='<%#DataBi nder.Eval(Conta iner, "DataItem.Title ")%>'
CommandName="Se lect" />
</ItemTemplate>
</asp:TemplateCol umn>
</Columns>
</asp:DataGrid>
</form>
"Tim::.." <myatix_at_hotm ail.com> wrote in message
news:BD******** *************** ***********@mic rosoft.com...

Can someone tell me how I do a response.redire ct using a linkbutton in a
datagrid!

I want to use the record id in a database to send a querystring to an HTML
editor so that users are able to edit a particular page they have chosen
from
a datagrid!

EG: If a user clicks the linkbutton in a datagrid it takes you to a page
with the following url...

../editor.aspx?id= 23

Would appritiate any help!

Thanks

[Tim::..]

Hi Ken,

Thanks for the reply! I have managed to get the copy you sent me to work but
for some reason I just can't get to get it to work with my code!

I am using a datagrid rather than a datatable! Would this effect it in a big
way!

I would be really interested why this doesn't work!

Thanks
This is my code..

<asp:datagrid id="DGPages" runat="server" EnableViewState ="False"
AlternatingItem Style-BackColor="Whit eSmoke" CssClass="txtAr ea"
ShowFooter="fal se" HeaderStyle-Font-Bold="True"
HeaderStyle-HorizontalAlign ="Center" CellPadding="4" Width="50%"
AutoGenerateCol umns="False"
BorderStyle="Ri dge" BorderWidth="1p x" GridLines="Hori zontal"
BorderColor="Li ghtGray">
<EditItemStyl e BackColor="#EEE EEE"></EditItemStyle>
<AlternatingIte mStyle BackColor="Whit eSmoke"></AlternatingItem Style>
<HeaderStyle Font-Bold="True" HorizontalAlign ="Center"
ForeColor="Whit e" BackColor="Blac k"></HeaderStyle>
<Columns>
<asp:BoundColum n DataField="Page Id"
Visible="False" ></asp:BoundColumn >

<asp:TemplateCo lumn>
<ItemStyle HorizontalAlign ="Center"></ItemStyle>
<ItemTemplate >
<img src="../images/page.gif">
</ItemTemplate>
</asp:TemplateCol umn>
<asp:TemplateCo lumn HeaderText="Pag e">
<ItemStyle HorizontalAlign ="Center"></ItemStyle>
<ItemTemplate >
<%# Container.DataI tem("header") %>
</ItemTemplate>
</asp:TemplateCol umn>
<asp:TemplateCo lumn HeaderText="Des cription">
<ItemStyle HorizontalAlign ="Center"></ItemStyle>
<ItemTemplate >
<%# Container.DataI tem("descriptio n") %>
</ItemTemplate>
</asp:TemplateCol umn>
<asp:TemplateCo lumn>
<ItemStyle HorizontalAlign ="Center"></ItemStyle>
<ItemTemplate >
<asp:LinkButt on ID="PageEdit"
CommandArgument ='<%#DataBinder .Eval(Container , "DataItem.PageI d")%>'
Text='<img border=0 src=../images/edit.gif alt=Edit Page>'
CommandName="Se lect" Runat="server">
</asp:LinkButton>
</ItemTemplate>
<ItemStyle HorizontalAlign ="Center"></ItemStyle>
</asp:TemplateCol umn>
<asp:TemplateCo lumn>
<ItemStyle HorizontalAlign ="Center"></ItemStyle>
<ItemTemplate >
<asp:LinkButt on ID="PagePropert ies"
CommandArgument ='<%#DataBinder .Eval(Container , "DataItem.PageI d")%>'
Runat="server" Text="<img border=0 src=../images/properties.gif alt=Page
Properties>" CommandName="Pr operties">
</asp:LinkButton>
</ItemTemplate>
</asp:TemplateCol umn>
</Columns>
</asp:datagrid>

Private Sub Page_Load(ByVal sender As System.Object, ByVal e As
System.EventArg s) Handles MyBase.Load

'Put user code to initialize the page here

If Not Page.IsPostBack Then

BindData()

End If

End Sub

Sub BindData()

Dim Myconn As New SqlConnection(C onfigurationSet tings.AppSettin gs("strConn"))

Dim cmd As New SqlCommand("Pag eDetails", Myconn)

cmd.CommandType = CommandType.Sto redProcedure

Myconn.Open()

Dim objOfficeName, objID As SqlParameter

objOfficeName = cmd.Parameters. Add("@OfficeNam e", SqlDbType.Char)

'objID = cmd.Parameters. Add("@ID", SqlDbType.Int)

objOfficeName.D irection = ParameterDirect ion.Input

'objID.Directio n = ParameterDirect ion.Input

objOfficeName.V alue = FindOffice()

'objID.Value = 2

Dim myReader As SqlDataReader = cmd.ExecuteRead er()

Dim hasRows As Boolean

hasRows = True

DGPages.DataSou rce = myReader

DGPages.DataBin d()

If DGPages.Items.C ount = 0 Then

lblNoContent.Vi sible = True

lblNoContent.Te xt = "There a currently no pages for" & " " & FindOffice()

End If

myReader.Close( )

Myconn.Close()

End Sub 'Loads Data into Datagrid

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

' Check for the right link button

If e.CommandName = "Select" Then

' Build the redirection URL

Response.Redire ct("../default.aspx?id =" & e.CommandArgume nt)

End If

End Sub

[Ken Cox [Microsoft MVP]]

Hey Tim,

Why not do it the simple way and use a hyperlink column?

<asp:hyperlinkc olumn DataNavigateUrl Field="pageid"
DataNavigateUrl FormatString="d estination.aspx ?id={0}"
DataTextField=" PageId"></asp:hyperlinkco lumn>

"Tim::.." <myatix_at_hotm ail.com> wrote in message
news:E9******** *************** ***********@mic rosoft.com...

Hi Ken,

Thanks for the reply! I have managed to get the copy you sent me to work
but
for some reason I just can't get to get it to work with my code!

I am using a datagrid rather than a datatable! Would this effect it in a
big
way!

I would be really interested why this doesn't work!

Thanks
This is my code..

<asp:datagrid id="DGPages" runat="server" EnableViewState ="False"
AlternatingItem Style-BackColor="Whit eSmoke" CssClass="txtAr ea"
ShowFooter="fal se" HeaderStyle-Font-Bold="True"
HeaderStyle-HorizontalAlign ="Center" CellPadding="4" Width="50%"
AutoGenerateCol umns="False"
BorderStyle="Ri dge" BorderWidth="1p x" GridLines="Hori zontal"
BorderColor="Li ghtGray">
<EditItemStyl e BackColor="#EEE EEE"></EditItemStyle>
<AlternatingIte mStyle
BackColor="Whit eSmoke"></AlternatingItem Style>
<HeaderStyle Font-Bold="True" HorizontalAlign ="Center"
ForeColor="Whit e" BackColor="Blac k"></HeaderStyle>
<Columns>
<asp:BoundColum n DataField="Page Id"
Visible="False" ></asp:BoundColumn >

<asp:TemplateCo lumn>
<ItemStyle HorizontalAlign ="Center"></ItemStyle>
<ItemTemplate >
<img src="../images/page.gif">
</ItemTemplate>
</asp:TemplateCol umn>
<asp:TemplateCo lumn HeaderText="Pag e">
<ItemStyle HorizontalAlign ="Center"></ItemStyle>
<ItemTemplate >
<%# Container.DataI tem("header") %>
</ItemTemplate>
</asp:TemplateCol umn>
<asp:TemplateCo lumn HeaderText="Des cription">
<ItemStyle HorizontalAlign ="Center"></ItemStyle>
<ItemTemplate >
<%# Container.DataI tem("descriptio n") %>
</ItemTemplate>
</asp:TemplateCol umn>
<asp:TemplateCo lumn>
<ItemStyle HorizontalAlign ="Center"></ItemStyle>
<ItemTemplate >
<asp:LinkButt on ID="PageEdit"
CommandArgument ='<%#DataBinder .Eval(Container , "DataItem.PageI d")%>'
Text='<img border=0 src=../images/edit.gif alt=Edit Page>'
CommandName="Se lect" Runat="server">
</asp:LinkButton>
</ItemTemplate>
<ItemStyle HorizontalAlign ="Center"></ItemStyle>
</asp:TemplateCol umn>
<asp:TemplateCo lumn>
<ItemStyle HorizontalAlign ="Center"></ItemStyle>
<ItemTemplate >
<asp:LinkButt on ID="PagePropert ies"
CommandArgument ='<%#DataBinder .Eval(Container , "DataItem.PageI d")%>'
Runat="server" Text="<img border=0 src=../images/properties.gif alt=Page
Properties>" CommandName="Pr operties">
</asp:LinkButton>
</ItemTemplate>
</asp:TemplateCol umn>
</Columns>
</asp:datagrid>

Private Sub Page_Load(ByVal sender As System.Object, ByVal e As
System.EventArg s) Handles MyBase.Load

'Put user code to initialize the page here

If Not Page.IsPostBack Then

BindData()

End If

End Sub

Sub BindData()

Dim Myconn As New
SqlConnection(C onfigurationSet tings.AppSettin gs("strConn"))

Dim cmd As New SqlCommand("Pag eDetails", Myconn)

cmd.CommandType = CommandType.Sto redProcedure

Myconn.Open()

Dim objOfficeName, objID As SqlParameter

objOfficeName = cmd.Parameters. Add("@OfficeNam e", SqlDbType.Char)

'objID = cmd.Parameters. Add("@ID", SqlDbType.Int)

objOfficeName.D irection = ParameterDirect ion.Input

'objID.Directio n = ParameterDirect ion.Input

objOfficeName.V alue = FindOffice()

'objID.Value = 2

Dim myReader As SqlDataReader = cmd.ExecuteRead er()

Dim hasRows As Boolean

hasRows = True

DGPages.DataSou rce = myReader

DGPages.DataBin d()

If DGPages.Items.C ount = 0 Then

lblNoContent.Vi sible = True

lblNoContent.Te xt = "There a currently no pages for" & " " & FindOffice()

End If

myReader.Close( )

Myconn.Close()

End Sub 'Loads Data into Datagrid

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

' Check for the right link button

If e.CommandName = "Select" Then

' Build the redirection URL

Response.Redire ct("../default.aspx?id =" & e.CommandArgume nt)

End If

End Sub

[Tim::..]

This doesn't provided me with what I require as far as I know!

I also get an error saying "The active scheme does not support the element!

Thanks
"Ken Cox [Microsoft MVP]" wrote:

Hey Tim,

Why not do it the simple way and use a hyperlink column?

<asp:hyperlinkc olumn DataNavigateUrl Field="pageid"
DataNavigateUrl FormatString="d estination.aspx ?id={0}"
DataTextField=" PageId"></asp:hyperlinkco lumn>

"Tim::.." <myatix_at_hotm ail.com> wrote in message
news:E9******** *************** ***********@mic rosoft.com...

Hi Ken,

Thanks for the reply! I have managed to get the copy you sent me to work
but
for some reason I just can't get to get it to work with my code!

I am using a datagrid rather than a datatable! Would this effect it in a
big
way!

I would be really interested why this doesn't work!

Thanks
This is my code..

<asp:datagrid id="DGPages" runat="server" EnableViewState ="False"
AlternatingItem Style-BackColor="Whit eSmoke" CssClass="txtAr ea"
ShowFooter="fal se" HeaderStyle-Font-Bold="True"
HeaderStyle-HorizontalAlign ="Center" CellPadding="4" Width="50%"
AutoGenerateCol umns="False"
BorderStyle="Ri dge" BorderWidth="1p x" GridLines="Hori zontal"
BorderColor="Li ghtGray">
<EditItemStyl e BackColor="#EEE EEE"></EditItemStyle>
<AlternatingIte mStyle
BackColor="Whit eSmoke"></AlternatingItem Style>
<HeaderStyle Font-Bold="True" HorizontalAlign ="Center"
ForeColor="Whit e" BackColor="Blac k"></HeaderStyle>
<Columns>
<asp:BoundColum n DataField="Page Id"
Visible="False" ></asp:BoundColumn >

<asp:TemplateCo lumn>
<ItemStyle HorizontalAlign ="Center"></ItemStyle>
<ItemTemplate >
<img src="../images/page.gif">
</ItemTemplate>
</asp:TemplateCol umn>
<asp:TemplateCo lumn HeaderText="Pag e">
<ItemStyle HorizontalAlign ="Center"></ItemStyle>
<ItemTemplate >
<%# Container.DataI tem("header") %>
</ItemTemplate>
</asp:TemplateCol umn>
<asp:TemplateCo lumn HeaderText="Des cription">
<ItemStyle HorizontalAlign ="Center"></ItemStyle>
<ItemTemplate >
<%# Container.DataI tem("descriptio n") %>
</ItemTemplate>
</asp:TemplateCol umn>
<asp:TemplateCo lumn>
<ItemStyle HorizontalAlign ="Center"></ItemStyle>
<ItemTemplate >
<asp:LinkButt on ID="PageEdit"
CommandArgument ='<%#DataBinder .Eval(Container , "DataItem.PageI d")%>'
Text='<img border=0 src=../images/edit.gif alt=Edit Page>'
CommandName="Se lect" Runat="server">
</asp:LinkButton>
</ItemTemplate>
<ItemStyle HorizontalAlign ="Center"></ItemStyle>
</asp:TemplateCol umn>
<asp:TemplateCo lumn>
<ItemStyle HorizontalAlign ="Center"></ItemStyle>
<ItemTemplate >
<asp:LinkButt on ID="PagePropert ies"
CommandArgument ='<%#DataBinder .Eval(Container , "DataItem.PageI d")%>'
Runat="server" Text="<img border=0 src=../images/properties.gif alt=Page
Properties>" CommandName="Pr operties">
</asp:LinkButton>
</ItemTemplate>
</asp:TemplateCol umn>
</Columns>
</asp:datagrid>

Private Sub Page_Load(ByVal sender As System.Object, ByVal e As
System.EventArg s) Handles MyBase.Load

'Put user code to initialize the page here

If Not Page.IsPostBack Then

BindData()

End If

End Sub

Sub BindData()

Dim Myconn As New
SqlConnection(C onfigurationSet tings.AppSettin gs("strConn"))

Dim cmd As New SqlCommand("Pag eDetails", Myconn)

cmd.CommandType = CommandType.Sto redProcedure

Myconn.Open()

Dim objOfficeName, objID As SqlParameter

objOfficeName = cmd.Parameters. Add("@OfficeNam e", SqlDbType.Char)

'objID = cmd.Parameters. Add("@ID", SqlDbType.Int)

objOfficeName.D irection = ParameterDirect ion.Input

'objID.Directio n = ParameterDirect ion.Input

objOfficeName.V alue = FindOffice()

'objID.Value = 2

Dim myReader As SqlDataReader = cmd.ExecuteRead er()

Dim hasRows As Boolean

hasRows = True

DGPages.DataSou rce = myReader

DGPages.DataBin d()

If DGPages.Items.C ount = 0 Then

lblNoContent.Vi sible = True

lblNoContent.Te xt = "There a currently no pages for" & " " & FindOffice()

End If

myReader.Close( )

Myconn.Close()

End Sub 'Loads Data into Datagrid

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

' Check for the right link button

If e.CommandName = "Select" Then

' Build the redirection URL

Response.Redire ct("../default.aspx?id =" & e.CommandArgume nt)

End If

End Sub