|
hi Vasudevan
Then what to do ? i want the name ranges of the excel sheet please help me this
|
|
|
|
|
how to add TreeView.dll in microsoft visual studio .net 2003
prasanna
|
|
|
|
|
|
|
Hi,
I've two webforms. When a condition is satisfied, I need to pop up a webform as a modal dialog box where the user can enter some text.After submitting this child form, the user had to be redirected to some other webform. Inorder to catch the text,I've used a session variable.
What I've worked is......
In html page, I've written
function giveReason(w,h)
{
wleft = (screen.width-w) / 2;
wtop = (screen.height-h) / 2;
imgwindow1=window.open("HiReason.aspx","imgwindow1","width="+w+",height="+h+",left="+wleft+",top="+wtop+"status:Yes;");
imgwindow1.focus();
}
And I've called the above script function in codebehind page as...
jstr = " giveReason(500,170);"
Page.RegisterClientScriptBlock("reasonKey", jstr)
After that...
In child form,
Dim strjscript As String = ""
strjscript = ""
strjscript &= "window.opener.Home.Text1.focus();"
strjscript &= "window.close();"
strjscript = strjscript & "</script" & ">"
RegisterClientScriptBlock("close", strjscript)
Home is some other webbform's id.
While running this,I'm getting the error.... "imgwindow1 is null or not an object. poop up window is blocked"
Any suggestions?? Thanks in advance....
-Priya
|
|
|
|
|
Instead use this
var winSettings = "dialogWidth:350px;dialogHeight:300px; help: no; status: no";
var qs = "../Calender/Calender.aspx";
var values = window.showModalDialog(qs,'cal',winSettings);
Where values will have all the return values from child form.
In Child Form:
var MyArgs = new Array();
MyArgs[0] = value1;
MyArgs[1] = value2;
window.returnValue = MyArgs;
window.close();
I hope this will help u.If not let me know.
|
|
|
|
|
|
I have a process to be run at the end of year in a leave management system. The process is started when the start process button is pressed, I need to show the employee number currently been processed in a label or a text box. What i did was i gave (Ex : text1.text = tabel(0).row(0).item(0)) when the record is bean read in the for loop. but it shoes only the last record in the process because the processing bar in the page was activated while the process is on. Is there another way to show the record that is being processed in the text box.
Thanx 
AMIF
|
|
|
|
|
Hi All,
I am creating dynamic stored procedure,means quuery condition is depending runtime supplied parameter values.
stored procedure is given below.
ALTER PROCEDURE GetSearchCriteria
@KeySkills nvarchar(50),
AS
Declare @Select nvarchar(2000)
declare @Where nvarchar(2000)
set @Where = ''
set @Select ='Select KeySkills from Jobseeker'
/*set @Select ='Select * from jobseeker'*/
if(@KeySkills is not NULL )
begin
set @Where = ' KeySkills = ' + @KeySkills end
set @Select = @Select + @Where
EXEC (@Select)
It gives error at statement in bold
Incorrect syntax near '='.
Regards,
|
|
|
|
|
KeySkills expects nvarchar, so the code should be
set @Where = ' KeySkills = ''' + @KeySkills + ''''
The '' above are two single quotes.
However, after saying that, you should use sp_executesql instead which to execute your dynamic sql, which accepts the following parameter:
EXEC sp_executesql @sqlString, @paramlist, [@param1], [@param2], ...
@sqlString example is 'SELECT * FROM tblA WHERE KeySkills = @KeySkills'
@paramlist is a list of parameters your sqlString requires, e.g.
SET @paramlist = '@KeySkills nvarchar(50), @Param2 nvarchar(50)'
@param1 to @paramN are your parameter values, it has to correspond to the exact ordering in @paramlist (e.g. @KeySkills have to be passed as first parameter).
Hope that helps.
"Democracy is two wolves and a sheep voting on what to have for dinner" - Ross
Edbert
Sydney, Australia
|
|
|
|
|
Hi Edbert,
As you suggest I made changes But Error is still coming on same line.
If possible please run this query at your end and correct it accordingly.
ALTER PROCEDURE GetSearchCriteria
@KeySkills nvarchar(50)
AS
Declare @Select nvarchar(2000)
declare @Where nvarchar(2000)
set @Where = ''
set @Select ='Select KeySkills from Jobseeker'
if(@KeySkills is not NULL )
begin
/* set @Where = ' KeySkills = ' + @KeySkills */
set @Where = ' KeySkills = ''' + @KeySkills + ''''
end
set @Select = @Select + @Where
EXEC sp_executesql @Select
RETURN
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
|
|
|
|
|
Oh! If you're going to use the sp_executesql you do not need the single quote between the @KeySkills.
And you're missing the WHERE clause after your SELECT statement.
Try this instead:
set @Where = ''
set @Select ='SELECT KeySkills FROM Jobseeker WHERE 1 = 1 '
if(@KeySkills is not NULL )
begin
<code>set @Where = ' AND KeySkills = @KeySkills '</code>
set @Select = @Select + @Where
SET @paramlist = '@KeySkills nvarchar(50)'
<code>EXEC sp_executesql @Select, @paramlist, @Keyskills</code>
Hope that one works.
"Democracy is two wolves and a sheep voting on what to have for dinner" - Ross
Edbert
Sydney, Australia
|
|
|
|
|
Hi,
Thanks A lot.
I hope we will meet again with new discussion.
Regards,
Nagraj
Let's Teach Life To Laugh........
|
|
|
|
|
|
Urgent
Hi all,
I have a textbox and a button with it. I want on clicking the button , a popup window should open. And after selecting record from popup window it should fill the value in the textbox of previous page.
Suggestions and links are welcome.
Regaruds,
Varun Arora,
Software Engineer,
Knowledge Calls,
Gurgaon, India
-- modified at 1:40 Thursday 22nd June, 2006
|
|
|
|
|
Can u please tell me u want popup on Button click or textbox click???
|
|
|
|
|
Button Click
Varun Arora,
Software Engineer,
Knowledge Calls,
Gurgaon, India
|
|
|
|
|
You can do like this.
this will be there in codebehind page.
Button1.Attributes.Add( "onclick", "popWin()" );
and this in the html part.
<script><br />
function popWin(){<br />
window.open('http://msdn.microsoft.com', '', '');");<br />
}<br />
</script>
Best Regards,
Apurva Kaushal
|
|
|
|
|
I have a created a user control which on compilation gives no error. BNut when I try to use this control on my web page gives me an error which sayd "Error creating user control" When I try to get the details of the error it says "Parse Error: Type "'System.Web.UI.UserControl' does not have a property named 'Title'". But I do have a property named Title in my user control. So what is the error. Can anyone help me out.
|
|
|
|
|
UserControl class already has a property named Title.
Make sure you don't override it with a new property in your custom user control that is private or protected, as it is probably called in the designer code.
Hope that helps.
"Democracy is two wolves and a sheep voting on what to have for dinner" - Ross
Edbert
Sydney, Australia
|
|
|
|
|
Well 'Title' was just an example. It is giving me an error for all of my properties like 'TitleBarLeft' and 'TitleBarRight' etc.
|
|
|
|
|
Hi ,
I have created a logic in stored procedure and in it i look if a variable satisfies certain condition ,if it doesn't i want to raiseerror with appropriate message.Pls tell me how to know if the error has occurred and capture the msg in the frontend.Pls let me know also the right syntax for
writing msgs in RAISERROR .
thnks in advance
|
|
|
|
|
Hi Sishya,
I am explaining RAISERROR syntax by simple example.Modify it as your need.
ALTER procedure sp_AddUsers
@UserID varchar(20)
as
if @UserID=''
Begin
Raiserror('Missing User ID.',16,1)
return(0)
End
Begin Transaction
insert into Users (UserID)
values(@UserID)
Commit Transaction
Regards,
Nagraj
Let's Teach Life To Laugh........
|
|
|
|
|
hi ,
pls tell how to capture this Message in raise error from frontend interface and what about the 16,1 in Raiserror('Missing User ID.',16,1)
|
|
|
|
|
Hi sishya,
16,1 are savirity,status parameters for RAISERROR procedure.Don't think much about then you can get details on net regrading this.
As your core problem To access this RAISEERROR return value....here is code.
private void someMethod()
{
try
{
// Do a RAISERROR inside of a SQL block like
// RAISERROR('You did something wrong with the value "%s"', 16, 1, @param1)
}
catch (SqlException sqle)
{
lblMessage.Text = sqle.Message;
}
catch (Exception err)
{
// Do something else with the exception
}
}
I hope this will help you.
Regards,
Nagraj
Let's Teach Life To Laugh........
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
