Using DataSet As Data Model in asp.net MVC 4 Project

Question

I want to use Data Set as my Model in my mvc 4 project. How to use the model binding with data sets. can any one give me a solution

ramiramilu · Accepted Answer · 2014-01-30 08:39:23Z

4

You can use DataSet Like this -

Controller Action -

public ActionResult Index()
{
    DataSet ds = new DataSet();
    DataTable dt = new DataTable("Marks");

    dt.Clear();
    dt.Columns.Add("Name");
    dt.Columns.Add("Marks");
    DataRow dr = dt.NewRow();
    dr["Name"] = "rami";
    dr["Marks"] = "500";
    dt.Rows.Add(dr);


    ds.Tables.Add(dt);

    return View(ds);
}

Index Action -

@model System.Data.DataSet

@using System.Data

@foreach (DataRow row in Model.Tables["Marks"].Rows)
{
    @(row["Name"] + " " + row["Marks"])
}

Output -

enter image description here

answered Jan 30, 2014 at 8:39

ramiramilu

17.2k6 gold badges51 silver badges66 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

user3252155 Over a year ago

thanks for the reply. but how i work with insert and updates with data sets now its give me "No parameterless constructor defined for this object." when i try to save data

ramiramilu Over a year ago

I dont think retrieving data is an easy job. Refer this solved thread - stackoverflow.com/questions/13375370/…. Its always better you can convert your datatable to models, and then use it in your CRUD operations.

Anthony Mason Over a year ago

It is true, if used as a model it needs a paramaterless constructor. So perhaps a strongly typed dataset or simply inheriting from one for your model would fix the issue.

Collectives™ on Stack Overflow

Using DataSet As Data Model in asp.net MVC 4 Project

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related