Could you please explain what you mean by WebRequest? I already have the method below to capture the information from the Feed to my DataGrid and so the information is already stored in a Dataset.. but how to get it from the Dataset to my already created Database is where I am stuck
.ASPX File
===========
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "
<html xmlns="
>
<head runat="server">
<title>RSS FEED READER</title>
</head>
<body>
<form id="form1" runat="server">
<asp:GridView ID="RecentPosts" runat="server" Style="z-index: 100; left: 17px; position: absolute;
top: 61px" AllowPaging="True" Width="471px" DataSourceID="XmlDataSource1">
<PagerSettings Position="Top" />
<FooterStyle BackColor="White" />
<SelectedRowStyle BackColor="White" />
<AlternatingRowStyle BackColor="#FF8000" BorderColor="#804000" HorizontalAlign="Left" />
<Columns>
<asp:CommandField ShowSelectButton="True" />
</Columns>
</asp:GridView>
<asp:XmlDataSource ID="XmlDataSource1" runat="server"></asp:XmlDataSource>
</form>
</body>
</html>
.VB FILE
===========
Partial Class _Default
Inherits System.Web.UI.Page
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
If Not IsPostBack Then
RecentPosts.DataSource = GetRSSFeed("
RecentPosts.DataBind()
End If
End Sub
Function GetRSSFeed(ByVal strURL As String) As DataTable
'Get the XML data
Dim reader As XmlTextReader = New XmlTextReader(strURL)
'return a new DataSet
Dim ds As DataSet = New DataSet()
ds.ReadXml(reader)
Return ds.Tables(1)
End Function
End Class
