I am trying to get an RSS feed on my website from a MySQL database (using VB.Net). I've been using [URL] as a starting pioint.
So far I have:
rss.aspx......
[Code]....
rss.aspx.vb.....
[Code]....
My problem is that it displays a completely blank page! No error, no text, nothing. I've tried just using the code to create a static XML file (without connecting to the database) and it still doesn't work.
Is there something that I am doing wrong or should i do it in a completely different way?
Why does a very simple script which inserts 26,000 records into a mysql database (myisam, no transactions) take 13 seconds in the php implementation, and then 35-50 seconds using mono+mysql connector? I thought asp.net was faster than php? Could the problem be the mono mysql connector is "platform independent", so the performance just stinks? or does asp.net suffer more overhead than php when it comes to executing each query? Aren't there any native linux binaries for mysql connector for mono that may be faster?
I have used ASD.NET code using SQL Database for Transaction operation successfully. By changing the Database Code to interface with MYSQL an Error occurs. If I remove the Transaction Code from within the the application, it works OK by displaying the MYSQL data (Read Only) in the layout of the application. I am using Mysql Essential-4.1.22-win32 and MYSQL Connector ODBC-3.51.2. My objective is to EDIT the MYSQL Data.
I'm using various tutorials to create an RSS Feed in asp.net. Most of these examples are in C, but have converted to vb.net without errors, except that the data is not showing when i run the page in which the feed is on, i am just given a blank white page:
My database table is called News_Items and contains: ID - Int Title - nvarchar(50) News - ntext PostDate - datetime
This table holes 6 records currently. My code is as follows (These files are shown in their entirity):
RSS_Feed.aspx - Inherits Default as anything else generates an error
I have been asked to setup RSS Fed capability on the web site I am designing. I guess that we want to notify folks when articles or content changes on the site. I have posted in beginners since I am new to using RSS feeds.
1. How can I allow visitors to my site to "sign up" for RSS feeds?
2. How can I generate a "feed" programmatically so that it is sent to those who signed up for RSS feeds?
3. If my questions indicate a fundamental misunderstanding of what RSS is.
My code is to update a record if it already exists in database else insert as a new record. My code is as follows:
protected void Button3_Click(object sender, EventArgs e) { OdbcConnection MyConnection = new OdbcConnection("Driver={MySQL ODBC 3.51 Driver};Server=localhost;Database=testcase;User=root;Password=root;Option=3;"); MyConnection.Open(); String MyString = "select fil_no,orderdate from temp_save where fil_no=? and orderdate=?"; OdbcCommand MyCmd = new OdbcCommand(MyString, MyConnection); MyCmd.Parameters.AddWithValue("", HiddenField4.Value); MyCmd.Parameters.AddWithValue("", TextBox3.Text); using (OdbcDataReader MyReader4 = MyCmd.ExecuteReader()) { //** if (MyReader4.Read()) { String MyString1 = "UPDATE temp_save SET order=? where fil_no=? AND orderdate=?"; OdbcCommand MyCmd1 = new OdbcCommand(MyString1, MyConnection); MyCmd1.Parameters.AddWithValue("", Editor1.Content.ToString()); MyCmd1.Parameters.AddWithValue("", HiddenField1.Value); MyCmd1.Parameters.AddWithValue("", TextBox3.Text); MyCmd1.ExecuteNonQuery(); } else { // set the SQL string String strSQL = "INSERT INTO temp_save (fil_no,order,orderdate) " + "VALUES (?,?,?)"; // Create the Command and set its properties OdbcCommand objCmd = new OdbcCommand(strSQL, MyConnection); objCmd.Parameters.AddWithValue("", HiddenField4.Value); objCmd.Parameters.AddWithValue("", Editor1.Content.ToString()); objCmd.Parameters.AddWithValue("", TextBox3.Text); // execute the command objCmd.ExecuteNonQuery(); } } }
I am getting the error as: ERROR [42000] [MySQL][ODBC 3.51 Driver][mysqld-5.1.51-community]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order,orderdate) VALUES ('04050040272009',' &' at line 1
The datatype for fields in table temp_save are:
fil_no-->INT(15)( to store a 15 digit number) order-->LONGTEXT(to store contents from HTMLEditor(ajax control)) orderdate-->DATE(to store date)
I am trying to insert html pages to MySQL with my Asp.NET project but i am getting error; You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'de Osman patlaması', '', '<div style="text-align: center"> <img src="/i' at line 1
How can i fix that problem my server side code is;
I have RSS Feed which i am calling on .ascx page, my problem when RSS down user control take time till timeout,i dont want to hang my page till time out, i want to run Rss feed some thing like in another thread,so without stoping page my application can start below code
I am looking for a simple (fastest execute solutions) for generate RSS feed from user search result in ListView & ObjectDataSource?
For example; User does some search, the search result summary is display in ListView. If the user like the search result, he/she click on RSS button, then RSS feed is generate with entire current view record/table.
I would like to implement gmail / google apps inbox feed in my application. I know inbox feed gives me read only results, but I want to the same. I google and found this is possible through[URL]. But I don't know how to implement it in asp.net.
dlRSS.DataSource = GetRSSFeed("http://www.foodsafetynews.com/headlines.xml") dlRSS.DataBind() 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(2) End Function <asp:DataList ID="dlRSS" runat="server" Width="100%" > <ItemTemplate> <strong><p><div><asp:HyperLink ID="TitleLink" runat="server" Text='<%# Eval("title") %>' Target="_blank" NavigateUrl='<%# Eval("link") %>'/></div></p></strong> <strong><p> <div><asp:Label ID="SubtitleLabel" runat="server" Text='<%# Eval("description") %>' /></div></p></strong> </ItemTemplate> </asp:DataList>
But is returning all rows in RSS Feed I would only like top 5 or so
I want to display the world's top 100 IT giants list up-to-date on my webapge. from where can i get the informaiton? Is it possible to get the RSS feed for this?
As part of our app, user can save some data as XML on server which becomes RSS feed for them. Now some of the file user created have & in file name as BB&T_RSS.xml. So when user point this to [URL], they won't get his. I tried BB%26T.xml, BB&T.xml without any success with IE, Chrome
