This message was discovered on ASPFriends.com 'aspngdatagridrepeaterdatalist' list.
| =?iso-8859-1?Q?Andr=E9_Colbi=F6rnsen?= |
How 'bout this:
<script language="VB" runat="server">
Dim strAbstract As String = Context.Request.Form("Abstract")
Sub Page_Load
If Not isPostBack Then
If Not strAbstract = "" Then
Abstract.Text = strAbstract
Else
strAbstract = Abstract.Text
End IF
BindDataGrid(strAbstract )
End If
End Sub
Sub BindDataGrid(ByVal strAbstract As String)
Dim SqlText As String = "SELECT tblCatalog.CatalogID,
tblCatalog.Title, tblCatalog.Author, tblCatalog.Publication,
tblCatalog.DatePublished, tblCatalog.CopyrightYear, tblCatalog.Abstract
FROM tblCatalog WHERE ((tblCatalog.Title) Like '%" & strAbstract & "%')"
Regards/Halsningar
Andre Colbiornsen
--------------------------------------
Sonnenburg Communications
Bergsgatan 3,
SE-211 54 Malmö
Sweden
Tel.: +46-(0)40-97 78 80
Fax.: +46-(0)40-97 78 80
Mob.: +46-(0)708-97 78 79
Mail: Click here to reveal e-mail address
Web.: www.sonnenburg.se
----------------------------------------
B2B Web Solutions - Specializing in .Net
----------------------------------------
-----Ursprungligt meddelande-----
Från: Eric [mailto:Click here to reveal e-mail address]
Skickat: den 24 juli 2002 22:18
Till: aspngDataGridRepeaterDatalist
Ämne: [aspngdatagridrepeaterdatalist] Re: Passing a value to a DataGrid
ok, but how I do both retrieve the value from the other page and also
from the label control? I added the lines in bold. Thanks.
<script language="VB" runat="server">
Sub Page_Load
If Not isPostBack Then
BindDataGrid()
End If
End Sub
Sub BindDataGrid
Dim strAbstract As String = Context.Request.Form("Abstract")
Abstract.Text = strAbstract
Dim SqlText As String = "SELECT tblCatalog.CatalogID,
tblCatalog.Title, tblCatalog.Author, tblCatalog.Publication,
tblCatalog.DatePublished, tblCatalog.CopyrightYear, tblCatalog.Abstract
FROM tblCatalog WHERE ((tblCatalog.Title) Like '%" & strAbstract & "%')"
'Create Sqlconnection
'Create SqlAdapter
'Create and fill DataSet
'Bind to DataGrid
Sub dgAbstract_PageIndexChanged(s As Object, e As
DataGridPageChangedEventArgs)
dgAbstract.CurrentPageIndex = e.NewPageIndex
BindDataGrid()
End Sub
</script>
<form runat="server">
<asp:label id="Abstract" runat="server" />
<asp:DataGrid id="dgAbstract" runat="server" />
</form>
-----Original Message-----
From: Das [mailto:Click here to reveal e-mail address]
Sent: Wednesday, July 24, 2002 3:16 PM
To: aspngDataGridRepeaterDatalist
Subject: [aspngdatagridrepeaterdatalist] Re: Passing a value to a
DataGrid
Best way is to have a Label Web Server Control with a visible property
set to "False". You can use this Label web server control to store any
value. Retrieving the value from the Label Web server control is also
very simple.
To know more about Label Web Server control, read this:
http://aspalliance.com/das/tutorial/label.aspx" target="_blank">http://aspalliance.com/das/tutorial/label.aspx
Want to start with ASP.NET, read my ASP.NET tutorial at
http://aspalliance.com/das/tutorial/default.aspx
:-)
Jesudas Chinnathampi (Das)
Co-Author - Beginning ASP.NET Databases using VB.NET
http://www.amazon.com/exec/obidos/ASIN/1861006195
Co-Author - Beginning ASP.NET Databases using C#
http://www.amazon.com/exec/obidos/ASIN/1861007418
Read my articles on ASP .NET at
http://aspalliance.com/das
----- Original Message -----
From: "Eric" <Click here to reveal e-mail address>
To: "aspngDataGridRepeaterDatalist"
<Click here to reveal e-mail address>
Sent: Wednesday, July 24, 2002 2:26 PM
Subject: [aspngdatagridrepeaterdatalist] Passing a value to a DataGrid
[Original message clipped]
| [aspngdatagridrepeaterdatalist] member Click here to reveal e-mail address = YOUR ID
| http://www.aspfriends.com/aspfriends/aspngdatagridrepeaterdatalist.asp
| = JOIN/QUIT
| [aspngdatagridrepeaterdatalist] member Click here to reveal e-mail address = YOUR
ID |
http://www.aspfriends.com/aspfriends/aspngdatagridrepeaterdatalist.asp JOIN/QUIT
|
|
| |
| |
| Eric |
Thanks again André for your patience for these simple questions. I think
we almost have it. The error is now:
Compiler Error Message: BC30455: Argument not specified for parameter
'strAbstract' of 'Public Sub BindDataGrid(strAbstract As String)'.
Sub dgAbstract_PageIndexChanged(s As Object, e As
DataGridPageChangedEventArgs)
dgAbstract.CurrentPageIndex = e.NewPageIndex
BindDataGrid() 'Error here
End Sub
-----Original Message-----
From: André Colbiörnsen [mailto:Click here to reveal e-mail address]
Sent: Wednesday, July 24, 2002 4:58 PM
To: aspngDataGridRepeaterDatalist
Subject: [aspngdatagridrepeaterdatalist] SV: Re: Passing a value to a
DataGrid
How 'bout this:
<script language="VB" runat="server">
Dim strAbstract As String = Context.Request.Form("Abstract")
Sub Page_Load
If Not isPostBack Then
If Not strAbstract = "" Then
Abstract.Text = strAbstract
Else
strAbstract = Abstract.Text
End IF
BindDataGrid(strAbstract )
End If
End Sub
Sub BindDataGrid(ByVal strAbstract As String)
Dim SqlText As String = "SELECT tblCatalog.CatalogID,
tblCatalog.Title, tblCatalog.Author, tblCatalog.Publication,
tblCatalog.DatePublished, tblCatalog.CopyrightYear, tblCatalog.Abstract
FROM tblCatalog WHERE ((tblCatalog.Title) Like '%" & strAbstract & "%')"
Regards/Halsningar
Andre Colbiornsen
--------------------------------------
Sonnenburg Communications
Bergsgatan 3,
SE-211 54 Malmö
Sweden
Tel.: +46-(0)40-97 78 80
Fax.: +46-(0)40-97 78 80
Mob.: +46-(0)708-97 78 79
Mail: Click here to reveal e-mail address
Web.: www.sonnenburg.se
----------------------------------------
B2B Web Solutions - Specializing in .Net
----------------------------------------
-----Ursprungligt meddelande-----
Från: Eric [mailto:Click here to reveal e-mail address]
Skickat: den 24 juli 2002 22:18
Till: aspngDataGridRepeaterDatalist
Ämne: [aspngdatagridrepeaterdatalist] Re: Passing a value to a DataGrid
ok, but how I do both retrieve the value from the other page and also
from the label control? I added the lines in bold. Thanks.
<script language="VB" runat="server">
Sub Page_Load
If Not isPostBack Then
BindDataGrid()
End If
End Sub
Sub BindDataGrid
Dim strAbstract As String = Context.Request.Form("Abstract")
Abstract.Text = strAbstract
Dim SqlText As String = "SELECT tblCatalog.CatalogID,
tblCatalog.Title, tblCatalog.Author, tblCatalog.Publication,
tblCatalog.DatePublished, tblCatalog.CopyrightYear, tblCatalog.Abstract
FROM tblCatalog WHERE ((tblCatalog.Title) Like '%" & strAbstract & "%')"
'Create Sqlconnection
'Create SqlAdapter
'Create and fill DataSet
'Bind to DataGrid
Sub dgAbstract_PageIndexChanged(s As Object, e As
DataGridPageChangedEventArgs)
dgAbstract.CurrentPageIndex = e.NewPageIndex
BindDataGrid()
End Sub
</script>
<form runat="server">
<asp:label id="Abstract" runat="server" />
<asp:DataGrid id="dgAbstract" runat="server" />
</form>
-----Original Message-----
From: Das [mailto:Click here to reveal e-mail address]
Sent: Wednesday, July 24, 2002 3:16 PM
To: aspngDataGridRepeaterDatalist
Subject: [aspngdatagridrepeaterdatalist] Re: Passing a value to a
DataGrid
Best way is to have a Label Web Server Control with a visible property
set to "False". You can use this Label web server control to store any
value. Retrieving the value from the Label Web server control is also
very simple.
To know more about Label Web Server control, read this:
http://aspalliance.com/das/tutorial/label.aspx" target="_blank">http://aspalliance.com/das/tutorial/label.aspx
Want to start with ASP.NET, read my ASP.NET tutorial at
http://aspalliance.com/das/tutorial/default.aspx
:-)
Jesudas Chinnathampi (Das)
Co-Author - Beginning ASP.NET Databases using VB.NET
http://www.amazon.com/exec/obidos/ASIN/1861006195
Co-Author - Beginning ASP.NET Databases using C#
http://www.amazon.com/exec/obidos/ASIN/1861007418
Read my articles on ASP .NET at
http://aspalliance.com/das
----- Original Message -----
From: "Eric" <Click here to reveal e-mail address>
To: "aspngDataGridRepeaterDatalist"
<Click here to reveal e-mail address>
Sent: Wednesday, July 24, 2002 2:26 PM
Subject: [aspngdatagridrepeaterdatalist] Passing a value to a DataGrid
[Original message clipped]
| [aspngdatagridrepeaterdatalist] member Click here to reveal e-mail address = YOUR ID
| http://www.aspfriends.com/aspfriends/aspngdatagridrepeaterdatalist.asp
| = JOIN/QUIT
| [aspngdatagridrepeaterdatalist] member Click here to reveal e-mail address = YOUR
ID |
http://www.aspfriends.com/aspfriends/aspngdatagridrepeaterdatalist.asp JOIN/QUIT
| [aspngdatagridrepeaterdatalist] member Click here to reveal e-mail address = YOUR ID
| http://www.aspfriends.com/aspfriends/aspngdatagridrepeaterdatalist.asp
= JOIN/QUIT
|
|
| |
|
|
|
|
|
