|
You don't seem to ever execute the stored procedure after setting up all of the parameters. As you, for some reason, are returning all of your data through OUT parameters, you should add the call cd.ExecuteNonQuery() after you finish adding your parameters. Also, don't forget to call the Dispose method on both the command and connection to free up the unmanaged resources.
Hope that helps.
--Jesse
|
|
|
|
|
Thank you. I completely overlooked that.
Quecumber256
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
Thank you, I'll put it in and see how it goes.
Quecumber256
|
|
|
|
|
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
|
|
|
|
|
You want to add a new cell within the one containing the link button? A nested cell? HTML tables don't work like that....
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
Use Table.Rows.AddAt(index, row)
|
|
|
|
|
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
|
|
|
|
|
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.
--Jesse
|
|
|
|
|
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
|
|
|
|
|
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)
|
|
|
|
|
Try replacing with '
|
|
|
|
|
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
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)
|
|
|
|
|
Escape it with a backslash?
|
|
|
|
|
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
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)
|
|
|
|
|
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
|
|
|
|
|
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
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)
|
|
|
|
|
Have you tried string.Format()? I think the Eval function can also be used in the way directly.
|
|
|
|
|
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
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)
|
|
|
|
|
Cracked it! Use ' . I test it using:
<html>
<body>
<span title='Andy's tooltip'>hello world</span>
</body>
</html> Regards
Andy
|
|
|
|