Web Development

Re: Input string not in a correct format

10-Apr-07 5:43

I have a simple data base I am reading values from to fill a datagrid. I found an example where if I try to get a value from a field in my table I get an error, seems like I need to use IsdbNull as follows:

If IsDBNull(dr(7)) Then
MyDataRow(7) = "N/A"
Else
MyDataRow(7) = dr.GetString(7) ' <--- get ex here if I have valid data
End If

If the field has valid data I get an exception "input string not in a correct format" How do I handle this? If I doa quick watch my field ontains valid data that is a string.

Thanks

Mark Greenwood10-Apr-07 18:02

Mark Greenwood

10-Apr-07 18:02

I would be tempted to use the following line

dr.GetDataTypeName(7);

And make sure it really is a string - the problem with using the watch window is that underneath it is essentially doing an object.ToString() for you which might make it appear that it's really a string when in fact it's an int, or a uniqueidentifier etc....

Worth a try anyway..

Mark.

How to trap error in case of asynchronous web calls

Amol Ravatale10-Apr-07 2:56

Amol Ravatale

10-Apr-07 2:56

I am consuming a web service in VB.NET desktop application.

I am using proxy class created from WSDL file using WSDL.exe utility.

The call is asynchronous.

Problem is if I provide wrong URL to call the web service, I do not receive
any error.

But if I am calling web service synchronously, it is giving error like "The Request failed with HTTP status 404: Not Found"

I do not receive any error in case of asynchronous call, although the URL is wrong.

Can anyone help?

Regards,
Amol

Every thing will come to you if you have faith.

URGENT!! How to embed excel in Webpage? [modified]

neo_60539-Apr-07 21:58

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

Bradml

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

Bradml

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

Bradml

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.

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

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

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

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

No-e10-Apr-07 5:54