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 marksattendance percentage parents from students where studentid=id( Datatable rows) Please share your ideas Thanks

Midhun T P · Answer

Hi With below code you can convert datatable column to comma separated string. Then you can pass that string to your SQL query - var list = datatable.Rows.OfType ().Select(dr => dr.Field int >( id )).ToList(); string ids = String.Join(   list);

Ankit Kumar · Answer

Hi @Ani Try just single line don't need to loop through. string ids=String.Empty; ids += String.Join(   (From row In dt.Rows Select CType(row.Item( YOurcolumnname ) String)).ToArray()); now you can pass query as follows SqlCommand cmd= new SqlCommand( Select marksattendance percentage parents from students where studentid in @studentid  yourconnection); cmd.Parameters.AddWithValue( @studentid ids); That's it and now execute your reader;

Nilesh Shah · Answer

do you mean you want to select multiple rows based on multiple IDs? then use IN clause and pass the IDs as comma seperated string. Here @ListofIDs is the string parameter containing IDs like 101 102 Select marksattendance percentage parents from students where studentid in (@ListofIDs)