private void LoadBeds()
{
IpdManager aIpdManager = new IpdManager();
txtseletedBed.DataSource = aIpdManager.GetAllBeds(cmbwardCabin.Text);
txtseletedBed.DisplayMember = "BedName";
txtseletedBed.ValueMember = "BedId";
//try
//{
// Conn obcon = new Conn();
// SqlConnection ob = new SqlConnection(obcon.strCon);
// SqlDataAdapter da = new SqlDataAdapter();
// da.SelectCommand = new SqlCommand();
// da.SelectCommand.Connection = ob;
// SqlCommand ds = da.SelectCommand;
// //ds.CommandText = "select* from tblBed where Ward=@Ward and Room=@Room and Status='Free'";
// ds.CommandText = "select * from ViewAllBeds";
// ds.CommandType = CommandType.Text;
// DataTable dt = new DataTable();
// da.Fill(dt);
// txtseletedBed.DataSource = dt;
// txtseletedBed.DisplayMember = "BedName";
// txtseletedBed.ValueMember = "ID";
//}
//catch
//{
//}
}
private void LoadBeds()
{
IpdManager aIpdManager = new IpdManager();
txtseletedBed.DataSource = aIpdManager.GetAllBeds(cmbwardCabin.Text);
txtseletedBed.DisplayMember = "BedName";
txtseletedBed.ValueMember = "BedId";
}