Web Development

browser compatibility problem

25-Sep-07 21:11

Hi,

This is how I create a connection for my spreadsheet in excel. The source code below about connecting to excel has no problem when accessing it in the local web server, but when accessing it from real web server the error appears.

I can't figure it out if what's really wrong.

Source code Error:

Dim sConnectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0;" _
& "Data Source=" & FileUpload.FileName.ToString & ";" _
& "Extended Properties=Excel 8.0;"

' Create connection object by using the preceding connection string.
Dim objConn As OleDbConnection = New OleDbConnection(sConnectionString)

' Open connection with the database.
objConn.Open()

' The code to follow uses a SQL SELECT command to display the data from the worksheet. 4158531 - 33
' Create new OleDbCommand to return data from worksheet.
Dim objCmdSelect As OleDbCommand = New OleDbCommand("Select * From [summary$]", objConn)

hifiger2004

nicetohaveyou24-Sep-07 22:56

nicetohaveyou

24-Sep-07 22:56

i have deployed a jsp and servelet applciation in intranet.

the pages work fine for all the browsers but not for safari.

actually i was using websphere for the EAR file.

when i tried to debug, i found that it was not showing any value for username
prior to the displaying of the page.

what the application does is that first of all before loading the page, it prompts for the user name and password for the domain i.e it checks for the active directory then only it load the file.

probably that is the point where safari does not work.
what could have gone wrong? do i need to configure something?

Problem in passing message betwin client server.

Tarun Dudhatra24-Sep-07 19:28

Tarun Dudhatra

24-Sep-07 19:28

Hi everyone.
I am developing one client live support or customer assistant application using asp.net with c#.

I developed 2 class one is
server and another is client.

In server class i wrote 5 method
1 for start the server.
2 for accept the connection from client.
3 to send data or msg to the client.
4. to receive the data or msg from client
5. to stop or disconnect the client from the server.

In client class i wrote 4 method
1 for connect to the server
2 for send data to the server
3 for receive data from the server
4 to disconnect from the server

I call server.start() method from page load event first from server.aspx page and in client.aspx page load

event I called client.connect() method to connect with the server. So when any client made a request

from remote server how we can come to know that some client made a request so we can accept it. and

from where i can call accept method is any thing is there to achieve it. pls help me if u can or send me

details decription ok
Some what like call back
Thanks

reading web site content

dhatchu24-Sep-07 18:34

dhatchu

24-Sep-07 18:34

dear all,

how to read website content in asp.net

can any one give me possible steps

Dhatchinamoorthy.R
9894824838

Re: reading web site content

Christian Graus24-Sep-07 18:38

Christian Graus

24-Sep-07 18:38

Please don't cross post.

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Web parts User control Events

zol_tech24-Sep-07 5:53

zol_tech

24-Sep-07 5:53

I have dynamically added user controls to the webparts.I have added event handlers to these user controls..
But the events do not fire..
can anyone tell me how do I go about resolving this issue..

Thanks
Jol

Re: Web parts User control Events

Jpuckett25-Sep-07 17:38

Jpuckett

25-Sep-07 17:38

What events? Are the controls housed in a placeholder or panel?

Need a code snippet or some detail to move forward on this. Smile | :)

Converting a PHP HexToBin function to C# [modified]

#realJSOP24-Sep-07 5:20

24-Sep-07 5:20

I'm converting some code from PHP to C# (.Net 2.0). Can someone that knows PHP verify that the C# code I wrote does the same thing as the original PHP code? The actual line I'm concerned about is inside the for loop.

private string HexToBin(string data) 
{
/*
    // original php function
    $len = strlen($data);
    $newdata='';
    for($i=0;$i<$len;$i+=2) 
    {
        $newdata .=  pack("C",hexdec(substr($data,$i,2)));
    }
    return $newdata;
*/
    int length = data.Length;
    string newData = "";
    for (int i = 0; i < data.Length; i += 2) 
    {
        string value = data.Substring(i, 2);
        newData += Int32.Parse(value, NumberStyles.HexNumber).ToString();
    }
    return newData;
}

Maybe that line in the for loop needs to be this?

newData += string.Format("{0}", Int32.Parse(value, NumberStyles.Integer));

If I completely mangled it up, don't be shy about telling me, but give me the correct code if you feel up to it.

-- modified at 11:50 Monday 24th September, 2007

"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
-----
"...the staggering layers of obscenity in your statement make it a work of art on so many levels." - Jason Jystad, 10/26/2001

Guffa24-Sep-07 7:34

24-Sep-07 7:34

You can't write a .NET function that does the same as that PHP code, as there are no binary strings in .NET. A PHP character is an eight bit value, while a .NET character is a 16 bit unicode character.

Binary data in .NET is usually represented as a byte array:

private byte[] HexToBin(string data) {
    int length = data.Length / 2;
    byte[] newData = new byte[length];
    for (int i = 0; i < length; i++) {
        string value = data.Substring(i * 2, 2);
        newData[i] = Byte.Parse(value, NumberStyles.HexNumber);
    }
    return newData;
}

---
single minded; short sighted; long gone;

#realJSOP24-Sep-07 9:55

24-Sep-07 9:55

Actually - I can:

