Hello Harpreet,
Take the multiple room number in single variable separated by comma format.
E.g.
String txt_roomno.Text= 'Single-101,Single-102,Single-103' ;
And write your SQL query as below
String sqlr = "update roominformation set status ='0' where roomno in '" + txt_roomno.Text + "'";