select query using datatable rows

Question

Hi,

 

I have data in datatable like below

 

Id	Name	Class
101	Adam	IV
102	Sara	V
103	Raj	X

 

I want to pass id to sql select query without using foreach loop like 

 

Select marks,attendance percentage, parents from students where studentid=id( Datatable rows)

 

Please share your ideas

 

Thanks,