ASP.NET MVC - Ajax passing null value to controller

Question

I am trying to send data from view to controller with Ajax but data is coming to controller as null.I tried many things but couldn't find a solution.frombody attribute didn't fix the problem, I made a few changes in startup but they didn't help me either.

Here are my scripts:

$(document).ready(function() {
    $("#addColumn").click(function() {
        AddColumnRecords();
    });
    $("#saveRecords").click(function() {
        SaveRecords();
    });
});

function AddColumnRecords() {
    var columnRecords="<tr><td>" + $("#columnName").val() + "</td><td>" + $("#type").val() +"</td><td>"+ document.getElementById('primaryCheck').checked+ "</td></tr>";
    $("#ColumnTable").last().append(columnRecords);
     $("#columnName").val(" ");
}

function SaveRecords() {
    var Columns = new Array();
     $("#ColumnTable").find("tr:gt(0)").each(function(){
        var name=$(this).find("td:eq(0)").text();
        var type=$(this).find("td:eq(1)").text();
        var isPrimary=$(this).find("td:eq(2)").text();
        var ColumnModel={};
        ColumnModel.Name = name;
        ColumnModel.Type = parseInt(type);
        ColumnModel.IsPrimaryKey = isPrimary;
        Columns.push(ColumnModel);
     });
    var Table={};
    var tableName=$("#tableName").val();
    Table.TableName=tableName;
    Table.Columns=Columns;
    console.log(JSON.stringify(Table));

    $.ajax({
        type:'POST',
        dataType:'JSON',
        contentType:'application/json; charset=utf-8',
        url:'/table/createtable',
        data:{table : JSON.stringify(Table)},
        success:function(data){alert("success")},
        error:function(){alert("error")}
    });
}

My table is:

public class Table
{
    public string TableName { get; set; }
    public List<Column> Columns { get; set; } = new List<Column>();
}

Column model class is:

public class Column
{
    public string Name { get; set; }
    public virtual Types Type { get; set; } = Types.String;
    public virtual bool IsPrimaryKey { get; set; } = false;
}

And this is the action method:

[HttpPost]
public IActionResult CreateTable([FromBody] Table table)
{
    return View();
}

console log

<div class="mb-3">
    <label for="tableName" class="form-label">Table Name</label>
    <input type="text" class="form-control" id="tableName" aria-describedby="tableName">
  </div>

<form>
  <div class="mb-3">
    <label for="columnName" class="form-label">Name</label>
    <input type="text" class="form-control" id="columnName" aria-describedby="columnName">
  </div>
  <div class="mb-3">
        <select class="form-select" aria-label="Default select example" id="type">
            @{
                <option value=3>@DatabaseSample.Models.Types.String</option>
                <option value=0>@DatabaseSample.Models.Types.Integer</option>
                <option value=5>@DatabaseSample.Models.Types.Boolean</option>
                <option value=4>@DatabaseSample.Models.Types.Char</option>
                <option value=2>@DatabaseSample.Models.Types.Double</option>
                <option value=1>@DatabaseSample.Models.Types.Float</option>
                <option value=6>@DatabaseSample.Models.Types.Date</option>
            }
</select>
  </div>

  <div class="mb-3 form-check">
    <input type="checkbox" class="form-check-input" id="primaryCheck">
    <label class="form-check-label" for="exampleCheck1">Primary key</label>
  </div>
  
</form>

<button id="addColumn" type="submit" class="btn btn-primary">Submit</button>




<table class="table" id="ColumnTable">
  <thead>
    <tr>
      <th scope="col">Column name</th>
      <th scope="col">Type</th>
      <th scope="col">Primary key</th>
    </tr>
  </thead>
</table>
<button id="saveRecords" type="submit" class="btn btn-primary">Save</button>

What is Types in your Column.cs? Could you share your code about Types? — Qing Guo
– Qing Guo, Commented May 17, 2022 at 10:40
It's enum: public enum Types { Integer, Float, Double, String, Char, Boolean, Date } — HeadEx
– HeadEx, Commented May 17, 2022 at 10:43

Qing Guo · Accepted Answer · 2022-05-18 03:19:37Z

2

Below is a work demo, you can refer to it.

