|
You need to set all sheets as visible = false except for the one you want to see.
<script language=vbscript>
Dim objExcel
Sub chartsheet_onclick()
call OpenWorkbook("c:\test\myFile.xls")
End Sub
Sub OpenWorkbook(strLocation)
Set objExcel = CreateObject("Excel.Application")
objExcel.Visible = true
objExcel.Workbooks.Open strLocation
objExcel.UserControl = true
objExcel.Sheets("sheet1").Visible = False
objExcel.Sheets("sheet2").Visible = True
objExcel.Sheets("sheet3").Visible = False
End Sub
</script>
------------------------------------
I will never again mention that I was the poster of the One Millionth Lounge Post, nor that it was complete drivel. Dalek Dave
CCC Link[ ^]
Trolls[ ^]
|
|
|
|
|
Hi Dalek,
Thanks for the replay.
I wanted the file to open on the second sheet only for some user and not change it for everyone.
I was sure there is a url parameters but all the examples I found doesn't work.
Thanks.
|
|
|
|
|
how will we generate dynamic fields in gridview and i want to generate both checkbox or dropdown according to the values in the db..
|
|
|
|
|
I have some issue on debug, pls follow the below code
CType(gvw.FindControl("FTddlCity"), DropDownList).Attributes.Add("onchange", "javascript:city_Visibility('" + CType(gvw.FindControl("FTddlCity"), DropDownList).ClientID + "','" + CType(gvw.FindControl("FTtxtCityName"), TextBox).ClientID + "');")
On compling the above codes, i got the error message:
BC30311: Value of type 'System.Web.UI.Control' cannot be converted to 'System.Windows.Forms.TextBox'.
But these code works fine in my teammate system,
I hope i may miss any installtion tools related.
Can anyone help me regarding.
Thanks in advance.
|
|
|
|
|
You are trying to convert a System.Web.UI.Control control to a System.Windows.Forms.TextBox control. The Web and Forms namespaces are different.
Unrequited desire is character building. OriginalGriff
I'm sitting here giving you a standing ovation - Len Goodman
|
|
|
|
|
Thanks on your response Richard.
The code which i have given is in asp.net web application (VB language).
And this code containing page is working fine in my Teammate(s) local run.
Only me getting this error.
Please guide me to get out of this issue.
Thanks on Advance.
|
|
|
|
|
palvesh wrote: Please guide me to get out of this issue.
As I said before you are trying to convert a Web object into a Windows.Forms object. Either your code or its references are incorrect. Check again the line of code that gives the error and also your project settings. Beyond that I cannot suggest anything else.
Unrequited desire is character building. OriginalGriff
I'm sitting here giving you a standing ovation - Len Goodman
|
|
|
|
|
Hope, this is the only possible i can do.
Thanks for your suggestion.
|
|
|
|
|
palvesh wrote: Hope, this is the only possible i can do.
Are you sure you understand what this code is doing, and the difference between the two namespaces? This error message is very clear and should not be causing you any confusion.
Unrequited desire is character building. OriginalGriff
I'm sitting here giving you a standing ovation - Len Goodman
|
|
|
|
|
Thanks for the suggestion griff.
I have removed the web.config and once again i referred all my tools/controls i have used in the application. But what the miracle is amoung two of my development server.
It works in one server but not in my local system.
Anyway i will try again the same option and close the issue.
Thanks once again Griff.
|
|
|
|
|
palvesh wrote: Thanks for the suggestion griff.
I am not Griff.
palvesh wrote: It works in one server but not in my local system.
So, you need to check what is different between the two systems. I get the feeling you still don't understand the original error message, but cannot think of anything to make it clearer.
palvesh wrote: Thanks once again Griff.
I am still not Griff.
Unrequited desire is character building. OriginalGriff
I'm sitting here giving you a standing ovation - Len Goodman
|
|
|
|
|
Richard.
Hope my question may look silly and make u to think wrong on my observation.
Richard, i got the issue exactly.
As per my error: the error message itself clearly explain and i have also sorted the issue. It's simply due to the wrong usage of namespace which refers window forms(System.Windows.Forms) in the web app page.
But what is my question is ..
How it works in one server and not in another which has the same coding/config.
Something i am missing to check other than these..
|
|
|
|
|
Sorry but I cannot answer that without seeing exactly what is on each system. Perhaps just one of those strange situations that we never manage to get an answer for.
Unrequited desire is character building. OriginalGriff
I'm sitting here giving you a standing ovation - Len Goodman
|
|
|
|
|
Thanks for the response Richard,
Now i am working in a new web application created in vs2010.
I have noticed a tag in the master page and webform page.Pls explain what is the exact usage of this.
In masterpage:
<asp:contentplaceholder id="head" runat="server">
In webform:
<asp:content id="Content1" contentplaceholderid="head" runat="Server">
|
|
|
|
|
I'm afraid I am not a web developer so cannot help you on this. I would suggest the ASP.NET website for more information.
Unrequited desire is character building. OriginalGriff
I'm sitting here giving you a standing ovation - Len Goodman
|
|
|
|
|
|
I've never tried to put a findcontrol in a findcontrol, but in vb the + signs are still & ampersands. However, since the code in the () is javascript, the plus + signs should work, if you require a direct print of the findcontrol.
You may not have imports system.web
or you need to prefix the control
System.Web.UI.DropDownList
or something like that, I don't remember where the dropdownlist resides at.
CType(gvw.FindControl("FTddlCity"), DropDownList).Attributes.Add("onchange", "javascript:city_Visibility('" + CType(gvw.FindControl("FTddlCity"), DropDownList).ClientID + "','" + CType(gvw.FindControl("FTtxtCityName"), TextBox).ClientID + "');")
Hmm, thinking out loud.
Findcontrol is server side processed, before the html is rendered and sent back to the client. The findcontrol in the Javascript is just an ID reference to the DropDown, so the Dropdown can be called in the DOM. Your using a server side name called FTddlCity to find it on the server side, when you can just let the client side do it's thing, using the client side id.
in Jquery, you can find the id asp.net server has assigned by calling
$('[id*="_FTddlCity"]').css('background-color', txtFocus).fadeOut("normal");
If you just assign a unique ID to the Dropdown, you can just call the ID in the Javascript. This will filter over the prefix the server will assign to the ID or the control. If you want to hard code an ID, it's attributes.add("id", "FTddlCity")
|
|
|
|
|
Since I am new with working with C#asp.net web controls 2010, I have the following question to ask about the gridview control:
1. Since there a way to change the orientation of the gridview control. Instead of being horizontal orientation, I would like the the gridview control to be vertical display? This column names would go down the left side of the grid? If this is possible, what do I need to do change the orientation?
2. I want to embeded dropdown list controls in different cells. Is there a way you recommend I accomplish this task? Is there some like 'BulkEditGridView' for dropdown list controls?
|
|
|
|
|
For your first question, You can transpose your data source and can achieve what you want. Do a bit of google how to "Transpose DataTable".
For Second question, just google "bulk edit GridView" and will get 100s of result.
I am pasting one of them for you here[^].
|
|
|
|
|
Hi Experts,
I have one default template in word in which i have to include strings from textbox. Can some one provide some idea of doing it using asp.net.
I tried usingASP.NET generating Dynamic word Documents[^]
but this is given in Vb. Can some one provide me any similar solution given in the above link using asp.net.
|
|
|
|
|
I am asking the following question since this is the first few C# asp.net 2010 web form pages I am working with at my company. My problem is I want to pass the value of orgName from the code listed below to a new web page called Next_Page.aspx as a session variable. The problem is by the time I get to the method called 'submit_button', I do not have the value of 'orgName' any longer. Thus can you tell me what I need to do to have the value of 'orgName' obtain from the 'FindOrg' available to the 'submit_button' method? If the value or orgname is within the (object sender, EventArgs e) of the SubmitButton method can you tell me how to access this value?
The code listed below is all from the same web page called first.aspx.cs.
The following is the current code:
[^]protected void FindOrg(object sender, EventArgs e)
{
try
{
String strOrgSql = "";
String orgName = txtOrgName.Text.Trim();
}
catch (Exception ex)
{
//do something
}
}
protected void submit_button(object sender, EventArgs e)
{
try
{
want orgname value here
Session["orgname"] = orgname;
Response.Redirect("~/Next_Page.aspx");
}
catch (Exception ex)
{
// do something
}
}
[^]
|
|
|
|
|
orgname is a variable local to the FindOrg method. It can't be used outside of that method. Use txtOrgName.Text.Trim();
No comment
|
|
|
|
|
How would I declare the variable so I can use it outside of this method? Would I set it up as a session variable?
|
|
|
|
|
You can put the variable at Class level. You can also put it in session variable and can be accessed at any other pages as well
|
|
|
|
|
In the case you have shown you don't need to use a variable to hold the value until it is passed to session, assign the value from the control directly to you e session variable
Session["orgname"] = txtOrgName.Text.Trim();
No comment
|
|
|
|