Standard SQL Statements

"SELECT * FROM users"

"SELECT * FROM users WHERE userid ='" + _userid.ToString() + "'";

"INSERT INTO User " +
"([UserID], [UserName], [UserImage]) " +
"VALUES ('"
+ _UserID.ToString() + "','"
+ _UserName + "','"
+ _userImage + "')";

"UPDATE User" +
"SET " +
" [UserName] = '" + _UserName.Trim() + "'," +
" [UserImage] = '" + _UserImage.Trim() + "'," +
+ " WHERE UserID = '" + _UserID.ToString() + "'";

"SELECT * FROM Tweets"

"SELECT * FROM Tweets WHERE tweetid ='" + _tweetid.ToString() + "'";

"INSERT INTO Tweets " +
"([TweetID], [Tweet], [DateStamp], [UserID]) " +
"VALUES ('"
+ _TweetID.ToString() + "','"
+ _Tweet + "','"
+ _DateStamp
+ _UserID.ToString() + "')";

"UPDATE Tweets" +
"SET " +
" [Tweet] = '" + _Tweet.Trim() + "'," +
" [DateStamp] = '" + _DateStamp.ToString() + "'," +
" [UserID] = '" + _UserID.ToString() + "'," +
+ " WHERE TweetID = '" + _TweetID.ToString() + "'";

"SELECT * FROM KeyWords"

"SELECT * FROM KeyWords WHERE KeyWordid ='" + _userid.ToString() + "'";

"INSERT INTO KeyWords" +
" ([KeyWordID], [KeyWord]) " +
"VALUES ('"
+ _KeyWordID.ToString() + "','"
+ _KeyWord + "')";

"UPDATE KeyWords" +
"SET " +
" [KeyWord] = '" + _KeyWord.Trim() + "'," +
+ " WHERE KeyWordID = '" + _KeyWordID.ToString() + "'";

"INSERT INTO Link" +
" ([LinkID], [KeyWordID], [TweetID]) " +
" VALUES ('"
+ _LinkID.ToString() + "','"
+ _KeyWordID.ToString() + "','"
+ _UserID.ToString() + "')";