Now doing a hotel management system, to realize the query function of the room, now is to get to the value, but how to realize the query function (new to c # bosses don't say too advanced, really don't understand the )

CodePudding user response:

Click on the room and then according to room no. Select the class room

CodePudding user response:

SQL is that a few statements, learned didn't have to learn, application is endless, so, for the database, the society is not equal to other fun,

CodePudding user response:

Is BaseSQL + users choose the query SQL
Example:
BaseSQL

 
String BaseSQL=Select * from A Where 1=1 

Users choose the query SQL
Empty String sWhere=And room status=

Combined the two run, can grasp the data to

 
String QuerySQL=BaseSQL + sWhere 

CodePudding user response:

reference wilson1966 reply: 3/f

is BaseSQL + users choose the query SQL
Example:
BaseSQL

 
String BaseSQL=Select * from A Where 1=1 

Users choose the query SQL
Empty String sWhere=And room status=

Combined the two run, can grasp the data to

 
String QuerySQL=BaseSQL + sWhere 

Thanks brother, now almost can

CodePudding user response:

Stitching SQL query conditions

CodePudding user response:

Don't want to splice SQL, where conditions with the or is possible,