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

[@j.m.2439]

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

[@minus4642]

Thank you! This video has helped me immensely.

[@enochnanaasare4102]

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]

are you type code like video , sure from type fields

[@mulanovaart5367]

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

[@peterkearns2749]

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]

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

[@mhd911]

Hi , how can i check the record count ?

[@christianchristian6208]

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?

[@programmingforeverybody]

kzbin.info/www/bejne/aZvbfnt7bLeHrdk this is solution

[@yashasjoo4480]

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

[@programmingforeverybody]

can you send me message error?

[@afiqahjumali6308]

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

[@programmingforeverybody]

you need some program>>> see this video>>>> kzbin.info/www/bejne/mnaonJSwaLx4lcU

[@gustianrosadi1725]

thanks bro appreciate your help

[@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]

Thank you data searched successfully

[@saidali1009]

how to search from two table with views can you make

[@programmingforeverybody]

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

[@saidali1009]

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

[@saidali1009]

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

[@abdokethoney5029]

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

[@programmingforeverybody]

kzbin.info/www/bejne/aZvbfnt7bLeHrdk

[@abdokethoney5029]

@@programmingforeverybody Do you have example of use isDbzNull command

[@abdokethoney5029]

@@programmingforeverybody Try email me to get. Work with you for my. Company..

[@programmingforeverybody]

[e-mail]

[@layuggeralddanao9715]

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

[@gerardogonzalez184]

Muchas gracias

[@anomolisagag2270]

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]

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

[@mariadass226]

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]

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