Bind multiple PartialViews in same page using DataSet in ASP.Net MVC

nauna

SOLVED CLOSED ACTIVE ANSWERED
User: nauna
Posted: on May 01, 2019 08:03 AM
Forum: ASP.Net MVC
Answer: 1
Views: 6150
Sample Code: Download

hello,

i have two partial view which needs to be bind with data base i have bind one like this and call it on index page

this is working now i have another partial view which needs to be call on index page so can i call its methods pass it on index method to pass data to partial view

        public ActionResult Index()
        {
            //Call first category in top category menu partial layout
            DataTable ds = new DataTable(); 
            CategoriesBL fc = new CategoriesBL();
            ds = fc.SelectFirstCategoriesBL();
            //how to send second partial view data by calling its method view will take only one ds
            return View(ds);
        }

using System.Data
@model DataTable

@foreach (DataRow row in Model.Rows)
{
    <li class="dropdown megamenu-fw">
    <a>@row["gender"]</a>
    <ul class="dropdown-menu fullwidth" style="display: none;">
        <li class="megamenu-content">
            <div class="mega-content">
                <div class="mega__item">
                    <h6>
                        <a>Second CAtegory</a>
                    </h6>
                    <small>
                        <ul>
                            <li><a># level</a></li>
                        </ul>
                    </small>
                </div>
            </div>
        </li>
    </ul>
</li>    
}

<div class="col-md-3 no-padding">
    <div class="p-data">
        <div class="ribbon-featured"><div class="ribbon-start"></div><div class="ribbon-content">20% Off </div><div class="ribbon-end"><figure class="ribbon-shadow"></figure></div></div>
        <div class="img-box">
            <img src="~/images/image-06.jpg" />
        </div>
        <div class="d-box">
            <span class="mark"> New </span>
            <p class="price">205.00 <span class="sticke">20</span></p>
            <p class="bg">
                <span> <i class="far fa-calendar-alt"></i> Date</span>
                <span class="pull-right"> <i class="fa fa-user"></i> username</span>
            </p>
            <p class="title">
                AlexVyan Black Universal Bike Motorcycle Cycle Mou

                <br /><br />
                <a class="d-btn">Detail</a>
            </p>
        </div>
    </div>
</div>

method to bind second partial view

        public DataTable SelectAllAds()
        {
            using (SqlConnection con = new SqlConnection(constring))
            {
                using (SqlCommand cmd = new SqlCommand("sp_ads", con))
                {
                    cmd.CommandType = CommandType.StoredProcedure;
                    cmd.Parameters.AddWithValue("@Action", "SelectAll");
                    DataTable dt = new DataTable();
                    con.Open();
                    using (SqlDataAdapter sda = new SqlDataAdapter(cmd))
                    {
                        sda.Fill(dt);
                    }
                    con.Close();
                    return dt;
                }
            }

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

dharmend...

0 4

Reply
ANSWER
User: dharmendr
Replied: on May 02, 2019 03:49 AM
Report

Hinauna,

Instead of returning DataTable from Index action method return DataSet and pass the DataSet to the View.

Refer below article for passing DataSet to View.

Check this example. Now please take its reference and correct your code.

Controller

public class HomeController : Controller
{
    // GET: /Home/
    public ActionResult Index()
    {
        System.Data.DataSet ds = new System.Data.DataSet();
        ds.Tables.Add(SelectFirstCategories());
        ds.Tables.Add(SelectAllAds());
        return View(ds);
    }

    private System.Data.DataTable SelectFirstCategories()
    {
        System.Data.DataTable dt = new System.Data.DataTable();
        dt.TableName = "Category";
        dt.Columns.AddRange(new System.Data.DataColumn[2] { 
            new System.Data.DataColumn("Id", typeof(int)), 
            new System.Data.DataColumn("Name", typeof(string)) });
        dt.Rows.Add(1, "Category 1");
        dt.Rows.Add(2, "Category 2");
        dt.Rows.Add(3, "Category 3");
        dt.Rows.Add(4, "Category 4");

        return dt;
    }

    private System.Data.DataTable SelectAllAds()
    {
        System.Data.DataTable dt = new System.Data.DataTable();
        dt.TableName = "Ads";
        dt.Columns.AddRange(new System.Data.DataColumn[2] { 
            new System.Data.DataColumn("Id", typeof(int)), 
            new System.Data.DataColumn("Name", typeof(string)) });
        dt.Rows.Add(1, "Ads 1");
        dt.Rows.Add(2, "Ads 2");
        dt.Rows.Add(3, "Ads 3");
        dt.Rows.Add(4, "Ads 4");

        return dt;
    }
}

View

<%@ Page Language="C#" Inherits="System.Web.Mvc.ViewPage<System.Data.DataSet>" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>Index</title>
</head>
<body>
    <h3>Categories</h3>
    <table>
        <tr>
            <th>Id</th>
            <th>Name</th>
        </tr>
        <%foreach (System.Data.DataRow row in Model.Tables[0].Rows) {%>
        <tr>
            <td><%=row["Id"]%></td>
            <td><%=row["Name"]%></td>
        </tr>
        <%} %>
    </table>
    <hr />
    <h3>Ads</h3>
    <table>
        <tr>
            <th>Id</th>
            <th>Name</th>
        </tr>
        <%foreach (System.Data.DataRow row in Model.Tables[1].Rows) {%>
        <tr>
            <td><%=row["Id"]%></td>
            <td><%=row["Name"]%></td>
        </tr>
        <%} %>
    </table>
</body>
</html>

Screenshot

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

Bind multiple PartialViews in same page using DataSet in ASP.Net MVC

Using DataSet (DataTable) as Model in View in ASP.Net MVC

Company

Explore

Follow us

Contact Us