|
Hi everyone,
I am trying to create a blog for our company website. I didn’t want to use a program like blogger to manage it, so I have created all the necessary pages to create new post and view posts. I am using asp.net and writing to a SQL database. So far so good!
I now want to allow users to subscribe to the RSS feed that I want to create. This is where the problem comes in. I have read so many articles about this that I have become quite confused. I’m not sure how to create the xml, or where to create the xml.
Here is the code that is used to view the blog posts.
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Try
Show_Blog_Posts()
Catch
lbl_message.Text = Err.Description
End Try
Page_Load_End:
End Sub
Private Sub Show_Blog_Posts()
Dim conn As New SqlConnection(ConfigurationSettings.AppSettings("c onnString"))
Dim cmd As New SqlCommand("sp_Return_Blog_Post", conn)
cmd.CommandType = CommandType.StoredProcedure
conn.Open()
'create datareader and display data
Dim dr As SqlDataReader
dr = cmd.ExecuteReader()
'Populate the datalist from the datareader
dl_history.DataSource = dr
dl_history.DataBind()
'close datareader and the connection
dr.Close()
conn.Close()
Show_Member_History_End:
End Sub
I would appreciate any help you could offer.
Regards,
Mark
|
