Problem Solved, https:
.Net Core Mvc 5.0
Startup.cs
using Newtonsoft.Json.Serialization;
public void ConfigureServices(IServiceCollection services)
{
services.AddControllersWithViews();
services.AddControllers().AddJsonOptions(jsonOptions =>
{
jsonOptions.JsonSerializerOptions.PropertyNamingPolicy = null;
});
}
Controller.cs
[HttpGet]
public IActionResult Get_DataBukuByID(string Kode_Buku)
{
BukuModel buku = new BukuModel();
using (SqlConnection con = new SqlConnection(this._configuration.GetConnectionString("db_perpustakaan")))
{
using (SqlCommand cmd = new SqlCommand())
{
con.Open();
cmd.Connection = con;
cmd.CommandType = CommandType.Text;
cmd.CommandText = "Select Judul, Penulis, Penerbit From Buku Where Kode_Buku = '" + Kode_Buku.Trim() + "'";
cmd.Parameters.AddWithValue("@Kode_Buku", Kode_Buku);
using (SqlDataReader rdr = cmd.ExecuteReader())
{
if (rdr.Read())
{
buku.Judul = rdr["Judul"].ToString();
buku.Penulis = rdr["Penulis"].ToString();
buku.Penerbit = rdr["Penerbit"].ToString();
}
else
{
ViewBag.Message = "Kode Buku tidak ditemukan !!!";
}
}
}
}
return Json(buku);
}
<script type="text/javascript" lang="javascript">
$(document).ready(function () {
$('#Btn_Search_Kode_Buku').on("click", function () {
$.ajax({
url: "@Url.Action("Get_DataBukuByID", "Pinjaman")",
type: "GET",
contentType: "application/json;charset=UTF-8",
dataType: "json",
data: { Kode_Buku: $('#txt_Search_Kode_Buku').val() },
success: function (data) {
if (data !="") {
$('#txtJudul').val(data.Judul);
$('#txtPenulis').val(data.Penulis);
$('#txtPenerbit').val(data.Penerbit);
}
else {
window.alert(' error : ' + data.message);
}
}
});
});
});
</script>