Change ajax like below:

    ...
    var Table={};
    var tableName=$("#tableName").val();
    Table.TableName=tableName;
    Table.Columns=Columns;
    console.log(JSON.stringify(Table));
  

      $.ajax({
                url:'/Home/Createtable',  
                type:'POST',                   
                data:Table,
                success:function(data){alert("success")},
                error:function(){alert("error")}               
            });

In HomeController:

       public IActionResult Index()
        {
            return View();
        }
       [HttpPost]
        public JsonResult CreateTable(Table table, List<Column> Columns)
        {
            var ccc = 0;  // do your staff...
            return Json(ccc);
        }

Result:

edited May 18, 2022 at 3:19

answered May 18, 2022 at 2:10

Qing Guo

9,2971 gold badge8 silver badges16 bronze badges

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

3 Comments

Qing Guo Over a year ago

@HeadEx Could you tell me the version of the asp.net you use?

HeadEx Over a year ago

it's asp.net 5.0

Qing Guo Over a year ago

@HeadEx You are welcome:) asp.net 5.0 is name asp.net core, Could you add your tag a "asp.net core" ?

Serhat MERCAN · Accepted Answer · 2022-05-17 11:29:52Z

2

In your ajax send codes, you convert the model to string!

$.ajax({
    type:'POST',
    dataType:'JSON',
    contentType:'application/json; charset=utf-8',
    url:'/table/createtable',
    data:{table : JSON.stringify(Table)},  //  <<------------- HERE
    success:function(data){alert("success")},
    error:function(){alert("error")}
});

that's mean you send a model like this; { table: "..."}

But your controller wants a Table model.

First option for solution; dont convert to string by JSON.stringfy()

$.ajax({
    type:'POST',
    dataType:'JSON',
    contentType:'application/json; charset=utf-8',
    url:'/table/createtable',
    data: Table,  //  <<------------- HERE
    success:function(data){alert("success")},
    error:function(){alert("error")}
});

Or second option; change controller paramter from Table to string. When you get the model string, then convert it to Table model inside of the controller function.

[HttpPost]
public IActionResult CreateTable([FromBody] string table)
{
    var mTable =  new JavaScriptSerializer().Deserialize<Table>(table);
    return View();
}

answered May 17, 2022 at 11:29

Serhat MERCAN

1,0983 gold badges15 silver badges32 bronze badges

2 Comments

HeadEx Over a year ago

I tried both options but it still doesn't work.

Serhat MERCAN Over a year ago

Try again after to change Types property to int (inside of the Columns class). If you couldn't get still, that means there is another problem

Omar · Accepted Answer · 2022-05-17 11:25:55Z

0

remove [FromBody] and try this

let Table = {
       TableName: $("#tableName").val(),
       ColumnsStr :JSON.stringify(Columns)
 //create a new property in Table model, calls ColumnsStr which will receive ColumnsStr 
};

$.ajax({
        type:'POST',
        dataType:'json',
        contentType:'application/json; charset=utf-8',
        url:'@(Url.Action("CreateTable", "table"))',
        data:Table,
        success:function(data){alert("success")},
        error:function(){alert("error")}
    });

and in the controller you can do that:

table.Columns = JsonSerializer.Deserialize<List<Column>>(table.ColumnsStr)

answered May 17, 2022 at 11:25

Omar

982 silver badges12 bronze badges

3 Comments

HeadEx Over a year ago

I tried but it still doesn't work

Omar Over a year ago

I think also you need to change button type from type="submit" to type="button", since it is an ajax call and type type="submit" will send the whole page to server.

Omar Over a year ago

or you can wrap the ajax call inside $("#Your Form ID Here").submit(function(event) {// Your ajax here } and remove onclick event inside $(document).ready

Parsa S · Accepted Answer · 2022-05-17 11:35:33Z

0

just for sending the table use this

data: JSON.stringify(Table)

answered May 17, 2022 at 11:35

Parsa S

1535 bronze badges

1 Comment

HeadEx Over a year ago

it didn't work.

Collectives™ on Stack Overflow

ASP.NET MVC - Ajax passing null value to controller

4 Answers 4

3 Comments

2 Comments

3 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

3 Comments

2 Comments

3 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related