DeMyu
asked on
ASP.NET Context Sensitive Help from the database
I am having problems getting the application documented in this url to work when the help content is stored in a database:
http://aspnet.4guysfromrolla.com/articles/082306-1.aspx
I have attached my code snippet.
Thank you
http://aspnet.4guysfromrolla.com/articles/082306-1.aspx
I have attached my code snippet.
Thank you
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="AnotherDemo.aspx.vb" Inherits="AnotherDemo" %>
----- AnotherDemo.aspx
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Another Context-Sensitive Help Demo</title>
</head>
<body>
<form id="form1" runat="server">
<div>
</div>
<div>
<br />
<asp:image ID="budget" runat="server" imageurl="images/common/question.gif" />
</div>
</form>
</body>
</html>
----- AnotherDemo.aspx.vb
Partial Class AnotherDemo
Inherits ContextSensitiveHelp
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
AddContextSensitiveHelp(budget, "LongHelp", "generalhelp.aspx?cname=budget", True, 20, 5, 400, 300)
End Sub
End Class
========= generalhelp.aspx
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="GeneralHelp.aspx.vb" Inherits="HelpFiles_GeneralHelp" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<link href="HelpFile.css" rel="stylesheet" type="text/css" />
<title>General Help</title>
</head>
<body>
<h1>General Help</h1>
<p><asp:Image runat="server" ImageAlign="Right" ImageUrl="~/Images/bookCover.jpg" ID="MyBookCoverImage" BorderColor="Black" BorderWidth="1px" BorderStyle="Solid" Width="100" Height="128" /></p>
<asp:DataList ID="dtlgalleries"
BorderStyle="Solid"
BorderWidth="1px"
runat="server"
PagerStyle-Visible="False">
<ItemTemplate>
<%# Eval("Help_Content") %>">
</ItemTemplate>
<ItemStyle VerticalAlign="Top" />
</asp:DataList>
<asp:SqlDataSource ID="SMGRWEB_DataSource" runat="server"
ConnectionString="<%$ ConnectionStrings:SITEdbConnectString %>" providername = "<%$ connectionstrings:SITEdbConnectString.ProviderName %>"
SelectCommand="dbo.P_SMGRWEB_WEBSITE_Show_Help_Content" SelectCommandType="StoredProcedure">
<SelectParameters>
<asp:Parameter Name="ControlName" Type="string" />
</SelectParameters>
</asp:SqlDataSource>
</body>
</html>
========= generalhelp.aspx.vb
Partial Class HelpFiles_GeneralHelp
Inherits System.Web.UI.Page
Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs)
SMGRWEB_DataSource.SelectParameters("ControlName").DefaultValue = "budget" 'request.querystring("cname")
End Sub
End Class
---- DB
CREATE PROCEDURE [dbo].[P_SMGRWEB_WEBSITE_Show_Help_Content]
(
@ControlName VARCHAR(50)=NULL
)
AS
SET NOCOUNT ON
SELECT Help_Content FROM dbo.context_help
WHERE ControlName = @ControlName
SET NOCOUNT OFF
GO
What problems are you having (exceptions, incorrect results, ...)?
ASKER
The generalhelp.aspx is not displaying the content from the database when passed the value of a querystring.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
TheLearnedOne,
Thank you! That resolved my problem plus the datasourceid was not declared in the datalist declaration. <asp:DataList ID="dtlgalleries"
DataSourceID="SMGRWEB_Data Source"
Thank you again.
Thank you! That resolved my problem plus the datasourceid was not declared in the datalist declaration. <asp:DataList ID="dtlgalleries"
DataSourceID="SMGRWEB_Data
Thank you again.