how to execute a sub procedure when returning a value from a popup window?
Ex.
in my parent form, this is the sub procedure i made SearchRecord(), after selecting a record from a child form (popup window), the SearchRecord() from parent form will execute..
I have a parent window parent.aspx and a popup window
popup.aspx. parent.aspx
has a confirm button which on click open popup.aspx. This popup.aspx holds a filled application form like leave application form of employees and a email sending button. That button on click send emails to the specified email addresses with attachment. The popup.aspx has a javascript function sendResponse() which call another javascript function display() of parent.aspx after sending the email. The display() function display a message by Label control regarding the email sending i.e., whether or not this email sending operation is successful. The sendResponse() function after calling display() close the popup.aspx window. I have successfully did all the aforesaid jobs.
Now the scenario is that I have a database which is holding various leave information like casual leave, medical leave etc of employees. After sending email successfully I have to update this database.It will be better to tell in this context that the email sending portion of my cs script is :
[Code]....
this info string is passed to the sendResponse() javascript function as :
[Code]....
And the sendResponse() function is :
[Code]....
Now the problem is, in which portion or when I do update the database. Should I update the database in try-catch block of email sending or from sendResponse() function?I have tried to call C# function UpdateDatabase() from sendRespose() as shown here. But this static method is creating too many problems like the popup.aspx is not closing automatically, if I try to call another C# non-static method from the static UpdateDatabase() method to close the window I have to call it by creating a new instance of that page, which is eventually not closing the popup window. Can I call stored procedure from javascript function sendResponse() and pass parameters to it? If so how can I call it?
I am looking through a sql stored procedure which I might need to update in the near future. Basically the stored procedure is about 20 lines long. The stored procedure first builds a query
and stores it in a variable named "@Sql". And then for the last two lines of the stored procedure it appears that the big sql statement stored in "@Sql" is executed by using the "EXEC" command. See below. What is confusing though is that the query appears to be exectuted twice? Why was the query written in this way. Don't both lines do the same thing? Why is it being done twice? Could this possibly be a mistake on the
part of the person who wrote the query. Below are the two lines I am talking about?
EXEC sp_executesql @sql
EXEC (@sql)
I have the following HTML
<tr>
<td class="label" valign="top">
Affiliate Party
</td>
<td class="field">
<input type="hidden" name="ctl00$MainContent$ExternalAccountAttributes$AffiliatePartyId" id="AffiliatePartyId" />
<input name="ctl00$MainContent$ExternalAccountAttributes$AffiliatePartyName" type="text" id="AffiliatePartyName" class="PartyLookup" />
</td>
</tr>
and the following Javascript/jQuery
$(".PartyLookup").after("<img src='Images/book_open.png' class='PartyLookupToggle' style='padding-left:4px;' />");
$(".PartyLookupToggle").click(function () {
window.open("PartySearch.aspx", "PartySearch", "width=400,height=50");
return false;
});
I need to be able to flag ANY PartyId input field with class="PartyLookup" so that it will modify the DOM and include the image next to the input field. The popup window returns data to populate both the hidden and text fields, but since the click() is generic I need to pass it the ID of the input field.
I am trying to return true or false from popup window to the parent window. Actually the parent window has a button control, which on click popup another window. The popup window holds some emailing data and a button "send". This "send" button onclick send email. Now I want to return true if the email is successfully sent otherwise false, to the parent window. Depending on returning value a label present on parent window displays a text message. But I am not able to implement it. Because it might happen that the popup window is blocked by web-browsers popup blocker or popup window is accidentally closed by user. So how can I confirm to parent window whether or not the email is successfully sent?
View 5 Repliesi have a page Parent.aspx,, and this is responsible to open the window as a model dialog(model.apsx). model.apsx has OK button when we click on this button then server side method called to save the data. while saving the data it return the id of saved data. i need this id on my Parent.aspx.Cs file, so how can i get this id on my Parent.aspx.cs file?
View 5 RepliesI have a login page that is loaded in popup window (colorbox) and after user logs in it should be closed and parent window should be loaded with new page.
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
Do While reader.Read()
If Trim(reader("ZAP").ToString()) = Trim(textBoxZap.Text) Then
Session("A") = "1"
Response.Redirect("~/default.aspx")
Else
lblErr.Text = "incorect"
End If
Loop
So once the buton is clicked and user name and password is corect popup window should be closed and user redirected to default aspx.
I am trying to open a popup window from main window using window.open() method. How to get back the value from the called popup window to the calling window in vb.net, basically i need to get back the value and populate in the text box available in the main window.
View 3 RepliesI have a page wich opens a popup window. I want to pass some variables, like some textbox.text and 2 dataTables from parent window to the popup window. And then I'll have to return some vars from popup window to parent window. So what is the best way to do this,
1) using Sessions("")
or
2)passing the variables as parameteres:
LinkButton1.Attributes.Add("onclick", "window.open('popup.aspx?field1=" & value1 & "&field2=" & value2 & ......
I don't know if it's appropiated passing 8 or 10 variables as the option2 because the user will see a very long url with all the variables, but maybe is more efficient than using Sessions.... Anyway, could somebody clear me up?
I am using a master page in my project. I opened a popup window from content page. What I want to do is, when I close the popup window, the data in the textbox available in popup should be assigned to a text box in parent form. But I dont want to refresh the parent window when I close the popup window. Can any one tell me how can I access textbox in a parent window from a popup window without refreshing the screens.
View 3 RepliesI want to receive value from parent's control to popup window's code behind. for example
<asp:RadioButton ID="rdoRate" GroupName="CouponType" value="0" runat="server" checked/>Rate
<asp:RadioButton ID="rdoAmount" GroupName="CouponType" value="1" runat="server"/>dollar
and recive selected radiobutton's value from popup window's code behind. My Solution is make querystring and pass the value.
for example >
window.open(url + ?selectedRadioVal=" + $("#~~checkedradiovalue~~) .. blah balh)
and receive the value by Reqeust.Querystring.Get().
But I can't send very long string. (maybe the url length is limited, right? Is there any good way to solve?
we are running a click-to-call service, my idea is basically like this: website have a link on their page, when the link is clicked, a web page(say it is popup.aspx) hosted on our server is popup, user can input their phone number, and click "call me" button to let the website call him. In the button click event, I want to get Request.UrlReferrer, then query the db to get website's phone. But in IE, Request.UrlReferrer is null(firefox is ok, not test chrome yet),my question is how to get opening window' url in IE? we put popup.aspx on our server because
our client website is not force to use asp.net. we have the control what we put on the popup window, and can modify the page just from our side, if we put the pop window on our partner's side, if we have 100 partner, and we change the page's design, we will notify everyone of them to change this, change that. we can implement a statics system to know how popup a day, which site is most popular,etc
I have a scenario where I have a popup window open and that will have links to open up another window that's going to pop open on top of the already open popup window. I've tried all sort of tricks (javascript window.open, target="_blank" etc.) but nothing seem to work. It always was opening the page on the already opened popup window.
View 1 RepliesI have an aspx page which contains a user control(a gridview). When I click on a link button in the gridview, I will open a popup window(An aspx page) successfully. When I click on save button in the popup, I am saving the details and refreshing the parent page successfully. I have a button in popup window. My requirement is:
When I click on the button inside popup window1, I would like to open another popup(aspx)(Say popup window2) in a new window without closing popup window1. When I save some changes in popup window2 and click on save button in popup window2, I need to close it and refresh popup window1.
I could probably figure this out if I tried to, but I have been working so long on code, I'm a little fried
I have a stored procedure, and I want to execute another stored procedure during a time period of lets say 1/1/2011 to 12/31/2011
How Would I accomplish this?
Does anybody if it is possible that a stored procedure returns rows which is the result of the execution of another sp? Something like..
[Code]....
I am having issues with the stored procedure returning an ObjectResult and then how do I return this is a list of type List.
View 2 RepliesI want to execute a method on VB.Net to return a date which is in the stored procedure. I tried using ExecuteScalar but it doesnt work it retruns error
'Implicit conversion from data type datetime to int is not allowed. Use the CONVERT function to run this query'
below is the code
Public Function GetHolidaydate(ByVal struserID as String) As DateTime
Dim objArgs1 As New clsSQLStoredProcedureParams
objArgs1.Add("@userID", Me.Tag)
objArgs1.Add("@Date", 0, 0, ParameterDirection.Output)
Return (CDate(ExecuteScalar(clsLibrary.MyStoredProcedure.GetHolidayDate, objArgs1)))
End Function
I call this stored procedure with a dataset. It always returns a 0 but should return a 1 or 2. Does anybody know why it isn't returning a 1 or 2.
ALTER PROCEDURE dbo.sp_InsertLinkVote
@LinkId int,
@LinkVoter nvarchar(50),
@LinkVotesDateTime datetime,
@LinkVotesGoodBad bit
AS
/* SET NOCOUNT ON */
If EXISTS
(SELECT
*
FROM
LinkVotes
WHERE
LinkId=@LinkId
and
LinkVoter = @LinkVoter )RETURN
1
ELSE
INSERT INTO
dbo.LinkVotes (LinkId,LinkVoter,LinkVotesDateTime,LinkVotesGoodBad)VALUES
(@LinkId,@LinkVoter,@LinkVotesDateTime,@LinkVotesGoodBad)RETURN
2
Here is were a call it in my code behind.
Dim VoteCheck
As
Integer
Dim InsertVote
As
New DataSetStoredProceduresTableAdapters.QueriesTableAdapter
VoteCheck = InsertVote.sp_InsertLinkVote(LinkId, User.Identity.Name, DateAndTime. Now,
True)
'0 is a good vote.
If VoteCheck = 0
Then
It seems to insert and not insert correctly, I just cannot get it to return the correct value.
I am developing a page in ASP.Net where I have the user enter a letter into a textbox. They then click a submit button and I all of the userids that start with that letter are to be displayed. So I need the SP to go through the database and match first letters with what was entered. Here is what I have as my code for the SP:
CREATE PROCEDURE dbo.exp2 @testchar Char(1)
declare @flag as char(2)
set @flag = @testchar + '%'
select userid
from ex_database
where userid like @flag
I have simple stored procedure to check if there is any email address in the database entered by user or not. My SP should return 1 when user enters a correct email. However, it is returning 0 or -1.
View 3 RepliesI am having problem in returning a status message (success or failure) from my sql server sp here is the code:
[Code]....
"Status" is an output parameter which is supposedly getting the message from sp and we are not able to get its value since
"dbCommand1.Parameters["@status"].Value" returns NULL everytime!
SP is available on request.
Is it possible to have a stored procedure return multiple ref cursors to a .Net application? I tried this, but it didn't work.
<code>
While odr.Read()
dtUserData.Load(odr, LoadOption.OverwriteChanges)
End While
odr.NextResult()
While odr.Read()
dtUserRoles.Load(odr, LoadOption.OverwriteChanges)
End While
</code>
[Code]....
iam using asp.net2.0 with c# with sql server 2000 when iam executing the procedure in local system it is working fine.but when iam executing in client system procedure returns null value, i have checked all connection string , and session value all are working
I am trying to execute a stored procedure in LINQ. When run in SQL Server it returns several fields, mostly integer and float fields. But when I call the stored procedure in LINQ, all it returns is 0. Here is how I am calling the stored procedure :
[Code]....
And here is the stored procedure :
[Code]....