Hello world for Azure using Visual studio 2008

Yesterday Suddenly i was thinking about Azure.Then i thought to explore Azure to see how to deploy the Application and just went through the Web and got some useful site and deployed my First Hello World Azure application.. Here is the URL.

Well i just used Vs 2008 and installed the Windows Azure Tools for Microsoft Visual Studio 1.1 . you can download it herehttp://www.microsoft.com/downloads/details.aspx?FamilyID=5664019e-6860-4c33-9843-4eb40b297ab6&displaylang=en . You need Windows Vista or above and Vs 2008 Sp1 to installed this. In Windows XP it does not worked.

After Installed. One the Visual studio you can see the Template in the New project Called “Cloud” and select the “Windows Azure cloud service”

After that you can see the 4 more option. if you want to have asp.net website then select the “Asp.Net Web Role” .

For Wcf select the “Wcf Service web role”.

After that do your coding in the WebRole project that we created. Once things are done. Just Build and run the application, But it will do a local deploy in our machine.. and so it will take sometime to execute.

Once this is done, Then we need to publish the Application in Azure. which i will show that in my Next post

Any queries write back to me

Regards,
Elam

connect to a csv file using odbc

This is one of my Most Visited Post So i am Publishing this again . Connecting to CSV file in C#
. Here is some sample C# code that works with CSV files using ODBC (using System.Data.Odbc):

string strConn = @"Driver={Microsoft Text Driver (*.txt; *.csv)};" +
"Dbq=C:;Extensions=csv,txt";

try
{
OdbcConnection objCSV = new OdbcConnection(strConn);
objCSV.Open();

OdbcCommand oCmd = new OdbcCommand("select column1,column2 " +
"from THECSVFILE.CSV", objCSV);
OdbcDataReader oDR = oCmd.ExecuteReader();

while (oDR.read())
{
// Do something
}
oDR.Close();
oCmd.Dispose();
objCSV.Close();
}
catch {}

Use the name of the CSV file in the SQL Statement itself, as in the code above. It will read the CSV file

If you have any queries on connectionstring . visit www.connectionstrings.com

Regards,
Elam