After I use dataadapter to get data from DB, and fill it in to datatable like below
SqlDataAdapter DA_subject = new SqlDataAdapter(str_subject_info, str_conn_sql);
DataTable DT_subject = new DataTable();
Can I use SQL statement in Datatable? or how can I assess the element of the datatable. for example assign an element in datatable to a variable.
Could you please give me example code to do it. thanks in advance