Germans also are gone :-(

My two favorite teams are out from WorldCup 2010, Germany and Argentina. :-( Spain really deserve that victory over Germany.

I know, it is bit late. But, I just came to a contribution from Microsoft for World Cup. So, I thought, I should share with you.

Track world cup scores with excel.

Read More

For using excel file as database

For reading Excel files and getting the data
string FilePath = Server.MapPath("exmaple.xls");

DataSet myDataset = new DataSet();
string strConn = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + FilePath + @";Extended Properties=""Excel 8.0;HDR=Yes;IMEX=1""";
OleDbConnection conn = new OleDbConnection(strConn);
conn.Open();
DataTable DTable = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
//here the code will read sheet from spreadsheet with any name --generic
OleDbDataAdapter myData = new OleDbDataAdapter
(@"SELECT * FROM [" +
DTable.Rows[0]["TABLE_NAME"].ToString() + "]", conn);
//
myData.Fill(myDataset);

Read More