User registered data only display.

Question

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.

Salman Beg · Accepted Answer

Can you try like this below link,
https://stackoverflow.com/questions/33784904/where-clause-in-linq-in-list-c-sharp

Salman Beg · Answer

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/

Salman Beg · Answer

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

vijayaasri palaniappan · Answer

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 palaniappan · Answer

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

vijayaasri palaniappan · Answer

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