|
hi,
i'm openin MS excel and genrating gnatt chart using code as below.
gnatt charts are open on server machine properly.
but it does not open excel(only page refresh) on client machine.
But when it open at client machine it always ask username,password windows.
I want to open it without username,password window
Can anybody knows what is solve problem?
Sub excelgnattchart(ByVal stringWrite)
Try
Dim ExcellProcess() As System.Diagnostics.Process = System.Diagnostics.Process.GetProcessesByName("EXCEL")
Dim a As Int32 = ExcellProcess.Length()
Dim b As Int32 = 0
If (a > 0) Then
While a > b
ExcellProcess(b).Kill()
b = b + 1
End While
End If
Catch ex As Exception
End Try
Dim oExcel As New Excel.ApplicationClass
Dim oBook As Excel.WorkbookClass
Dim oBooks As Excel.Workbooks
Dim fname As String = "c:\chart.xls"
Try
Dim file As New FileInfo(fname)
Dim sWriter As TextWriter = file.CreateText()
sWriter.WriteLine(stringWrite.ToString)
sWriter.Flush()
sWriter.Close()
oExcel.Visible = True
oBooks = oExcel.Workbooks
oBook = oBooks.Open(fname, , True)
oExcel.Cells.Select()
oExcel.Charts.Add()
oExcel.ActiveChart.ChartType = Excel.XlChartType.xlColumnClustered
oExcel.ActiveChart.Location(Excel.XlChartLocation.xlLocationAsNewSheet)
oExcel.ActiveChart.HasTitle = False
oExcel.Charts.Move()
oBook.Close(False)
System.Runtime.InteropServices.Marshal.ReleaseComObject(oBook)
oBook = Nothing
System.Runtime.InteropServices.Marshal.ReleaseComObject(oExcel)
oExcel = Nothing
System.GC.Collect()
GC.WaitForPendingFinalizers()
file.Delete()
Catch ex As Exception
Console.Write("Exception :" & ex.Message)
End Try
|
|
|
|
|
cint(2.5) = 2
but cint(3.5) = 4
i check it for even odd values and i found that
for only odd it give next number.
why this happen?
|
|
|
|
|
There are two different rounding methods:
:: Rounding away from zero
:: Rounding to nearest even
The method you are using has been implemented to use the later one.
The Math.Round method has overloads that let you decide the rounding method.
---
b { font-weight: normal; }
|
|
|
|
|
Thanks for clarifying my doublts.
|
|
|
|
|
I having a Parent page with TextBox control.
I need to access this TextBox control's value from Child page.
I didn't know how to access in the server side from Child Page. can anyone help me on above problem.
- dhans
|
|
|
|
|
Hi,
U can pass any number of values from parent form to child form by QueryString.
Thanks and Regards.
|
|
|
|
|
Hi,
I have to deal with large amount of data, so i cannot use Querystring or session. Is there any other solution?
thanks for quick reply
- dhans
|
|
|
|
|
Sorry to say but I dont know any other option for this..... 
|
|
|
|
|
you can use global veriable in global.asax
i think this will help u
|
|
|
|
|
What do you mean by child page? is that a class derived from the original page?
If you're talking about 2 different ASPX pages, I think there is no way to retrieve values of a page from another page. I believe that as soon as you switch from one page to another, the previous page is discarded with everything in it, so I suppose there is no way to get back values from controls in it. You might be able to do so however if you're running a web user control and you want to retrieve the values of the parent page (containing the control). One thing for sure is that you can access programmatically any user control from the parent page and change the values of the controls in it, now whether you can go the other way around is something worth investigating.
Sorry, some theories, no solutions 
Talal
"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning."
--Rich Cook
|
|
|
|
|
whatever u told is ok. but it is possible by storing textbox's value in session or using 'shared veriable' in Global.asax
What do u think?
|
|
|
|
|
Hello all,
In my Winform i am using webBrowser control. in this i am displaying the asp.net page. it is working fine.
but I want to get the Page Title using webBrowser control. How to get this?
any sounds
regards
GV Ramana
|
|
|
|
|
Try this
Dim PageTitle = WebBrowser1.DocumentTitle
|
|
|
|
|
Hi,
A tester has installed the web application that I created in ASP.NET 2.0 onto his test machine. (This is done using the .msi)
When the tester encounters an eror on the website, then he gets the default page for the error. This I think should not happen as I have set the following in the web.config
<customerrors mode="RemoteOnly" defaultredirect="CustomError.aspx">
I think he is supposed to be directed to the error page i.e. CustomError.aspx
Any thoughts please?
Thanks
|
|
|
|
|
In web.config you can set like this
<customErrors mode="RemoteOnly"/>
-- modified at 7:04 Thursday 15th June, 2006
|
|
|
|
|
Hello there
I have written an image editor Application in ASP.net. I am doing some calculation at client side before posting using Java Script. I need to save my java script from any hacker as it Contains business logic. Is there any way to make javascript hidden...
Like I added the JavaScript File but when user saves the page from explorer then he can get the javascript file as well...
Support will be highly appreciated.
Regards
Rizwan Bashir
|
|
|
|
|
AFAIK, there's no way to prevent the user from downloading the script file, IMO what you might do is to make it hard to read/understand. Also, using javascript to contains business logic is a risk, and not a good practice. You should do it at the server side, and you can inscrease the responsiveness using AJAX to invoke the logic at the server side.
|
|
|
|
|
Hi to all,
Can anyone tell me how do I save the viewstate datatable where records of viewstate datatable are displayed on Datagrid on web form.
When I click on the save button all the data of datagrid or viewstate datatable should be saved in database.
Please help.
Thanks and Regards.
|
|
|
|
|
I'm curious as to why you need to persist the datatable in the ViewState. Do you want to keep the current state of the datagrid which supports paging? The simple way is to persist at the server side with the Session object, another option is to save it in DB, when the user click Save, you simply "commit" data in DB.
|
|
|
|
|
Hi,
Can someone please tell me if there i any free forum available written in C#. I need to implement it in my summer project.
Please provide me with the links.
Thanks.
Deepak Surana
|
|
|
|
|
|
Hello all can any body help me in solving the problem? The thing is flash is calling a javascript function in a webpage of mine after every two secand & i am inserting those values in database through Ajax. every thing is working fine but the problem is when flash call the function of javascript then it make the click sound which is default sound of browser as all of us get get it when we navigate through browser. I want to stop that coz flash is playing a movie & this voice is iretating after every two secands.Thx in advance for any help.
|
|
|
|
|
How do I define short cut keys with alphabet combinations. like Alt+F+N in my applicaiton.The definition is given for digits combination.How do I do that with alphabets
Regards
Uma
|
|
|
|
|
|
Hi,
How can I generate popup window in asp.net.
Thanks in advance
Sunil
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
