none
ameliyathene progrogramı için boş olan ameliyathane tarih ve saate nasıl veri ekleyebilirim RRS feed

  • Question

  • ameliyathane randevu sistemi yapmaya çalışıyorum ama BOŞ olan tarih ameliyathane doktor ve saatte nasıl randevu aldırabilirim ameliyathane tablosundan ameliyathane, personel tablosundan doktor, ameliyat türü tablosundan ameliyat

    en aşağıdaki combobaxa da saatler tablosundan getir butonuna basınca boş olan tabloları getirmeyi planlıyordum ama 

    yapamadım şimdiden çok değerli görüşleriniz için teşekkür ediyorum.

    bunun sql sorgusunu oluşturamadım(öğrenciyim)

    Thursday, June 20, 2019 11:08 PM

All replies

  • Türkçe konuşamıyorum bu yüzden Google Translate kullanıyorum.

    Tablolar (oda, doktor vb.) İçin BindingSource oluşturmalı ve açılan kutulara bağlamanız gerekir.

    DoctorComboBox.DataSource = DoctorsBindingSource; DoctorComboBox.DisplayMember = "DoctorName"; DoctorBox.ValueMember = "DoctorID"; // doktorlar tablosundaki birincil anahtar DoctorComboBox.DataBindings.Add(new Binding("SelectedValue", DoctorsBindingSource, "AppointmentDoctor"));
    // AppointmentDoctor, randevu tablosundaki yabancı anahtar alandır

    Bu kodu formun yapıcısına veya Load olayına koyabilirsiniz. Bu kod yalnızca açılan kutuları başlatır. Ayrıca her tablonun tableadapter için Dolgu yöntemleri oluşturmanız gerekir.

    Kullanıcı tarihi girdiğinde, kodunuz o tarihi alabilir ve Dolgu yöntemi için argüman olarak kullanabilir.

    Umarım bu sana yardımcı olur! :)


    • Marked as answer by krky.bugraa Friday, June 21, 2019 11:08 AM
    • Unmarked as answer by krky.bugraa Friday, June 21, 2019 11:08 AM
    Friday, June 21, 2019 1:14 AM
  • Hi friend,

    Welcome to MSDN forum.

    I used Google translate and according to your description, you're having some trouble using Sql query statement in your code. Please check if Robert's answer helps resolving this issue, if it's helpful for solving your issue, please consider marking it as accepted answer, which will benefit others with similar issue.

    Also, since this is VS general forum, we talk about usage of VS Tools here. I will help move this thread to appropriate forum for you. Please let me know your project type and programming language you use.

    Looking forward to your reply!

    Best Regards

    Lance


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.


    Friday, June 21, 2019 2:57 AM
  • Merhaba

    Program olarak VS kullanıyorum.

    Veritabanında da SQL Server kullanıyorum.

    Benim yapamadığım nokta sql sorgusu. Teşekkürler

    Friday, June 21, 2019 11:00 AM
  • Size cevap için teşekkür ederim. I can not do if the sama date on the same doctor if the appoinment in  the same operating room to prevent the appointment.

    I'll be happy if you can help me.

    Thanks.

    Friday, June 21, 2019 11:15 AM
  • Hi friend,

    What language you use? C# or VB.net?

    Also, is the project you developed a winform app or WPF app? Please share more info here so that I can help move this thread to appropriate forum for better support.

    Thanks for your understanding!

    Best Regards

    Lance


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Monday, June 24, 2019 9:49 AM
  • Hi friend,

    Since this is English forum. And it seems you use the Turkish language, I suggest you open a new thread in Turkish forum, you can get more professional support there.

    Thanks for your understanding and cooperation.

    Have a nice day!

    Best Regards

    Lance


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Tuesday, June 25, 2019 3:23 AM