ASP.NET

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

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="test.aspx.cs" Inherits="test" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
    <asp:TextBox name="txt1" value="Search Our Website…" runat="server" Font-Names="Mangal" onfocus="this.value=(this.value=='Search Our Website…')? '' : this.value ;" TextMode="SingleLine" />
    </div>
    </form>
</body>
</html>

Private Function SendRelayCommandTest(ByVal e As String) As String
        'SendTextToIP("setstate,1:" & thePort & "," & TheState)
        'Dim IPHostCC1 As String = "192.168.1.105"
        Dim IPHostCC1 As String = "226.45.306.158"

        Dim IPHostPort As Integer = 49989       	 Dim tcpClient As New System.Net.Sockets.TcpClient()
        tcpClient.Connect(IPHostCC1, IPHostPort)
        Dim networkStream As NetworkStream = tcpClient.GetStream()
        
        Dim strResponse As String
        Dim strCommand As String
        strCommand = e ' RelayEventArgs.SetState & ",1:" & e.Port & "," & e.State
        strResponse = "No response"
        Try
            If networkStream.CanWrite Then
                Dim sendBytes As [Byte]() = Encoding.ASCII.GetBytes(strCommand & vbCr)
                networkStream.Write(sendBytes, 0, sendBytes.Length)
                
                Dim bytes(tcpClient.ReceiveBufferSize) As Byte
                networkStream.Read(bytes, 0, CInt(tcpClient.ReceiveBufferSize))
                Dim returndata As String = Encoding.ASCII.GetString(bytes)
                strResponse = "Return: " & CStr(returndata)
            Else
                If Not networkStream.CanWrite Then
                    strResponse = "Error: Cannot write data to the Relay device"
                    tcpClient.Close()
                End If
            End If
        Catch ex As ArgumentNullException
            strResponse = "ArgumentNullException: " & ex.Message
        Catch ex As SocketException
            strResponse = "SocketException: " & ex.Message
        Catch ex As Exception
            strResponse = "Exception: " & ex.Message
        Finally
            tcpClient.Close()
            networkStream.Close()
        End Try
        Return strResponse


    End Function