ASP.Net MVC: Merge (Combine) multiple rows value with comma separated in Linq

zeeshanp...

SOLVED CLOSED ACTIVE ANSWERED
User: zeeshanpas
Posted: on Aug 19, 2022 12:33 PM
Forum: ASP.Net MVC
Answer: 1
Views: 2149
Sample Code: Download

My requirement i had saved for multiple subjects, multiple courses and multiple school levels and i want to show it in the grid as below as comma separated and i am trying to fetch as a list From the don't know how to make to show in grid like below

For ex:

subject schoollevel courses

Maths Elementary ALgebra,Geometry,statistics

English Elemntary 3rd grade english,4th grade english

Maths Middle school ALgebra,Geometry,statistics

public ActionResult GetCoursetut(int? TutorID)
{
    BLDal objBLDal = new BLDal();
    DataTable dt = new DataTable();
    OracleParameter[] paramusp = new OracleParameter[2];
    List<TutorProfileupdate> objCourses = new List<TutorProfileupdate>();
    paramusp[0] = objBLDal.CreateInParameter("iTutorid", OracleType.Number, TutorID);
 
    paramusp[1] = objBLDal.CreateOutParameter("ocursor", OracleType.Cursor);
 
    dt = objBLDal.GetDataTableStoreProcedure("SESSION_ROUTING.Tutor_course_details", paramusp, 1);
 
    if (dt != null && dt.Rows.Count > 0)
    {
        objCourses = (from DataRow _ctx in dt.Rows
                      select new TutorProfileupdate
                      {
                          CourseID = _ctx["COURSE_ID"] == DBNull.Value ? "" : _ctx["COURSE_ID"].ToString(),
                          CourseName = _ctx["Coursename"] == DBNull.Value ? "" : _ctx["Coursename"].ToString(),
                          SubjectId = _ctx["subject_id"] == DBNull.Value ? "" : _ctx["subject_id"].ToString(),
                          Subject = _ctx["subjectname"] == DBNull.Value ? "" : _ctx["subjectname"].ToString(),
                          SchoolLevel = _ctx["title"] == DBNull.Value ? "" : _ctx["title"].ToString(),
                          SchoolLevelId = _ctx["school_level_id"] == DBNull.Value ? "" : _ctx["school_level_id"].ToString()
                      }).ToList();
       // var str = (string.Join(",", objCourses.Select(x => x.CourseID.ToString()).ToArray()));
    }
    return Json(objCourses, JsonRequestBehavior.AllowGet);
}

var tutcoursUrl = '@Url.Action("GetCoursetut", "Common", new { Area = "" })';
$.ajax({
    type: "GET",
    url: tutcoursUrl,
    data: {
        'TutorID': selectedtutorID
    },
    contentType: "application/json; charset=utf-8",
    dataType: "json",
    success: function (data) {
        debugger;
        if (data != undefined && data.length > 0) {
 
            $.each(data, function (i, Tutor) {
                debugger;
                selectedCourses += Tutor.CourseName + ',';
                selectedCoursesId += Tutor.CourseID + ',';
                tab.append('<tr><td name="sub">' + Tutor.Subject + '</td><td hidden name="subId">' + Tutor.SubjectId + '</td><td name="sclevl">' + Tutor.SchoolLevel + '</td><td hidden name="sclevlId">' + Tutor.SchoolLevelId + '</td><td name="selectdcours">' + selectedCourses + '</td><td hidden name="selectdcoursId">' + selectedCoursesId + '</td><td></td><td><button class="btnedit">Edit</button></td><td><button class="btndelete">Delete</button></td></tr>');
            });                       
        }
    },
    error: function (data) {
        alert("fail");
    }
});

Above is my code which i tried

Could you please help me in this as soon as possible?

Download FREE API for Word, Excel and PDF in ASP.Net

PrinceG

0 2

Reply
ANSWER
User: PrinceG
Replied: on Aug 20, 2022 06:45 AM
Report

