How to fetch data from a SSMS table by taking primary key as input and should display on the screen

Question

1.00/5 (1 vote)

See more:

Aim: need to fetch the employee details on the screen by taking Emp_ID as an input.

Can anyone please help me in this?

1) i should create an EF model for that table.
2) i should write a stored procedure for fetching data with the primary key Emp_ID.
3) we have a Table EmpDetails like below

Table EmpDetails:

Emp_ID(pk) F_Name L_Name Email_ID Mobile_Num
123456 Sunil Kumar sunil.Kumar@wipro.com 1111111111
222222 Ravi Teja ravi.teja@wipro.com 2222222222
333333 Pavan Kumar pavan.kumar@wipro.com 3333333333
444444 Arun Kumar arun.kumar@wipro.com 4444444444

4) i need to create a screen like

Browser Screen:

Emp_ID : ______ GetDetails(button)
F_Name : ______
L_Name : ______
Email_ID : ______
Mobile_Num : ______

In the above screen when user gives an Emp_ID and clicks the GetDetails button then all the details of that employee should populate on the screen in the respective text boxes of the variables.

What I have tried:

I have created Table and EF but dont know the further steps

Posted 18-Jul-18 3:51am

Member 13916650

Updated 18-Jul-18 20:32pm

Add a Solution

Comments

F-ES Sitecore 18-Jul-18 10:27am

Your question is basically "How do I write a website?" You can't learn some a broad technology by asking questions on a forum. Get a book on MVC or at least go through a tutorial like this one

https://docs.microsoft.com/en-us/aspnet/mvc/overview/older-versions/mvc-music-store/mvc-music-store-part-1

That will take you through the basics such as getting data from a database and showing it.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Vincent Maverick Durano · Answer 1 · 2018-07-18T20:32:00

You need to start learning the basic first and know how stuff works, especially the request and response thing in the stateless world of web.

If you are new to ASP.NET MVC, I'd recommend you to refer my series of article here: ASP.NET MVC 5: Building Your First Web Application - Part 1[^]

You can also head over to the official docs to learn ASP.NET MVC: Learn | The ASP.NET Site[^]