C#

But with some field values Excel gets lost.<br />
<br />
Example of such a file (save as test.xls):<br />
<table cellspacing="0" rules="all" border="1" id style="border-collapse:collapse;"><br />
<tr><br />
	<td>Text</td><td>Date</td><td>Value1</td><td>Value2</td><br />
</tr><br />
<tr><br />
	<td>First</td><td>2006-01-26</td><td>0</td><td>0</td><br />
</tr><br />
<tr><br />
	<td>+Second</td><td>2006-01-26</td><td>0</td><td>0</td><br />
</tr><br />
<tr><br />
	<td>Third</td><td>2006-01-26</td><td>0</td><td>0</td><br />
</tr><br />
</table>

<br />
using System;<br />
using System.Collections.Generic;<br />
using System.ComponentModel;<br />
using System.Data;<br />
using System.Data.SqlClient;<br />
using System.Drawing;<br />
using System.Text;<br />
using System.Windows.Forms;<br />
<br />
namespace tracker<br />
{<br />
    public partial class frmMain : Form<br />
    {<br />
        SqlConnection objDBConnection;<br />
        SqlDataAdapter objDBAdapter;<br />
        DataSet objDBDataSet;<br />
        DataGridView objDBGridView;<br />
<br />
        public frmMain()<br />
        {<br />
            InitializeComponent();<br />
        }<br />
<br />
        private void frmMain_Load(object sender, EventArgs e)<br />
        {<br />
            this.objDBConnection = new SqlConnection("Server=BigHouse;Database=tracker;Trusted_Connection=yes");<br />
            try<br />
            {<br />
                this.objDBConnection.Open();<br />
                this.toolStripStatusLabel1.Text = "Connected to Tracker database";<br />
            }<br />
            catch (Exception connerr)<br />
            {<br />
                this.toolStripStatusLabel1.Text = "Cannot connect to Tracker database";<br />
            }<br />
<br />
            <br />
            this.getProjectGridData();<br />
<br />
            /* test data */<br />
            DataRow r = this.objDBDataSet.Tables["tbl_projects_main"].Rows[0];<br />
            Console.WriteLine("num records = " + <br />
                                this.objDBDataSet.Tables["tbl_projects_main"].Rows.Count + <br />
                                " and " + <br />
                                r["prj_name"].ToString());<br />
            /* END test data */<br />
<br />
            this.objDBGridView = new DataGridView();<br />
            this.objDBGridView.DataSource = this.objDBDataSet.Tables["tbl_projects_main"];<br />
            this.objDBGridView.AutoGenerateColumns = true;<br />
            this.objDBGridView.Location = new Point(0, 0);<br />
            this.objDBGridView.Size = new Size(700, 490);<br />
            this.objDBGridView.MinimumSize = new Size(700, 490);<br />
            this.objDBGridView.BackgroundColor = System.Drawing.Color.AliceBlue;<br />
            this.objDBGridView.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCellsExceptHeader);<br />
            <br />
            this.objDBGridView.Visible = true;<br />
        }<br />
<br />
        private void getProjectGridData()<br />
        {<br />
            string strSql;<br />
            strSql = "SELECT * FROM dbo.tbl_projects_main";<br />
            this.objDBDataSet = new DataSet();<br />
            this.objDBAdapter = new SqlDataAdapter();<br />
            this.objDBAdapter.SelectCommand = new SqlCommand(strSql, this.objDBConnection);<br />
            this.objDBAdapter.Fill(this.objDBDataSet, "tbl_projects_main");<br />
        }<br />
    }<br />
}<br />

public class ControllerPage : System.Web.UI.Page
{
    protected long m_nStatusCode;

    long PropStatusCode(value)
    {
        get { return m_nStatusCode;  }
        set { m_nStatusCode = value; }
    }
}


public abstract class DerivedPage : ControllerPage
{
    // does need to do anything with/to the data member defined above
}


public partial class MyPage : DerivedPage
{
    // sets/gets the property value defined in the base ControllerPage class
    public void MyFunction()
    {
        this.StatusCode = 1;
        if (this.StatusCode == 1)
        {
            // do something
        }
    }
}