asp.net - How can i fetch all images associated by category from database -

hi have table in database named images. want fetch image_path table shown below matching category it.

ex: if select web development category should fetch image_path related category.

i working on asp.net web pages. please guide me how can achieve it?

id      category                 image_path    4	new websites	         img\images\1982d16f-1a85-49c3-b7ac-94e05152273d_01.jpg  6	mobiles                  img\images\87678076-3f19-43c0-909f-eec172d69919_02.jpg  7	web development	         img\images\4fef0362-b5fd-43d1-b988-c5d7e674add0_03.jpg  8	web development	         img\images\5752419a-013d-4c09-99af-f28132102189_04.jpg  9	web development	         img\images\e4876bff-b647-48d6-a3a0-b1e7bfb6d60a_05.jpg  10	web designing	         img\images\e86c3edc-0591-4157-8525-33e52ca21f64_06.jpg  11	mobiles	                 img\images\2b6ccd51-77f1-4da8-9ed6-98c2b069e92d_07.jpg  12	mobile apps	         img\images\44694e2e-24dc-4f06-bb8f-88b597322c0d_005.jpg  13	mobile apps	         img\images\9d5ca99a-f6fd-43d7-8a05-a6671f73bd54_006.jpg

as your're saying "if select", i'm assuming you're having drop down in scenario.

it's simple follow query pull records related selected item database.

select image_path images category = '"+dropdown1.selecteditem+"' 

the above query trick.

if you're beginner, learn ado.net. proceed further.

note: dropdown assumption. can keep per requirement.