MVC form

Mohammed Rizwanullah

11y1.6kLINQ

Hi,

I have created a master table for the coloums classID and ClassName,i want a mvc form with entityframework to display or to make use

of that data in the other application.

Thanks & Regards

Rizwan

17 Replies

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

Suraj Sahoo11y ago
Hello Rizwan,
Based on your latest query, you need to do this in the javascript file using jquery. Based on the dropdown value change, take the dropdown selected value and make an ajax call to get the other value to be updated from the table.
Please check the below fiddle for some information.

http://jsfiddle.net/taditdash/9Kfnt/

I hope this idea surely helps you. You just need to add the ajax call into the Onchange function of the dropdown. Retrieve the value from table in ajax and inside the ajax sucess function add the value wherever you want.
Accept If helps you.
Thanks
Mohammed Rizwanullah11y ago
Hi Sir,

I have two tables,student and class, i have taken the values of student name in the dropdown list , now when i select the name in the dropdownlist i want to dispaly the respective classname from the table,.could you plz help me with the query and where to write it in mvc.

Thanks
Rizwan
Suraj Sahoo11y ago
Hello Rizwan,
You can try and use a Partial class that will extend the main class which has FirstName and LastName as properties.
Then in the Partial class have a property called FullName and since it extends the main class, whenever it is called you can have a property fullName in access too which you can use to set the dropdown.
http://www.codeproject.com/Articles/709273/Partial-Classes-in-Csharp-With-Real-Example
I hope you understand
Accept if helps you.
Thanks
Mohammed Rizwanullah11y ago
Hi,

I have two columns in the database, firstname,lastname, i want to concat two names and want to produce as Fullname in dropdownlist.is there any help?

Thanks
Rizwan
Mohammed Rizwanullah11y ago
Hi,

This is Rizwan,i already sent the Database of MVCDB, there are two tables, i want to create a third with StudentName in dropdown,when we select student name,student class should be displayed, could you plz help me out in mvc 3 with EF.

Thanks
Rizwan
Mohammed Rizwanullah11y ago
HI,

am creating a mvc app to perform CRUD, but to perform Create, it stores only one time
the ID field does not increament,
public ActionResult Create()
{

return View();
}

//
// POST: /Student/Create

[HttpPost]
public ActionResult Create(Student Model)
{
try
{
// TODO: Add insert logic here

if (!ModelState.IsValid)
return View();

_db.AddToStudents(Model);
_db.SaveChanges();
return RedirectToAction("Index");
}
catch
{
return View();
}
}

help me out with this.

Thanks
Rizwan
Ravi Patel11y ago
Hi ,

I checked your source code you are not using Entity Framework Database first approach

Please go to msdn https://www.asp.net/mvc/overview/getting-started/database-first-development/setting-up-database

and download visual studio 2013 http://www.visualstudio.com/
Mohammed Rizwanullah11y ago
Plz find the rar file,
Ravi Patel11y ago
Hi,

where you uploaded i did not get any database backup file

take the database backup and compress that database backup in zip or rar formate then upload
Mohammed Rizwanullah11y ago
Hope u got the db backup?
Mohammed Rizwanullah11y ago
backup
Ravi Patel11y ago
Hi Mohammed ,

attach your database back up file here
Mohammed Rizwanullah11y ago
Hi Sir, i have already sent you the code,could you plz help me out, Details,edit,create not working.
Ravi Patel11y ago
Hi,

if you are using strongly view

[HttpPost]
public ActionResult Create(User users)
{
try
{
//TODO: Add insert logic here
MyDbDataContext dbContext = new MyDbDataContext();
dbContext.User.Add(users); // here User is your Model class name
dbContext.SaveChanges();

return RedirectToAction("Index");
}
catch
{
return View();
}
}
Mohammed Rizwanullah11y ago
Hi,

