sorry for the crosspost, i was a bit impatient, and thank you for your help, Regards!

i am trying to export a excel file to the user when they click a button, i tried Response.WriteFile("filename"), it only display the content in the same page, can someone tell me whats the code to prompt them with a save as option? Thank you in advance.

i am trying to export a excel file to the user when they click a button, i tried Response.WriteFile("filename"), it only display the content in the same page, can someone tell me whats the code to prompt them with a save as option? Thank you in advance.

I always get this exception -- System.Data.OracleClient.OracleException: ORA-00911: invalid character at System.Data.OracleClient... which indicates the connection is not valid. Following is my code: string connectionString = "Data Source=ora01;User ID=zd01;password=1234;Persist Security Info=True;"; OracleConnection con = new OracleConnection(connectionString); con.Open(); string sql = "insert into ua_user values(4, 'vivien', 'vivien', 9);"; OracleCommand command = new OracleCommand(sql, con); command.ExecuteNonQuery(); con.Close(); the sql command is working, and this worked under .net 1.1, now I am writing under .net 2.0, it seems refuse to work. Can anyone tell me what I did wrong, thank you in advance.

I am upgrading an application from asp 1.0 to 2.0. It seems like my old connection string for oracle doesn't work for this asp.net 2.0. No matter I read data or execute command, I always get this exception -- System.Data.OracleClient.OracleException: ORA-00911: invalid character at System.Data.OracleClient... which indicates the connection is not valid. My connnection string is: string connectionString = "Data Source=ora01;User ID=zd01;password=1234;Persist Security Info=True;"; OracleConnection con = new OracleConnection(connectionString); con.Open(); I can't find any errors in this connection setting, the sql commmand is tested and working. Any idea will be highly appreciated, Regards!

I uninstalled windows installer 3.1 then .net is able to install. Its so wierd, but i know it must be something wrong with my windows installer, maybe another small bug from microsoft.

thank you vega, the exact error message is "prerequisite programs are missing, setup has detected that the following prerequisite programs are not installed: Microsoft Windows Installer 3.0". The problem is that windows installer 3.0 wont allow me to install it. What should I do, I have tried with my spare pc which is windows server 2000, it installed perfectly.

when i try to install windows installer 3.0 it says "Setup has detected that the service pack version of this system is newer than the update you are applying. there is no need to install this update". But i guess the windows installer 3.0 doesnt know I need it for .net 2.0.

thank you for your help, i installed 3.1 but its still the same

I am trying to install .net 2.0 framework on my xp sp2, but the installtion asks for the windows installer 3.0 which is already included in xp sp2, however i downloaded windows installer 3.0 and tried to install it but it failed because sp2 is already there. Did anyone have similar problem like this? Currently I have .net 1.1 and vs2003 in my computer, do i have to uninstall it before install .net 2.0? Thank you in advance.

there is no .net2003/5, only .net 2.0/3.0 which is the sdk for u to write applications. Maybe u mean visual studio .net/ visual studio 2005, the latter is the later version embedded .net sdk 2.0

I had a similar experience before, what you need to do is right click the ie->view source to find out the html source code and go to line#168 to see what error it is. Normally it is not a ie error but a program error such as unthrowed exception

Thank you very much for your quck help, you gave me a thought of doing it in a different way, the actual code is String.format({0:#.##}, float).

Morning! I am calculating a percentage and the float value is, say 12.34567, I know float has 7 digits precision, is there any easy way to set the precision to 4 or 2 digits after .? So that I have 12.3 or 12.34, Thanks a lot.

Thank you so much for your help

Can anyone please teach me how to add " into string, I was writing sql statement and need " in it. Thank you in advance.

thanks for your reply, tried firefox and it even wont show me the page, the page is full of old javascript which isn't supported by firefox.

I am running a asp.net applicatin in localhost. In one aspx file I got Line: 1, Char: 99, Error: Unterminated string constant error message, the wierd thing is when I run it from web server the exactly same code, its perfect. Is it possible that I need to configure something in my local machine, can someone please help, Thanks in advance.

Thank you so much for your help, problem solved. Regrads!

Thank you. do you mean the page directive in aspx file html code, it already specify the c# file, as below <%@ Page language="c#" Codebehind="login.aspx.cs" AutoEventWireup="false" Inherits="dsscopy.login" %> but its just not in the Solution Explorer, which is annoying when i try to open the c# file cause its not there.