Hello,
In a database table named t_content I have the following records:
id page name content
1 index introduction
Introduction Text
2 index welcome Welcome Text
3 index notes
4 contacts address Mailing Address
In index.aspx I want to display the content text from records 1, 2 and 3
in three existing div's. Something as:
<div id="introductio n">Introduct ion Text</div>
<div id="welcome">We lcome Text</div>
<div id="notes">&nbs p;</div> << " " is used when content is
empty.
As far as I understand I should retrieve all the fields which
page="index".
Then i should create N variables such as:
var_ { [name] from record 1} = { [content] from record 1}
var_ { [name] from record 2} = { [content] from record 2}
....
For the table example it would become something as:
<div id="introductio n">var_introduc tion</div>
<div id="welcome">va r_welcome</div>
<div id="notes">var_ notes</div>
Where:
var_introductio n = "Introducti on Text"
var_welcome = "Welcome Text"
var_notes = " "
Is my plan the right way to do something like this?
Can someone help me out in doing this?
I had created a dataset (See the end of post) from my table where I
filter a certain page where @page = ... and @name = ....
It's working fine. Now I need to change this to have something as I
described.
Thank You,
Miguel
Here is my dataset:
ASPX
....
<% @Import Namespace="Syst em.Data" %>
<% @Import Namespace="Syst em.Data.SqlClie nt" %>
<script runat="server">
Function dsContent(ByVal page As String, ByVal name As String) As
System.Data.Dat aSet
Dim connectionStrin g As String =
System.Configur ation.Configura tionSettings.Ap pSettings("conn ectionString")
Dim dbConnection As System.Data.IDb Connection = New
System.Data.Ole Db.OleDbConnect ion(connectionS tring)
Dim queryString As String = "SELECT [t_content].* FROM
[t_content] WHERE (([t_content].[page] = @page) AND ([t_content].[name]
= @name))"
Dim dbCommand As System.Data.IDb Command = New
System.Data.Ole Db.OleDbCommand
dbCommand.Comma ndText = queryString
dbCommand.Conne ction = dbConnection
Dim dbParam_page As System.Data.IDa taParameter = New
System.Data.Ole Db.OleDbParamet er
dbParam_page.Pa rameterName = "@page"
dbParam_page.Va lue = page
dbParam_page.Db Type = System.Data.DbT ype.String
dbCommand.Param eters.Add(dbPar am_page)
Dim dbParam_name As System.Data.IDa taParameter = New
System.Data.Ole Db.OleDbParamet er
dbParam_name.Pa rameterName = "@name"
dbParam_name.Va lue = name
dbParam_name.Db Type = System.Data.DbT ype.String
dbCommand.Param eters.Add(dbPar am_name)
Dim dataAdapter As System.Data.IDb DataAdapter = New
System.Data.Ole Db.OleDbDataAda pter
dataAdapter.Sel ectCommand = dbCommand
Dim dataSet As System.Data.Dat aSet = New System.Data.Dat aSet
dataAdapter.Fil l(dataSet)
Return dataSet
End Function
</script>
<html>
....
Web.Config
....
<appSettings>
<add key="connection String" value="Provider =Microsoft.Jet. OLEDB.4.0;
Ole DB Services=-4; Data Source=C:\db.md b" />
</appSettings>
