code_junkie

Create a new tab or window for a web page from ASP.NET

Nov 13th, 2011
127
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.79 KB | None | 0 0
  1. protected void RecentButtonsRepeater_ItemCommand(object source,
  2. RepeaterCommandEventArgs e)
  3. {
  4. string code = ((LinkButton)e.Item.Controls[1]).Text;
  5. string sql = "SELECT RunID FROM ProductionRuns WHERE RunCode = @code";
  6. SqlConnection sqlconn = new SqlConnection(QCDataPath);
  7. sqlconn.Open();
  8. SqlCommand sqlcomm = new SqlCommand(sql, sqlconn);
  9. sqlcomm.Parameters.AddWithValue("@code", code);
  10. SqlDataReader sdr = sqlcomm.ExecuteReader();
  11.  
  12. sdr.Read();
  13.  
  14. int id = sdr.GetInt32(0);
  15.  
  16. sdr.Close();
  17. sqlconn.Close();
  18.  
  19. Session["RunID"] = id;
  20. Server.Transfer("Sheet.aspx");
  21. }
  22.  
  23. <script type="text/javascript">
  24. function ReOpenScoreHome() {
  25. window.open("Scoresheets.aspx", "reopenwindow");
  26. }
  27. </script>
  28. </head>
  29. <body onload="ReOpenScoreHome()">
Add Comment
Please, Sign In to add comment