By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
457,727 Members | 1,263 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 457,727 IT Pros & Developers. It's quick & easy.

Err when creating link to each line of grid ..?

P: n/a
Hi,
I am having err when creating link to each line of grid at LINE 38. My
objective in asp.net is: each line can be linked to page with your
parameters as VB 5/6, Delphi 5/6/7, etc....
See the code bellow:
Thanks!
---------------------------------------
Vilmar Brazão de Oliveira
HI-TEC Informática

<%@ Page Language="vb" Debug="true" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>

<script language="VB" runat="server">
Sub Page_Load(sender as Object, e as EventArgs)
Dim connString as String 'Create a connection string
connString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=" &
Server.MapPath("Northwind.mdb")
'C:\Arquivos de programas\Microsoft Office\Office\Samples\Northwind.mdb

'Open a connection
Dim objConnection as OleDbConnection
objConnection = New OleDbConnection(connString)
objConnection.Open()

'Specify the SQL string
Dim strSQL as String = "SELECT * FROM Clientes"

'Create a command object
Dim objCommand as OleDbCommand
objCommand = New OleDbCommand(strSQL, objConnection)

'Get a datareader
Dim objDataReader as OleDbDataReader
objDataReader = objCommand.ExecuteReader(CommandBehavior.CloseConn ection)

'Do the DataBinding
dgResults.DataSource = objDataReader
dgResults.DataBind()

'Close the datareader/db connection
objDataReader.Close()

'Montagem de link.
Dim I as Double
Dim Registro as String

For I = 0 To Me.dgResults.Items.Count - 1
Dim NomeLink As LinkButton =
CType(datagrid.Items(i).FindControl("NomeLink"), LinkButton) 'LINE 38
Registro = Tabela.Rows(I)
lnkEdita.CommandArgument = "Param=" & valor
Next
End Sub

Sub myItems_ItemDataBound(ByVal Sender As Object, ByVal e As
DataGridItemEventArgs)
dgResults.Attributes.Add("onClick","javascript:ale rt('texto');")

If e.Item.ItemType = ListItemType.Item Then
e.Item.Attributes.Add("onmouseover",
"this.style.backgroundColor='#EEEEEE'")
e.Item.Attributes.Add("onmouseout",
"this.style.backgroundColor='#F7EFC6'")
ElseIf e.Item.ItemType = ListItemType.AlternatingItem Then
e.Item.Attributes.Add("onmouseover",
"this.style.backgroundColor='#EEEEEE'")
e.Item.Attributes.Add("onmouseout",
"this.style.backgroundColor='#F7EFC6'")
End If
End Sub

Protected Sub EventoNoClick(ByVal sender As Object, ByVal e As
System.Web.UI.WebControls.CommandEventArgs)
Response.Redirect("SeuAspx.aspx?" & e.CommandArgument)
End Sub

'FFFFEF »»um tom de amarelo bem claro.
'F7EFC6 »»um tom de amarelo meio ocre.
</script>

<html>

<head>
<title>Exemplo consulta com ASP.Net - 02</title>
</head>

<body text="#000000" bgcolor="#ffffff">
<h1>Exemplo consulta com ASP.Net - 01</h1>

<asp:DataGrid
id="dgResults" runat="server" Width="700" BackColor="#F7EFC6"
BorderColor="black"
ShowFooter="false" CellPadding="3" CellSpacing="0" Font-Name="Verdana"
Font-Size="8pt"
HeaderStyle-BackColor="#ffaad" OnItemDataBound="myItems_ItemDataBound">
</asp:DataGrid>

<asp:TemplateColumn HeaderText="Assunto">
<ItemStyle width="33%"></ItemStyle>
<ItemTemplate>
<asp:LinkButton id="NomeLink" runat="server" OnCommand="EventoNoClick"
Font-Size="9pt"
Text='<%# DataBinder.Eval(DataSet, "Tables[Tabela].DefaultView.[0].Campo")
%>'>
</asp:LinkButton>
</ItemTemplate>
</asp:TemplateColumn>

</body>
</html>
Nov 18 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.