Visual basic.net: retrieve data from SQL server Database and display in textbooks-VB.net

Поделиться
HTML-код
  • Опубликовано: 20 сен 2024

Комментарии • 32

  • @minus4642
    @minus4642 6 месяцев назад

    Thank you! This video has helped me immensely.

  • @j.m.2439
    @j.m.2439 Год назад

    thank you!! i was able to get a data using the code from your tutorial!! thank you very much!

  • @gustianrosadi1725
    @gustianrosadi1725 9 месяцев назад

    thanks bro appreciate your help

  • @Haval.M5
    @Haval.M5 Год назад

    Just curious on why you used a DataSource, seems like that you could've achieved the data pull with your SQL statements? Sorry, I'm fairly new to VB.
    Edit: Sorry, I looked again, you used it to pull the Data Source info for the connection lol. My bad.

  • @AnandKumar-fo8rb
    @AnandKumar-fo8rb 4 года назад

    Thank you data searched successfully

  • @layuggeralddanao9715
    @layuggeralddanao9715 2 года назад

    THANKYOU VERY MUCH !!!!!!!!!!

  • @yashasjoo4480
    @yashasjoo4480 3 года назад +3

    Hii .. I used used u r code , I'm using my SQL and vb.net2019 . I'm getting eror like conn is nothing ...it's not working

  • @gerardogonzalez184
    @gerardogonzalez184 3 года назад

    Muchas gracias

  • @enochnanaasare4102
    @enochnanaasare4102 4 года назад +3

    hi, i tried using your code for retrieving data from sql server database and displaying in textbox using vb.net and i had incorrect syntax near "=". and the error was on myreader = cmd.ExecuteReader, how do i resolve that?

    • @programmingforeverybody
      @programmingforeverybody  4 года назад

      are you type code like video , sure from type fields

    • @mulanovaart5367
      @mulanovaart5367 3 года назад

      i faced the same challenge, did you end up finding the solution?

    • @peterkearns2749
      @peterkearns2749 2 года назад

      i had the same and i had a space in the database naming e.g. Coca Cola and the correction of Cocacola fixed this problem. I had the same problem when the heading of my database did not match the code i put in.

    • @Haval.M5
      @Haval.M5 Год назад

      I am getting this same error. I am typing a alphanumeric in the textbox1 field. Like 12A345-6789.

  • @christianchristian6208
    @christianchristian6208 3 года назад +1

    i tried your code but i had a invalid attempt to read when no data is present. but i have data in my sql database, how can i fix this?

  • @afiqahjumali6308
    @afiqahjumali6308 3 года назад +1

    Hi, i wanna ask... is Sql server database same with phpmyadmin?? Or i need to install some apps?

    • @programmingforeverybody
      @programmingforeverybody  3 года назад

      you need some program>>> see this video>>>>
      ruclips.net/video/dEEkaz3WE_c/видео.html

  • @mhd911
    @mhd911 4 года назад +1

    Hi , how can i check the record count ?

  • @abdokethoney5029
    @abdokethoney5029 Год назад

    If no. Data in sql... Retrive Null... Mske if statment for. Reader

  • @anomolisagag2270
    @anomolisagag2270 3 года назад

    i was searching for, how to retrieve data from database and store it to visual basic variable
    for example, u have "first name" in a database, and u store it in "Dim name as String"...
    how do we do that?

    • @anomolisagag2270
      @anomolisagag2270 3 года назад

      @@browndrex1547 umm, thku
      but since its 3 months ago, ive already figured it out

  • @saidali1009
    @saidali1009 2 года назад

    how to search from two table with views can you make

    • @programmingforeverybody
      @programmingforeverybody  2 года назад

      بنفس الفكرة اللي في الفيديو ده ولا شكل تاني ؟

    • @saidali1009
      @saidali1009 2 года назад

      @@programmingforeverybody اهلين اخي الكريم
      عملت مشروع بسيط عن طريق اس كيو أل وتم ربطة بالفيجوال بيسك
      الجدول الأول فيه البيانات التالية:
      الرقم المدني ( التكرار غير مقبول )
      الاسم
      تاريخ الميلاد
      هاتف العمل
      هاتف النقال
      العنوان
      الملاحظات
      الجدول الثاني
      الرقم المدني( السماح بالتكرار )
      التاريخ
      الراتب الشهري
      الخصم
      تم ربط الجدولين عن طريق( فيؤوview) وتم عمل فورم في الفيجوال بيسك دوت نت وتم استعداء الاستعلام ...
      اللي اريده منك يا اخي الكريم
      عند ادخال الرقم المدني تظهر جميع البيانات في الحقول
      واضافة باقي الخانات مثل الراتب الشهري والخصم
      مع إضافة زر الحفظ
      //// ولكم جزيل الشكر ///
      وفي ميزان حسناتك

    • @saidali1009
      @saidali1009 2 года назад

      أتمنى وصلت الفكرة
      والف شكر اخي الكريم

  • @mariadass226
    @mariadass226 3 года назад

    i used your code but im getting an error like invalid column name but when i give Username and fetch the last entered dat is shown what is the problem can you please help

    • @programmingforeverybody
      @programmingforeverybody  3 года назад

      invalid column name: this mean there is error column name in statement's select