Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Working with XML Feeds

Status
Not open for further replies.
ASPNETnewbie

ASPNETnewbie

Programmer
May 9, 2006
93
US
I would like to save information from a Data Feed directly to a database on my server, I tried catching the information in a dataset and then saving it back to the database but basically, got errors all over the place. Can anyone help me with better information on how to achieve this? Is there a link to some tutorial that could help?
 
Sort by date Sort by votes
You want to save the whole feed as one chunk of information?

Usually you'd end up using a WebRequest object to get the feed and start doing what you want with it from there.
 
Upvote 0 Downvote
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>
&nbsp;

</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
 
Upvote 0 Downvote
if you wanna use that datset loop through it and perform an insert into your database.
 
Upvote 0 Downvote
Actually, if you use a DbDataAdapter (like SqlDataAdapter) you can perform a database update without having to loop through the rows.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

G12Consult
  • Locked
  • Question
Help with Json
Replies
2
Views
926
gmmastros
gmmastros
weberm
  • Locked
  • Question
How do I make a page with multiple AJAX custom controls?
Replies
2
Views
877
weberm
weberm
Jo_Miracle
  • Locked
  • Question
Loading Dynamic XML Files In To A Tree View Web Server Control
Replies
1
Views
240
jbenson001
jbenson001
G12Consult
  • Locked
  • Question
Forms authentication not working
Replies
4
Views
561
Rajkumarrrrr
Rajkumarrrrr
baran121
  • Locked
  • Question
Sending data with bluetooth on webproject
Replies
1
Views
318
jbenson001
jbenson001

Part and Inventory Search

Sponsor

Back
Top