ouput parameter and resultset from single stored procedure ? - ASP.NET Discussion Boards

ADY00715-Mar-07 5:39

15-Mar-07 5:39

Hi all, can someone tell me what is the code for adding text to the clipboard pls.

This code is working for me from the Internet Explorer but not for the firefox.

function ClipBoarda(b)<br />
			    {<br />
						Copied = document.getElementById('txtTextCode_'+b).createTextRange();<br />
						document.getElementById('txtTextCode_'+b).focus();<br />
						document.getElementById('txtTextCode_'+b).select();<br />
						Copied.execCommand("Copy");<br />
				}

Thanks alot for any feedback.

Adrian De Battista - Web Designer, Web Programmer, Software Programmer From Malta. My Website .. www.MaltaTrade.org

Urgent

Sarfaraj Ahmed15-Mar-07 4:13

Sarfaraj Ahmed

15-Mar-07 4:13

I have got 2 table, CustomerTable and OrderTable

CustomerTable:
CustomerID CustomerName
101 James
102 Andy
103 Bryan

OrderTable:
OrderID ProductID CustomerID
1001 10001 101
1002 10002 101
1003 10003 101
1004 10004 102
1005 10005 102
1006 10006 103

I want the output as below
CustomerID CustomerName OrderID ProductID
101 James 1001,1002,1003 10001,10002,10003
102 Andy 1004,1004 10004,10005
103 Bryan 1006 10006

Sarfarj Ahmed

Re: Urgent

Marcus J. Smith15-Mar-07 4:25

Marcus J. Smith

15-Mar-07 4:25

Dont cross post. Ill answer this in the SQL forum.

_Cle^aKO

"I think you'll be okay here, they have a thin candy shell. 'Surprised you didn't know that." - Tommy Boy
"Fill it up again! Fill it up again! Once it hits your lips, it's so good!" - Frank the Tank (Old School)

Re: Urgent

Sarfaraj Ahmed15-Mar-07 4:33

Sarfaraj Ahmed

15-Mar-07 4:33

Thank You very much
Im waiting for your answer

Sarfarj Ahmed

Re: Urgent

enjoycrack15-Mar-07 6:27

enjoycrack

15-Mar-07 6:27

even though it's not for asp.net forum...but i am try to answer you...

select CustomerID CustomerName OrderID ProductID
from CustomerTable inner join OrderTable on CustomerID

....run and debug it Wink | ;)

<< >>

8x Solutions Ltd

InnerException propery what? Help with exception!

Lordveralix15-Mar-07 4:04

Lordveralix

15-Mar-07 4:04

I'm trying to add 2 parameters to a localreport in vs2005 using c#

This is my code.

List < ReportParameter > paramList = new List < ReportParameter > ();

paramList.Add(new ReportParameter("startdate", sd.ToString("MMM dd yyyy")));
paramList.Add(new ReportParameter("enddate", sd.ToString("MMM dd yyyy")));

this.reportViewer1,LocalReport.SetParameters(paramList);

