public void updateContent() { String query = "update StickyNotes set Content_of_Notes = '" + Content + "',Categories_ID=" + Categoryid + " where Title = '" + Title + "';"; try { dbconnection.Manipulate(query); } catch (Exception e) { Console.WriteLine(e.Message); } }
public void Update() { string query; query = "Update Users set Usertype_ID=" + UsertypeID + ",FirstName='" + Firstname + "',LastName='" + Lastname + "',Address_Name='" + Addrss + "',Phone_No='" + Phone + "',Email='" + Email + "',Gender='" + Gender + "',Username='******',Passcode='" + Password + "' where Users_ID=" + Userid; try { user.Manipulate(query); } catch (Exception e) { Console.WriteLine(e.Message); } }
public void addSticky() { string query; query = "insert into StickyNotes(Users_ID,Categories_ID,Date_Created,Title,Content_Of_Notes,Isstickied,Iscompleted)values('" + Userid + "'," + Categoriesid + ",'" + Date + "','" + Title + "','" + Content + "'," + Isstickied + "," + Iscompleted + ");"; try { stick.Manipulate(query); } catch (Exception e) { Console.WriteLine(e.Message); } }
public void Addcategory() { string query; query = "insert into Categories(Categories_Name)values('" + Category + "')"; try { categ.Manipulate(query); } catch (Exception e) { Console.WriteLine(e.Message); } }
public void addusertype() { string query; query = "insert into Usertype(Usertype_Name) values('" + Usertype + "')"; try { conn.Manipulate(query); } catch (Exception e) { Console.WriteLine(e.Message); } }