如何在MVC4上执行类似的操作？ [英] How to perform like operation on MVC4 ?

问题描述

Actual am fresher in I.T, This is my sql server query.. i need to implement on my project MVC ... can u explain or guide me how to do this in mvc ??


select * from tblBusinessCategory as b
inner join tblUser as u
on b.BusinessID=u.BusinessCategoryId
inner join tblAddress as a
on u.AddressId=a.AddressID
where u.BusinessCategoryId in
   (select BusinessCategoryId from tblBusinessCategory where BusinessCategory LIKE '%d%'
    UNION
    select BusinessCategoryId from tblBusinessCategory where BusinessName like '%d%'
    UNION
    select BusinessCategoryId from tblBusinessCategory where BusinessDescription like '%d%')



My controller

       public ActionResult Index(string txtValue)
        {
            var s = txtValue.ToString();
            Session["searched"] = s;
            if (txtValue.Length > 0)
            {
                string[] keywords = txtValue.Trim().Split(new string[] { " " }, StringSplitOptions.RemoveEmptyEntries);

                return View(list);
            }
            else
            {
                ViewBag.Message = true;
                return View();
            }
        }

MY view:

<div class="searchform cf">
    @using (Html.BeginForm())
    {
        <input type="text" name="txtValue" id="txtValue" value="@Session["searched"]" placeholder="Need more ?">

        <button type="submit" value="Search" style="margin-top: 5px;">Search</button>
    }
</div>
<div style="margin: 35px 0px 0px 90px">

    @if (ViewBag.Message == true)
    {
        <label id="lblMessage" title="Please enter keyword" style="color:red;">Please enter keyword...!</label>
    }
    else
    {
        if (Model != null)
        {
            if (Model.Count() != 0)
            {

                <div>
                    <h2 style="font-size: 15px;">Searched for "<i style="  padding: 0px 10px; color: #595FFF;">@Session["searched"]</i>"</h2>
                </div>

                <div>
                    @foreach (var item in Model)
                    {

                        <b style="margin-left: -8px; font-size: large;color: #2B9CE2;">
                            @Ajax.ActionLink(@item.bName, "Businessdetails", "Search", new { id = item.bID }, null)
                        </b>
                        <div class="hover">
                            test
                        </div>
                        <h3 style="margin: 0px;">@item.bCategory</h3>
                        <h4 style="margin: 5px 0px 5px 0px;color: rgb(0, 145, 0);">@item.AddressID</h4>
                    <h4 style="margin: 5px 0px 5px 0px;color: rgb(0, 145, 0);">@item.UserID</h4>
                        <h4 style="margin: 5px 0px 5px 0px;color: rgb(0, 145, 0);">@item.MobileNumber</h4>
                        <h4 style="margin: 5px 0px 5px 0px;color: rgb(0, 145, 0);">@item.City</h4>
                    <h4 style="margin: 5px 0px 5px 0px;color: rgb(0, 145, 0);">@item.bDescription</h4>
                    }
                </div>
            }
            else
            {
                <label id="lblErrorMsg" title="Record not fount...!" style="color:red;">Record not found...!</label>
            }
        }
    }

推荐答案

使用ado.net



了解ADO.NET的初学者教程 [ ^ ]

Use ado.net

A Beginner's Tutorial for Understanding ADO.NET[^]

这篇关于如何在MVC4上执行类似的操作？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！