-
Can any one help me how to write query for this select SELECT q_ar.id, q_ar.s_ar, q_ar.sura_ar, q_ar.a_ar, q_ar.ayat_ar, q_en.tr_y, q_en.tr_p, q_en.tr_s FROM q_ar INNER JOIN q_en ON q_ar.s_ar = q_en.s_en AND q_ar.a_ar = q_en.a_en ORDER BY q_ar.id Thanks, K
-
Thanks kbradl1! The Select command didn't work for me(Incorrect syntax near '*') but I was able to get the QueryCommand to work. This leads me to a new challenge! I am working on a grid view control and I am trying to enable paging. How would I do this in the QueryCommand?
-
This might work, although I haven't tested it: VB: Dim sel As New [Select](DataService.Provider, New String() {"*", "Firstname + ' ' + Lastname As Fullname"}) However this is the way I would do it: VB: Dim fquery As New QueryCommand("Select *, Firstname + ‘ ‘ + lastname...