| Open Excel files outside of Internet Explorer |
|
 |
Index ‹ Web Programming ‹ ASP.Net
|
- Previous
- 1
- ASP.Net >> Hide DataDrig column at run timeHi,
I want to set visible to false in my datagrid to all fields that are an ID.
How can I do this?
I'm using ItemDataBound event but it gives me an error: "Index was out of
range. Must be non-negative and less than the size of the collection.
Parameter name: index"
I have this code:
---------------------------------------------------------------------------------------------
Sub Item_Bound(ByVal sender As Object, ByVal e As DataGridItemEventArgs)
Try
Dim i As Integer = 0
Dim lCol As Integer = dg.Columns.Count()
Dim strH As String
For i = 0 To lCol
strH = dg.Columns(i).HeaderText().ToUpper()
If Left(strH, 2) = "Id" Then
dg.Columns(i).Visible = False
End If
Next
Catch ex As Exception
lblMsgErro.Text = ex.Message()
End Try
---------------------------------------------------------------------------------------------
--
Programming ASP.NET with VB.NET
Thank's (if you try to help me)
Hope this help you (if I try to help you)
ruca
- 2
- Frontpage Client >> Why is my site not publishing to the remote web site side?As a rookie builder please be patient.
In FP2003 I am republishing my site with changes. However, the changes are
not happening.
When I right click on the page which is on the 'Remote Web Site side and try
to preview that page in my browser I get that page that says "this page
cannot be displayed."
When I preview the page on the Local Web site page I can view it just fine.
I have retried and retried to publish with no success.
Any help is very much appreciated.
Thank you,
Michael
- 3
- Frontpage Client >> Auto resize of background pictureHi,
I've put in my own background picture on my webpage. It looks fine when I am
in a lower resolution, however, when I am on a higher one, it tends to tile,
making it look bad. Is there a way to make the pciture automatically fit the
screen?
I'm using Frontpage 2003.
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- Frontpage Programming >> "Embedded" Pagination, how do I?I want to prepare a site that, when printed, the pages are all paginated to
A4. During composition I also wish to prepare a A4 pages.
The rationale that not all those who will need to access the material will
do so via a PC so I want a quick way of being able to produce a hard copy
version that is page for page like the website.
Any ideas please?
--
73
Brian
G8OSN
www.g8osn.org.uk
and
www.qsl.net/g8osn for FREE training material for the UK Foundation and
Intermediate Licences
- 13
- ASP.Net >> Get Web.Config sectionHello,
How can I get the value of an element of a web.config section?
For example:
<A>
<B>
<add name = "Name1" value = "Value1" />
<add name = "Name2" value = "Value2" />
<add name = "Name3" value = "Value3" />
</B>
</A>
I want to get the Value2 given the name of the section "B" and the
name "Name2".
Could you please tell me how to do this?
Thanks,
Miguel
- 14
- IIS >> http File Downloads...I have a file that I'm trying to access via web. ie. www.mydomain/myfile. There is no extension on my file. I want the user to be prompted with the familiar open...close...save..download dialog box. This use to work with NT 4. I've since move the site to a Win2003 server. Why doesn't this work anymore?
- 15
- IIS >> Network Computers not showing upI have Windows 2003 server With SP1.
Approximatly 20 client workstations all running 2000 pro or XP pro.
The issue is when I browse the network the only computer that appears
under the domain is the server. Some of the workstation were migrated
from an NT4 domain, some where just purchashed and added new to the
network. The computers did show up before. I can not recall anything
that has changed to break this behavior. I checked the Computer browser
service on the workstations.
Am I missing something obvious? A new security measure?
Thank you in advance.
-SLA
|
| Author |
Message |
mattdaddym

