|
Hi,
You have mistakes ...
Nekkantidivya wrote: Set @Query='Select * from emplayee where empId=1"
You have ended up with double quotes.
Nekkantidivya wrote: Declare @Query varchar(max)
Replace 'max' with some number like 200 as your string cant go over this.
Correct it n then check.
modified on Saturday, April 18, 2009 7:24 AM
|
|
|
|
|
Create Procedure [dbo].[Test]
@EmpID Int
as
AS
BEGIN
SET NOCOUNT ON
Select * from emplayee where empId <= @EmpID
END
You better ask these question in the SQL part of this forum. They'll give you more proper answers.
In Word you can only store 2 bytes. That is why I use Writer.
|
|
|
|
|
i placed a print button in the aspx page and i clicked on print button then in print javascript i wrote window.print ..the print page is comming correctly but the page is comming with along the buttons that exits in the page ..how to get only text of the page for the print
|
|
|
|
|
Hi,
I have created on virtual direcory pointing to one test appliation.When i try to acess that application i am getting the following error. if anybody will give reply it would be helpful for me
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Web.Hosting.HostingEnvironmentException: Failed to access IIS metabase.
with regards,
Kiran
|
|
|
|
|
|
Hi,
I have repaired installed asp.net. now it is working thanks for givining solution.
with regards,
Kiran
|
|
|
|
|
Please forgive the expressin error in this message, I am not good at English 
I must get the instance reference of a running MS WORD progress in my asp.net webform, I tried
to use Marshal.GetActiveObject() like below，But it throws a exception like "....UNAVAILABE"
----------------------------------
Object wordApp = Marshal.GetActiveObject( "Word.Application" )；
----------------------------------
I have found by google a discuss thread below for a same question like me, but it seemed not give an answer at last.
http://www.developmentnow.com/g/16_2005_1_0_0_47728/Marshal-GetActiveObject-throws-an-exception-in-a-C-webservice-but.htm[^]
Any reply will be great appreciated!
modified on Saturday, April 18, 2009 6:14 AM
|
|
|
|
|
Michael Tang wrote: I must get the instance reference of a running MS WORD progress in my asp.net webform
Your question is not clear. Are you trying to get a process handle of MsWord? If yes, is this process running on server?
|
|
|
|
|
N a v a n e e t h,
Thank you very much for your help and sorry for my not clear question
The MsWord process is running on server and it has openned some doc file, and now I'am try to interact with the MsWord process in my ASP.NET application. So I tried to use GetActiveObject to get a objec reference to the MsWord process. But it just throwed a exception.
And the GetActiveObject（）can work well in a C# WINFORM application, while not in an ASP.NET application.
I think the discuss thread I mentioned above in my question may gave the possible reason of this quesion. Here is the abstract of the post:
---------------------------------------------
Hello,
Based on my research, GetActiveObject obtains a running instance of an
object from the running object table (ROT). Each WinStation has it's own
ROT. The interactive desktop is one WinStation and has it's own ROT and
that is where the desktop application will have registered the running
object. The ASP.NET process is running under a seperate account and exists
in a non-interactive WinStation with its own ROT. That is why it fails.
I think the only way for this to work would be to launch the third party
application process from ASP.NET so it exists in the same WinStation. Of
course the application will then not be visible and the user cannot
interact with it.
--------------------------------------------
Thanks a lot
|
|
|
|
|
sorry, I think I didn't express myself clear again at the end of my last post just now ----
I think the discuss thread I mentioned above in my question may gave the possible reason of this quesion, but it didn't give a way to solve the problem
|
|
|
|
|
Thanks for the explanation.
Michael Tang wrote: The ASP.NET process is running under a seperate account and exists
in a non-interactive WinStation with its own ROT. That is why it fails.
This could be the reason why it is failing. BTW, whatever you are trying looks odd to me. If you can tell us why you are doing this and what is the expected behavior, there may be better solutions.
|
|
|
|
|
Navaneeth,
Thank you so much for your help and sorry for my late reply now.
Actually, I'm not really need to let my ASP.NET app to interact with "MsWord", instead, it's an ole server we developed by VC++ by ourselves. Due to my poor English and to express the question here easily, I used "MsWord".
The ole server's duty is doing some special tasks on our server, let's call it "MY-OLE-SERVER" below. MY-OLE-SERVER is running as a sperate process. And we have an another C# WINSERVICE app to comunicate with it. This is not the problem, it's ok for the WINSERVICE app to use Marshal.GetActiveObject() to get reference with MY-OLE-SERVER. But at the same time, our ASP.NET app need to make some deal with MY-OLE-SERVER also and as you know, it's just not running ok.
So do you have any good suggestion for our problem?
Thank you again
|
|
|
|
|
Hi,
When the session is timed out if I click on any of the child menu nodes of the tree control in asp.net then it is not responding,corresponding page is not getting displayed and not redirecting to login page. Plz do reply if any of you have idea about this problem
with regards,
kiran
|
|
|
|
|
Kiran 2671048 wrote: Plz do reply if any of you have idea about this problem
You haven't provided enough information to answer. Explain your question in detail with relevant code snippets if you wish to get help.
|
|
|
|
|
Hi,
Thank you for your reply, here below I have given my problem
I have one treeview based menu control. In showtree(). I am am adding all parent menus to tree view control. In Tree_TreeNodePopulate(), i am calling childs(). In childs(), i am adding child nodes to the parent menus. everythig is working fine. but my problem is when the session is timed out, if i click on child nodes control, it is not redirecting to login page. I tried the following code also but it is not working.
if (Session["UserInfo"] != null)
{
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "window", "window.location.href='Logout.aspx'", true);
}
|
|
|
|
|
Well, the code you have provided works only when Session["UserInfo"] has value. When session timed out, how are you expecting it will have some value? 
Looks like you need to change the condition
if (Session["UserInfo"] == null)
{
Response.Redirect("Logout.aspx");
}Does that solve your problem? 
|
|
|
|
|
Hi,
I tried to use this code but i am getting the following error:
Response.Redirect cannot be called in a Page callback.
with regards,
Kiran
|
|
|
|
|
characteristics of foreign key
|
|
|
|
|
Forgot to type your question? As you are new to CP, I suggest to read the forum guidelines before you post. You can try this[^] as well to ask better questions.
|
|
|
|
|
how to clear all item from list box
|
|
|
|
|
|
Listboxid.items.clear()
Er. Jagwinder Singh
|
|
|
|
|
hi friends
i need to Pass the value code behind to xslt file
example:
String str="test"
i pass this value in Myxslt.XLST difilr
Known Is Drop.Unknown Is Ocean
|
|
|
|
|
Hello Everybody
I have put a Button name btnDelete into Template Field also I put AJAX Confirm button extender. What I want to do is when I click btnDelete then it will ask whether I want to delete that row or not.
How Can I do it?
If you have any example then it will be really greatful
Thanks in Advance
Sarfaraj
Sarfarj Ahmed
|
|
|
|
|
No worries!
Just done it.
Thanks
Sarfarj Ahmed
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
