("SelectUserName @Name", new SqlParameter("@Name", Name))

Atta Kumah

Please i want to use below statement to get Particular User Details From Database to View without assigning String Name to a specific Name(I want to Enter, let say Kumar in a different Page and get the user Details in another Page). Please this is Homework and i am finding things difficult.

Please Humble appeal. Any answer is kindly welcome and honored

This is My Controller

public async Task Index( )

{

using (var context = new UserDb())

{

string Name = " Kumar";

var Data = context.tbl_Employee.SqlQuery("SelectUserName @Name", new SqlParameter("@Name", Name)).ToList();

return View(Data);

}

5 Replies

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

Jignesh Kumar7y ago
Accepted answer
Hi,

Please find below link, You have to pass model to your action method from there you can take values from model properties.

https://www.aspsnippets.com/Articles/ASPNet-MVC-Pass-Get-data-from-View-to-Controller-example.aspx
+1
Atta Kumah7y ago
Please Mr Jignesh Kumar i wanted to do away with "Atta Kumah". I want a parameter that will input a value ("Atta Kumah")
0
Jignesh Kumar7y ago
1. public async Task Index( )
2. {
3. using (var context = new UserDb())
4. {
5. string Name = "Atta Kumah";
6. var Data = await (context.tbl_Employee.Where(x.Name == Name).ToList());
7. return View(Data);
8. }
9. }
0

Siddhartha Sharma7y ago

use context.tbl_employee.where(x=>x.Name(table column)==Name).ToList();

Abhishek Mishra7y ago

Try this code

public async Task Index( )
{
using (var context = new UserDb())
{
string name= "Kumar";
var objData= context.tbl_Employee.Where(x=>x.Name.Equals(name)).ToList();
return View(objData);
}
}