how will the code change when used in a website

[jsan]

Excel.Workbook xlWorkBook;
Excel.Worksheet xlWorkSheet;
how will the above code change when used in a website.. plz do reply fast..:'(its very urgent

[kvprajapati]

>how will the above code change when used in a website

No need to change the code if c# language is selected at page directive.

[jsand]

this code works fine in a windows application but when changed to website in ASP.Net 2.0 it gives errors.. :'( plzzzzzzzzz do help us.. we are stuck in are project with dis..

using System;
using System.Drawing;
using System.Data;
using System.ComponentModel;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using Excel = Microsoft.Office.Interop.Access;

public partial class excel : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        Excel.Application xlApp = new Excel.ApplicationClass();
        Excel.Workbook xlWorkBook;
        Excel.Worksheet xlWorkSheet, xlWorkSheet2;
        object misValue = System.Reflection.Missing.Value;
        xlWorkBook = xlApp.Workbooks.Add(misValue);

        xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);
        xlWorkSheet2 = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(2);
        xlWorkSheet.Cells[1, 1] = "Hello";
        xlWorkSheet.Cells[1, 2] = "World";
        xlWorkSheet2.Cells[3, 4] = "jovita";
        xlWorkBook.SaveAs("C:\\Documents and Settings\\student\\My Documents\\Visual Studio Projects\\csharp-Excel.xls", Excel.XlFileFormat.xlWorkbookNormal, misValue, misValue, misValue, misValue, Excel.XlSaveAsAccessMode.xlExclusive, misValue, misValue, misValue, misValue, misValue);

        xlWorkBook.Close(true, misValue, misValue);
        xlApp.Quit();

        releaseObject(xlWorkSheet);
        releaseObject(xlWorkBook);
        releaseObject(xlApp);
    }
    private void releaseObject(object obj)
    {
        try
        {
            System.Runtime.InteropServices.Marshal.ReleaseComObject(obj);
            obj = null;
        }
        catch (Exception ex)
        {
            obj = null;
            MessageBox.Show("Exception Occured while releasing object " + ex.ToString());
        }
        finally
        {
            GC.Collect();
        }
    }

}

[jsand]

plz give us a select query to retrive selected columns from two tables present in sql 2oo5 database.. we are usin c# in ASP.Net 2.0

[jsand]

plz give us a detailed step wise instructions to send email in ASP.Net 2.0 and sql 2005 using c#...... can u also inform us which servers we have to download for the proper functioning of the email...is it possible to send the emails successfully with out downloading the servers..

[kvprajapati]

>when changed to website in ASP.Net 2.0 it gives errors..

Have to add the reference of Office InterOp? Please show us error trace.