₦airaland Forum

Pls, I'm just new in vb.net.
How can i make a subform appear in a TabPage.

Please can someone help me to convert this JET-SQL to T-SQL

SELECT IIf(IsNull([Last Name]),IIf(IsNull([First Name]),[Company],[First Name]),IIf(IsNull([First Name]),[Last Name],[Last Name] & ", " & [First Name])) AS [File As], IIf(IsNull([Last Name]),IIf(IsNull([First Name]),[Company],[First Name]),IIf(IsNull([First Name]),[Last Name],[First Name] & " " & [Last Name])) AS [Student Name], Students.*
FROM Students
ORDER BY IIf(IsNull([Last Name]),IIf(IsNull([First Name]),[Company],[First Name]),IIf(IsNull([First Name]),[Last Name],[Last Name] & ", " & [First Name])), IIf(IsNull([Last Name]),IIf(IsNull([First Name]),[Company],[First Name]),IIf(IsNull([First Name]),[Last Name],[First Name] & " " & [Last Name]));


Please u can mail me d solution @ sollyk4u4real@yahoo.com
Thanks

Pls, i need urgent solution.

While installing oracle 10g my new  Hp, it gives error,  :  TNS permission denied @ db configuratn assistance.
Meanwhile, i hv been install it on other pc 4 more than 2 yrs without  problem.but not on vista os