First, Do not concatenate strings to build a SQL command. It leaves you wide open to accidental or deliberate SQL Injection attack which can destroy your entire database. Use Parametrized queries instead.
Then try something like this:
SELECT s.USN, s.Name, s.FName, c.CC, c.C_Ttile, c.Credits
FROM Student_Data s
INNER JOIN Course_Data c
ON s.Dept=c.Dept AND s.Branch=c.Branch
WHERE s.USN=@USN
ORDER BY c.CC
Don't forget to add the @USN parameter to your SqlCommand object and set it's value to the textbox content!