I don't know how to write to SQL. Normally I can add name or id into class in View and write it to SQL on Controller side. But now I have 2 dropdownlists and I don't know how to write it to SQL My question is How can write html code ıd and name for going to İnsert SQL ? (I know picture 1 for text but I dont know @Html.RenderAction Please Help me !! 5 4 3 2 (I know UserName and UserSurName how can add with html ) 1

a <select> just posts its name and selected value just like a text box. If you are trying to get both the value and text, you have two options: on postback regenerate the city list, and lookup the text by the passed value (best method) with javascript copy the text to a hidden field when a value is selected.

In order to perform an INSERT SQL operation using the values from the two dropdown lists in your HTML code, you'll need to utilize JavaScript or jQuery to capture the selected values from the dropdowns . Then, you can send an AJAX request to the controller with the selected values, where you'll handle the database insertion logic.

How can I do (Write Html Code with Controller ?)

Accepted answer

Lan Huang-MSFT 26,916 Microsoft Vendor

Hi @Harun Ergün,

I know picture 1 for text but I dont know @Html.RenderAction

You need to get the dropdown name like "input":

model.City = form["DrpSehir"].Trim();
model.City1 = form["Drpilce"].Trim();

User's image

(I know UserName and UserSurName how can add with html )

If I understand correctly, you want to persist the value on the page when the create button is clicked, you can return the model.

 return View(model);

Best regards,
Lan Huang

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Harun Ergün 260 Reputation points

2023-05-22T08:38:10.8766667+00:00

Yes, it writes to sql but not as text but with SQL id. I want text how can ı do ?
Lan Huang-MSFT 26,916 Reputation points Microsoft Vendor

2023-05-22T10:09:52.2766667+00:00

Hi @Harun Ergün,

It may be a code design problem, I think you need to provide all the code about DropDownList, so we can know where your problem is.

Based on the code you've provided so far, I think you can change the value to text.
Harun Ergün 260 Reputation points

2023-05-22T10:43:49.2+00:00

I try and Drpilce came to text but DrpSehir same. DrpSehir came to number
AgaveJoe 26,256 Reputation points

2023-05-22T12:45:48.37+00:00

If I understand correctly, the ilcegetir action is returning an ID but you expect text. You have not shared the ilcegetir action or the return type so we can only guess how the design works. IS there anyway you can share the relevant code?

As requested in your other threads, please paste the actual code not a screenshot, it is much easier to help when we have the code.

Harun Ergün 260

using Newtonsoft.Json.Linq;
using Newtonsoft.Json;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using WebApplication1.Models;
using System.Globalization;
using Microsoft.Ajax.Utilities;
using System.Web.WebPages;
using System.Xml.Linq;
using System.Web.UI.WebControls;
using System.ComponentModel.DataAnnotations;
using System.Runtime.CompilerServices;
using System.Security.Cryptography.X509Certificates;
using System.Runtime.Remoting.Contexts;

namespace WebApplication1.Controllers
{
    public class FormExample1Controller : Controller
    {

        ISKOMENUEntities3 context = new ISKOMENUEntities3();
        public ISKOMENUEntities3 ISKOMENUEntities { get; private set; }
        public object Email { get; private set; }



        // GET: FormExample1
        ISKOMENUEntities3 db = new ISKOMENUEntities3();

        Class1 cs = new Class1();

        public ActionResult Deneme()
        {
            

            cs.Sehirler = new SelectList(db.Tbliller, "id", "ad");
            cs.ilceler = new SelectList(db.tblilceler, "ilceid", "ilcead");


            return View(cs);
        }

        public JsonResult ilcegetir(int p)
        {
            var ilceler = (from x in db.tblilceler
                           join y in db.Tbliller on x.Tbliller.id equals y.id
                           where x.Tbliller.id == p
                           select new
                           {
                               Text = x.ilcead,
                               Value = x.ilceid.ToString()
                           }).ToList();
            return Json(ilceler, JsonRequestBehavior.AllowGet);
        }


        

        
        public ActionResult Create()
        {
            return View();
        }
        [HttpPost]
        public ActionResult Create(FormCollection form)
        {
            
            ISKOMENUEntities3 db = new ISKOMENUEntities3();
            Users1 model = new Users1();


            model.UserName = form["UserName"].Trim();

            model.UserSurName = form["UserSurName"].Trim();

            model.City = form["DrpSehir"].Trim();

            model.City2 = form["Drpilce"].Trim();

            model.Gender = Int16.Parse(form["Gender"]);

            model.Military = Int16.Parse(form["Military"]);

            model.Marital = Int16.Parse(form["Marital"]);

            model.Phone = form["Phone"].Trim();

            model.Phone2 = form["Phone2"].Trim();
            model.Email = form["Email"].Trim();

            

            if (form["lisansBaslangicTarih"] != "")
                model.LisansBaslangicTarih = DateTime.Parse(form["lisansBaslangicTarih"]);
            if (form["lisansBitisTarih"] != "")
                model.LisansBitisTatih = DateTime.Parse(form["lisansBitisTarih"]);

            model.YabanciDil = form["YabanciDil"];

            model.YabanciDil2 = form["YabanciDil2"];

            model.KayitTarihi = DateTime.Today;

            db.Users1.Add(model);
            db.SaveChanges();
            return View();




        }

         


    }
}


@{
    ViewBag.Title = "ISKO DÜNYASINA HOŞGELDİNİZ!";
    Layout = "~/Views/Shared/_Layout.cshtml";
}

<script src="~/Scripts/jquery-3.6.4.js"></script>
<link href="~/Content/bootstrap.min.css" rel="stylesheet" />

<br />
<br />
<body>

    <form action="/FormExample1/Create" method="post" class="was-validated" onsubmit="return demo()">
        @*Text*@
        <div class="mb-3">
            <label for="isimgiris" class="form-label">İsim</label>
            <input type="text" name="UserName" ıd="UserName" class="form-control" placeholder="İsim Giriniz.." required>
            <div class="invalid-feedback">
                Lütfen İsminizi Giriniz!
            </div>
            <div class="valid-feedback">
                Güzel Görünüyor!
            </div>
        </div>


        <div class="mb-3">
            <label for="soyisimgiris" class="form-label">Soyisim</label>
            <input type="text" name="UserSurName" class="form-control" placeholder="Soyisim Giriniz.." required>
            <div class="invalid-feedback">
                Lütfen Soyisminizi Giriniz!
            </div>
            <div class="valid-feedback">
                Güzel Görünüyor!
            </div>
        </div>
        @*DROPDOWNLİST-WİTH-SQL*@



        @{Html.RenderAction("Deneme");}







        <br />
        @*RADİO BUTTON*@
        <div class="form-group">
            <label>Cinsiyet :</label>
            <br />
            <br />
            <div class="form-check">
                <input type="radio" class="form-check-input" id="Gender" required="" name="Gender" value="0" checked>Erkek
                <label class="form-check-label" for="radio1"></label>
            </div>
            <div class="form-check">
                <input type="radio" class="form-check-input" id="Gender" required="" name="Gender" value="1">Kadın
                <label class="form-check-label" for="radio2"></label>
            </div>
        </div>
        <br />
        <br />
        <div class="form-group">
            <label>Aslerlik Durumu :</label>
            <br />
            <br />
            <div class="form-check">
                <input type="radio" class="form-check-input" id="Military" required="" name="Military" value="0" checked>Yapıldı
                <label class="form-check-label" for="radio1"></label>
            </div>
            <div class="form-check">
                <input type="radio" class="form-check-input" id="Military" required="" name="Military" value="1">Tecilli
                <label class="form-check-label" for="radio2"></label>
            </div>
            <div class="form-check">
                <input type="radio" class="form-check-input" id="Military" required="" name="Military" value="2">Muaf
                <label class="form-check-label" for="radio2"></label>
            </div>
        </div>
        <br />
        <br />
        <div class="form-group">
            <label>Evlilik Durumu :</label>
            <br />
            <br />
            <div class="form-check">
                <input type="radio" class="form-check-input" id="Marital" required="" name="Marital" value="0" checked>Evli
                <label class="form-check-label" for="radio1"></label>
            </div>
            <div class="form-check">
                <input type="radio" class="form-check-input" id="Marital" required="" name="Marital" value="1">Bekar
                <label class="form-check-label" for="radio2"></label>
            </div>
        </div>
        <br />
        <br />
        @*Text*@
        <div class="mb-3">
            <label for="telefon1" class="form-label">Telefon</label>
            <input type="number" name="Phone" required="" class="form-control" placeholder="0(XXX) XXX-XX-XX">
            <div class="invalid-feedback">
                Lütfen Telefon Giriniz!
            </div>
            <div class="valid-feedback">
                Güzel Görünüyor!
            </div>

        </div>
        <div class="mb-3">
            <label for="telefon2" class="form-label">Telefon 2</label>
            <input type="number" name="Phone2" required="" class="form-control" placeholder="0(XXX) XXX-XX-XX">
            <div class="invalid-feedback">
                Lütfen Telefon Giriniz!
            </div>
            <div class="valid-feedback">
                Güzel Görünüyor!
            </div>

        </div>
        <div class="mb-3">
            <label for="emailgiris" class="form-label">Email</label>
            <input type="email" name="Email" required="" class="form-control" placeholder="Mail giriniz..">
            <div class="invalid-feedback">
                Lütfen Email Giriniz!
            </div>
            <div class="valid-feedback">
                Güzel Görünüyor!
            </div>
        </div>

        @*TARİH*@

        <div class="mb-3">
            @Html.Label("Tarih", "Lisans Başlangıç Tarihi", htmlAttributes: new { @class = "control-label col-mb-3" })
            <div class="mb-3">

                <input type="date" class="form-control" id="lisansBaslangicTarih" required="" name="lisansBaslangicTarih" placeholder="Lisans Başlangıç Tarihi Giriniz..">
                <div class="invalid-feedback">
                    Lütfen Lisans Başlangıç Tarihini Giriniz!
                </div>
                <div class="valid-feedback">
                    Güzel Görünüyor!
                </div>
            </div>
        </div>
        <br />
        <div class="mb-3">
            @Html.Label("Tarih", "Lisans Bitiş Tarihi", htmlAttributes: new { @class = "control-label col-mb-3" })
            <div class="mb-3">

                <input type="date" class="form-control" id="lisansBitisTarih" required="" name="lisansBitisTarih" placeholder="Lisans Bitiş Tarihi Giriniz..">
                <div class="invalid-feedback">
                    Lütfen Lisans Bitiş Tarihi Giriniz!
                </div>
                <div class="valid-feedback">
                    Güzel Görünüyor!
                </div>
            </div>
        </div>
        <br />

        @*DROPDOWNLİST*@
        <div class="mb-3">
            <label class="form-check-label" for="exampleCheck1">Yabancı Dil </label>
            <div class="dropdown">

                <select id="YabanciDil" name="YabanciDil" class="form-control" placeholder="Yabancı Dil Seçiniz..">
                    <option value="" disabled selected hidden>Yabancı Dil</option>
                    <option>İngilizce</option>
                    <option>Fransızca</option>
                    <option>Almanca</option>
                </select>
            </div>

        </div>
        <div class="mb-3">
            <label class="form-check-label" for="exampleCheck1"> Seviye </label>
            <div class="dropdown">

                <select id="YabanciDil2" name="YabanciDil2" class="form-control" placeholder="Yabancı Dil Seviyesi Seçiniz..">
                    <option value="" disabled selected hidden>Seviye</option>
                    <option>Az</option>
                    <option>Orta</option>
                    <option>İyi</option>
                </select>
            </div>
        </div>

        <br />
        <br />
        @*BUTTON*@
        <center>
            <button type="submit" id="btn1" class="btn btn-info">Gönder</button>
        </center>

    </form>
</body>



<script>


    // Example starter JavaScript for disabling form submissions if there are invalid fields
    (function () {
        'use strict'

        // Fetch all the forms we want to apply custom Bootstrap validation styles to
        var forms = document.querySelectorAll('.needs-validation')

        // Loop over them and prevent submission
        Array.prototype.slice.call(forms)
            .forEach(function (form) {
                form.addEventListener('submit', function (event) {
                    if (!form.checkValidity()) {
                        event.preventDefault()
                        event.stopPropagation()
                    }

                    form.classList.add('was-validated')
                }, false)
            })
    })()


</script>

@model WebApplication1.Models.Class1
@{
    Layout = null;
}


<script src="~/Scripts/jquery-3.6.4.min.js"></script>
<link href="~/Content/bootstrap.min.css" rel="stylesheet" />

<script>
    $(function () {
        $('#DrpSehir').change(function () {
            var id = $('#DrpSehir').val();
            $.ajax({
                url: '/FormExample1/ilcegetir',
                data: { p: id },
                type: "POST",
                dataType: "Json",
                success: function (data) {
                    console.log(data);
                    $('#Drpilce').empty();
                    for (var i = 0; i < data.length; i++) {
                        $('#Drpilce').append("<option value='" + data[i].Text + "'>" + data[i].Text + "</Option>");
                    }
                }
            });
        });
    });</script>

<br />
<div class="mb-3">



    @Html.Label("iller")
    @Html.DropDownList("DrpSehir", Model.Sehirler, "---Seçiniz---", new { @class = "form-control" })
    <br />
    @Html.Label("ilçeler")
    @Html.DropDownList("Drpilce", Model.ilceler, "---Seçiniz---", new { @class = "form-control" })




</div>

AgaveJoe 26,256 Reputation points

2023-05-22T13:36:44.4066667+00:00
The ilcegetir action returns an anonymous type with Text and Value properties. The JavaScript code reads only the Text property. Change the code to set the option's value.

for (var i = 0; i < data.length; i++) { $('#Drpilce').append("<option value='" + data[i].Value + "'>" + data[i].Text + "</Option>"); }

If you are still having trouble then there could be other issues with the code that requires basic troubleshooting.
Harun Ergün 260 Reputation points

2023-05-22T13:43:14.6166667+00:00

When I choose your code caming ilcegetir is int. But my code ilcegetir came to Text my proplem's Drpsehir not came text. I want Drpsehir type text
AgaveJoe 26,256 Reputation points

2023-05-22T14:01:43.18+00:00

The screenshot might indicate a general design bug.

The IDs uniquely identity the text in the Tbliller and tblilceler tables. There should be a table that relates Tbliller and tblilceler IDs. Simply join the Tbliller and/or tblilceler to get the text by Id.
Lan Huang-MSFT 26,916 Reputation points Microsoft Vendor

2023-05-23T02:23:22.9466667+00:00
Hi @Harun Ergün,

I want Drpsehir type text

You can use linq to get the value of text by id.(I don't know your table, you can change the following fields according to your own data.)

int id =Convert.ToInt32( formCollection["DrpSehir"].Trim()); model.City= (from s in db.Tbliller where s.id == id select s.ad).FirstOrDefault();

Share via

How can I do (Write Html Code with Controller ?)

2 additional answers