How to retrieve values from database?

Question

0.00/5 (No votes)

See more:

How Do I retrieve the database table values and fill them in to html table depends up on my html text box value in my MVC4 project. I am new to MVC, please help me to do this. Thank you.

I have code like bellow

MODEL is:

C#

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.ComponentModel.DataAnnotations.Schema;
using System.ComponentModel.DataAnnotations;
using System.Data.Entity;

namespace MvcTabletest.Models
{
    [Table("tbl_mainProducts")]
    public class orderfromcatalog
    {
        [Key]
        public int ID { get; set; }
        public string str_CatID { get; set; }
        public string str_SpecialDietID { get; set; }
        public string str_BrandID { get; set; }
        public string str_Description { get; set; }
        public string str_summery { get; set; }
        public string str_ImagePath { get; set; }
        public string Item_ID { get; set; }
        public decimal dec_Price { get; set; }

    }
    public class MainProductsContext : DbContext
    {
        public DbSet<orderfromcatalog> arderfromcatalog { get; set; }
    }

}

VIEW :

XML

<html>
<head>
</head>
<body>
<form id="quickbuy" c action="" method="post">

    <table class="qbTable" cellpadding="0" cellspacing="0" border="1">
            <tr>
                <th class="qbItemIndex">&nbsp;</th>
                <th class="qbItemNumber">Item Number</th>
                <th class="qbItemQty">Qty</th>
                <th class="qbItemDesc">Product Details</th>
                <th class="qbItemUtil">&nbsp;</th>
                <th class="qbItemPrice">Price</th>
                <th class="qbItemTotal">Total</th>
            </tr>

            <tr id="qbItemRow-1">
                <td class="qbItemIndex">1</td>
                <td class="qbItemNumber">
                    <input id="Item_ID" name="" onchange="" type="text" value="" size="9" maxlength="12"/>
                </td>
                <td class="qbItemQty">

                </td>
                <td class="qbItemDesc">
                    <div id="desc-1"></div>
                </td>
                <td class="qbItemUtil">
                </td>
                <td class="qbItemPrice">
                    <div id="price-1"></div>
                </td>
                <td class="qbItemTotal">
                    <div id="total-1"></div>
                </td>
            </tr></form></table>
</body>
</html>

Posted 16-Sep-14 21:46pm

RAJU Kandarapu

Updated 26-Sep-14 1:17am

Kenneth Haugland

v3

Add a Solution

Comments

Kornfeld Eliyahu Peter 17-Sep-14 3:54am

And the question is?

RAJU Kandarapu 27-Sep-14 3:23am

When i enter the Item Number, i want to retrive Product Details and price from sql database

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Suraj Sahoo | Coding Passion · Answer 1 · 2014-10-07T23:37:00

You need to have a controller action Like

C#

public ActionResult GetProductDetails(int id)
{
    //call your service method where you do the context changes.
    var details = _abcService.GetProductDetails(id);
    var viewModel = new ProductViewModel
        {
            product = details //this would be a list of type product class.
        }
    return View(viewModel);
}

View Model would go as below

C#

public List<product> products{get; set;}

</product>

Please comment with any doubt you have
Thanks
:)

I will help you · Answer 2 · 2014-09-26T03:29:00

Controller:

C#

public class MainProductsController : Controller
{
    private MainProductsContext db = new MainProductsContext ();

    public ActionResult Index()
    {
        return View(db.arderfromcatalog.ToList());
    }
}

Index View:

C#

@model IEnumerable<mvctabletest.models.orderfromcatalog> 
[...].@foreach (var item in Model) {
    <tr>
        <td>
            @Html.DisplayFor(modelItem => item.ID)
        </td>
        <td>
            @Html.DisplayFor(modelItem => item.str_CatID)
        </td>
        <td>
            @Html.DisplayFor(modelItem => item.str_BrandID)
        </td>        
    </tr>
}
[...].</mvctabletest.models.orderfromcatalog>

How to retrieve values from database?

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0