Read in a CSV file using C# Razor in Umbraco and Display the details:

-



@{
try {
var dataFile = Server.MapPath("~/App_Data/Contact-List.csv");
Array csvData = File.ReadAllLines(dataFile);

int dataStartsRow = 5;
int thisRow = 0;
<h2>Reading File Starting at 5th Row, because that is where the data Starts</h2>
foreach (string dataLine in csvData)
{
thisRow = thisRow  +1;
int columnInSpreadsheet = 0;
foreach (string dataItem in dataLine.Split(','))
{
if (thisRow >= dataStartsRow)
{
@dataItem <br />
}

}
}



}
catch {
<h2>Error:  Check to see if the file Contact-List.csv exists and is not open.</h2>
}

}






Comments

Post a Comment

Popular posts from this blog

Umbraco - Reset the Admin Password via SQL Server

-
To reset the admin password of a Umbraco website. 1. In Sql server, run the following script on the database: USE  INSERT-YOUR-DATABASE-NAME-HERE GO UPDATE umbracoUser set userdisabled=0, userLogin='admin', userPassword='default' where id=0 2. In your web config file, find the "UsersMemnershipProvider" section, change the setting: passwordFormat="Hashed" to passwordFormat="Clear" You should now be able to login using the Username: Admin and the Password: default ("the two sweetest words in the english language").
Read more

Create a .NET Contact Form that Gets the Last Url Visited in C# Can also be Used in Umbraco

-
This is a Simple Contact From done in C# .Net and also can be used in Umbraco.  Paste the code in to Visual Web Developer for a better view. The important bits are coment in the second file.  One of the Commented out lines highlights how to get the mailto address from an Umbraco field. The code Below includes the myContactForm.ascx.cs codebehind file and the myContactForm.ascx file. 1) The myContactForm.ascx file:  <%@ Control Language="C#" AutoEventWireup="true" CodeFile="ContactFormforPublications.ascx.cs" Inherits="usercontrols_ContactFormPublications" %> <div class="contact-form" id="contactForm" runat="server">     <h3>Request a Publication</h3>     <div class='int'>         <form runat="server">         <asp:Panel DefaultButton="contactFormSubmit" runat="server">      ...
Read more

Umbraco Macro for IFrame when Embedding Video, Vimeo Universal Player, or other types of IFrame on to a Page XSLT version and Razor Version

-
Vimeo Uneversal Player is cross platform compatiable, and uses IFrames, so you need a Macro to Embedd a video from Vimeo in to Umbraco: Part A: Create the XSLT File and Macro  (If you want to use Razor instead of xslt, the Razor code is at the bottom of this post) 1) Create a New Clean XSLT File and tick Create Macro. 2) Give the Macro a Name, such as: Vimeo IFrame Embedd for Vimeo Universal Player 3) Paste in the following Code: <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE xsl:Stylesheet [ <!ENTITY nbsp "&#x00A0;"> ]> <xsl:stylesheet     version="1.0"     xmlns:xsl=" http://www.w3.org/1999/XSL/Transform "     xmlns:msxml="urn:schemas-microsoft-com:xslt"     xmlns:umbraco.library="urn:umbraco.library"     exclude-result-prefixes="msxml umbraco.library"> <xsl:output method="xml" omit-xml-declaration="yes"/> <xsl:para...
Read more