Member Avatar for castajiz_2 
            cmd = new SqlCommand
            ("select beggining_school,
            end_school FROM Student,student_weekend,Weekend WHERE
            Student.ID=student_weekend.studentID AND  
            student_weekend.WeekendID=Weekend.ID ", con);

I just want to say that i don't have any problem concerning my code functionality. I would just like the design to be like the above example.That is, I dont'want my whole sql expression to be on the same line. However if i want my expression to be on more than one line somehow the string get's lost and visual studio doesn't treat the expression as a string anymore.

Edited by castajiz_2 because: NONE
  • 2 Contributors
  • 1 Reply
  • 158 Views
  • 1 Hour Discussion Span
  • Latest Post Latest Post by deceptikon
Member Avatar for deceptikon

Two options. One is a verbatim string:

var query = @"select beggining_school,
end_school FROM Student,student_weekend,Weekend WHERE 
Student.ID=student_weekend.studentID AND 
student_weekend.WeekendID=Weekend.ID"

Note that indentation is significant in the string, as are newlines. The other, my preference, is literal concatenation because there aren't any "hidden" characters:

var query = 
    "select beggining_school," +
    "end_school FROM Student,student_weekend,Weekend WHERE " +
    "Student.ID=student_weekend.studentID AND " +
    "student_weekend.WeekendID=Weekend.ID"
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.