Hi! I'm having a problem in database.. I have this SQL for my vb.net project
Sql = "SELECT STUDENTS.stud_id, STUDENTS.stud_no, [stud_last] & '" & Me.Label1.Text & "' & [stud_first] AS Expr1, STUDENTS.gender00, STUDENTS.course00, SECTION00.sec_code, STUDENTS.Q1, STUDENTS.Q2, STUDENTS.Q3, STUDENTS.Q4, STUDENTS.Q5, STUDENTS.Q6, STUDENTS.Q7, STUDENTS.Finals, STUDENTS.username00, STUDENTS.stud_id FROM SECTION00 INNER JOIN STUDENTS ON SECTION00.sec_id = STUDENTS.sec_id WHERE sec_code LIKE '" & cmd_section.Text & "' AND stud_last LIKE '" & TextBox1.Text & "' ORDER BY STUDENTS.stud_last"
you can see the Expr1 where there is stud_last and stud_first, but when i have it for the search button to search and view the student by its last name, and it doesn't work.. Please help..