the report requires the two parameters 'startdate' and 'enddate' but for some reason I'm getting a 'LocalProcessingException was undhandled (an error occured during local report processing'

Am I going about setting the parameters incorrectly?

Re: InnerException propery what? Help with exception!

Lordveralix15-Mar-07 4:17

Lordveralix

15-Mar-07 4:17

Well I figured out the issue, the parameter 'startdate' on the report was actually 'Startdate'. Which would make sense as to why i was getting an exception.

But another problem has arisen.

in the above code I am ... just figured that out too. Nevermind! Woo!

ouput parameter and resultset from single stored procedure ?

rama charan15-Mar-07 3:42

rama charan

15-Mar-07 3:42

hi..
can we use ouput parameter and resultset from stored procedure at same time in datagrid in asp.net 1.1.if possible pls say some sample code for it.

thanks in advance.

Rama Charan Prasad

"Be happy and Keep smiling.Thats what u want be always.. Smile | :)

Re: ouput parameter and resultset from single stored procedure ?

Sylvester george15-Mar-07 3:58

Sylvester george

15-Mar-07 3:58

yes you can
ouput parameter comes as a parameter
and resultset comes as a dataset

Regards,
Sylvester G
sylvester_g_m@yahoo.com

thanks

rama charan15-Mar-07 4:00

rama charan

15-Mar-07 4:00

thnks for the reply...

Rama Charan Prasad

"Be happy and Keep smiling.Thats what u want be always.. Smile | :)

Referencing asp:Label from a javascript function

snir_ya15-Mar-07 3:22

snir_ya

15-Mar-07 3:22

Hi,

I'm trying to reference a server control asp:label from a javascript function during a client side validation procedure. What is the right way to reference an already-rendered server control?

Thanks.

Here's my javascript code:

<code><script type="text/javascript" language="javascript">

</script></code>

Re: Referencing asp:Label from a javascript function

Sandeep Akhare15-Mar-07 3:29

Sandeep Akhare

15-Mar-07 3:29

document.getElementById("ControlID");

or
document.getElementByName("ControlID");

try this one this will give control which can be store in var

Thanks and Regards
Sandeep

If you want something you never had,
do something you have never done!

Re: Referencing asp:Label from a javascript function

snir_ya15-Mar-07 4:02

snir_ya

15-Mar-07 4:02

Thank you Sandepp for your reply.

But it doesn't work.
I can't get the label. I'm sure i'm using its correct id and name. I checked the rendered html.

Here's the code
putting the label:

<b><asp:Label ID="lblError" runat="server" Text="wowowow"></asp:Label></b>
calling it from a javascript function:

<b>var labelErr = document.getElementByName("lblError");
if(labelErr)
{
window.alret("wow");
labelErr.value = "New Value mother f***er!";
}
else
{
window.alert("now");
}</b>

Re: Referencing asp:Label from a javascript function

Sandeep Akhare15-Mar-07 4:07

Sandeep Akhare

15-Mar-07 4:07

What problem are you getting (post the error) ?
And What you want to do with labelErr ?

Thanks and Regards
Sandeep

If you want something you never had,
do something you have never done!

Re: Referencing asp:Label from a javascript function

snir_ya15-Mar-07 4:15

snir_ya

15-Mar-07 4:15

window.alert("Hi 1");
var labelErr = document.getElementByName("lblError");
window.alert("Hi 2");
labelErr.value = "There is an error";

I want to put new text in the label.
There's no error, only nothing happens with the label.
I will get the first message box with "Hi 1" but i will not get the second. Meaning, there's a problem with the second line of code.

Re: Referencing asp:Label from a javascript function

Sandeep Akhare15-Mar-07 4:20

Sandeep Akhare

15-Mar-07 4:20

snir_ya wrote:
var labelErr = document.getElementByName("lblError");

it should be document.getElementById("lblError"); instead of name as you have not given name try with that

Thanks and Regards
Sandeep

If you want something you never had,
do something you have never done!

Re: Referencing asp:Label from a javascript function

snir_ya15-Mar-07 4:25

snir_ya

15-Mar-07 4:25

Yessssss! it worked. Thanks SunDeep.

Now, when i try to set text to this label it doesn't have any effect:

var labelErr = document.getElementById("lblError");
labelErr.text = "Hopps";

or

var labelErr = document.getElementById("lblError");
labelErr.value = "Hopps";

Do you know why?

Re: Referencing asp:Label from a javascript function

Sandeep Akhare15-Mar-07 4:42

Sandeep Akhare

15-Mar-07 4:42

lable Don't have the value its innertext
labelErr.innerText="Some text";

Thanks and Regards
Sandeep

If you want something you never had,
do something you have never done!

Re: Referencing asp:Label from a javascript function

snir_ya15-Mar-07 4:45

snir_ya

15-Mar-07 4:45

Thanks a lot Sandeep. After three days it finally works.
How did you know to use innerText? Do you know of a good html reference (web site or tutorial) that summerizes html elements attributes?

Snir.

Re: Referencing asp:Label from a javascript function

Sandeep Akhare15-Mar-07 4:49

Sandeep Akhare

15-Mar-07 4:49

My pleasure Smile | :)

Don't know but you can google it ? There are lots of resources on the web you will definetly get it Roll eyes | :rolleyes:

Thanks and Regards
Sandeep

If you want something you never had,
do something you have never done!

Re: Referencing asp:Label from a javascript function

Guffa15-Mar-07 3:32

Guffa

15-Mar-07 3:32

You can't access a server control from Javascript, as the server control only exists on the server while the page is created.

Examine the source of the web page to find out how the control is rendered into html elements, which you can access from Javascript.

---
single minded; short sighted; long gone;

Re: Referencing asp:Label from a javascript function

snir_ya15-Mar-07 4:17

snir_ya

15-Mar-07 4:17

Of course i did Guffa.

This code will not pop up the second alert only the first one. I'm sure the label's html name is "lblError".

window.alert("Hi 1");
var labelErr = document.getElementByName("lblError");
window.alert("Hi 2");

Re: Referencing asp:Label from a javascript function

Sandeep Akhare15-Mar-07 4:22

Sandeep Akhare

15-Mar-07 4:22

snir_ya wrote:
Of course i did Guffa.

Yes but Guffa is right as you are not getting the asp control but its html source as the server control are not active in client side they rendered at server side

Thanks and Regards
Sandeep

If you want something you never had,
do something you have never done!

Re: Referencing asp:Label from a javascript function

Guffa15-Mar-07 12:02

Guffa

15-Mar-07 12:02

That's because the document object doesn't have any method named getElementByName. More than one element can have the same name, so the method is named getElementsByName and returns a collection of elements.

If you want to access a single element, use the getElementById method.

---
single minded; short sighted; long gone;

Re: Referencing asp:Label from a javascript function [modified]

Sylvester george15-Mar-07 4:33

Sylvester george

15-Mar-07 4:33

this is the way to do

var f=document.getElementById("Label1")<br />
    alert(f.innerText)<br />
    f.innerText = 'sdfsdf'

-- modified at 10:39 Thursday 15th March, 2007

Regards,
Sylvester G
sylvester_g_m@yahoo.com

Last Visit: 31-Dec-99 18:00 Last Update: 14-May-24 14:55

Refresh

ᐊ Prev 1...5201 5202 5203 520452055206 5207 5208 5209 5210 Next ᐅ

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.