Sunday, November 29, 2009

Excel Integration with .Net

It is possible to interact with Excel from Ado .Net OleDb Provider. Here I am using Office 2007 and .xls format of Excel. I am saving the Excel file inside the bin directory of the application.
Here I am populating both a DataGridView and ComboBox with Excel Data.

using System.Data.OleDb;
OleDbConnection cnn;

public DataSet GetData(String SheetName){
String Query = "SELECT * FROM [" + SheetName + "];"; OleDbDataAdapter myCommand = new OleDbDataAdapter(Query, cnn);
DataSet myDataSet = new DataSet();
myCommand.Fill(myDataSet, "ExcelInfo");
return myDataSet;
private void Form1_Load(object sender, EventArgs e){

cnn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + "Alloc.xls" + ";" + "Extended Properties=Excel 8.0");
OleDbDataAdapter da;
DataSet ds = GetData("Sheet1$");
DataTable dt = ds.Tables[0];
dataGridView1.DataSource = ds.Tables[0];
comboBox1.DataSource = ds.Tables[0]; comboBox1.DisplayMember = "CategoryName";


Courtesy : Praseed Pai

Friday, November 6, 2009

Microsoft Office SharePoint Server (MOSS) Installation ScreenShots

Microsoft Office SharePoint Server (MOSS) is Web based collaboration, content and document management platform from Microsoft.

MOSS requires Windows Server 2003 Sp1 or above, .Net Framework 2.x and 3.x. The contents are stored in Sql Server 2005.

To start the installation double click the OfficeServer.exe present inside MOSS2007_SETUP folder.

Here I am selecting the basic installation. I shall take up Advanced installation in another blog.

As mentioned earlier the MOSS contents are stored inside Sql Server 2005 as shown below.

Courtesy : Biju S Alapatt, Alen Austin

Wednesday, November 4, 2009

Deploying and Migrating Your Client/Server Infrastructure to Windows 7 / Windows Server 2008 R2

Date : 5th November 2009

Venue : Taj Gateway Hotel

Waterfront Hall

Marine Drive, Ernakulam 682 011

Kerala, India

Time : 10.00 AM to 1.30 PM

10:00 am -11:30 am
Introducing Windows 7
In this session we will have a look into the new Windows 7 feature enhancements like Security, Web enhancements, UI Enhancements and tools for IT Pros

11:30 -11:45 am

11:45 am – 12:30 pm
Windows 7 – Upgrade and Deployment
In this session you will get to see and know the tools available to upgrade, migrate and deploy Windows 7 in the enterprise like User State Migration Tool, Microsoft Assessment and Planning Toolkit, Windows Easy Transfer, and Microsoft Deployment Toolkit 2010.

12:30 – 1:30 pm
What’s New in Windows Server 2008 R2
In this session we will have a look into the new Active Directory features, Group Policy changes and other new features in Windows Server 2008 R2.

Click here to Register now!
For More Details, you can call 080 41161412.