Web Development

9-Apr-07 21:58

URGENT!! How to ember an excel in webpage? I'm not saying the normal file link that points to an xls file. But I want to use the excel object to do it. Which allow me to call function like pivot table for the excel sheet.

Which actually mean when i click a button then it'll load the data from sql server to an excel sheet on sheet1 and also the pivot table on sheet2. Can the excel sheet exist virtually without saving it as a xls file 1st? (direct load from database)

I hv googled for a week but cant find the solution. can someone please help?

* much prefered if the answer can be in VB.net or vbscript Wink | ;)

-- modified at 4:07 Tuesday 10th April, 2007

-- modified at 4:10 Tuesday 10th April, 2007

-- modified at 4:11 Tuesday 10th April, 2007

Wat key(s) do IM user press most?
> ENTER - to send msg

Wat key(s) do gamer press most?
> WASD

Wat key(s) do Programmer press most?
.
.
.
> Ctrl C + Ctrl V

Bradml9-Apr-07 22:11

9-Apr-07 22:11

M'fraid that ain't how it works.

Brad
Australian

- unknown PHP Developer on "Job Prospect"

Requirement: * Experience working with XML, XSL, XPath

Comment: and other things starting with X.

neo_60539-Apr-07 22:39

9-Apr-07 22:39

sorry .. i really dunno how it work .. just hopefully someone can give me some ideas .. coz quite urgent..

Wat key(s) do IM user press most?
> ENTER - to send msg

Wat key(s) do gamer press most?
> WASD

Wat key(s) do Programmer press most?
.
.
.
> Ctrl C + Ctrl V

Bradml9-Apr-07 22:41

9-Apr-07 22:41

Embedding Excel (as in making a web based Excel) is too hard for it to be urgent. To create a dynamic Excel sheet you can just create it and print the binary.

Brad
Australian

- bryce on "Problems with Code Project"

*sigh* Maunder's been coding again...

neo_60539-Apr-07 23:03

9-Apr-07 23:03

ya, i believe it's very hard too..

but by printing the binary .. i cant call the pivot table function, right?? actually nvm if it's not web-based. i just want to get the pivot table function to be called.

Wat key(s) do IM user press most?
> ENTER - to send msg

Wat key(s) do gamer press most?
> WASD

Wat key(s) do Programmer press most?
.
.
.
> Ctrl C + Ctrl V

neo_605310-Apr-07 20:51

How can make a flash banner as a ref link?

10-Apr-07 20:51

any help?

Wat key(s) do IM user press most?
> ENTER - to send msg

Wat key(s) do gamer press most?
> WASD

Wat key(s) do Programmer press most?
.
.
.
> Ctrl C + Ctrl V

Omar Mallat9-Apr-07 21:23

Omar Mallat

9-Apr-07 21:23

I have a flash object in my page and I need to go to a link when the user click on the flash.
the flash is inserted into the page using this way:
<object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=7,0,19,0" width="581" height="93" title="sho" align="left" id=ShockwaveFlash2>

<param name="movie" value="show.swf">

<param name="quality" value="High">

<param name="_cx" value="15372">

<param name="_cy" value="2461">

<param name="FlashVars" value>

<param name="Src" value="show.swf">

<param name="WMode" value="Window">

<param name="Play" value="-1">

<param name="Loop" value="-1">

<param name="SAlign" value>

<param name="Menu" value="-1">

<param name="Base" value>

<param name="AllowScriptAccess" value>

<param name="Scale" value="ShowAll">

<param name="DeviceFont" value="0">

<param name="EmbedMovie" value="0">

<param name="BGColor" value>

<param name="SWRemote" value>

<param name="MovieData" value>

<param name="SeamlessTabbing" value="1">

<param name="Profile" value="0">

<param name="ProfileAddress" value>

<param name="ProfilePort" value="0">

<param name="AllowNetworking" value="all">

<param name="AllowFullScreen" value="false">

<embed src="show.swf" width="581" height="93" align="left" quality="high" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash"></embed></object>

OmarMallat

Re: How can make a flash banner as a ref link?

Bradml9-Apr-07 22:12

Re: How can make a flash banner as a ref link?

9-Apr-07 22:12

You need to do this in action script.

Brad
Australian

- unknown PHP Developer on "Job Prospect"

