This is my technical area for troubleshooting and learning new programming skills and much more. Here, you will find answers on a wide range of technologies such as AI, Machine Learning, OpenAI, Databricks, ASP.NET, C#, Python, Microsoft Access, MySQL, Amazon Web Services, SQL Server, PL/SQL, JD Edwards, SAS, Salesforce, APIs, MVC, and many others. Please feel free to visit and join the discussion!
Showing posts with label ASP.NET c#. Show all posts
Showing posts with label ASP.NET c#. Show all posts
Saturday, December 18, 2010
ASP.NET 4.0 using Visual Studio 2010 deployment Package/Publish Web tool
Sunday, April 27, 2008
created rss feed using access database, ASP.NET c#, webservices, this is live sample..
http://docs.google.com/Doc?id=dqwxgxp_25d252d4gj
created rss feed using access database, ASP.NET c#, webservices, this is live sample..
<%@ WebHandler Language="C#" Class="rss" %>
using System;using System.Web;using System.Data.OleDb;using System.Text;using System.Xml;
public class rss : IHttpHandler {
public void ProcessRequest(HttpContext context) {
string sTxt = BuildXmlString(); context.Response.ContentType = "text/xml"; context.Response.ContentEncoding = System.Text.Encoding.UTF8; context.Response.Write(sTxt); } private string BuildXmlString() { string sTitle = "Super Value Deals and Deals of The Day"; string sSiteUrl = "http://www.visli.com"; string sDescription = "Super Value Deals and Deals of The Day"; string sTTL = "60";
System.Text.StringBuilder oBuilder = new System.Text.StringBuilder(); oBuilder.Append(""); oBuilder.Append("");
oBuilder.Append(""); oBuilder.Append(sTitle); oBuilder.Append(" ");
oBuilder.Append(""); oBuilder.Append(sSiteUrl); oBuilder.Append("");
oBuilder.Append(""); oBuilder.Append(sDescription); oBuilder.Append(" ");
oBuilder.Append(""); oBuilder.Append(sTTL); oBuilder.Append(" ");
AppendItems(oBuilder);
oBuilder.Append(" "); return oBuilder.ToString(); }
public void AppendItems(System.Text.StringBuilder oBuilder) {
string connectionString = "provider=Microsoft.Jet.OLEDB.4.0;data source=c:\\xxxxxxxx\\database\\AbcDB.mdb"; OleDbConnection myOleDbConnection = new OleDbConnection(connectionString); OleDbCommand myOleDbCommand = myOleDbConnection.CreateCommand(); string ProdTy = "M2"; string Strsql = "SELECT top 101 * from vcxsd where ProdType='M2'";
myOleDbCommand.CommandText = Strsql; myOleDbConnection.Open();
OleDbDataReader myOleDbDataReader = myOleDbCommand.ExecuteReader();
myOleDbDataReader.Read(); while (myOleDbDataReader.Read()) { string sTitle = "Super Value Deals and Deals of The Day"; string sLink = "http://www.visli.com/"; string sDescription = "Super Value Deals and Deals of The Day"; string sPubDate = "System.DateTime.Now";
oBuilder.Append("- ");
oBuilder.Append(""); oBuilder.Append(myOleDbDataReader["TextUrl"].ToString()); oBuilder.Append(" ");
oBuilder.Append(""); oBuilder.Append(myOleDbDataReader["NameUrl"].ToString()); oBuilder.Append(""); oBuilder.Append(""); oBuilder.Append("<img src=" + myOleDbDataReader["ImageUrl"].ToString() + ">" + "<br>" + myOleDbDataReader["Price"].ToString() + "<br>visit <a href=http://www.visli.com>http://www.visli.com</a>"); oBuilder.Append(" ");
oBuilder.Append(""); oBuilder.Append(myOleDbDataReader["UpdDate"].ToString()); oBuilder.Append(" ");
oBuilder.Append(" ");
} }
public bool IsReusable { get { return false; } }
}
Edit this page (you have permission) Edit this page (if you have permission) Report spam Google Docs -- Web word processing, presentations and spreadsheets.
created rss feed using access database, ASP.NET c#, webservices, this is live sample..
<%@ WebHandler Language="C#" Class="rss" %>
using System;using System.Web;using System.Data.OleDb;using System.Text;using System.Xml;
public class rss : IHttpHandler {
public void ProcessRequest(HttpContext context) {
string sTxt = BuildXmlString(); context.Response.ContentType = "text/xml"; context.Response.ContentEncoding = System.Text.Encoding.UTF8; context.Response.Write(sTxt); } private string BuildXmlString() { string sTitle = "Super Value Deals and Deals of The Day"; string sSiteUrl = "http://www.visli.com"; string sDescription = "Super Value Deals and Deals of The Day"; string sTTL = "60";
System.Text.StringBuilder oBuilder = new System.Text.StringBuilder(); oBuilder.Append(""); oBuilder.Append("
oBuilder.Append("
oBuilder.Append(""); oBuilder.Append(sSiteUrl); oBuilder.Append("");
oBuilder.Append("
oBuilder.Append("
AppendItems(oBuilder);
oBuilder.Append("
public void AppendItems(System.Text.StringBuilder oBuilder) {
string connectionString = "provider=Microsoft.Jet.OLEDB.4.0;data source=c:\\xxxxxxxx\\database\\AbcDB.mdb"; OleDbConnection myOleDbConnection = new OleDbConnection(connectionString); OleDbCommand myOleDbCommand = myOleDbConnection.CreateCommand(); string ProdTy = "M2"; string Strsql = "SELECT top 101 * from vcxsd where ProdType='M2'";
myOleDbCommand.CommandText = Strsql; myOleDbConnection.Open();
OleDbDataReader myOleDbDataReader = myOleDbCommand.ExecuteReader();
myOleDbDataReader.Read(); while (myOleDbDataReader.Read()) { string sTitle = "Super Value Deals and Deals of The Day"; string sLink = "http://www.visli.com/"; string sDescription = "Super Value Deals and Deals of The Day"; string sPubDate = "System.DateTime.Now";
oBuilder.Append("
oBuilder.Append("
oBuilder.Append(""); oBuilder.Append(myOleDbDataReader["NameUrl"].ToString()); oBuilder.Append(""); oBuilder.Append("
oBuilder.Append("
oBuilder.Append("
} }
public bool IsReusable { get { return false; } }
}
Edit this page (you have permission) Edit this page (if you have permission) Report spam Google Docs -- Web word processing, presentations and spreadsheets.
Subscribe to:
Posts (Atom)