Link to home
Start Free TrialLog in
Avatar of kdeutsch
kdeutschFlag for United States of America

asked on

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 & "')"



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>'../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("'" + Request.ApplicationPath + "../Reports/SRpIsses.aspx?ID=" & SSN & " '" + 'Width=100,height=100');", True)

Open in new window

Avatar of BurnieP
Flag of Canada image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of kdeutsch


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

ClientScript.RegisterClientScriptBlock(Me.[GetType](), "open", "<script type='text/javascript'>'" & Request.ApplicationPath & "../Reports/SRpIsses.aspx?ID=" & SSN & "','Width=100,height=100');</script>")
Still get the same thing Invlid argument.  The highlight starts at the
and calls character 32

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", "'" & Request.ApplicationPath & "../Reports/SRpIsses.aspx?ID=" & SSN & "','Width=100,height=100');")
Hi, You have to use this code after insert query is executed.

using System.Windows.Form;

MessageBox.Show("Record successfully added");

Do you have working in an update panel on your side.  I have in an update panel, these things are a pain.

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.
Ok this works and calls the a javascript alert window after the insert .
 ClientScript.RegisterStartupScript(Me.GetType(), "ClientScript", "alert ('hello')", True)
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.

maybe that information fills in automatically.??

<script type='text/javascript''/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>
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.