|
hi
I want to open Excel file on my local computer .
File is located on server's drive for eg.D\Project\Test.xls
How can i open this file on clients computer in Asp.Net.
I try this Code
public Excel.Application ExcelObj = null;
string filepath = AppDomain.CurrentDomain.BaseDirectory + @"PO_Attachment/"+lstattach.SelectedValue.ToString() ;
theWorkbook= ExcelObj.Workbooks.Open(
filepath, 0, true, 5,
"", "", true, Excel.XlPlatform.xlWindows, "\t", false, false,
0, true);
Excel.Sheets sheets = theWorkbook.Worksheets;
Excel.Worksheet worksheet = (Excel.Worksheet)sheets.get_Item(1);
ExcelObj.Visible = true;
But file can't open
So plz give solution or Code for opening this file
Its Very Very Argent
So plz Help me
thanks
Vivek Deshpande
|
|
|
|
|
|
Hello...
Can someone tell me how to save and retrieve a gif/doc file to a my sql server. i need to upload resume and photograph through my form.
Nizha
|
|
|
|
|
Dears
I’m using VS2005 , if we use postbackURL property button or link button it will pass all controls values in page (form method and encrypted ) to second page and we can get the values in second page by using Request.form[“ControlName”]
Now , I need same way to pass the variables values in code behind of page1 to page2 by using postbackURL
Can any one explain how I can write do it
thanks a lot
-- modified at 8:53 Monday 16th October, 2006
|
|
|
|
|
Hi,
For ex, in Source's (Source.aspx) CodeBehind (C#),
string val_a="abc";<br />
string val_b="def";<br />
<br />
LinkButton.PostBackURL="Target.aspx?a=" + val_a + "&b=" + val_b;
You can get the values in Target page(Target.aspx.cs) using,
string a = Request.QueryString["a"].ToString();<br />
string b= Request.QueryString["b"].ToString();
Also You may use PreviousPage property of ASP.NET 2.0
The following could be added to Target.aspx:
<%@ PreviousPageType VirtualPath="~/Source.aspx" %><br />
<br />
TextBox nameBox = PreviousPage.NameBox;
Here,NameBox is the TextBox control in the Source Page.
-- modified at 3:31 Monday 16th October, 2006
Regards,
Jay 
|
|
|
|
|
The main issue is the "Select a Format" and "Size" dropdown boxes on the ReportViewer. Those controls seem to always have the highest z-order and I cannot show anything ontop of them....
- What I am trying to show ontop of them...
I cannot seem to place a <div> using absolute positioning with a table inside the <div> tags on top of those combo boxes...
- Why Would I want to do such a thing...
I am using Microsoft Visual Studio 2005 ASP.Net 2.0, ReportViewer with rendering LocalReports that show RDL Files. Showing the RDL files are working just fine with the ReportViewer but I want to have prompt options like SQL Server Reporting Service. I also have this working pretty good also.
- So Whats The Problem Again....
I searched the web for a combobox with check buttons like SQL Server Reporting services multivalue option and was unable to find one, so I made my own custom control that does nearly the same thing. My drop down is a <div> tag with a table with checkboxes. When I tell my <div> to have visibility eqaul to "visible" it show the drop down correctly on top of everyting on the page but always under the ReportViewer Comboboxes.
I have tried setting the z-order to 999999 on my <div> tag, <table> tag, and <input> tags and it is still under the report viewer comboboxes.
Please Help....
Chris
|
|
|
|
|
In IE the combo box is rendered using the windows control and ignores z-order. Most menu scripts and the like find the combox box controls and hide them while they are over where the controls should be.
Using the GridView is like trying to explain to someone else how to move a third person's hands in order to tie your shoelaces for you.
-Chris Maunder
|
|
|
|
|
I have a aps.net website where I'm trying to show an alert via javascript.
I'm setting a string variable to the following in the code-behind:
m_strAssemblyMisMatch = "<script language=\"javascript\">alert(\"" +
"This website may not function as expected due to assembly version \n" +
"mis-matches that were detected during application initialization. The \n" +
"following mis-matches were found:\n\n" +
strBadAss +
"\nPlease login and notify a support representative." +
"\");</script>";
The strBadAss variable contains text like
"\tAssemblyNameOne\n\tAssemblyNameTwo\n\tAssemblyNameThree\n" .
I'm rendering this string in the aspx page with the following statement:
<%=m_strAssemblyMisMatch%>
If I leave the linefeed characters in the string, I get a javascript error claiming there's an un-terminated string constant, and the alert dialog is NOT displayed. If I remove all of the linefeeds, the alert dialog IS displayed (with everything on one line of course).
In an attempt to see if there was indeed an un-terminated string, I tried the following:
m_strAssemblyMisMatch = "<script language=\"javascript\">alert(\"" +
"This website may not function as expected due to assembly version \n" +
"\");</script>";
Once again, if I left the linefeed in the string, it wouldn't work, but if I removed the linefeed character, it was fine.
Can anyone tell me what I'm doing wrong?
"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
|
|
|
|
|
Just a guess - the newline escapes are being turned into actual newlines by the C# compiler, so by the time they make it onto the page, you now have a string spanning multiple lines (which JS doesn't like). Try double escaping the newlines (\\n).
every night, i kneel at the foot of my bed and thank the Great Overseeing Politicians for protecting my freedoms by reducing their number, as if they were deer in a state park. -- C hris L osinger, Online Poker Players?
|
|
|
|
|
Yeah - figured that out and came here to update my message. I hate C#.
"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
|
|
|
|
|
You have to Quote the JavaScript string to make it work. As \n gets converted to a new line.
Look at the implementation of System.Web.UI.Util.QuoteJScriptString(String, Boolean) using Reflector.
Debugging is twice as hard as writing the code in the first place. Therefore, if you write the code as cleverly as possible, you are, by definition, not smart enough to debug it. -Brian Kernighan
|
|
|
|
|
Wrong answer, but thanks for responding. I had to double-backslash the linefeed character to fix it.
"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
|
|
|
|
|
John Simmons / outlaw programmer wrote: I had to double-backslash the linefeed
That is what I call Quoting. The System.Web.UI.Util.QuoteJScriptString(String, Boolean) is a general purpose function that converts everything like tab characters and special unicode characters to JS friendly form.
Debugging is twice as hard as writing the code in the first place. Therefore, if you write the code as cleverly as possible, you are, by definition, not smart enough to debug it. -Brian Kernighan
|
|
|
|
|
This is often known as escaping, which comes from the use of the escape character (0x1b) in environments like DOS and with matrix printers.
Also the term encoding is sometimes used, as in the HtmlEncode and UrlEncode methods.
---
b { font-weight: normal; }
|
|
|
|
|
On Button Postback an Aspx Page runs the following onclick C# event handler:
{
// dr[“Content”] - DataRow Item type byte[] where is a song in mp3 format
ar = dr[“Content”];
Response.ContentType=“audio/mpeg”;
Response.Clear();
Response.BufferOutput = true;
Response.BinaryWrite(ar);
Response.Flush();
}
I received error in Response.Flush() – The remote host closed the connection.(HttpException).
Please help me,
Thanks
hector
|
|
|
|
|
I think you forgot the specify the length of your response. This should be equal to the size of the audio file you are sending to the client. Now the connection gets closed in the middle of the operation, because the client thinks he's done downloading the data and there's nothing left.
WM.
What about weapons of mass-construction?
|
|
|
|
|
How can I set StreamOutput Lentgth ?, I think “al.length” was taken for “Response.Binary(al)” but maybe not. In debugger Response.OutputStream.Length is showing a SystemNotSupportedException.
Also “Response.OutputStream.Length” is readonly
|
|
|
|
|
|
Can anybody help to display data as table using crystal report from an asp.net page
Thanks
|
|
|
|
|
Hello,
What datasource are you using for the grid? If you use a dataset paging should be supported, I'm unsure of the other sources, it sounds totally logical that IEnumerable sources don't support this kind of functionality.
WM.
What about weapons of mass-construction?
|
|
|
|
|
code snippet
dim sCode,sName
dim oCmd, sSqlString
dim oNewConnection, oNewRecordset, sNewSQL
sCode=replace(request.Form("txtCode"),"'","''")
sName=replace(request.Form("txtName"),"'","''")
sSqlString2 ="DELETE * FROM tblcode WHERE (code = " & sCode & " AND codeOwner= '" & sName &"')"
Set oNewConnection = Server.CreateObject("ADODB.Connection")
'open the connection to the database
oNewConnection.Open(sConnString2)
oNewConnection.execute(sSqlString2)
but when i try to excute that i get the following error
Microsoft OLE DB Provider for SQL Server error '80040e14'
Line 1: Incorrect syntax near '*'.
kenny
|
|
|
|
|
1. Remove the * in the query. You are deleting records, not specific fields of records.
2. You have forgotten the apostrophes around the value you are comparing to the code field.
---
b { font-weight: normal; }
|
|
|
|
|
thanks made the changes and it worked, i didn't need to put the apostrophes around the values though
|
|
|
|
|
keroed_edmond wrote: i didn't need to put the apostrophes around the values though
Are you sure? You are escaping the apostrophes in the value, is that something that you just do without knowing why, or can the value actually contain apostrophes? If it can, then you need to put apostrophes around the value.
---
b { font-weight: normal; }
|
|
|
|
|
hi all,
when i try to upload large files (file length is bigger then maxRequestLength i recive error page(this page can't be displayed dns error) all i want to make is to find a way to display error page instead of this default error page.
i tried to use custom error page but it doesn't work.
does any one has idea?
Thanks in advance.
marcoryos
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
