• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 595
  • Last Modified:

Call a popup window after sql insert

As part of my Procedure I first insert data to a sql Db and then i want to popUp a small 100 by 100 window which just has a print window that opens , it prints goes away an they go onto the next task.  THis worked good in 1.1 code but having trouble getting to work in 4.0 code.  what am I doing wrong here.


sql = "Insert tblSRpEventData (intPersonnelId, intUnitSRPId, intQuestionId, bitAnswer, strData, strRemarks, dtDoc, dtLogged, strlogged) VALUES (" & PersId & ", " & UnitID & ", " & AQuesId & ", " _
                    & "" & Aanswer.SelectedValue & ", '" & Adata.Text & "', '" & ARemarks.Text & "', '" & ADtdate.Text & "', '" & Date.Today & "', '" & userlogon & "')"

            insertUpdateDelete(sql)
        Next

        ClearAdminGrid()

My first method is to put a lable on the aspx page and call the label but nothing is happening.
 lbljavascript.Text = "<script language=javascript>window.open('../Reports/SRPIssues.aspx?id=" & SSN & " '', 'width=1 height=1 top=1 left=1');</script>"

The second methis is to try to do with page controls but can't seem to get he systax correct.
 Page.ClientScript.RegisterStartupScript("window.open('" + Request.ApplicationPath + "../Reports/SRpIsses.aspx?ID=" & SSN & " '" + 'Width=100,height=100');", True)

Open in new window

0
kdeutsch
Asked:
kdeutsch
  • 7
  • 3
1 Solution
 
BurniePCommented:
Hi,

Try using ClientScript.RegisterClientScriptBlock like this :


ClientScript.RegisterClientScriptBlock(Me.[GetType](), "open", "<script type='text/javascript'>window.open('" + Request.ApplicationPath & "../Reports/SRpIsses.aspx?ID=" & SSN & "','Width=100,height=100');</script>")

Open in new window

0
 
kdeutschAuthor Commented:
Hi,
It gives me an error of invalid argument then says liine 53 character 32.
ClientScript.RegisterClientScriptBlock(Me.[GetType](), "open", "<script type='text/javascript'>window.open('" + Request.ApplicationPath & "../Reports/SRpIsses.aspx?ID=" & SSN & "','Width=100,height=100');</script>")
0
 
BurniePCommented:
Hmmm..  Maybe it is the + in window.open('" +... Change it for &

ClientScript.RegisterClientScriptBlock(Me.[GetType](), "open", "<script type='text/javascript'>window.open('" & Request.ApplicationPath & "../Reports/SRpIsses.aspx?ID=" & SSN & "','Width=100,height=100');</script>")
0
Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

 
kdeutschAuthor Commented:
Hi,
Still get the same thing Invlid argument.  The highlight starts at the
>window.open
and calls character 32
0
 
BurniePCommented:
Hi,

I am really confused because it is working fine on my side.  Hmmm...  it might not like the <script tags..  I removed them, maybe..

ClientScript.RegisterClientScriptBlock(Me.[GetType](), "open", "window.open('" & Request.ApplicationPath & "../Reports/SRpIsses.aspx?ID=" & SSN & "','Width=100,height=100');")
0
 
SAMIR BHOGAYTAFreelancer and IT ConsultantCommented:
Hi, You have to use this code after insert query is executed.

using System.Windows.Form;

MessageBox.Show("Record successfully added");
0
 
kdeutschAuthor Commented:
BurnieP,

Do you have working in an update panel on your side.  I have in an update panel, these things are a pain.
0
 
kdeutschAuthor Commented:
samirbhogayta:

If I use form controls is messes up all my web page controls when I do this my code behind goes crazy with all kins os blue underlines.
0
 
kdeutschAuthor Commented:
hi,
Ok this works and calls the a javascript alert window after the insert .
 ClientScript.RegisterStartupScript(Me.GetType(), "ClientScript", "alert ('hello')", True)
0
 
kdeutschAuthor Commented:
hi,
Ok this is what I get for the link when it trys to open I get an javascript error on the bottom of the page in corner.  if I put the link into my page it works fine, but what I see is missing and I guess I don't know if its a problem is the server name and http before this part.
'/ReadinessTracker/Reports/SRPIssues.aspx?

maybe that information fills in automatically.??

<script type='text/javascript' window.open('/ReadinessTracker/Reports/SRPIssues.aspx?ID=10','Width=100,height=100');</script><script type='text/javascript'>new Sys.WebForms.Menu({ element: 'mnuMaster', disappearAfter: 500, orientation: 'horizontal', tabIndex: 0, disabled: false });</script>
0
 
kdeutschAuthor Commented:
Ok, the script works, to a point in that its not the script giving me the error, it has to do with my master page menu system and that I had misspelled link address.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 7
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now