//按条件查询课程 public object ShowCourse(string check) { List <TimeTable> list1 = new List <TimeTable>(); string sql = @" select CourseName,[Date],MemberJoint,[Status] from TimeTable where CourseName like '%" + check + @"%' or convert(varchar(1024),[Date],120) like '%" + check + @"%'"; try { DataView dv = new DataView(dbs.SelectDataBase(sql).Tables[0]); DataTable dt = dv.Table; for (int i = 0; i < dt.Rows.Count; i++) { list1.Add(new TimeTable { CourseName = Convert.ToString(dt.Rows[i]["CourseName"]), Date = Convert.ToString(dt.Rows[i]["Date"]), MemberJoint = Convert.ToString(dt.Rows[i]["MemberJoint"]), Status = Convert.ToString(dt.Rows[i]["Status"]), }); } } catch (Exception e) { return("false"); } return(list1); }
public string GetUserID() { string UserID; string sql = " select UserID from Users where FirstName='Sam'"; DataView dv = new DataView(dbs.SelectDataBase(sql).Tables[0]); DataTable dt = dv.Table; UserID = Convert.ToString(dt.Rows[0]["UserID"]); return(UserID); }