Loading

select query using datatable rows

select query using datatable rows

Ani

9y953Learn iOS Programming

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,

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ankit Kumar9y ago
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 marks,attendance percentage, parents from students where studentid in @studentid", yourconnection);
cmd.Parameters.AddWithValue("@studentid",ids);
That's it and now execute your reader;
Midhun Tp9y ago
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);
Nilesh Shah9y ago
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 marks,attendance percentage, parents from students where studentid in(@ListofIDs)