Loading
Passing values from database to next page  
  •   
  •   
  •   
  •   
  •   
  •   
    • new.aspx.cs :
    1. using System;  
    2. using System.Collections.Generic;  
    3. using System.Linq;  
    4. using System.Web;  
    5. using System.Web.UI;  
    6. using System.Web.UI.WebControls;  
    7. using System.Data;  
    8. using System.Data.SqlClient;  
    9. using System.Net;  
    10. using System.Globalization;  
    11. using System.IO;  
    12. public partial class View_new : System.Web.UI.Page  
    13. {  
    14. protected void Page_Load(object sender, EventArgs e)  
    15. {  
    16. //this.txtUserName.Text = Request.QueryString["username"];  
    17. }  
    18. protected void btnLogin_Click(object sender, EventArgs e)  
    19. {  
    20. //string filepath = Server.MapPath("~/PMCustom/images/") + "top-button.png";  
    21. //FileInfo file = new FileInfo(filepath);  
    22. //Response.ClearContent();  
    23. //Response.AddHeader("Content-Disposition", "attachment;filename=" + file.Name);  
    24. //Response.TransmitFile(file.FullName);  
    25. //Response.End();  
    26. SqlCommand lsCmd = new SqlCommand("SP_VALIDATE_LOGIH");  
    27. lsCmd.Parameters.AddWithValue("@USERNAME", txtUserName.Text);  
    28. lsCmd.Parameters.AddWithValue("@PASSWORD", txtPassword.Text);  
    29. DataTable dt = ConnCls.ret_dt_Cmd(lsCmd);  
    30. string strUserid = dt.Rows[0]["USERID"].ToString();;  
    31. //string strDataMode = dt.Rows[0]["DATAMODE"].ToString();  
    32. string strloggedInTime = System.DateTime.Now.ToString();  
    33. string strhostName = Dns.GetHostName();  
    34. string strIpAddress = Dns.GetHostByName(strhostName).AddressList[0].ToString();  
    35. if (strUserid != "0")  
    36. {  
    37. HttpCookie userid = new HttpCookie("userid");  
    38. userid.Value = strUserid;  
    39. Response.Cookies.Add(userid);  
    40. string doll = Request.Cookies["userid"].Value;  
    41. Response.Write(doll);  
    42. HttpCookie username = new HttpCookie("username");  
    43. username.Value = txtUserName.Text;  
    44. Response.Cookies.Add(username);  
    45. string roll = Request.Cookies["username"].Value;  
    46. Response.Write(roll);  
    47. //HttpCookie ipaddress = new HttpCookie("ipaddress");  
    48. //ipaddress.Value = Dns.GetHostByName(strhostName).AddressList[0].ToString();  
    49. //Response.Cookies.Add(ipaddress);  
    50. //int loginIdVal = insertLog(strUserid, strUserName);  
    51. //HttpCookie loginId = new HttpCookie("logInId");  
    52. //loginId.Value = loginIdVal.ToString();  
    53. //Response.Cookies.Add(loginId);  
    54. //HttpCookie dataMode = new HttpCookie("dataMode");  
    55. //dataMode.Value = strDataMode.ToString();  
    56. //Response.Cookies.Add(dataMode);  
    57. if (strUserid != "0")  
    58. {  
    59. Response.Redirect("~/home/accountshome.html");  
    60. }  
    61. }  
    62. }  
    63. public int insertLog(string pUserid, string pUsername)  
    64. {  
    65. System.Web.HttpBrowserCapabilities objHBC = Context.Request.Browser;  
    66. string userLanguage = CultureInfo.CurrentCulture.Name;  
    67. SqlCommand cmd = new SqlCommand("PM_INSERT_LOG");  
    68. cmd.Parameters.Add("@USERID", pUserid);  
    69. cmd.Parameters.Add("@USERNAME", pUsername);  
    70. cmd.Parameters.Add("@BROWSERNAME", objHBC.Browser);  
    71. cmd.Parameters.Add("@VERSION", objHBC.Version);  
    72. cmd.Parameters.Add("@SPIXELHEIGHT", hdnScreenHeight.Value);  
    73. cmd.Parameters.Add("@SPIXELWIDTH", hdnScreenWidth.Value);  
    74. cmd.Parameters.Add("@ISMOBILE", objHBC.IsMobileDevice.ToString());  
    75. cmd.Parameters.Add("@ISJAVASCRIPT", objHBC.JavaScript.ToString());  
    76. cmd.Parameters.Add("@BROWSERTYPE", objHBC.Type);  
    77. cmd.Parameters.Add("@MOBILEMODEL", objHBC.MobileDeviceModel.ToString());  
    78. cmd.Parameters.Add("@CLIENTDETAIL", Context.Request.UserAgent.ToString());  
    79. cmd.Parameters.Add("@ISTABLES", objHBC.Tables.ToString());  
    80. cmd.Parameters.Add("@ISCOOKIES", objHBC.Cookies.ToString());  
    81. cmd.Parameters.Add("@ISACTIVEX", objHBC.ActiveXControls.ToString());  
    82. cmd.Parameters.Add("@PLATFORM", objHBC.Platform);  
    83. cmd.Parameters.Add("@USERLANGUAGE", userLanguage);  
    84. DataTable dt = ConnCls.ret_dt_Cmd(cmd);  
    85. string returnVal = dt.Rows[0]["LOGINID"].ToString();  
    86. return Convert.ToInt32(returnVal);  
    87. }  
    88. }  
    accountsHomehtml :
    1.   
    2. "http://www.w3.org/1999/xhtml">  
    3.   
    4.   
    5.   
    6.   
    7. "text/javascript" src="https://ajax.googleapis.com/ajax/libs/angularjs/1.2.7/angular.min.js">  
    8. "text/javascript" src="https://ajax.googleapis.com/ajax/libs/angularjs/1.2.7/angular-cookies.js">  
    9.   
    10.   
    11. "LoginApp" ng-controller="LoginController">  
    12.   

    13. Login successful!

        
      
  •   
  • Username : "lblUserName" class="hidden-xs">{{getUsername()}}  
  • User Id : "lblUserId" class="hidden-xs">{{getUserid()}}  
  •   
  •   
  •   
  • newAjs.js :  
  • var app = angular.module("LoginApp", ['ngCookies'])  
  • .controller("LoginController", function ($scope, $cookies) {  
  • $scope.getUsername = function () {  
  • return $cookies.get("username");  
  • }  
  • $scope.getUserid = function () {  
  • return $cookies.get("userid");  
  • }  
  • });  
    • I can display the values by checking it in the database in the same page, but I cannot pass it to the next page. I don't know what mistake I have done.

    3 Replies

    Know the answer? Post it — somebody with the same question will find it here.