ASP.NET

14-Feb-07 4:24

Thank you. I completely overlooked that.

Quecumber256

Quecumber25614-Feb-07 5:00

14-Feb-07 5:00

I put in the ExecuteNonQuery command and now I'm getting this:
String[3]: the Size property has an invalid size of 0.

What's causing this?

Thanks,

Quecumber256

Colin Angus Mackay14-Feb-07 5:13

Colin Angus Mackay

14-Feb-07 5:13

I'm guessing you haven't told the parameters the expected size of the result, and it has defaulted to zero. In your stored proc you declare the various parameters with a size (e.g. @myParam VARCHAR(25)) add that information to the parameter definition.

Or better yet, ditch this and use ExecuteDataReader and get the data out that way (i.e. remove all but the input parameters). Using output parameters is okay for one or two values, but this is a wee bit much.

Upcoming events:
* Glasgow Geek Dinner (5th March)
* Glasgow: Tell us what you want to see in 2007

My: Website | Blog | Photos

Quecumber25614-Feb-07 6:06

14-Feb-07 6:06

Could you use the code snippet I sent and give me an example of this method? I'm still wet behind the ears where VB.NET and ASP.NET are concerned.

Thanks,

Quecumber256

Bassam Saoud14-Feb-07 5:17

Bassam Saoud

14-Feb-07 5:17

probably because you didnt supply a size, for example:

cd.Parameters.Add("@varLName", Data.SqlDbType.NVarChar,50)<code><br />
where 50 should match the size of your column in DB

Quecumber25614-Feb-07 6:06

Add new cell in htmltable control

14-Feb-07 6:06

Thank you, I'll put it in and see how it goes.

Quecumber256

Mohammed Elkholy14-Feb-07 3:41

Mohammed Elkholy

14-Feb-07 3:41

i have a web page that displays data from dataset in HtmlTable

i add linkbutton in specific cell

i want whaen i click this linkbutton add new table cell in the specific cell

i hope my question clear

thanks for help

MD_NADA

badgrs14-Feb-07 3:47

14-Feb-07 3:47

You want to add a new cell within the one containing the link button? A nested cell? HTML tables don't work like that....

tarasp14-Feb-07 4:17

tarasp

14-Feb-07 4:17

If you create the table like this:

<asp:Table ID="MyTable" runat="server"></asp:Table>

then you can add rows and/or cells like this:

TableRow tr = new TableRow();
TableCell td = new TableCell();

tr.Controls.Add(td);
MyTable.Controls.Add(tr);

Tara

Mohammed Elkholy14-Feb-07 4:22

Mohammed Elkholy

14-Feb-07 4:22

this is right thank you

but if i did this code the row will be the last row

i want to add the new row after the current row

if i am clicking in rowindex 2 the new row will be rowindex 3

thanks

MD_NADA

badgrs14-Feb-07 4:47

how to change the webservice

14-Feb-07 4:47

Use Table.Rows.AddAt(index, row)

srinandan..14-Feb-07 3:27

srinandan..

14-Feb-07 3:27

Hi all

i am using a web service in my asp.net 2.0 project
wstest.WebservicePvr.com/ABCClass.asmx

there are folder created like

App_WebReferences 
  -wstest
	-WebservicePvr
		-com 
		  -ABCClass.disco
		  -ABCClass.discomap
		  -ABCClass.wsdl

then i have created the object like follow in all the code behind file.

using wstest.WebservicePvr.com;
ABCClass _objABCClass=new ABCClass();

using this code accessing the all the web method and i have done my project and it working properly.
Now the problem i have to change the live webservice
Is it possible to handle this problem from the web.config.
Please help.
Many many thanks in advance

Regards,
Srinandan

Re: how to change the webservice

Jesse Squire14-Feb-07 3:54

Jesse Squire

14-Feb-07 3:54

