public DataSet GetEvents() { String query = "SELECT * FROM [event]"; OleDbCommand cmd = new OleDbCommand(query); DBUtil util = new DBUtil(); DataSet ds = util.FillDataSet(cmd, "event"); return(ds); }
public DataSet GetEvents() { String query = "SELECT * FROM [event]"; OleDbCommand cmd = new OleDbCommand(query); DBUtil util = new DBUtil(); DataSet ds = util.FillDataSet(cmd, "event"); return ds; }
public Boolean login(string username, string password) { string query = "select * from [user] where username='******' and password='******'"; OleDbCommand cmd = new OleDbCommand(query); DBUtil util = new DBUtil(); DataSet ds = util.FillDataSet(cmd, "user"); int ResultRows = ds.Tables[0].Rows.Count; if ( ResultRows > 0) return true; else return false; }
public Boolean login(string username, string password) { string query = "select * from [user] where username='******' and password='******'"; OleDbCommand cmd = new OleDbCommand(query); DBUtil util = new DBUtil(); DataSet ds = util.FillDataSet(cmd, "user"); int ResultRows = ds.Tables[0].Rows.Count; if (ResultRows > 0) { return(true); } else { return(false); } }
public Event queryEvent(string date) { string sql = "SELECT * FROM [event] WHERE EventDate= #" + date + "#"; OleDbCommand cmd = new OleDbCommand(sql); DBUtil util = new DBUtil(); DataSet ds = util.FillDataSet(cmd, "event"); foreach (DataRow dr in ds.Tables[0].Rows) { DateTime ddt = (DateTime)dr.Field <DateTime?>("EventDate"); string title = dr.Field <string>("Title"); string content = dr.Field <string>("Content"); Event e = new Event(); e.title = title; e.eventDate = ddt; e.content = content; return(e); } return(null); }
public Event queryEvent(string date) { string sql = "SELECT * FROM [event] WHERE EventDate= #" + date + "#"; OleDbCommand cmd = new OleDbCommand(sql); DBUtil util = new DBUtil(); DataSet ds = util.FillDataSet(cmd, "event"); foreach (DataRow dr in ds.Tables[0].Rows) { DateTime ddt = (DateTime)dr.Field<DateTime?>("EventDate"); string title = dr.Field<string>("Title"); string content = dr.Field<string>("Content"); Event e = new Event(); e.title = title; e.eventDate = ddt; e.content = content; return e; } return null; }