Database Help

I am a complete newbie in the process of creating asp.net & sql code. I can't seem to get it right and have looked and relooked at my code. Instead of posting my code and confusing everyone, I'll give a brief description of what I'm trying to do. I know this is easy, it's just a little confusing...

----------------

On default.aspx page
1) Call t_crcnr_new_res table (New Resource)

2) Check "asoc_corp_id" column in New Resource table for this user's corpID

3) If the CorpID is found, check "new_res_i" column and display correct graphic depending on its value.
If CorpID is not found, create a new row in New resource table. "asoc_corp_id" is going to be the CorpID that was found by the associate recognition script. "new_res_i" will be set to "Y," meaning show the "new content" graphic. If "N", show the "old content" graphic.

Also on default.aspx, there are two graphic buttons. The graphics and links will be different depending on "Y" or "N." If it is Y, go to new_content.aspx. If N, go to past_alerts.aspx.

----------------

On new_content.aspx -- the actual New Alert page.
1) Display most recently posted resource (determined by the Resource Info table "t_crcri_rsrc_info", "pstd_d" column). Need title ("rsrc_ttle_nm"), URLs ("rsrc_url_x" & "down_rul_x"), type ("rsrc_type_c").

2) On page load, call t_crcnr_new_res table (New Resource) and change "new_res_i" to "N" for this person's corpID.

-----------------

On past_alerts.aspx page, simply display list of all resources table (t_crcri_rsrc_info), sorted by posted date ("pstd_d" column), most recent first.

Thanks so much...