private string HexToBin
{
    string newData = "";
    if (data != "")
    {
        for (int i = 0; i < data.Length; i += 2)
        {
            string hexValue = data.Substring(i, 2);

            // either of the next two lines work

            string binValue = string.Format("{0}", <code>Int32</code>.Parse(hexValue, NumberStyles.AllowHexSpecifier));
            // - or -
            //string binValue = string.Format("{0}", <code>Byte</code>.Parse(hexValue, NumberStyles.HexNumber));
            newData += binValue;
        }
    }
    return newData;
}

Guffa24-Sep-07 10:29

24-Sep-07 10:29

John Simmons / outlaw programmer wrote:
either of the next two lines work

That depends on what you mean by "work". They both do something, and the result is the same in both cases, but neither of them produce a result that is useful in any way.

If you have a string containing hexadecimal values, like "07FF10", that code will produce a string containing "725516". That's not a binary string as all, it's just a string containing the digits from the decimal representation of the hexadecimal values. It can't be used for anything at all, not even reproducing the hexadecimal string, as is't impossible to determine where one value ends and the next one begins.

---
single minded; short sighted; long gone;

#realJSOP25-Sep-07 0:14

25-Sep-07 0:14

Guffa wrote:
That depends on what you mean by "work". They both do something, and the result is the same in both cases, but neither of them produce a result that is useful in any way.

The original question was regarding the similarity in functionality, not what the result is to be used for. So back to the original intent - does the C# version do the same thing as the PHP version?

Guffa25-Sep-07 0:25

Re: Converting a PHP HexToBin function to C# [SOLVED]

25-Sep-07 0:25

John Simmons / outlaw programmer wrote:
The original question was regarding the similarity in functionality, not what the result is to be used for. So back to the original intent - does the C# version do the same thing as the PHP version?

No, they don't, as they can't. As I explained, strings doesn't work the same in .NET as in PHP, so there is no .NET equivalent of the PHP binary string.

If you want to work with binary data in .NET you use a byte array instead.

If the binary data represents encoded text, you use one of the Encoding classes to decode the data back to a string. If the binary data for example is text encoded as UTF-8, you use the Encoding.UTF8.GetString method to decode the byte array into a string.

---
single minded; short sighted; long gone;

#realJSOP25-Sep-07 3:37

Re: Converting a PHP HexToBin function to C# [SOLVED]

25-Sep-07 3:37

I finally got a chance to try this at home, and here's the C# version of the PHP code posted in the original message:

private string HexToBin(string data) 
{
    string newData = "";
    if (data != "")
    {
        for (int i = 0; i < data.Length; i += 2)
        {
            string hexValue = data.Substring(i, 2);
            newData += Convert.ToChar(Byte.Parse(hexValue, NumberStyles.HexNumber));
        }
    }
    return newData;
}

Guffa25-Sep-07 19:49

AOL API for Calendar data?

25-Sep-07 19:49

That function doesn't do the same as the PHP function.

As I already explained, you need to use an Encoding class do decode the data if you want the result as a string. Now you are just taking the data and using it as unicode character codes. That only works for the characters that happen to have the same character code in unicode as they have in the encoding that was used to create the data.

---
single minded; short sighted; long gone;

vbmithai23-Sep-07 20:00

vbmithai

23-Sep-07 20:00

Can anybody tell me that AOL support the calendar data api to access canlendar data of AOl in to third party website?
If yes then tell me which AOL API support that and how can i use that API.
Thank you.
Waiting for reply

Vishal Mithawala.

CCAvenue intregation

Abhishek0323-Sep-07 19:56

Abhishek03

23-Sep-07 19:56

Hi..

I want to know the integration procedure of CCAvenue Payment gateway to integrate it with a ASP.NET 2.0 Shopping Cart Web Site. I am not able to see the procedure on CCAvenue's official website without beeing registered.

Can anyone provide me the solution to complete the task. I will be very thankful.

Abhishek Dubey Smile | :)

abhi

How the FILEUPLOAD to prevent from posting back?

hifiger200423-Sep-07 7:23

Re: How the FILEUPLOAD to prevent from posting back?

23-Sep-07 7:23

Hi,

I have problem in Fileupload, it will postback. Is there a way to prevent from posting back?

Thank you

hifiger2004

Guffa23-Sep-07 8:57

Re: How the FILEUPLOAD to prevent from posting back?

23-Sep-07 8:57

No. The file data is sent in the request to the server. No postback, no upload.

---
single minded; short sighted; long gone;

hifiger200423-Sep-07 12:16

Re: How the FILEUPLOAD to prevent from posting back?

23-Sep-07 12:16

How can we control the process to execute it just only once?

Because, I have one button wherein the process will upload the excel file and at the same time will add the number of quantities into the database.

If this will be the case how can I control the process, because it will affect also on the adding of quantities, it will result to times 2 which is not correct.

hifiger2004

Christian Graus23-Sep-07 12:42

Christian Graus

23-Sep-07 12:42

One thing you can do is, on your postback, once your code has processed the postback, in your prerender, redirect to the same URL, and put something on the query string to make the page reload it's data. This way, a refresh will not perform the postback again.

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Re: How the FILEUPLOAD to prevent from posting back?

hifiger200423-Sep-07 17:20