S
Shapper
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="introduction">Introduction Text</div>
<div id="welcome">Welcome Text</div>
<div id="notes"> </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="introduction">var_introduction</div>
<div id="welcome">var_welcome</div>
<div id="notes">var_notes</div>
Where:
var_introduction = "Introduction 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="System.Data" %>
<% @Import Namespace="System.Data.SqlClient" %>
<script runat="server">
Function dsContent(ByVal page As String, ByVal name As String) As
System.Data.DataSet
Dim connectionString As String =
System.Configuration.ConfigurationSettings.AppSettings("connectionString")
Dim dbConnection As System.Data.IDbConnection = New
System.Data.OleDb.OleDbConnection(connectionString)
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.IDbCommand = New
System.Data.OleDb.OleDbCommand
dbCommand.CommandText = queryString
dbCommand.Connection = dbConnection
Dim dbParam_page As System.Data.IDataParameter = New
System.Data.OleDb.OleDbParameter
dbParam_page.ParameterName = "@page"
dbParam_page.Value = page
dbParam_page.DbType = System.Data.DbType.String
dbCommand.Parameters.Add(dbParam_page)
Dim dbParam_name As System.Data.IDataParameter = New
System.Data.OleDb.OleDbParameter
dbParam_name.ParameterName = "@name"
dbParam_name.Value = name
dbParam_name.DbType = System.Data.DbType.String
dbCommand.Parameters.Add(dbParam_name)
Dim dataAdapter As System.Data.IDbDataAdapter = New
System.Data.OleDb.OleDbDataAdapter
dataAdapter.SelectCommand = dbCommand
Dim dataSet As System.Data.DataSet = New System.Data.DataSet
dataAdapter.Fill(dataSet)
Return dataSet
End Function
</script>
<html>
....
Web.Config
....
<appSettings>
<add key="connectionString" value="Provider=Microsoft.Jet.OLEDB.4.0;
Ole DB Services=-4; Data Source=C:\db.mdb" />
</appSettings>
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="introduction">Introduction Text</div>
<div id="welcome">Welcome Text</div>
<div id="notes"> </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="introduction">var_introduction</div>
<div id="welcome">var_welcome</div>
<div id="notes">var_notes</div>
Where:
var_introduction = "Introduction 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="System.Data" %>
<% @Import Namespace="System.Data.SqlClient" %>
<script runat="server">
Function dsContent(ByVal page As String, ByVal name As String) As
System.Data.DataSet
Dim connectionString As String =
System.Configuration.ConfigurationSettings.AppSettings("connectionString")
Dim dbConnection As System.Data.IDbConnection = New
System.Data.OleDb.OleDbConnection(connectionString)
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.IDbCommand = New
System.Data.OleDb.OleDbCommand
dbCommand.CommandText = queryString
dbCommand.Connection = dbConnection
Dim dbParam_page As System.Data.IDataParameter = New
System.Data.OleDb.OleDbParameter
dbParam_page.ParameterName = "@page"
dbParam_page.Value = page
dbParam_page.DbType = System.Data.DbType.String
dbCommand.Parameters.Add(dbParam_page)
Dim dbParam_name As System.Data.IDataParameter = New
System.Data.OleDb.OleDbParameter
dbParam_name.ParameterName = "@name"
dbParam_name.Value = name
dbParam_name.DbType = System.Data.DbType.String
dbCommand.Parameters.Add(dbParam_name)
Dim dataAdapter As System.Data.IDbDataAdapter = New
System.Data.OleDb.OleDbDataAdapter
dataAdapter.SelectCommand = dbCommand
Dim dataSet As System.Data.DataSet = New System.Data.DataSet
dataAdapter.Fill(dataSet)
Return dataSet
End Function
</script>
<html>
....
Web.Config
....
<appSettings>
<add key="connectionString" value="Provider=Microsoft.Jet.OLEDB.4.0;
Ole DB Services=-4; Data Source=C:\db.mdb" />
</appSettings>