Add Keyword Field

iguta · January 21st, 2010, 02:02 PM

Using the Title fields as my gudie, I have added a keyword field to my database and can use the admin/AddEditArticle.aspx page to add keywords to my content pages. I can also view the page on the ShowArticle.aspx and admin/ManageArticles.apsx pages.

However, when I try to load the BrowseArticles.aspx page the ArticlesProvider.cs throws the following exception;

Code:

Keywords 
 
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 
 
Exception Details: System.IndexOutOfRangeException: Keywords
 
Source Error: 
 
Line 106:        protected virtual ArticleDetails GetArticleFromReader(IDataReader reader, bool readBody)
Line 107:        {
Line 108:            ArticleDetails article = new ArticleDetails(
Line 109:               (int)reader["ArticleID"],
Line 110:               (DateTime)reader["AddedDate"],
Source File: ...\App_Code\DAL\ArticlesProvider.cs    Line: 108

Once this is sorted I would like to use content='<%# Eval("Keywords") %> in a keyword metatag for SEO purposes.
Please advise.

Lee Dumond · January 21st, 2010, 02:27 PM

You haven't posted the entire method, so it's hard to say what the problem is.

However, I suspect that the reader your are passing in as an argument has no "Keywords" field in it.

So, when you try something like reader["Keywords"], the runtime sees that the index "Keywords" is not in the range of existing reader indexes, which would throw an IndexOutOfRangeException.

iguta · January 21st, 2010, 02:41 PM

I believe the method that I needed to alter is;

Code:

protected virtual ArticleDetails GetArticleFromReader(IDataReader reader, bool readBody)
{
ArticleDetails article = newArticleDetails(
(int)reader["ArticleID"],
(DateTime)reader["AddedDate"],
reader["AddedBy"].ToString(),
(int)reader["CategoryID"],
reader["CategoryTitle"].ToString(),
reader["Title"].ToString(),
reader["Keywords"].ToString(),
reader["Abstract"].ToString(),
null,
reader["Country"].ToString(),
reader["State"].ToString(),
reader["City"].ToString(),
(reader["ReleaseDate"] == DBNull.Value ? DateTime.Now : (DateTime)reader["ReleaseDate"]),
(reader["ExpireDate"] == DBNull.Value ? DateTime.MaxValue : (DateTime)reader["ExpireDate"]),
(bool)reader["Approved"],
(bool)reader["Listed"],
(bool)reader["CommentsEnabled"],
(bool)reader["OnlyForMembers"],
(int)reader["ViewCount"],
(int)reader["Votes"],
(int)reader["TotalRating"]);
if (readBody)
article.Body = reader["Body"].ToString();
return article;
}

Does this suffice? I added reader["Keywords"].ToString(),

Lee Dumond · January 21st, 2010, 03:41 PM

I don't know. Why don't you tell us if it works?

iguta · January 21st, 2010, 03:55 PM

I should have mentioned ... that is the code that is presently throwing the exception.

Solved my problem, I neglected to change the GetPublishedArticlesByCategory stored procedure!

How do I go about retrieving the keyword content from the database?

... I've discovered that System.Web.UI.HtmlControls permits me to add the meta tag as illustrated below.

Code:

HtmlMeta meta = newHtmlMeta();
meta.Name = "keywords";
meta.Content = article.Keywords;
this.Header.Controls.Add(meta);

I'll use this approach to take the title and abstract fields and create title and description meta tags.

I remain open to better/improved suggestions.