Visual basic.net: retrieve data from access database- in VB.net

[@ameloskii3086]

Finally, short precise and easy to understand. Exactly what I needed to dive into databases. Thanks very much.

[@programmingforeverybody]

thanks

[@harshsinghal2436]

Perfect ,small,easy , understandable code thank you sr

[@wandryparrapadilla2471]

Thannksssssss, from DR.

[@nasuhasri]

Sir, im getting error System.Data.OleDb.OleDbException: 'No value given for one or more required parameters.' at myReader code. I tried to find the solution but I dont understand it. How to fix this?

[@nasuhasri]

Update: I have find the solution. At mysql statement I used string as condition so i have to put ' '. Thank you sir! I love your tutorials. Currently your tutorials are my main reference for my project

[@programmingforeverybody]

kzbin.info/www/bejne/aZvbfnt7bLeHrdk

[@its_fhn]

@@nasuhasri i am facing a similar issue, can you elaborate the solution

[@nasuhasri]

@@its_fhn I got my sql wrong. Hence why vb do not get the value from user

[@ilhamhafiez5511]

@@nasuhasri how with Microsoft access?? I can't find my solution 🥺

[@rommellyndondagaas2117]

Sir how about using combobox instead of txtbox in filling up of the id or name? And using ms access as database.

[@programmingforeverybody]

ok

[@rommellyndondagaas2117]

Thank you so much sir.

[@rommellyndondagaas2117]

Sir, can I ask what version of visual basic you are using?

[@tahaahmed4273]

@@rommellyndondagaas2117 most likely 2019

[@jakedurante5307]

Can you show how to retrieve data automatically from just loading the system ? Thanks that would help a lot :)

[@programmingforeverybody]

yes

[@vdofficialchannel9841]

You just need to modify the code, copy and paste the code on the form load function. Hope this helps.

[@alial-zubaidi4662]

I always get error on myreader = cmd.ExecuteReader Why?

[@programmingforeverybody]

can you send me all code and fields database

[@alial-zubaidi4662]

@@programmingforeverybody it worked after I refreshed the server 🤔

[@programmingforeverybody]

@@alial-zubaidi4662 Ok

[@mulanovaart5367]

Hello, i tried using your code for retrieving data from access database and displaying in textbox using vb.net and i had incorrect syntax and the error was on myreader = cmd.ExecuteReader, how do i fix it?

[@programmingforeverybody]

Can you type code and fields database?

[@abdulh8958]

شرح ممتاز ولكن كيف اعمل تعديل او edit على access data base

[@programmingforeverybody]

kzbin.info/www/bejne/rYGzgaibrJidp6c

[@abdulh8958]

@@programmingforeverybody I got error system. Data.oledb.oledbexception: "syntax error (missing operator) in query expression 'spare parts'

[@abdulh8958]

I got error

[@programmingforeverybody]

What's Error?

[@abdulh8958]

@@programmingforeverybody I got error system. Data.oledb.oledbexception: "syntax error (missing operator) in query expression 'spare parts'