Sql - Create ASP.NET Syndication Feeds With SqlConnection And .NET?
May 19, 2009
This seems to be a great article by Scott Mitchell for creating syndicated feeds in ASP.NET 3.5. The problem for me is that it uses C# and Linq, which I'm not as sharp on at the current time.[URL]...Does anyone know where an example might exist for the System.ServiceModel.Syndication namespace that can produce a syndicated feed like this article using VB.NET and a SQLConnection object?
I've looked around and every example seems to be produced in C# and Linq (which is probably a testament to my need to learn them soon rather than later).
View 2 Replies
ADVERTISEMENT
Jan 23, 2010
I am a CS grad, but haven't had much to do with programming since my school days as I went the BA route.Anyways, there are a few things that I do manually on the computer and thought that I could probably save time by creating an application for them.But I'm not really sure how to start.I'd like to be able to keep a history of Completed eBay listing so that I know when the price point is good and when it is too high.I noticed that eBay has an RSS feed, so I think I can do it. Just a couple of quick questions:
1 - Can I instruct VB.net to open a web browser and read an RSS feed, or would I need to manually do this myself and then run the application?
2 - What is the best way to work with RSS feeds? Should I convert the data into XML first?
View 2 Replies
Apr 15, 2012
how to convert rss feeds to datagrid in this fomat
<Row>
<Cell><Data ss:Type="String">Symbol</Data></Cell>
<Cell><Data ss:Type="String">Close</Data></Cell>
<Cell><Data ss:Type="String">Prev</Data></Cell>
[code]....
the values in the first <row> </row> of data are the column headings for the corresponding cells in the other <row> </row>considering that I can work with xml in the other format this is quite strange so any help will be needed.
View 3 Replies
Apr 25, 2010
i trying to display an rss feed but i dont think im using the right object as the webbrowser object does not work. ive tried several other objects but to no avail. is there a specific tool i should use or is it my code?
View 2 Replies
Jul 8, 2011
I am working on a program which can list all news from a webpage ( url...), but I have problems to get the news. I know that it is possible to get the rss feeds where all the news are listed ( for this example it's url...) via XML to LINQ ( I need all links, titles and descriptions ), but I have no knowledge in it
View 2 Replies
Feb 21, 2011
im developing an vb.net application that displays live scores for soccer. Is it a must that i must get the live score from the xml feed like looping through the "nodes" to get what i want to display on vb.net form? is it more customizable with xml? Somehow i saw some website provide the web link to add to site, is the link can be used in my form in order to serve my purpose?
View 4 Replies
May 21, 2011
I've integrated a bit of code into my project using Visual Basic, that reads RSS feeds. It works absolutely fine. I did however intend it to read Facebook notifications to users of my program. The idea was, if you go on Facebook, clikc Notifications, click See All Notifications, click via RSS, you get an RSS feed right there. When I use the address in the address bar for my project's RSS reader though, I just get an error.
Like I said, it works for other feeds, just not working for Facebook notifications.
View 8 Replies
Dec 9, 2010
I have a requirement to consume only the latest two rss feeds (using .NET) to reduce latency in reading RSS. I found plenty of examples to consume RSS. However, I did not find any to limit the feeds being read. And, this is not for a windows forms application.
View 2 Replies
May 15, 2012
Public Class Form1
Private Sub Button1_Click(sender As System.Object, e As System.EventArgs) Handles Button1.Click
Dim rssUrl = _[code]....
I get a Null Reference Exception on the next to last line of code. (Object reference not set to an instance of an object.) The line that begins with "Temperature.Text = .......". If I remove the last two lines of code the program works.If I edit the last two line to read "yweather:condition/@temp, and yweather:condition/@date" instead of what's shown above, the program works. I think it has something to do with the XML NameSpaceManager not being setup correctly.
View 2 Replies
Sep 15, 2010
I have a form that contains a RichTextBox control that I have set to multiline. I also have a menu item that allows the user to save the contents of the RichTextBox as either a .rtf document or a .txt document. Here's the code I'm using so far:
If sfdSaveTextFile.ShowDialog() = DialogResult.OK Then
m_strDocFileLocation = sfdSaveTextFile.FileName
m_strDocFileExtension = System.IO.Path.GetExtension(m_strDocFileLocation)
[Code]....
into the RichTextBox control (rtb) then saves as a text file this would save the text file like: "TempTemp"
Is there any way to write to the text file with line feeds included?
View 4 Replies
Dec 6, 2011
How can I split this into columns: The Church OfficeOakley Hall8 Castle Street Its been imported into a dgv from a CSV, it is the business address field in Outlook. Can I do a split from addresses that contain returns/line feeds?
View 8 Replies
Jan 27, 2012
Need to get length of a string minus the line feed chars and came up with this. Is there a better/more efficient way?
Function GetLenMinus_LF(s As String) As Integer
s = s.Replace(ControlChars.Lf, String.Empty)
Return s.Length
End Function
View 5 Replies
Feb 15, 2011
Is there any way, in my project's properties, to put a carriage return or a line feed in the Description field of the Assembly Information dialog box, in which the Description information would then appear in the description field of the about box of my project?
View 3 Replies
Jan 13, 2011
I am trying to update some code. I have a vb file that begins with this...
Imports System.Data.SqlClient
Imports System.Data.Sql
Imports System.Data.SqlTypes
[Code].....
...and it accepts it. Why do I need to explicitly write out System.Data.SqlClient every time I use an object from that class???
View 4 Replies
May 17, 2010
i would like to know if there's something wrong in this asp.net code:
mydatareader = mycmd.executeReader()
if myDataReader.HasRow then
// Do something
[code].....
View 4 Replies
Jul 20, 2011
I am confused about something and I hope someone here can give me an answer
View 3 Replies
Nov 20, 2011
I am learning ADO.NET But it very hard for me... I dont understand why have got this compiler error:"Declaration expected" for the connection.Open().[code]
View 1 Replies
Jun 2, 2009
What would happen if you call Close() on a SqlConnection object before you call Close() on a SqlDataReader using that connection?
Actually, what I really want to know is whether or not the order in which you Close them matters. Does calling SqlConnection.Close() completely close the connection, or will it remain open if you do not call Close() on a SqlDataReader using that connection?
I don't think I really understand how connection closing works.
View 3 Replies
Apr 26, 2012
I keep getting the following exception when I do:
[code]...
View 1 Replies
Aug 13, 2010
I'm having a problem with my global connection function. It used to be a readonly property but I changed it to a function because the code anaylsis engine was complaining about my property raising exceptions. The function is designed to take account of our offsite database mirroring system, so if it can't create a connection to the principal server it switches the connection string to the mirror server. This works fine in another project we have:
Public Shared Function Connection() As SqlConnection
If String.IsNullOrEmpty(ActiveConnectionString) = True Then
Throw New PropertyNotSetException("Cannot call Connection() before
[Code].....
View 2 Replies
Jun 19, 2009
I have a SqlConnection global variable in my proyect that it is always open (I wouldn't like to start a discussion about keep the connection open all the time or close it everytime a transaccion is executed).
This variable is sent to every class I need to execute a function or method. Instead of checking the connection in every single operation, is there any way to monitor the connection state in a centralized way ?
View 3 Replies
Jan 4, 2012
I'm trying to add transaction support to our database object.This object is a Remoting object. (this to ensure that on the Windows Client, no database connection is required.)Now I want to add support for transactions;Basically, a client will need to use it like this;
BeginTransaction
ExecuteNonQuery("insert...")
ExecuteNonQuery("insert...")
[code].....
View 2 Replies
Jan 28, 2011
I am recently new to Visual Basic and am starting to learn some things i have managed to connect to the SQL Server and Insert rows to a table. But is there a way to be able to re-use an already existing connection ?My code below. I tried to create a class for the Connection object.
Imports System.Data.SqlClient
Imports System.Data.Sql
Public Class dbConnection
[code]....
View 7 Replies
May 20, 2010
[code]in this code, do the objects con and cmd get disposed because the return statement is placed before the end using statement.
View 1 Replies
Jul 14, 2011
Imports System.Data.Sql
Imports System.Data.SqlClient
Imports System.Configuration
Module Module1
[code].....
this is my connection string on my pc how can i make this as a dynamic connectionstring so i cant remove the db and get a new connectionstring?
View 9 Replies
Mar 2, 2012
I asked a question earlier where I was told a simple way to "bind data to objects" is to just run a SqlConnection(connectionString). The response also included a comment saying I could get fancy with L2S and Entity Frameworks, so I looked deeper into those. It seems all you have to do with the DataContext object is point to the database. Why would SqlConnection be a benefit? What is the difference (or pros/cons) of using either one of these? Is one more "standard"? Is one more modern?
View 1 Replies
May 16, 2011
I'm running a multithreaded application that connects to a database, the connections are closed when I'm done with them (and I dispose of all the threads). I've tried clearing the connection pools, setting pooling=false and I've used both .dispose and .close.
I get the error "cannot drop the database X because it is currently in use" if I try to drop the database I connected to after the connections have all been closed.
Below is my code:
Dim comExecuteInsert As New SqlCommand
Dim comm As New SqlConnection
If (Not comm Is Nothing) Then
comm = Nothing
End If
[Code] .....
The stored procedure creates temporary tables which it later drops and inserts data into tables existing in the database.
View 4 Replies
Jul 17, 2009
HTML SqlConnection connection = Getconnection() Anybody knows which reference should be added for Getconnection()? I am using 2008. Tried System.Data but...
View 4 Replies
Nov 1, 2009
My code read a thousand files, and for each file a connection is made and open to check against a recordset in SQL. After 143 files, the application will stopped and thrown this exception regarding maximum pool size reached. What I don't understand is I'm closing the connection after every file is processed, could it be I'm doing it incorrectly?
Please see my code below. I was only able to make this work by setting max pool size = 3000 in the connection string, since closing the connection does not seem to work.[code...]
View 10 Replies
Nov 6, 2009
I have seen some comments about the difference of sqlconnection vs oledbconnection.
View 9 Replies
