public DataTable UserUpdate() { DataTable dt = null; string query; query = "select * from Users where Users_ID=" + Userid; //MessageBox.Show(query); try { dt = user.Retrieve(query); } catch (Exception e) { Console.WriteLine(e.Message); } return(dt); }
public string userIDD() { string query = "select Users_ID from Users where Username = '******';"; DataTable datatable = null; try { datatable = dbconnection.Retrieve(query); } catch (Exception e) { Console.WriteLine(e.Message); } string userid = datatable.Rows[0][0].ToString(); return(userid); }
private void Stickynote_Load(object sender, EventArgs e) { string query; query = "select * from Categories"; DataTable dt1 = cate.Retrieve(query); cmb1.DataSource = dt1; cmb1.DisplayMember = "Categories_Name"; cmb1.ValueMember = "Categories_ID"; }
private void Userentry_Load(object sender, EventArgs e) { DataDisplay(); string query; query = "select * from Usertype"; DataTable dt1 = user.Retrieve(query); cmb6.DataSource = dt1; cmb6.DisplayMember = "Usertype_Name"; cmb6.ValueMember = "Usertype_ID"; }
public DataTable NoteCounttodaydate(string todaydate) { DataTable dt = null; string query; query = "select Count(IsCompleted) from StickyNotes where Date_Created='" + todaydate + "'and IsCompleted='1' and Users_ID=" + usersss(); MessageBox.Show(query); try { dt = conn.Retrieve(query); } catch (Exception e) { Console.WriteLine(e.Message); } return(dt); }
public DataTable Categorydgv() { DataTable dt = null; string query; query = "Select Categories_ID,Categories_Name from Categories"; try { dt = categ.Retrieve(query); } catch (Exception e) { Console.WriteLine(e.Message); } return(dt); }
public DataTable Usertypedgv() { DataTable dt = null; string query; query = "Select Usertype_ID,Usertype_Name from Usertype"; try { dt = conn.Retrieve(query); } catch (Exception e) { Console.WriteLine(e.Message); } return(dt); }
public DataTable getName(int UserID) { String query = "select FirstName,LastName from Users where Users_ID = " + UserID + ";"; DataTable dt = null; try { dt = stick.Retrieve(query); } catch (Exception e) { Console.WriteLine(e.Message); } return(dt); }
public bool checkUser() { string query; query = "select Username from Users where Username='******' and Passcode='" + password + "'"; DataTable dt = null; try{ dt = conn.Retrieve(query); } catch (Exception e) { Console.WriteLine(e.Message); } if (dt.Rows.Count > 0) { return(true); } else { return(false); } }