Guest User

Untitled

a guest
Dec 12th, 2018
74
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.82 KB | None | 0 0
  1. case "utbildare":
  2. rewriteToUrl = "/ShowPresentation.aspx?utbildareId=" + GetPresentation(Identifier, site);
  3. break;
  4.  
  5. ////////////////////////////////////
  6.  
  7.  
  8. private string GetPresentation(string Identifier, string site)
  9. {
  10. string RetVal = String.Empty;
  11. SqlCommand sc = new SqlCommand();
  12. sc.CommandText = "SELECT utbildareid FROM utbildarpresentationer WHERE site = @site AND urlbase = @Identifier";
  13. sc.CommandType = System.Data.CommandType.Text;
  14. sc.Parameters.Add("@Identifier", SqlDbType.VarChar, 150).Value = Identifier;
  15. sc.Parameters.Add("@site", SqlDbType.VarChar, 2).Value = site;
  16. SqlDataReader dr = DataHandler.CommandDataReader(sc);
  17. if (dr.HasRows)
  18. {
  19. dr.Read();
  20. RetVal = Convert.ToString(dr["utbildareid"]);
  21. }
  22. dr.Close();
  23. return RetVal;
  24. }
Add Comment
Please, Sign In to add comment