C# ASP.NET MVC 実験 – テックメモ

通常だとSQL Serverなどが定番だが、手軽に利用できるmdbを使ってみた。

using System.Collections.Generic;
using System.Web.Mvc;

using System.Data.OleDb;

namespace WebApplication2.Controllers
{
    public class HomeController : Controller
    {
        public ActionResult Test()
        {
            List<object> obj = new List<object>();
            obj.Add(new { id = 2, name = "taro" });
            obj.Add(new { id = 3, name = Request.Params["serial"] });

            return Json(obj);
        }

        public ActionResult Index()
        {
            List<string> list = new List<string>();
            using (OleDbConnection con = new OleDbConnection())
            {
                con.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + Server.MapPath("./") + @"\dat.mdb" + "";
                con.Open();

                OleDbCommand cmd = new OleDbCommand("select * from tbl",con);
                using (OleDbDataReader dr =cmd.ExecuteReader())
                {
                    while (dr.Read())
                    {
                        list.Add(dr["serial"].ToString());
                    }
                }

            }
            return View(list);
        }
    }
}

using System.Collections.Generic;

using System.Web.Mvc;

using System.Data.OleDb;

namespace WebApplication2.Controllers

{

public class HomeController : Controller

{

public ActionResult Test()

{

List<object> obj = new List<object>();

obj.Add(new { id = 2, name = "taro" });

obj.Add(new { id = 3, name = Request.Params["serial"] });

return Json(obj);

}

public ActionResult Index()

{

List<string> list = new List<string>();

using (OleDbConnection con = new OleDbConnection())

{

con.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + Server.MapPath("./") + @"\dat.mdb" + "";

con.Open();

OleDbCommand cmd = new OleDbCommand("select * from tbl",con);

using (OleDbDataReader dr =cmd.ExecuteReader())

{

while (dr.Read())

{

list.Add(dr["serial"].ToString());

}

return View(list);

}

@model List<string>

@foreach (string item in Model)
{
    @item;
}

<form action="" method="post">
    AAA：
    <input type="text" id="txt" value="AAA" /><br />
    BBB：
    <input type="text" id="txt" value="BBB" />
    <input type="button" id="btn" value="送信" />
</form>

<script>
        
    $(document).on("click", "#btn", function () {
        SayHello("");
    });

    function SayHello(msg) {

        var serial = $("#txt").val();

        $.ajax({
            type: "POST", url: "/Home/Test", acync: false,
            data: {
                serial: serial
            },
            dataType: 'json',
            success: function (json) {

                for (var i = 0; i < json.length; i++){
                    alert(json[i].name);
                }
                alert(msg);
            }, error: function () {
                alert("NG");
            }
        });
    }
</script>

@model List<string>

@foreach (string item in Model)

{

@item;

}

AAA：

BBB：

</form>

$(document).on("click", "#btn", function () {

SayHello("");

});

function SayHello(msg) {

var serial = $("#txt").val();

$.ajax({

type: "POST", url: "/Home/Test", acync: false,

data: {

serial: serial

dataType: 'json',

success: function (json) {

for (var i = 0; i < json.length; i++){

alert(json[i].name);

}

alert(msg);

}, error: function () {

alert("NG");

}

});

}

</script>