Requirement: * Experience working with XML, XSL, XPath

Comment: and other things starting with X.

haggenx16-Apr-07 12:12

haggenx

16-Apr-07 12:12

Is true, you need make a javascript same this

function Click_link(link)
{
window.open(link);
}

And, the swf file you must call this function with geturl function of swf flash.

Manuel say: Greetings from Mexico, Cuando salga el sol, no estare aqui...
---------------------------------------

Web: http://www.otakuzone-fanzine.com
Forum: http://www.otakuzone-fanzine.com/foro

How can I determine the right button image for my custom combobox button for the selected desktop motif? [modified]

howardjr9-Apr-07 14:23

howardjr

9-Apr-07 14:23

I wrote a custom combobox that uses an image button. However, if the user changes their desktop motif, then the button images on my combobox won't change, which doesn't look very good, expecially if there are any regular drop-down-lists on the page.

Is there a way to determine which motif the desktop is using with javascript, vbscript, or something else?

An alternative would be to "sample" the color of one or more points in the button area of a regular drop-down-list on a page before the one my combobox is displayed on, then use this information to determine the motif, and have my aspx's code select the right button-set for my combobox when building the page. How can I "sample" the color of a drop-down-list's button?

Incidently, I'm using IE6 SP6 with VB.Net 2003 with client-side javascript for my target browser and the development language.

Thank you

DataGrid - Selected Item problem

No-e9-Apr-07 7:08

No-e

9-Apr-07 7:08

I am having difficulty with a detail button on a datagrid, I just need a button or something next to each record I list, when the user clicks it I give them more detail or something. I immediatly went to the Microsoft help and found an example where they do this:

<asp:datagrid id="ItemsGrid" bordercolor="Black" showfooter="False" cellpadding="3" cellspacing="0" headerstyle-backcolor="#aaaadd" onselectedindexchanged="IndexChange_Command" runat="server">
<columns>
<asp:buttoncolumn text="Select" commandname="Select">

they declare this:

Sub IndexChange_Command(sender As Object, e As EventArgs)
' Display the details of the selected item.
DetailsLabel.Text = _
"Item Number: " & ItemsGrid.SelectedItem.Cells(1).Text & "
" & _
"Description: " & ItemsGrid.SelectedItem.Cells(2).Text & "
" & _
"Price: $" & ItemsGrid.SelectedItem.Cells(3).Text & "
"
End Sub

I run their example and it works the IndexChange gets called when I click a link in the table. (I did not include all the detail where the fill the grid that works fine) so I decide to try the same thing and declare this:

<asp:datagrid id="DataGrid1" runat="server" width="959px" height="94px" caption="Lots Currently Running" allowsorting="True" allowpaging="True" allowcustompaging="True" onsortcommand="Sort_Grid" onselectedindexchanged="IndexChange_Command">
<columns> <asp:buttoncolumn text="Select" commandname="SelectCurrentLot" buttontype="PushButton">

And declare this:
Sub Select_CurrentLot(ByVal sender As Object, ByVal e As EventArgs)
' Display the details of the selected item.
DetailsLabel1.Text = "You Clicked " & DataGrid1.SelectedItem.Cells(1).Text
End Sub

My grid shows up, gets populated, but when I click the button nothing gets called... where oh where did I go wrong? I am new at this so there may be something else I am missing... BTW, the Sort_Grid works fine.

Thanks in advance

P.S. as a side question I am using VS .NET, I wss putting my code in XXX.aspx.VB, HTML and such in XXX.ASPX, the MS example has it all in one XXX.aspx with runat server directives) is there any particular reason for this?

kubben9-Apr-07 13:47

kubben

9-Apr-07 13:47

If you add a new button column to your datagrid, then set the commandname to something like select. Then in the itemcommand you can do whatever display stuff you need to do. Here is a link to microsoft help that shows how to add a button column.
http://msdn2.microsoft.com/en-us/library/aa984252(VS.71).aspx[^]

Hope that helps.
Ben

No-e10-Apr-07 2:40

No-e

10-Apr-07 2:40

Thanks for the help, but I think I am still missing something.

I create an event handler as follows:

  <br />
Private Sub DataGrid2_ItemCommand(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataGridCommandEventArgs) Handles DataGrid2.ItemCommand<br />
        ' Display the details of the selected item.<br />
        DetailsLabel1.Text = "TEST"<br />