|
Posted: Fri Feb 06 07:12:55 CST 2004 |
Top |
ASP.Net >> Open Excel files outside of Internet Explorer
Hi
I'm rendering my datagrid to a HTML stream with a .xls extension to open in Excel however it opens in the browser. Is there a way to programatically force it to open Excel? I know you can configure a setting in windows explorer to do this but i want to do this without any client interaction
Thanks
Web Programming93
|
| |
|
| |
 |
Ken

|
Posted: Fri Feb 06 07:12:55 CST 2004 |
Top |
ASP.Net >> Open Excel files outside of Internet Explorer
Are you sending the content as an attachment with a name? That seems to work
for me... it launches Excel.
"Neil" <EMail@HideDomain.com> wrote in message
news:EMail@HideDomain.com...
> Hi,
>
> I'm rendering my datagrid to a HTML stream with a .xls extension to open
> in Excel however it opens in the browser. Is there a way to
> programatically force it to open Excel? I know you can configure a setting
> in windows explorer to do this but i want to do this without any client
> interaction.
>
> Thanks
|
| |
|
| |
 |
Steve

|
Posted: Fri Feb 06 16:25:32 CST 2004 |
Top |
ASP.Net >> Open Excel files outside of Internet Explorer
Some code like this should do the trick.
Response.AddHeader("Content-Disposition","attachment;filename=myfile.xls");
--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://Steve.Orr.net
"Neil" <EMail@HideDomain.com> wrote in message
news:EMail@HideDomain.com...
> Hi,
>
> I'm rendering my datagrid to a HTML stream with a .xls extension to open
in Excel however it opens in the browser. Is there a way to programatically
force it to open Excel? I know you can configure a setting in windows
explorer to do this but i want to do this without any client interaction.
>
> Thanks
|
| |
|
| |
 |
| |
 |