Sir i have gone through your link, the data is listing in index view,but unable to create, update,edit or delete.
namespace StudentDetails.Controllers
{

public class StudentController : Controller
{

//
// GET: /Student/

public ActionResult Index()
{
var dbContext = new MyDbDataContext();
var userList = from user in dbContext.StudentDetails select user;
var users = new List();
if (userList.Any())
{
foreach (var user in userList)
{
users.Add(new StudentDetails.Models.User()
{
StudentID = user.StudentID,
FirstName = user.FirstName,
LastName = user.LastName,
Age = Convert.ToInt32(user.Age),
School = user.School,
Residence = user.Residence,
Phone = user.Phone,
Email = user.Email,
ClassID = Convert.ToInt32(user.ClassID)
});
}
}
return View(users);
}

//
// GET: /Student/Details/5

public ActionResult Details(int? id)
{
var dbContext = new MyDbDataContext();
var userDetails = dbContext.StudentDetails.FirstOrDefault(studentID => studentID.StudentID == id);
var user = new StudentDetails.Models.User();
if (userDetails != null)
{
user.StudentID = userDetails.StudentID;
user.FirstName = userDetails.FirstName;
user.LastName = userDetails.LastName;
user.Age = Convert.ToInt32(userDetails.Age);
user.School = userDetails.School;
user.Residence = userDetails.Residence;
user.Phone = userDetails.Phone;
user.Email = userDetails.Email;
user.ClassID = Convert.ToInt32(userDetails.ClassID);
}
return View(user);
}

//
// GET: /Student/Create

public ActionResult Create()
{
return View();
}

//
// POST: /Student/Create

[HttpPost]
public ActionResult Create(User users)
{
try
{
//TODO: Add insert logic here
var dbContext = new MyDbDataContext();
dbContext.StudentDetails.InsertOnSubmit(users);//Getting error while inserting
dbContext.SubmitChanges();
return RedirectToAction("Index");
}
catch
{
return View();
}
}

//
// GET: /Student/Edit/5

public ActionResult Edit(int? id)
{
var dbContext = new MyDbDataContext();
var userDetails = dbContext.StudentDetails.FirstOrDefault(studentID => studentID.StudentID == id);
var user = new StudentDetails.Models.User();
if (userDetails != null)
{
user.StudentID = userDetails.StudentID;
user.FirstName = userDetails.FirstName;
user.LastName = userDetails.LastName;
user.Age = Convert.ToInt32(userDetails.Age);
user.School = userDetails.School;
user.Residence = userDetails.Residence;
user.Phone = userDetails.Phone;
user.Email = userDetails.Email;
user.ClassID = Convert.ToInt32(userDetails.ClassID);
}
return View(user);
}

//
// POST: /Student/Edit/5

[HttpPost]
public ActionResult Edit(int? id, User userDetails)
{
try
{
// TODO: Add update logic here
var dbContext = new MyDbDataContext();
var user = dbContext.StudentDetails.FirstOrDefault(StudentID => StudentID.StudentID == id);

if (userDetails != null)
{

user.FirstName = userDetails.FirstName;
user.LastName = userDetails.LastName;
user.Age = Convert.ToInt32(userDetails.Age);
user.School = userDetails.School;
user.Residence = userDetails.Residence;
user.Phone = userDetails.Phone;
user.Email = userDetails.Email;
user.ClassID = Convert.ToInt32(userDetails.ClassID);
dbContext.SubmitChanges();
}
return RedirectToAction("Index");
}
catch
{
return View();
}
}

//
// GET: /Student/Delete/5

public ActionResult Delete(int id)
{
return View();
}

//
// POST: /Student/Delete/5

[HttpPost]
public ActionResult Delete(int id, FormCollection collection)
{
try
{
// TODO: Add delete logic here

return RedirectToAction("Index");
}
catch
{
return View();
}
}
}
}

Error1The best overloaded method match for 'System.Data.Linq.Table.InsertOnSubmit(StudentDetails.StudentDetail)' has some invalid argumentsD:\MyMVC\StudentDetails\StudentDetails\Controllers\StudentController.cs8517StudentDetails
Error2Argument 1: cannot convert from 'StudentDetails.Models.User' to 'StudentDetails.StudentDetail'D:\MyMVC\StudentDetails\StudentDetails\Controllers\StudentController.cs8557StudentDetails
Ravi Patel11y ago
Hi ,

check this link
http://www.c-sharpcorner.com/UploadFile/1492b1/connecting-the-mvc-application-with-the-help-of-entityframew/
Suraj Sahoo11y ago
Hello Rizwan,
Now since you have your database and tables ready, you can follow Entity Framework DB-First approach.

http://www.entityframeworktutorial.net/database-first-with-entity-framework.aspx

Then you need to establish an Ado.Net Entity Model connection to the MVC project, which you will find in the Add New Item template in the DATA section.
Then after the connection is established, you need to use the context to be able to access the data records in the table, more information you will get from the link.
Accept if helps anyway.
Thanks