End Sub

When the grid displays I have the buttons I woudl expect but when I click them this procedure does not run, it seems to run the page_load event Confused | :confused:

Am I missing something else?

kubben10-Apr-07 2:46

kubben

10-Apr-07 2:46

You might need to set itemCommand method in the datagrid in the html
OnItemCommand="DataGrid2_ItemCommand". At least that is how I usually connect up those type of events. YOu also need to make sure you have set the commandname property in the button in the datagrid.

Hope that helps.
Ben

CHECKBOX - GET VALUE USING RECORDSET FIELD

No-e10-Apr-07 5:54

No-e

10-Apr-07 5:54

Thanks, that fixes it. Appreciate your help

M

hifiger20049-Apr-07 6:45

hifiger2004

9-Apr-07 6:45

Hi Everyone,

I have a problem with my classic asp programming. I think I missed something. I encountered logical error an hour ago. And below is one of the lines in my source code wherein I encountered error.

As looking on the code below, I don't know if what was lacking, because it won't satisfy the condition, and it won't go to the next line "SaveRecord".

I am actually generating a checkboxes, dynamically and the checkboxes are based from the CategoryID. if the checkbox is checked then the value is not equal to "". The question is how am I be able to test the value if it will be checked or not?

btw, in relation to this topic, if you'll have another idea about this matter please let me know. thanks in advance.

if Request(CStr(rsCategory("CategoryID"))) <> "" then
SaveRecord
End If

hifiger2004

Server not remembering Session Variables

MaxRelaxman9-Apr-07 4:53

MaxRelaxman

9-Apr-07 4:53

I'm having trouble setting up a web site for my beta testers. On my local everything runs perfectly but the on the server, the web session doesn't seem to be remembered.

Here's the session state part of my web.config file
<sessionstate
="" mode="InProc" cookieless="false" timeout="20" stateconnectionstring="tcpip=127.0.0.1:42424" sqlconnectionstring="data source=127.0.0.1;userid=sa;password=">

I've tried using StateServer instead of InProc with the server running the session state process but still no luck. From what I understand, InProc should be fine if you're on a single server with only a couple fields stored in the session state anyway.

Thanks in advance!

Re: Server not remembering Session Variables

Paddy Boyd10-Apr-07 5:22

Paddy Boyd

10-Apr-07 5:22

Does your test system have underscores in the domain name? IE has problems maintaining session state if this is the case...

Re: Server not remembering Session Variables

MaxRelaxman11-Apr-07 3:20

MaxRelaxman

11-Apr-07 3:20

Nope, the domain and server names don't have any special characters. I'm thinking it might be because I haven't run aspnet_regsql.exe yet (discovered while googling). It doesn't seem like doing that would have anything to do with sessions but I'm running out of ideas.

Thanks for your answer though :v)

Re: Server not remembering Session Variables

Morantex11-Apr-07 8:44

Morantex

11-Apr-07 8:44

We do plan to include a SessionStateProvider class in our next beta, so I wanted to make you aware of this technology.

You are encouraged to download the current Persistore beta and experiment with it, it will be possible to persist session and other data in ASP.NET apps easily and efficiently.

The current beta includes a basic implementation of a MembershipProvider, which may be enough to whet your appetite. (Our own website uses it for user registration and login etc).

Questions, comments etc always welcome.

Hugh

Advanced .NET Persistence
http://www.morantex.com

Monitering an internet connection of a system remotely

kyreddy9-Apr-07 3:52

kyreddy

9-Apr-07 3:52

Hi,
I got a requirement to develope an application which takes care for monitering the internet connection of a customer and it directs the customer to resolve some basic issues related to connection failure by himself with appropriate guidance provided.Here i have a big question whether i go for developing a WebApplication or Desktop Application.

Here r some possible issues that may be rised on the client side
1.cable is not connected properly
2.modem issues
3.system performance is low

also guide me which services are available in .net to access wether is system is connected to the internet or not and some relevant info

i am working on VS2005 ,Xp professional OS

kyreddy

javascript search item

Socheat.Net9-Apr-07 0:44

Socheat.Net

9-Apr-07 0:44

Hi, can anyone help me I want to search item that display from database with javascript?
Thanks

................

Re: javascript search item

Bradml9-Apr-07 3:21