The url of the webservice can be specified in your .config file rather then hardcoded in the proxy. To do so, right-click the web reference and set its connection property to dynamic. Also, the proxy has a url property that you can set. For programatic manipulation, see examples here[^] and here.[^]

Hope that helps. Smile | :)

--Jesse

Update Progress Is A Bitch And I want to slay it

Sam Heller14-Feb-07 3:20

Sam Heller

14-Feb-07 3:20

Good day my fellow people.

How are you.

I was wondering along my route through Atlas and such. If you have a single UpdateProgress in your master page then it will show the progress panel on any inner pages asych call. Is this correct and also can this be prevented at certain times for certain UpdatePanels?

Thanks for reading and keep it real. Ciao

Display a single quote in a GridView's ToolTip

-Dr_X-14-Feb-07 3:11

14-Feb-07 3:11

The following code works:

<<asp:TemplateField ItemStyle-Width="1px">
  <<ItemTemplate>
    <<asp:ImageButton ID="imbView" runat="server" ImageUrl="~/Images/ViewSearch.gif"
      CommandName="View" CommandArgument='<%# Eval("UID") %>' 
      ToolTip='<%# "View employee information for " & Eval("FullName") & "." %>' />
  <</ItemTemplate>
<</asp:TemplateField>

As I said, all works well here. However, I would prefer to have the following display for the ToolTip instead:

ToolTip='<%# "View " & Eval("FullName") & "' employee information." %>'

However it does not like the single quote ('). I have tried placing 2 and 3 single quotes in a row and it still fails.
Any ideas?

Thanks,
Michael

I firmly believe that any man's finest hour, the greatest fulfillment of all that he holds dear, is that moment when he has worked his heart out in a good cause and lies exhausted on the field of battle - victorious.
Vince Lombardi (1913-1970)

andyharman14-Feb-07 3:25

andyharman

14-Feb-07 3:25

Try replacing with '

-Dr_X-14-Feb-07 3:31

14-Feb-07 3:31

Thanks for the reply however it literally show up the "'". I even tried the following:

ToolTip='<%# System.Web.HttpUtility.HtmlDecode("View " & Eval("FullName") & "' employee information.") %>'

It failed as well.

Any other ideas?
Michael

badgrs14-Feb-07 3:43

14-Feb-07 3:43

Escape it with a backslash?

-Dr_X-14-Feb-07 3:47

14-Feb-07 3:47

Thanks but I have already tried that as well. I get the usual 'server tag not well formed' error and the page does not render.

Michael

DavidNohejl14-Feb-07 4:23

DavidNohejl

14-Feb-07 4:23

Try ToolTip='<%# MyCodebehindFormatingMethod(Eval("FullName")) %>'

"Throughout human history, we have been dependent on machines to survive. Fate, it seems, is not without a sense of irony. " - Morpheus

-Dr_X-14-Feb-07 4:35

14-Feb-07 4:35

I'd rather not use a code-behind function.
Here's the work-around I came up with:

ToolTip='<%# "View " & Eval("FullName") & chr(39) & "s employee information." %>'

It doesn't seem to mind the chr(39) with in the html.
If anyone comes up with a better one, feel free to post...

Michael

badgrs14-Feb-07 4:45

14-Feb-07 4:45

Have you tried string.Format()? I think the Eval function can also be used in the way directly.

-Dr_X-14-Feb-07 5:00

14-Feb-07 5:00

It liked this:

ToolTip='<%# String.Format("View " & Eval("FullName") & "{0}s employee information.", chr(39)) %>'

but not this

ToolTip='<%# String.Format("View " & Eval("FullName") & "{0}s employee information.", "'") %>'

For some reason it really jsut does not like the single quote.

Michael

andyharman14-Feb-07 6:25

andyharman

14-Feb-07 6:25

Cracked it! Use '. I test it using:

<html>
<body>
<span title='Andy&#39;s tooltip'>hello world</span>
</body>
</html>

Regards
Andy

-Dr_X-14-Feb-07 6:49