Hi zeeshanpas,

Please refer below sample.

Model

public class TutorProfileupdate
{
    public string Subject { get; set; }
    public string School_level { get; set; }
    public string Course { get; set; }
}

Controller

public class HomeController : Controller
{
    // GET: Home
    public ActionResult Index()
    {
        return View();
    }

    [HttpPost]
    public JsonResult Index(string subject)
    {
        List<TutorProfileupdate> items = new List<TutorProfileupdate>();
        items.Add(new TutorProfileupdate { Subject = "Maths", School_level = "Elementary", Course = "ALgebra" });
        items.Add(new TutorProfileupdate { Subject = "Maths", School_level = "Elementary", Course = "Geometry" });
        items.Add(new TutorProfileupdate { Subject = "Maths", School_level = "Elementary", Course = "statistics" });
        items.Add(new TutorProfileupdate { Subject = "English", School_level = "Elementary", Course = "3rd grade english" });
        items.Add(new TutorProfileupdate { Subject = "English", School_level = "Elementary", Course = "4th grade english" });
        items.Add(new TutorProfileupdate { Subject = "Maths", School_level = "MiddleSchool", Course = "ALgebra" });
        items.Add(new TutorProfileupdate { Subject = "Maths", School_level = "MiddleSchool", Course = "Geometry" });
        items.Add(new TutorProfileupdate { Subject = "Maths", School_level = "MiddleSchool", Course = "statistics" });

        List<TutorProfileupdate> result = (items.GroupBy(x => new { x.Subject, x.School_level })
            .Select(x => new TutorProfileupdate
            {
                Subject = x.Key.Subject,
                School_level = x.Key.School_level,
                Course = string.Join(",", x.Select(y => y.Course))
            })).ToList();
        return Json(result, JsonRequestBehavior.AllowGet);
    }
}

View

@model ListComma_Seperated.Models.TutorProfileupdate

@{
    Layout = null;
}

<!DOCTYPE html>

<html>
<head>
    <meta name="viewport" content="width=device-width" />
    <title>Index</title>
</head>
<body>
    <div class="row">
        <div class="col-sm-12">
            <table id="tbl_NetworkList" style="width: 360px;" class="table table-hover table-bordered table-striped table-responsive">
                <thead>
                    <tr>
                        <th>
                            Subject
                        </th>
                        <th>
                            School_level
                        </th>
                        <th>
                            Course
                        </th>
                    </tr>
                </thead>
                <tbody id="tblBody_NetworkList"></tbody>
            </table>
        </div>
    </div>
    <script type="text/javascript" src="https://ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js"></script>
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css" />
    <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.2/css/bootstrap.min.css" />
    <script type="text/javascript">
        $(function () {
            $.ajax({
                type: "POST",
                url: "/Home/Index",
                data: '{}',
                contentType: "application/json; charset=utf-8",
                dataType: "json",
                success: function (r) {
                    var tableBody = $('#tblBody_NetworkList');
                    $.each(r, function (index, item) {
                        tableBody.append('<tr><td name="sub">' + item.Subject + '</td><td name="sclevl">' + item.School_level + '</td><td name="selectdcours">' + item.Course + '</td><td class="btncolwidth"><ul class="icons-link"><li><a name="btn_EditNewtork"  href="javascript:void(0);" title="Click on this link to edit Network details."><i class="fa fa-pencil"></i><span class="pl5 s10">Edit</span></a><li><li><a name="btn_DeleteNewtork" value="Edit"  href="javascript:void(0);" style="margin-left:15px;" title="Click on this link to Delete."><i class="fa fa-trash-o"></i><span class="pl5 s10 ">Delete</span></a></li> </ul></td></tr>');
                    });
                },
                error: function (r) {
                    alert(r.responseText);
                }
            });
        });
    </script>
</body>
</html>

Screenshot

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

ASP.Net MVC: Merge (Combine) multiple rows value with comma separated in Linq

Company

Explore

Follow us

Contact Us