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"; }