CSC-177 - ASP.NET

Testing your code.

2009-12-16T08:04:00.000-08:00

Be sure that all Guids are being inserted properly. Null's or Empty Guids will throw off everyone's code.

Good Luck!

SQL Script

2009-12-15T12:14:00.001-08:00

For creating the DotNetTwitter Database on your local SQL Server.

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Following]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Following]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Keywords]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Keywords]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Link]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Link]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Tweets]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Tweets]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Users]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Users]
GO

CREATE TABLE [dbo].[Following] (
[FollowingID] [uniqueidentifier] NOT NULL ,
[UserID] [uniqueidentifier] NULL ,
[FollowingUserID] [uniqueidentifier] NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Keywords] (
[KeywordID] [uniqueidentifier] NOT NULL ,
[Keyword] [char] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Link] (
[LinkID] [uniqueidentifier] NOT NULL ,
[KeywordID] [uniqueidentifier] NULL ,
[TweetID] [uniqueidentifier] NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Tweets] (
[TweetID] [uniqueidentifier] NOT NULL ,
[Tweet] [char] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[DateStamp] [datetime] NULL ,
[UserID] [uniqueidentifier] NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Users] (
[UserID] [uniqueidentifier] NOT NULL ,
[UserName] [char] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[UserImage] [char] (110) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO

About the Final: Oops.

2009-12-14T07:53:00.000-08:00

Alright, I set the time wrong, the Final goes live at Noon today(12/14/2009)
You are more than welcome to use your notes or any other resource, but you only have 45 minutes to take the final, so use your time wisely.

The Final is available under "Lessons"
You have until 12/19/2009, 11:59pm to take the final.

Twitter Application.

2009-12-14T07:25:00.000-08:00

Deadline: 12/19/2009, 11:59pm
Points: 100

Minimum Requirements:
Users need to be able to login or register if their login account/username does not exist.
Users will be able to post tweets and mark keywords
Users will be able to view all Tweets from all Users
Users will be able to edit their Tweets
Display a list(checkbox list, listbox, datalist, or repeater) of all keywords
Selecting keywords will display related Tweets

Extra Credit:
Display top 10 keywords (+10pts)
Ability to select multiple keywords to narrow your search (+10pts)
Implement ability to Follow Users:
Display a list of users you are following, selecting the user will display their Tweets (+10pts)
When displaying all users' tweets, display an icon or label showing that you are following them(+10pts)
When displaying all users' tweets, have a button allowing the user to follow that user, if you are already following that user, display the "following" icon from above(+10pts)

Standard SQL Statements

2009-12-13T19:18:00.001-08:00

"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() + "')";

The Final.

2009-12-13T13:24:00.000-08:00

Here's a preview of the final. The final exam will be opened tonight at midnight.

1. What is a DataTable a collection of?

2. How do I check to see if a user is viewing a page for the first time?

3. Which control is similar in funcationality and behavior to a ListBox?

4. Name the main parts of an Object Class.

5. I have a session variable called "MyData". How would I cast "MyData" as a DataTable?

6. What is the primary event for a Button object?

7. I am getting the following error:
System.NullReferenceException: Object reference not set to an instance of an object.
Most likely, this is caused by:

8. Imagine a student database table. I need to add a method to my object class which would select all graduating seniors. What type of method would I make this?

9. I have a DataTable called 'dtClassSchedule' with three columns: "DepartmentCode", "ClassCode", "Section".

I need to add a new row where:
"DepartmentCode" = "CSC"
"ClassCode" = "177"
"Section" = "290"

How would I hard code this?

10. With our class projects in mind, what is the first event fired from a .aspx web page?

11. Which control is similar in functionality and behavior to a DropDownList?

12. What is a GUID used for?

13. Which control(s) are a collection of ListItems?

14. Suppose I have an Object Class called MyClass, and an Accessor called Value1.

Would I be using a 'get' or 'set':
this.TextBox1.Text = MyClass.Value1;

15. Suppose I have an Object Class called MyClass, and an Accessor called Value1.

Would I be using a 'get' or 'set':
MyClass.Value1 = this.TextBox1.Text;

16. Explain the post-back process.

17. What command do we use to bind a column from a DataTable to a control embedded in a template column of a GridView?

18. I am need of two constructors for my Object Class called MyClass. One constructor takes an ID of type Guid and a FilePath of type string, the other takes only the ID. What would my constructors be?

19. Suppose we have a TextBox called 'MyTextBox'.
It's text property is set to 'Hello World'.
How would I parse the text into a string array?
How would I loop through the array?

20. Imagine a student database table. I need a method in my object class which updates a student record with new information. This method is an example of:

21. What steps would I take to connect a .aspx page to a SQL Database.

22. I have a music database table with the following columns:

TrackID
TrackName
TrackLength
ArtistID

For the Object Class: list the Accessors, Public Methods, and Static Methods.

Publishing site/connection string

2009-12-08T15:58:00.000-08:00

site:
http://hydra.csit.parkland.edu/(application-YourInitials)/

i.e.

http://hydra.csit.parkland.edu/DataTableSQL-Cdey/

connection string: (inside web.config)

(appSettings)
(add key="ConnectionString"
value="packet size=4096;user id=student; password=fall2009;data source=hydra; integrated security=SSPI; persist security info=false; initial catalog=DotNetTwitter"/)
(/appSettings)

also make these changes to your web.config, if these lines already exist, change their values, else add them:
(customErrors mode="Off"/)

(compilation debug="true")

NOTE: REPLACE Parenthesis w/ Greater Than/Less Than signs

Useful queries.

2009-12-08T14:16:00.000-08:00

Aside from the usual select/update/insert/select all
these queries will help you "connect" -or- "relate" your data.

this query will return a table of tweetid/tweet/datestamp/userid/username/userimage:

SELECT dbo.Tweets.TweetID, dbo.Tweets.Tweet, dbo.Tweets.DateStamp, dbo.Users.UserID, bo.Users.UserName, dbo.Users.UserImage
FROM dbo.Tweets INNER JOIN
dbo.Users ON dbo.Tweets.UserID = dbo.Users.UserID

Adding a "WHERE" Clause will allow you to select Tweets on a specific user, or just to get a specific tweet.

this query will return a table of tweetID/tweet/datestamp/keywordid/keyword:

SELECT dbo.Tweets.Tweet, dbo.Tweets.DateStamp, dbo.Keywords.Keyword, dbo.Tweets.TweetID, dbo.Keywords.KeywordID
FROM dbo.Tweets INNER JOIN
dbo.Link ON dbo.Tweets.TweetID = dbo.Link.TweetID INNER JOIN
dbo.Keywords ON dbo.Link.KeywordID = dbo.Keywords.KeywordID

adding a "WHERE" Clause will allow to to select Tweets on a given keyword or keywordID or select all the keywords a specific TweetID

this query will return a table of userid/username/userimages/user_1id/user_1name/user_1images

SELECT dbo.Users.UserID, dbo.Users.UserName, dbo.Users.UserImage, Users_1.UserID AS Expr1, Users_1.UserName AS Expr2,
Users_1.UserImage AS Expr3
FROM dbo.Users INNER JOIN
dbo.Following ON dbo.Users.UserID = dbo.Following.UserID INNER JOIN
dbo.Users Users_1 ON dbo.Following.FollowingUserID = Users_1.UserID

adding a "WHERE" clause, will give you a list of "users_1"s , which is the users a specific "userid" is following are "following"

Update!

2009-12-02T08:03:00.000-08:00

The CoolGuy app on Angel has been updated. Go through the Web.Config file, look over the Classes, and look at the modification in the default code. Email me if you have any issues.

you can hit the app at:

Getting our Tags/AdjDesc for a CoolGuy ID

2009-12-01T17:43:00.000-08:00

sqlCmd.CommandText = "SELECT CoolGuy.LineID, Adj.AdjDesc " +
"FROM CoolGuy INNER JOIN " +
" Link ON CoolGuy.LineID = Link.LineID " +
" INNER JOIN Adj ON Link.AdjID = Adj.AdjID " +
" WHERE CoolGuy.LineID = '" + _LineID.ToString() + "'";
_SQLConnection.Open;
sda.Fill(_Tags);
_SQLConnection.Close;

Connection String to hydra

2009-12-01T16:21:00.001-08:00

value="packetsize=4096;user id=student; password=fall2009;data source=hydra; integrated security=SSPI; persist security=false; initial catalog=CoolGuy"

Our Twitter Database Diagram

2009-11-17T15:08:00.000-08:00

From here we can see you our tables in our .NET Twitter, plus how our tables are related.

Relational Databases/Objects

2009-11-10T09:18:00.001-08:00

We have an object for our Tweets, we need to create an object for our Keywords and relate the Keyword Object to our Tweet object.

Stay Tuned...

.NET Twit Grows

2009-10-27T18:06:00.000-07:00

So our Twitter apps are growing... update your apps so you are actually saving your data including the ability to update/edit your previous Tweets.

Sample Code from Week 9 (or is it 10?) is posted to Angel.

Update your interface by Monday, Nov 1.

Next Week: Out Tweet Object!
Charlie

Multiple Tweets

2009-10-21T08:30:00.000-07:00

Now that we've played w/ DataTable and the Gridview control, its time to integrate this into our .NET Twit app.

After you save your Tweet:

1. Add a DateTime Stamp to your Tweet
2. Create a DataTable which will hold your Tweet, your KeyWords, and the DateTime Stamp.
3. Bind the DataTable to a GridView

This aspect of your .NET Twit will be due this Friday, Oct. 23rd. If you have any questions, email me or post a comment here.

- Charlie

Midterm Assignment

2009-10-13T13:14:00.000-07:00

I'm not big on written Midterms (you will have a written Final)

Your Midterm project is to build the Keyword parser method for our .NET-Twitter application.

Have the user enter text into a Multiline TextBox - any Keywords the user wishes to enter will need to preceeded by a '#' sign. After the text has been entered the user will hit a submit Button which will do two things:

1. the Textbox will disappear and a Label will display with the same text as that which was entered by the user.
2. A CheckBoxList will display all the Keywords as Items. If a word is selected in the CheckBoxList, highlight the Word in the Label (using html tags)

Also provide a switch back to the Edit Mode (TextBox viewable, Label hidden) where the user can make any changes to the Text - be sure to update the CheckBoxList. Words should only appear once in the CheckBoxList, but the user can Keyword the same word multiple times in the text.

This assignment will be due on Friday, October 16th, by 11:59pm

Class Project.

2009-10-06T14:02:00.000-07:00

Our class project will consist of designing a Twitter-Like application. There will be 3 to 4 parts to this app. Each part will be a independently graded project. First part of our application will be the input.

Design a text editor with the following features:
1. A TextBox which can hold 250 characters
2. The ability to preview the post
3. The ability to edit a post
4. Search and Replace - Create a DropDownList which will hold each word (only once) and TextBox to replace the selected word from the DropDownList with the text in the TextBox.
5. Character Count
6. Word Count

The TextEditor will be due Friday, October 16th.