How To Get Data From SQL Database To TextBox ComboBox RadioButton Directly In VB | ProgrammingGeek

hello viewers welcome to programming gig i am here with a new tutorial that is displayed data from sql server database to text box combo box data feature and radio button control in bb.org application [Music] start asking microsoft sql server management studio server name is carlock hyphen svr authentication sql authentication username sa login name and password is sql server authentication password now connect yes now expand the database folder my database name is programmingdb action on the programming dv expander table this is the table product underscore setup underscore tab and these are the records in the database table product area item name design color date and warranty type now start microsoft sql server microsoft visual studio new project windows on this phone application this is the location where the application will be created now my project name is display data to textbox project okay the project is so created now research this form okay now i'm gonna design this form with level control text box combo box and button control to perform uh this uh tutorial completely operation link given in the description box below okay now now change the text of this uh label label one this label controller used as title this form size is 16 and actually display data from sql server database to text box and color is button paste okay now change the back color of this form back color is yes now this is looking nice level i just added one more label control this level control for product id and change the color for color and piece font size 12 on both true okay now add more five level control for item name design color date and warranty type change the text of this uh level control edit level control design this one for color and listen for insert it and this one for warranty type okay now add a text box control from the toolbox yes resize this stackbox control change the font size font size is 12. okay now copy and paste now the combo box yes and change the text of this uh font size 12 and add a date and figure control this datum figure control will be used for insert it since the font size 12 okay now add a radio button control ready button change the color of font color button paste font size is 12 and the text is allowed just copy this radio button and add same things this id button i'll use for not allowed okay now the button control this button control uh used for charging there or records based on product id text is fine for color button page font size 10 onboard true okay and back color bar purple now this is looking nice okay now add a dedicated view control from the toolbox just to drive a database review control and drop it in there windows form okay now go to the form load event all right go to load data in data grid view so first of all connect with the sql server database table dim con as new sql connection to use sql connection you should add namespace input system.sql client now uh go to the server explorer add connection server name is catalog hyphen sbr ask us authentication usernames and passwords specification password and database name my database name is programmingdb yes okay yes this is added now and this is the table you can see right click the database and click on property and double click the connection listing coffee and paste it in the double quotation of sql connection okay you can see id okay now dim com as new sql command my skill command is to select records all the records and display in the daily grid view so select start from product underscore set of underscore tab initialize the connection string on name ds as new scale dated after com comis command sql command name dt as new data table finally ds dot fill dd data grid be one direct view my directory name is data will be one the data is equal to dd okay you can see id is essay but password register so you should put your original password that's close to authentication password debug yes the records all the records displaying in the data display data in related control based on product id to do that uh go to the button click event and just copy the sql connection and command to the records selection records okay now we should add a higher close uh for productivity so tab higher product underscore id this is the column name primary key column product id equal to syntax including double quotation and percent and that is uh my declare variable dim pid as integer yes this is the integer type and my table name is the technique's name is textbooks1 change the textbook's name so that you can write code easily and perfectly so textbox txt pid txt feed name item 260p name and text design and color is combo color and ready button is ready you allow android you already want to easily not allow okay now go to the uh add items in the comment box black white i just added two color okay now time's name is txtvid dot text okay now in higher product id equal to fee id root v id okay now if dt dot rows dot count greater than i mean if the records exist and the database table then txt fee name dot text equal to dt dot rows zero i mean row index zero and column index one one is item name dot twisting zero is productivity and one column column index one one is item name and design design is row zero and column two design let's check one zero one fine yes laptop del is displaying perfectly and one zero two wireless dell is also working but color item name is not displaying it because so write code combo color text equal to dt dot rows 0 and column index is 3 dot twisting then the temperature 1 the text equal to dt dot rows zero and column index four dot twisting okay fine now radio button so to display radio button checked i should add a variable team warranty as string equal to initially it will be blank then if if dt dot row 0 in column index is 5 dot twisting equal to allowed i mean if the data in the data the database is allowed then it will check the radio radio allowed so uh photoready allow dot checked equal to draw if it's not allowed i mean it's not allowed then it will check the radio not allow [Music] yes and debug one zero one find yes not allow one zero one is warranty text hello but it's displaying not allow so this is error one zero two not allow one zero three not allow maybe uh let's check the code oh yes this is allowed yes let's check 101 allowed yes it's working fine 102 not allowed yes based on the records on the redo not allowed and 103 allowed yes thanks for watching this tutorial [Music] you

Channel: ProgrammingGeek

Views: 3,537

Keywords: programminggeek, get data from sql in vba, get data from sql in vb.net, read data from sql in vb.net, get data from sql view vb.net, retrieve data from sql server in vb.net, retrieve data from sql database in vb.net, get data from sql to combobox vb.net, how to get data from sql in vb.net, retrieve data from sql to textbox vb.net, retrieving data from sql server using vb.net

Id: b97AkGMf530

Length: 11min 9sec (669 seconds)

Published: Sun Nov 01 2020