ASP.NET

<div runat="server" id="watermark_cancelled">

And style sheet is:

#watermark_cancelled    
{
    width:720px;    
    position:absolute;    
    z-index: -1;    
    background-image:url('../images/Cancelled_WM1.png');
    background-repeat: no-repeat;
    background-attachment: fixed;
    position:absolute;
    z-index: -1;
    display:block;
}

protected void ExportToExel_Click(object sender, EventArgs e)
        {
            string a = string.Format("{0:MM/dd/yyyy}", dtBeginDate.SelectedDate.Value); //get value of FromDate
            string b = string.Format("{0:MM/dd/yyyy}", dtEndDate.SelectedDate.Value); //get value of ToDate

            //call function to Read SQL database between FromDate & ToDate.
            SqlDataReader dtReader = VNPTTracking.DataAccess.Report.ReportOnlineVehicle(id, a, b);


            // Prepair to export to Excels
            HttpContext context = HttpContext.Current;
            context.Response.Clear(); 

            //Vietnamese, so I have to use this function
            context.Response.ContentEncoding = System.Text.Encoding.Unicode;             context.Response.BinaryWrite(System.Text.Encoding.Unicode.GetPreamble());

            // Write header in row 1 in Excels
            string[] s = { "Biển số", "Tỉnh/TP", "Khách hàng", "Tài khoản", "Mã thiết bị", "Cảm ứng dầu", "Địa chỉ hiện tại", "Thời điểm nhận tin cuối" };
            int n = 0;
            for (int i = 0; i < s.Count(); i++)
            {
                context.Response.Write(s[n] + "\t");  //get value s[n] of s matrix, add "\t" to mark position where write in next column
                n++;
            }
            context.Response.Write(Environment.NewLine); 
            
            
            while (dtReader.Read()) //run the data reader. Each line write a row in Excels
            {
                context.Response.Write(dtReader.GetValue(0) + "\t"); //Biển số
                context.Response.Write(dtReader.GetValue(1) + "\t"); //Tỉnh/TP
                context.Response.Write(dtReader.GetValue(2) + "\t"); //Khách hàng
                context.Response.Write(dtReader.GetValue(3) + "\t"); //Tài khoản
                context.Response.Write(dtReader.GetValue(4) + "\t"); //Mã thiết bị

                if (Convert.ToInt32(dtReader.GetValue(5)) == 1) //Cảm ứng dầu
                {
                    context.Response.Write("Có" + "\t");
                }
                else context.Response.Write("Không" + "\t");

                context.Response.Write(dtReader.GetValue(6) + "\t"); //Địa chỉ hiện tại
                context.Response.Write(dtReader.GetValue(7) + "\t"); //Thời điểm nhận tin cuối
               
                context.Response.Write(Environment.NewLine); 
                            
            }

            // File name
            context.Response.AddHeader("content-disposition", "attachment; filename=Report.xls");
            context.Response.ContentType = "application/ms-excel";
            context.Response.End();
  
        }

I work for a small company where a C# web form 2010 application was written. My job is to make enhancements to the application since I have limited C# web experience.

For now I just want to deploy the production code to my workstation and run the website on my workstation using IIS 7 that is compatible with IIS6.

When I look at the deployment project file in this application, I see debug and release folders that contain the setup.exe and application.msi files.

However from the ways I have been trying to deploy the application, I do not the setup.exe and application.msi files. 

I have probably been using the web deploy item that comes with Visual studio.net 2010 professional edition. I also wanted to mention, the network administrator does not have 'web deploy' installed on the production server.

Thus can you tell me and/or point me to a reference where I can setup a deployment project the way the contract shop does? 

Since I am new to working  with IIS and communicates with a C# web form 2010 web application, I have a few questions to ask about how to test the web application with IIS. The IIS I need to work with is IIS 7 that needs to be compatible with IIS6. (This is due to the web application I am working uses meta data files.) Of the ways to work with IIS , I do not think I want to use IIS Express as the web server since IIS EXpress is version IIS 7.5 and above and I want to use IIS 6.

Of the options I am listing below, I would like to know what the better option is and how to accomplish the tasks on my own workstation:

1. I would will use Cassini to test the web application. I will then deploy the web application to IIS on my own workstation and test the web application. How can I accomplish those tests separately? (Note: the network administrator at my small company has already installed IIS for me. (Note: I have not setup IIS to communicate with the web application yet.)

2. I would use IIS as the test web server on my workstation.

Thus can you tell me and/or show me references on how to accomplish these goals?

Hi

Need to know how to connect to Oracle (11g) database from Log4net.config (using appenders) file. As I need to wright the logs to the Oracle (11g) database when any user logon to the web application.

Note: I am succesfully able to wright the logs to the text files but not able to wright the logs to the Oracle (11g) database.

Any help is greatly appreciated.

Regards

Bala