Index ‹ Web Programming ‹ ASP.Net |
- Next
- 1
- 2
- ASP.Net >> Groupname for Radiobutton kills Listener from Buttons?I have the following problem (especially with the groupname-attribut of the
RadioButton-Control) when developing in Visual Studio 2005 Beta.
I load an ascx-control in an aspx-page. This ascx-control itself creates
dynamically many radiobuttons in this way:
foreach (DataRow radiobutton_item in rbl_values.Rows)
{
RadioButton single_radiobutton = new RadioButton();
single_radiobutton.ID = "idname";
single_radiobutton.GroupName = "groupname";
this.Page.Controls.Add(single_radiobutton);
}
When loading the aspx-Page (and its controls) everything is fine and
groupname works as it should (I could only select one of the group). But when
a postback to this site occurs it seems that the listener of the
submit_button (placed on the aspx-Page) is killed. When I do not define the
Groupname of the RadioButton the submit_button works as it should (listeners
are not killed?!) but I can select more than only one radiobutton as I don't
have a group which they belong to.
I tried it already with an alternative:
single_radiobutton.Attributes.Add("name", mygroupname) instead of
single_radiobutton.GroupName = "groupname"; (seen in
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.dotnet.framework.aspnet&mid=3079eba1-694a-431a-8ae4-a458895a37ec&sloc=en-us)
but this didn't help.
Do you knwo this issue?
- 3
- ASP.Net >> Session state issuesHi,
I am getting the exception "Unable to connect to SQL Server session
database." many a times in my web app. I am dotNet 2 and Sql Server
2005.
(1) I use StateServer, and everything is working fine.
sqlConnectionString="data source=abc_db\abc1;user
id=abcd;password=1234"
I get the following error:
Stack Information : at
System.Web.SessionState.SqlSessionStateStore.ThrowSqlConnectionException(SqlConnection
conn, Exception e) at
System.Web.SessionState.SqlSessionStateStore.SqlStateConnection..ctor(SqlPartitionInfo
sqlPartitionInfo) at
System.Web.SessionState.SqlSessionStateStore.GetConnection(String id,
Boolean& usePooling) at
System.Web.SessionState.SqlSessionStateStore.ResetItemTimeout(HttpContext
context, String id) at
System.Web.SessionState.SessionStateModule.BeginAcquireState(Object
source, EventArgs e, AsyncCallback cb, Object extraData) at
System.Web.HttpApplication.AsyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&
completedSynchronously)
Inner Exception : System.Data.SqlClient.SqlException: Cannot open
database "ASPState" requested by the login. The login failed. Login
failed for user 'abcd'. at
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection
owningObject) at
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection
owningConnection) at
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection
outerConnection, DbConnectionFactory connectionFactory) at
System.Data.SqlClient.SqlConnection.Open() at
System.Web.SessionState.SqlSessionStateStore.SqlStateConnection..ctor(SqlPartitionInfo
sqlPartitionInfo)
Has anyone faced a similar type of problem?
Thanks a lot.
Rahul
- 4
- 5
- ASP.Net >> Date controlI need date picker control which allows that user pick more than just one
date.
For example, user pick 12,15 and 17 november and on page submit I can read
the selection from the calendar control.
Does anybody know the solution?
Thank you,
Simon
- 6
- Frontpage Client >> Sharing Main Category ListI am wondering if anyone is able to shed some light on my dilema... I have 6
computers in an office that are now sharing a public folder (so its bascially
networked)... and we are beginning to create and develop and buyers
database... but here's where the problem lies... each of us have different
Main Category listings... so if we enter a person's details and try to put
them in a specific category no one else can pick that category up... is there
a way of simplfying the system so that when anyone of us open up the category
listing - we all have the same ones. And if we change anything in the Main
Category listing - then it changes on everyopne machine. Is this at all
possible??
I would really apprecaite any help.
Cheers
Stephanie
- 7
- 8
- Frontpage Client >> Spell checkHas anyone else had the issue where the spell check says a word is spelled
wrong, you correct it and it reads your word as two words (the corrected
portion, and the new portion) and still says it's spelled wrong? very
bizzare. If so, do you know how to keep it from doing this?
- 9
- ASP.Net >> problems with some characterHi,
I've problem with some character input by the user into a web form.
The requestEncoding and responseEncoding are set to "iso-8859-1", but some
character truncate the request (I see this using the tracing).
How did you solve this type of problems ?
Thank you.
Bye
Stefano
- 10
- ASP.Net >> implementing searchHow to implement filtering or searching of the data like we have in
MSDN.when we tye any word in the lookup it should automatically be
sorted and as we go on entering the search should be more refined any
method to do this
please let me know.
thanks in advance
- 11
- ASP.Net >> on line poll site - need helpHi
I have a on line poll site for the coming general election in Sri Lank
http://jinath.europe.webmatrixhosting.net/ (asp.net
My problem is people can vote more that one time, I have put a cookie and session
But they can delete the cookie and open a new browser and vote again , I tried the new GUID (unique identifiers) whish .net have but it generating different GUID for same computer
So please any one have a good idea to overcome this proble
---
Posted using Wimdows.net NntpNews Component - Posted from .NET's Largest Community Website: http://www.dotnetjunkies.com/newsgroups/
- 12
- 13
- Frontpage Client >> Not able to allow annonomous users to upload to my folderI am trying to place an upload form into my website. I followed the
instructions given by frontpage until I get to where it says right click on
the folder and deselect the option for allowing scripts. I can not do this
because that selection is "dimmed" as well as the options to allow annonomous
users to upload to the folder and for uploaded files to write over files that
are already there. How do I make these things come out of "dimness" so that I
can chose these options? By the way the allowing scripts option is not
choosen in its present form. Thanks
- 14
- Frontpage Client >> Page BreakIs it possible to insert a page break in a form in FrontPage 2000 so
that the printing of the form can be controlled? Thanks for any help.
- 15
- ASP.Net >> Sort DataSetHello,
I have a DataSet with a DataTable that has 2 columns: Level and
LevelName
I want to sort the rows ascending using Level values.
How can I do this?
Thanks,
Miguel
|
|
|