How to select & store column values from MS SQL DB

Question

in my case, i am entering USER ID. and then I want to select the EMAIL ID and PASSWORD field values of the particular user and store them to the variable (in C#).

Manav Pandya · Accepted Answer

Hello   This is really simple to implement , just follow some step :   1 . Use textbox and add one submit button   2 . Onsubmit call one method with parameter id    3 . Connect your database and fire query using ado.net like :   select Email , Password from your_table_name where ID = Convert.toInt32(textbox1.text)   4 . Store email and password anywhere you want    5 . Use this data as per your requirement    I hope it will be useful to you   Still you can refer other article :   http://www.c-sharpcorner.com/UploadFile/009464/get-data-from-database-using-selected-ids/    Thanks