|
I have a stored procedure that retruns XML
CREATE Stored Procedure <proc_name>
@Param1 INT, @Param2 INT,
AS
BEGIN
SELECT * FROM TABLENAME FOR XML PATH('XMLPATH');
END
GO
I am trying to assign this result to a variable.
i.e
DECLARE @XMLVARIABLE NVARCHAR(MAX)
SET @XMLVARIABLE = EXEC <proc_name> @Param1_Value, @Param2_Value;
But unable to achieve this, Can anyone help out here?
|
|
|
|
|
Change your code as below
CREATE Procedure Proc1
(
@Param1 INT,
@Param2 INT
@Param3 NVARCHAR(1000) OUT
)
AS
BEGIN
SELECT @Param3 = (SELECT * FROM TABLENAME FOR XML PATH('XMLPATH'))
SELECT @Param3
END
DECLARE @XMLVARIABLE NVARCHAR(1000)
EXEC Proc1
@Param1 = 101,
@Param2 = 102,
@Param3 = @XMLVARIABLE OUTPUT
|
|
|
|
|
Hello Ramesh,
The solution you have given is correct, but I cannot touch the stored procedure, its already been used in lots of places. So I just have to assign the XML value returned from that stored proc.
|
|
|
|
|
im using asp.net 1.1 and in one of my aspx page i m using ajax.
now during ajax call i m showing a div which contain a rotating picture.
my problem is when i click on button window frazzed. picture is displayed for short time but not rotating.
cud anyone till me how to show waiting picture during ajax call in asp.net 1.1
One person's data is another person's program.
--J.Walia
|
|
|
|
|
Hi, can you post your code.
Hope this one can help.
Thanks
Hi, Please select Good Question if my answer are fit to your Question.
|
|
|
|
|
Hi friend,
Use callback function to show something to the user till you get a response from server. You can get server status from AJAX using that control your callback function. Refer this.[^]
Hope I have helped you to some extend.
|
|
|
|
|
because i m new in ajax so i dont know about callback function
cud u please paste the code
One person's data is another person's program.
--J.Walia
|
|
|
|
|
Do you think I understood your question ? If 'Yes' follow this[^]
|
|
|
|
|
yes i solved my problem
now i open the div onreadystatechange
Thanks for ur help
One person's data is another person's program.
--J.Walia
|
|
|
|
|
You can try the Modal Update Progress in codeproject:
http://www.codeproject.com/KB/ajax/ModalUpdateProgress.aspx
Either you love IT or leave IT...
|
|
|
|
|
Hi I'm using modal popup extender control & update panel in my application. some pages in this application have more than one update panels. now i want to disabled all the buttons in a particular page during a add/delete/update operation with displaying progress bar so that no one click on any button on the page during operation. how can i achieve this?
|
|
|
|
|
Hi, you can use asp:panel with update image like ajax.gif set your panel.visible=false
in your button add event
btnadd_click
(
panel.visible = true
Insert.....
delete....
update....
panel.visible=false
)
Hope this one can help.
Thanks
Hi, Please select Good Question if my answer are fit to your Question.
|
|
|
|
|
sayrecollado wrote: Hi, Please select Good Question if my answer are fit to your Question.
Dmm.. There is no Good Question Option only Good Answer is there
cheers,
Abhijit
CodeProject MVP
|
|
|
|
|
Hi There,
I Want To Know How To Write Query With Case In Linq To Sql.
Thanks,
|
|
|
|
|
Hi, you can create a case in stored procedure. then use that stored as method to your DATAContextClass
Hope this one can help.
Thanks
Hi, Please select Good Question if my answer are fit to your Question.
|
|
|
|
|
|
Hi, create a stored procedure with your sql statement with CASE statement.
then after you saved the S.P. (stored procedure) drag it to your DATAContextClass.dhml
then you will see right side of the pane the name of your SP
then in your code behind call that SP
datacontextclass dc = new datacontextclass();
var q =
from a in convert.tostring(dc.nameofyourSP)
where a.columnfield == textbox1.text
grid1.datasource = q;
grid1.databind();
Hope this one can help.
Thanks
Hi, Please select Good Question if my answer are fit to your Question.
|
|
|
|
|
|
Hi, Thanks hope youve understand.
Hope this one can help.
Thanks
Hi, Please select Good Question if my answer are fit to your Question.
|
|
|
|
|
|
Hi all,
How i integrate the webcam in my web application iam working on attandance system for employees where i have to capture their phots during sign In and store inside database .
What are possible ways to integrate webcam any article or suggestion ?
Best Regards
Rameez
|
|
|
|
|
Hi,
Very good and interesting question. You have to use the ActiveX object of the WebCam driver. Please follow the link:
http://weblogs.asp.net/nleghari/articles/webcam.aspx
Either you love IT or leave IT...
|
|
|
|
|
Hi
I've added the global.aspx to website with code
void Application_Start(object sender, EventArgs e)
{
// Code that runs on application startup
Application["userCount"] = 0;
}
and
void Session_Start(object sender, EventArgs e)
{
// Code that runs when a new session is started
Application.Lock();
Application["userCount"] = (int)Application["userCount"] + 1;
Application.UnLock();
Label2.Text = Application["userCount"].ToString();
}
then to the page Default.aspx the label
</form>
<div>
<asp:Label ID="Label2" runat="server" Text=""></asp:Label>
</div>
</body>
and then getting errror
The name 'Label2' does not exist in the current context c:\WebSite1\Global.asax
I'm not sure what is wrong here. Please help?
|
|
|
|
|
It seems you need to get your hands on a basic ASP.NET book and read it. The error means what it says.
Christian Graus
Driven to the arms of OSX by Vista.
"I am new to programming world. I have been learning c# for about past four weeks. I am quite acquainted with the fundamentals of c#. Now I have to work on a project which converts given flat files to XML using the XML serialization method" - SK64 ( but the forums have stuff like this posted every day )
|
|
|
|
|
I don't think to be possible make reference to user control inside global.asax, use a webForm with a label to display the Application["userCount"] value.
|
|
|
|