User registered data only display.

vijayaasri palaniappan

Hi,

If user(eg:Ram) registered my page and add one student name(eg:Janu). When Ram login, it shows only ram registered data (janu data) in that page depends on userid (GUID). Please tell Idea ..

Thank You.

6 Replies

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

Salman Beg5y ago
Accepted answer
Can you try like this below link, https://stackoverflow.com/questions/33784904/where-clause-in-linq-in-list-c-sharp
vijayaasri palaniappan5y ago
Hi Salman,

I found the answer.And it display user registered data with the help of this link
https://www.c-sharpcorner.com/UploadFile/abhikumarvatsa/filter-records-in-mvc/

Thank You For Your Response.
vijayaasri palaniappan5y ago
Hi Salman,

public ActionResult List( EmployeeData___TBL e,StudentTBL e1)
        {
            var data1 = Session["userid"].ToString();
            var userdetails = db.EmployeeData___TBL.Where(x => x.UserId == data1).FirstOrDefault();
            var data2 = db.SP_ViewStudent(data1);
            List emp = new List();
            var res = emp.Where(a => a.userid == data1);
            foreach (var val in res)

            {

                Console.WriteLine("Employee Name: {0} ", val.Name);

            }

            var data = db.StudentTBLs.ToList();
                return View(data);

        }

It shows error. Because I give the List. Plaease correct it or tell idea
Salman Beg5y ago
As you are using linq, so in that linq query you need to apply where clause and in the where clause you need to pass userid. See this below link for example, https://www.geeksforgeeks.org/linq-filtering-operator-where/amp/
vijayaasri palaniappan5y ago
Hi Salman Beg,

Thank You For your idea.I was created as you said bt i display the table records using list it takes that condition bt "var data = db.StudentTBLs.ToList(); " when it reach this line it simply display the all records in table. How to display particular record which is equal to userid. Please share your idea
Salman Beg5y ago
Whenever a new user register into the system then at that same time create a unique id associated with that user. When that user add a new student then at that same time associate that user unique id with student. So whenever the user login get the unique id and based on that unique id retrieve all students and display them. Basically in the student table also you need to store the unique id of user and during retrieve you can join and fetch those records easily. Thanks