is there any missing to contact with my table in sql?

Question

1.00/5 (3 votes)

See more:

Razor

@{
    ViewBag.Title = "Getdata";
    <script src="~/Scripts/jquery-2.1.3.min.js"></script>
    <script>

        $(document).ready(function () {
            $("#btn").click(function () {
                $("#text1").val("");

                $.get("/country/Create", {}, function (data) {
                    $.each(data, function (index, row) {
                        $("#tb1").append("<table><tbody><tr><td>" + row.ID + "</td><td>" + row.Name + "</td></tr></tbody></table>");
                    });
                });
            });
        });
    </script>
}


country:<input type="text" id="text1" />
<input type="button" value="Add" id="btn" />

Posted 17-Feb-15 3:25am

Sedeek Mohamed Reda

Updated 17-Feb-15 8:18am

v4

Add a Solution

Comments

phil.o 17-Feb-15 9:31am

Not a question. Just a code dump without any explanation.
Please see CodeProject QA FAQ

[no name] 17-Feb-15 9:36am

hi there,Because its belong to the firs page i have sent or first question

phil.o 17-Feb-15 9:54am

Still, this post does not qualify as a valid question in itself. If you want to bring some more informations on your previous question, click the improve button in it and add informations there.

King Fisher 17-Feb-15 13:52pm

not clear.update your question with some information

Sergey Alexandrovich Kryukov 17-Feb-15 16:15pm

Missing?! You are not showing anything related to SQL at all, only HTML and JavaScript.
—SA

[no name] 17-Feb-15 16:52pm

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using Project1.Models;
namespace Project1.Controllers
{
public class countryController : Controller
{
//
// GET: /country/

public ActionResult Index()
{
return View();
}

[HttpGet]
public ActionResult Create() {

return View();

}
[HttpPost]
public JsonResult Create(string name)
{
country co = new country();
co.Name = name;

dbproject1Entities db = new dbproject1Entities();
db.country.Add(co);
db.SaveChanges();
return Json(db.country.Where(x => x.Name.Contains(name)).ToList(), JsonRequestBehavior.AllowGet);

}
}
}

1 solution

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)

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) · Answer 1 · 2015-02-17T20:00:00

One thing I marked here is that you are making tables for each data row returned. But I don't think you needed that. Ideally all the rows should be in a Table.

So, the below code...

JavaScript

$.get("/country/Create", {}, function (data) {
    $.each(data, function (index, row) {
        $("#tb1").append("<table><tbody><tr><td>" + row.ID + "</td><td>" + row.Name + "</td></tr></tbody></table>");
    });
});

should be like...