public DataSet.DsPSMS.ST_ROOM_MSTDataTable getAllRoomData(out string msg) { DataSet.DsPSMS.ST_ROOM_MSTDataTable result = new DataSet.DsPSMS.ST_ROOM_MSTDataTable(); try { timedb.Open(); result = timedb.selectAllRoomData(); if (result != null && result.Rows.Count > 0) { msg = result.Rows.Count + " user found"; } else { result = null; msg = "user not found"; } } catch { msg = "error has occure when insert data"; return(null); } finally { timedb.Close(); } return(result); }
public DataSet.DsPSMS.ST_ROOM_MSTDataTable selectAllRoomData() { string query = "SELECT * FROM ST_ROOM_MST ORDER BY ROOM_ID "; SqlCommand cmd = new SqlCommand(query, conn); SqlDataAdapter da = new SqlDataAdapter(cmd); DataSet.DsPSMS.ST_ROOM_MSTDataTable dt = new DataSet.DsPSMS.ST_ROOM_MSTDataTable(); da.Fill(dt); return(dt); }
public void bindClass() { msg = "aaa"; ddlstuclasslist.Items.Clear(); DataSet.DsPSMS.ST_ROOM_MSTDataTable rooms = timeService.getAllRoomData(out msg); ddlstuclasslist.DataSource = rooms; ddlstuclasslist.DataTextField = "ROOM_NAME"; ddlstuclasslist.DataValueField = "ROOM_ID"; ddlstuclasslist.DataBind(); ddlstuclasslist.Items.Insert(0, new ListItem("Select Class", "0")); }
public DataSet.DsPSMS.ST_ROOM_MSTRow selectClassByid(int id) { //conn.Open(); string query = "SELECT * FROM ST_ROOM_MST WHERE ROOM_ID=" + id; SqlCommand cmd = new SqlCommand(query, conn); SqlDataAdapter da = new SqlDataAdapter(cmd); DataSet.DsPSMS.ST_ROOM_MSTDataTable dt = new DataSet.DsPSMS.ST_ROOM_MSTDataTable(); da.Fill(dt); //return single row return(dt[0]); }
public DataSet.DsPSMS.ST_ROOM_MSTRow getClassByid(int id) { DataSet.DsPSMS.ST_ROOM_MSTRow resultData = new DataSet.DsPSMS.ST_ROOM_MSTDataTable().NewST_ROOM_MSTRow(); resultData = timedb.selectClassByid(id); return(resultData); }