// Display all records

        public JsonResult Get_data()

        {
            DataSet ds = dblayer.get_record();

            List <register> listrs = new List <register>();

            foreach (DataRow dr in ds.Tables[0].Rows)

            {
                listrs.Add(new register

                {
                    Sr_no = Convert.ToInt32(dr["Sr_no"]),

                    Email = dr["Email"].ToString(),

                    Password = dr["Password"].ToString(),

                    Name = dr["Name"].ToString(),

                    Address = dr["Address"].ToString(),

                    City = dr["City"].ToString()
                });
            }

            return(Json(listrs, JsonRequestBehavior.AllowGet));
        }
Пример #2
0
        // Display all records

        public JsonResult Get_data()
        {
            DataSet ds = dblayer.get_record();

            List <Student> listrs = new List <Student>();

            foreach (DataRow dr in ds.Tables[0].Rows)
            {
                listrs.Add(new Student
                {
                    sid = Convert.ToInt32(dr["sid"]),

                    std_name = dr["std_name"].ToString(),

                    f_name = dr["f_name"].ToString(),

                    Department = dr["Department"].ToString(),

                    semester = dr["semester"].ToString(),

                    roll_no = dr["roll_no"].ToString(),

                    cnic = dr["cnic"].ToString(),

                    mob_no = dr["mob_no"].ToString(),

                    google_id = dr["google_id"].ToString(),

                    passworrd = dr["passworrd"].ToString(),

                    studentregisterationtime = dr["studentregisterationtime"].ToString()
                });
            }

            return(Json(listrs, JsonRequestBehavior.AllowGet));
        }