C# - How To Search Values From MySQL Database And Set It Into TextBox In C# [with source code]

[@punamwaje1456]

This tutorial video is really helped me to complete my project... Thank you so much 🙏

[@FilthyLemon]

If I had a penny for every coding tutorial without somebody explaining...

[@1BestCsharpblog]

enter the id you want to search for, the id type i use in my database is integer so i have to convert the text id to integer, if a data exists with this id show it, if not show a message or ........ the source code in the description

[@jay-annoliveros5358]

hello how about instead of using textbox and button. Use combobox, does the code is still the same?

[@1BestCsharpblog]

use "comboBoxName.Text;"

[@jay-annoliveros5358]

@@1BestCsharpblog Thank you!! but do I really need to use a button? Can I just select a item in combobox then auto fetch the other data to the textbox?

[@sammypaige9286]

I came across your video and It helped me a lot but I'm wondering... I have a datagridview and wish to automatically select the searched data on it. Hope you can help me..

[@tragen13]

i want to use the getdata query instead of the sql commands, can you help?

[@yusufs8575]

Hi, is it the same code when you want to connect access database? not with sql

[@xmaster040]

3:21 I dont want to use int for my textbox because i also want to use letters what do i have to do?

[@1BestCsharpblog]

WHERE id = '" +TextBoxID.Text+ "'"

[@xmaster040]

thank you!

[@satyeshdubey1282]

how we can show fie path in fileupload like this after clicking button

[@coroomchannel414]

what about string (textbox) searching?

[@RodrigoSilva-eo6mv]

you are the best

[@OrderOfLemons]

Hi #1BestCsharp blog, I tried using this in my code: string sq = "SELECT * FROM new.users WHERE username=" + username_Txt.Text; - but resulted in an error. Is there a away to fix it up correctly?

[@1BestCsharpblog]

try this : string sq = "SELECT * FROM new.users WHERE username='" + username_Txt.Text+"'";

[@OrderOfLemons]

1BestCsharp blog thank you. worked :)

[@OrderOfLemons]

Another question, im getting an error with this: cmd.CommandText = "SELECT * from chat LIMIT " + cCfirst + "," + cClast + "'"; How do i word it correctly?

[@garudakurt5166]

@@1BestCsharpblog 'You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'Code=' at line 1. What's wrong with this I follow this format but I got this error message! I hope you can help me.

[@srilankann5947]

Sir how to Create barcode rdlc report c#

[@kamleshjha21]

please give this code in 3 layer architecture or make a video for this part in 3 layer architecture(files in 3 layer is DAL, BEL, BAL and last but not least is main page or a button_click))

[@nareshs3962]

use full video sir

[@alkadedhia2498]

Not working

[@efrainjoseejmj6579]

danilo gostoi dos teus curso em video mas esto com dilfilculdade