SQL Server - How to change room status of multiple rooms????

Asked By Priyanka on 01-Aug-13 05:58 AM

I am using code like below to change room status. It was working fine because till that time i had to change only single room status.

String sqlr = "update roominformation set status = '0' where roomno = '" + txt_roomno.Text + "'";
new OleDbCommand(sqlr, sr, trans).ExecuteNonQuery();

Now i have multiple rooms in the single text box (txt_roomno) like Single-101,Single-102,Single-103. Before this i have only one room in the text box like Single-101,so there is no problem while updating this....
My Question is now how can i change the status of multiple room numbers from single text box....
It will be like First change the status of Single-101, then Single-102, after that Single-103...
I dont know how to achieve this task..
Please help....