C# Programming

User Generated




This is a C# Programming project.

Please review the two attachments and let me know

Thank you

Unformatted Attachment Preview

500 499 498 497 496 495 494 493 492 491 490 489 488 487 486 485 484 483 482 481 480 479 478 477 476 475 474 473 472 471 470 469 468 467 466 465 464 463 462 461 460 459 458 457 456 455 454 453 452 451 450 449 448 447 446 445 444 443 442 441 440 439 438 437 Beach Boys, Fun Fun Fun Bob Dylan, Rainy Day Women #12 & 35 Joe Cocker, The Letter Ten Years After, I'd Love To Change The World Kingsmen, Louie Louie Humble Pie, Thirty Days In The Hole Beatles, I Should Have Known Better Bob Seger, Still The Same Santana, Evil Ways Robert Palmer, Addicted To Love Lovin' Spoonful, Summer In The City David Bowie, Rebel Rebel Phil Collins, In The Air Tonight Steely Dan, Deacon Blues Sly/Family Stone, Dance To The Music Credence Clearwater Revival, Suzie Q George Thorogood, Move It On Over Eric Clapton, Forever Man Hollies, Bus Stop Sugarloaf, Green-Eyed Lady Peter Gabriel, Sledgehammer Rolling Stones, Let It Bleed Tom Petty, Free Fallin' 2 Neil Young, Southern Man Crosby Stills Nash, Helplessly Hoping Chambers Brothers, Time Has Come Today Santana, Black Magic Woman Eagles, One Of These Nights Canned Heat, On The Road Again Dr. John, Right Place Wrong Time Rolling Stones, Waiting On A Friend Grateful Dead, Sugar Magnolia Jethro Tull, Bungle In The Jungle Beatles, Glass Onion John Fogerty, Old Man Down The Road John Mellencamp, Pink Houses Moody Blues, The Voice Supertramp, Goodbye Stranger Thunderclap Newman, Something In The Air Bob Seger, Turn The Page ZZ Top, Gimme All Your Lovin' Eric Clapton, Layla ( Unplugged) Elvis Costello, Allison Pink Floyd, Breathe Doors, The End The Clash, Should I Stay Or Should I Go Police, Don't Stand So Close To Me Beatles, Ballad Of John And Yoko Bob Dylan, Knockin' On Heaven's Door Pete Townshend, Rough Boys Foreigner, Cold As Ice Deep Purple, Woman From Toyko Jethro Tull, Living In The Past Beatles, Lucy In The Sky w/ Diamonds Crosby Stills Nash, Wooden Ships Led Zeppelin, All Of My Love Norman Greenbaum, Spirit In The Sky Credence Clearwater Revival, Up Around The Bend Allman Brothers, Melissa Outlaws, Green Grass & High Tides Bruce Springsteen, Spirit In The Night Peter Frampton, Baby I Love Your Way Beatles, Please Please Me Steve Miller, The Joker 436 435 434 433 432 431 430 429 428 427 426 425 424 423 422 421 420 419 418 417 416 415 414 413 412 411 410 409 408 407 406 405 404 403 402 401 400 399 398 397 396 395 394 393 392 391 390 389 388 387 386 385 384 383 382 381 380 379 378 377 376 375 374 373 Dire Straits, So Far Away Queen, Tie Your Mother Down Mott The Hoople, All The Young Dudes Rolling Stones, Beast Of Burden Van Morrison, Wild Night Tom Petty, I Won't Back Down Led Zeppelin, Dy'er Ma'ker Stephen Stills, Love The One You're With Bob Dylan, Just Like A Woman Rod Stewart, You Wear It Well Beatles, Norwegian Wood U2, Sunday Bloody Sunday Peter Gabriel, In Your Eyes Van Halen, Dance The Night Away Rolling Stones, Mother's Little Helper Thin Lizzy, The Boys Are Back In Town Rick Derringer, Rock 'N Roll Hootchie Koo Boston, Peace Of Mind Focus, Hocus Pocus Traffic, John Barleycorn Must Die Blue Oyster Cult, Burnin' For You ELO, Strange Magic Animals, It's My Life Jethro Tull, Cross-Eyed Mary Cream, Badge Grateful Dead, Friend of the Devil Cars, My Best Friend's Girl Doors, 20th Century Fox Tom Petty, Refugee Bad Company, Bad Company Deep Purple, Highway Star Neil Young, Rockin In The Free World Elton John, Madman Across The Water America, Horse With No Name Peter Frampton, Do You Feel Like We Do? Who, Substitute Bruce Springsteen, Pink Cadillac Led Zeppelin, Good Times Bad Times Guess Who, No Sugar Tonight Chicago, Make Me Smile Doors, Waiting For The Sun Eric Clapton, I Shot The Sheriff Beatles, Magical Mystery Tour Queen, Fat Bottom Girls Who, You Better You Bet Badfinger, Baby Blue Grand Funk Railroad, Bad Time Rolling Stones, Tumbling Dice Bob Dylan, Positively 4th Street Edgar Winter, Frankenstein Paul McCartney, Jet Kinks, Celluloid Heroes Yes, Wonderous Stories Steve Winwood, Arc Of A Diver Rush, Tom Sawyer Steely Dan, Dirty Work Canned Heat, Goin' Up The Country Van Halen, Runnin' With The Devil Bad Company, Movin' On Santana, Oye Como Va ZZ Top, La Grange Nazareth, Hair of the Dog Jimi Hendrix, The Wind Cries Mary Tom Petty, American Girl 372 371 370 369 368 367 366 365 364 363 362 361 360 359 358 357 356 355 354 353 352 351 350 349 348 347 346 345 344 343 342 341 340 339 338 337 336 335 334 333 332 331 330 329 328 327 326 325 324 323 322 321 320 319 318 317 316 315 314 313 312 311 310 309 Alice Cooper, School's Out James Gang, Funk #49 Rolling Stones, Start Me Up Golden Earring, Radar Love Moody Blues, Story In Your Eyes Paul McCartney, Another Day The Boxtops, The Letter Genesis, We Can't Dance Who, Going Mobile T. Rex, Band a Gong (Get It On) Cat Stevens, Wild World Steely Dan, Josie Todd Rundgren, Hello It's Me Elton John, Funeral/Love Lies Bleeding Procol Harum, Conquistador U2, New Year's Day George Thorogood, Bad To The Bone ZZ Top, Sharp Dressed Man Pink Floyd, Shine On You Crazy Diamond Styx, Blue Collar Man Peter Gabriel, Solsbury Hill ELO, Livin' Thing Heart, Barracuda Hollies, Long Cool Woman Beatles, Hard Day's Night David Bowie, Fame Neil Young, Heart Of Gold Guess Who, Share the Land America, Sister Golden Hair Who, Magic Bus Bruce Springsteen, Going Down Chicago, Beginnings Credence Clearwater Revival, Proud Mary Rolling Stones, Get Off My Cloud Jethro Tull, Thick As A Brick Led Zeppelin, Fool In The Rain Animals, Don't Let Me Be Misunderstood Badfinger, No Matter What George Harrison, My Sweet Lord Cheap Trick, I Want You To Want Me BTO, Takin' Care Of Business Boston, Foreplay/Long Time Zombies, She's Not There Elton John, Tiny Dancer John Fogerty, Centerfield Beatles, We Can Work It Out Kinks, Destroyer Who, My Wife Uriah Heep, Easy Livin' Steve Miller Band, Take The Money And Run Moody Blues, Ride My See-Saw Pink Floyd, Young Lust Derek & Dominoes, Bell Bottom Blues Allman Brothers, Midnight Rider Bruce Springsteen, Brilliant Disguise Steely Dan, FM (No Static At All) Supertramp, Give A Little Bit Beatles, Penny Lane Rolling Stones, Play With Fire Bob Seger, Against The Wind Paul Simon, Kodachrome Crosby Stills Nash, Long Time Gone Led Zeppelin, Misty Mountain Hop Elton John, Levon 308 307 306 305 304 303 302 301 300 299 298 297 296 295 294 293 292 291 290 289 288 287 286 285 284 283 282 281 280 279 278 277 276 275 274 273 272 271 270 269 268 267 266 265 264 263 262 261 260 259 258 257 256 255 254 253 252 251 250 249 248 247 246 245 Yes, Owner Of A Lonely Heart Argent, Hold Your Head Up James Gang, Walk Away Deep Purple, Hush The Band, Up On Cripple Creek ELO, Fire On High Bad Company, Can't Get Enough Credence Clearwater Revival, Green River Beatles, Paperback Writer Kinks, Tired Of Waiting For You Who, The Kids Are Alright Rush, New World Man Styx, Renegade Bob Dylan, Blowin' In The Wind Foghat, Fool For The City Nazareth, Love Hurts Byrds, So You Wanna Be A Rock 'N Roll Star Alice Cooper, Eighteen Beatles, I Wanna Hold Your Hand Who, I Can See For Miles Rolling Stones, Paint It Black Guess Who, Laughing Steely Dan, Rikki Don't Lose That Number Chicago, 25 Or 6 To 4 Lynyrd Skynyrd, Sweet Home Alabama Led Zeppelin, Over The Hills And Far Away Steppenwolf, Magic Carpet Ride Rolling Stones, Heartbreaker Moody Blues, Tuesday Afternoon Rascals, Good Lovin' Badfinger, Come And Get It Todd Rundgren, I Saw The Light Doobie Brothers, Black Water Byrds, Eight Miles High Eagles, Already Gone Eric Clapton, Tears In Heaven Beatles, She Loves You Credence Clearwater Revival, Have You Ever Seen The Rain? Who, Eminence Front Police, Every Little Thing (She Does Is Magic) David Bowie, Young Americans Steve Miller, Jet Airliner Beatles, Strawberry Fields Bruce Springsteen, Hungry Heart Dire Straits, Sultans Of Swing Doors, People Are Strange Fleetwood Mac, Say You Love Me Elton John, Your Song Yes, Long Distance Runaround Beatles, Here Comes The Sun Heart, Magic Man Bad Company, Feel Like Makin' Love Country Joe & the Fish, Fixin' To Die Rag Cat Stevens, Peace Train Mountain, Mississippi Queen ELO, Turn To Stone Troggs, Wild Thing Led Zeppelin, Trampled Under Foot Credence Clearwater Revival, Heard It Through The Grapevine Bob Dylan, Shelter From The Storm Seals and Crofts, Summer Breeze Steely Dan, Reeling In The Years Rascals, People Got To Be Free Strawberry Alarm Clock, Incense/Peppermints 244 243 242 241 240 239 238 237 236 235 234 233 232 231 230 229 228 227 226 225 224 223 222 221 220 219 218 217 216 215 214 213 212 211 210 209 208 207 206 205 204 203 202 201 200 199 198 197 196 195 194 193 192 191 190 189 188 187 186 185 184 183 182 181 Beatles, Twist And Shout The Band, The Weight Allman Brothers, Whipping Post Doors, Riders On The Storm Buffalo Springfield, For What It's Worth David Bowie, Space Oddity Alice Cooper, No More Mr. Nice Guy Eric Clapton, Lay Down Sally Rolling Stones, Street Fighting Man Blind Faith, Can't Find My Way Home Moody Blues, Question Blue Oyster Cult, Godzilla Beatles, Sun King Medley Who, 5:15 Ted Nugent, Stranglehold Credence Clearwater Revival, Bad Moon Rising Foghat, Slow Ride Fleetwood Mac, The Chain Elton John, Honky Cat Steely Dan, Do It Again Animals, We Gotta Get Out Of This Place Bruce Springsteen, Tunnel Of Love Byrds, Mr. Tambourine Man Chicago, Colour My World Beatles, Golden Slumbers Medley Who, I Can't Explain Kinks, A Well Respected Man Beatles, Get Back AC/DC, You Shook Me All Night Long Guess Who, These Eyes Kiss, Rock 'N Roll All Night Eric Clapton, After Midnight Pink Floyd, Us And Them Rolling Stones, Angie Police, Message In A Bottle Heart, Crazy On You ZZ Top, Tush Tom Petty, Breakdown Lynyrd Skynyrd, Gimme Three Steps Beach Boys, Good Vibrations Beatles, Ticket To Ride Doobie Brothers, Long Train Running Peter Frampton, Show Me The Way Kinks, All Day And All Of The Night Led Zeppelin, Ramble On Boston, Rock And Roll Band ELO, Evil Woman Beatles, Eight Days A Week The Firm, Radioactive Bob Dylan, Tangled Up In Blue Credence Clearwater Revival, Lodi Queen, Keep Yourself Alive AC/DC, T.N.T. Led Zeppelin, Heartbreaker/Livin' Lovin' Maid Doobie Brothers, Listen To The Music Neil Young, Cinnamon Girl Jackson Browne, Running On Empty Cars, Just What I Needed Moody Blues, Your Wildest Dreams Who, Bargain Doors, Love Me Two Times Janis Joplin, Piece Of My Heart Cream, Strange Brew Van Halen, Jump 180 179 178 177 176 175 174 173 172 171 170 169 168 167 166 165 164 163 162 161 160 159 158 157 156 155 154 153 152 151 150 149 148 147 146 145 144 143 142 141 140 139 138 137 136 135 134 133 132 131 130 129 128 127 126 125 124 123 122 121 120 119 118 117 Jethro Tull, Locomotive Breath Rolling Stones, You Can't Always Get What You Want Bob Seger, Old Time Rock 'N Roll Billy Joel, Piano Man Steve Miller, Fly Like An Eagle Guess Who, No Time Elton John, Rocket Man Kansas, Dust In The Wind Bruce Springsteen, Born In The U.S.A. Steve Winwood, Higher Love Badfinger, Day After Day Ted Nugent, Cat Scratch Fever Fleetwood Mac, Tusk Dire Straits, Money For Nothing Who, Long Live Rock Cat Stevens, Morning Has Broken Crosby Stills Nash, Teach Your Children Eagles, Take It Easy Grand Funk Railroad, I'm Your Captain/Closer To Home Beatles, In My Life Pink Floyd, Time Chicago, Saturday In The Park Yardbirds, Heart Full Of Soul Led Zeppelin, Immigrant Song Rolling Stones, Under My Thumb Doors, Love Her Madly Spencer Davis Group, Gimme Some Lovin' ELP, From The Beginning Queen, Crazy Little Thing Called Love Crosby Stills Nash, Suite: Judy Blue Eyes Van Morrison, Domino Head East, Never Been Any Reason Billy Idol, Rebel Yell Edgar Winter Band, Free Ride Bruce Springsteen, Glory Days Byrds, Turn Turn Turn Styx, Come Sail Away Black Sabbath, Paranoid Eagles, Life In The Fast Lane Genesis, Home By The Sea David Bowie, Ziggy Stardust Foreigner, Feels Like The First Time Credence Clearwater Revival, Down On The Corner Police, Synchronicity II Eric Clapton, Let It Rain Elton John, Crocodile Rock Beatles, Help! Traffic, Low Spark Of High Heeled Boys Rolling Stones, Honky Tonk Woman Bad Company, Rock 'n' Roll Fantasy ZZ Top, Legs Beatles, Day Tripper Cream, Crossroads ELO, Telephone Line Fleetwood Mac, Don't Stop Joe Walsh, Life's Been Good Supertramp, Logical Song Neil Young, Old Man Beatles, Eleanor Rigby Iron Butterfly, In A Gadda Da Vida Crosby Stills Nash, Ohio Aerosmith, Sweet Emotion Guess Who, American Woman Doors, Hello I Love You 116 Led Zeppelin, Going To California 115 Beatles, Come Together 114 Pink Floyd, Welcome To The Machine 113 Zombies, Time Of The Season 112 Allman Brothers Band, Jessica 111 Who, Squeeze Box 110 ELP, Karn Evil 9 109 Doobie Brothers, China Grove 108 Rolling Stones, Ruby Tuesday 107 Blue Oyster Cult, Don't Fear The Reaper 106 Van Morrison, Moondance 105 Paul McCartney, Band On The Run 104 BTO, You Ain't Seen Nothin' Yet 103 Yardbirds, For Your Love 102 Beatles, Revolution 101 Elton John, Daniel 100 ELO, Don't Bring Me Down 99 Beatles, Long and Winding Road 98 Janis Joplin, Me And Bobby McGee 97 Who, Who Are You 96 Credence Clearwater Revival, Fortunate Son 95 Joe Walsh, Rocky Mountain Way 94 Pink Floyd, Brain Damage/Eclipse 93 David Bowie, Suffragette City 92 Queen, We Will Rock You/Champions 91 Beatles, All You Need Is Love 90 Grateful Dead, Touch Of Grey 89 Eagles, Heartache Tonight 88 Procol Harum, Whiter Shade Of Pale 87 Eric Clapton, Wonderful Tonight 86 ELP, Lucky Man 85 Beatles, Sgt. Pepper/With A Little Help From My Friends 84 Fleetwood Mac, Go Your Own Way 83 Rolling Stones, Gimme Shelter 82 Manfred Mann, Blinded By The Light 81 Kinks, Lola 80 Grand Funk Railroad, We're An American Band 79 Crosby Stills Nash, Woodstock 78 Jimi Hendrix, All Along The Watchtower 77 Tom Petty, Running Down A Dream 76 Allman Brothers, Ramblin' Man 75 Beatles, Something 74 Jefferson Airplane, Somebody To Love 73 Pink Floyd, Hey You 72 Led Zeppelin, Thank You 71 Don McLean, American Pie 70 Doors, Break On Through 69 Rod Stewart, Maggie May 68 Jimi Hendrix, Fire 67 Van Morrison, Brown Eyed Girl 66 Bruce Springsteen, Dancing In The Dark 65 Bob Dylan, Lay Lady Lay 64 David Bowie, Changes 63 Fleetwood Mac, Rhiannon 62 Elton John, Bennie And The Jets 61 Police, Every Breath You Take 60 Paul McCartney, Maybe I'm Amazed 59 Who, Pinball Wizard 58 Aerosmith, Walk This Way 57 Jimi Hendrix, Foxy Lady 56 Led Zeppelin, Communication Breakdown 55 Pink Floyd, Another Brick In The Wall (Pt. 2) 54 Rolling Stones, Sympathy For The Devil 53 Doors, Touch Me 52 Beatles, While My Guitar Gently Weeps 51 Elton John, Goodbye Yellow Brick Road 50 Steppenwolf, Born To Be Wild 49 Animals, House Of The Rising Sun 48 John Lennon, Instant Karma 47 Jimi Hendrix, Hey Joe 46 Deep Purple, Smoke On The Water 45 Cream, Sunshine Of Your Love 44 Rolling Stones, Brown Sugar 43 Who, My Generation 42 Doors, L.A. Woman 41 Led Zeppelin, Black Dog 40 Eric Clapton, Cocaine 39 Beatles, Let It Be 38 Boston, More Than A Feeling 37 Free, All Right Now 36 Grateful Dead, Casey Jones 35 Kansas, Carry On My Wayward Son 34 Kinks, You Really Got Me 33 Pink Floyd, Wish You Were Here 32 Lynyrd Skynyrd, Freebird 31 Led Zeppelin, Whole Lotta Love 30 Rolling Stones, Jumping Jack Flash 29 Aerosmith, Dream On 28 Jethro Tull, Aqualung 27 Beatles, Hey Jude 26 Jefferson Airplane, White Rabbit 25 Doors, Roadhouse Blues 24 Yes, Roundabout 23 Who, Behind Blue Eyes 22 Led Zeppelin, Kashmir 21 Moody Blues, Nights In White Satin 20 Bob Dylan, Like A Rolling Stone 19 Pink Floyd, Money 18 Grateful Dead, Truckin' 17 Queen, Bohemian Rhapsody 16 Jimi Hendrix, Purple Haze 15 Beatles, Yesterday 14 Cream, White Room 13 Rolling Stones, It's Only Rock 'N Roll 12 Who, Baba O'Riley 11 Led Zeppelin, Rock And Roll 10 John Lennon, Imagine 9 Bruce Springsteen, Born To Run 8 Eagles, Hotel California 7 Pink Floyd, Comfortably Numb 6 Doors, Light My Fire 5 Who, Won't Get Fooled Again 4 Beatles, A Day In The Life 3 Derek And The Dominoes, Layla 2 Rolling Stones, Satisfaction 1 Led Zeppelin, Stairway To Heaven COSC 3315 HOMEWORK # 6 This Homework tests your skills on implementing a database in Visual studio. Start early, finish early and you won’t have to ask me for any extensions. In this HW you are going to develop a database application that will show the Top 500 Rock and Roll Songs. Here is what you are going to do (I left out some of the details for you to figure out): Read the whole document a couple of times to let it sink - - - Attached is a text file that contains titles of songs. The file contains 500 lines. Each line has o Rank of song o Artist o Song Title Create a Windows application Add a new “Service based database “ to your project. Create a table in this database, call it songs. The table should have four columns SongID (int, primary key), Rank of song (int), artist (nvarchar(50)), and song title (nvarchar(50)). Link this table to your application using “Add New data source” Add a grid view of the table to your application and run the program to check if it is working By now the table is empty. The next step is to fill it out using the data in the text file. Open the file and read each line. Tokenize the line to extract rank, artist, and song title. Open the xsd file and create a new Insert Query that will add records into the table For each line you read from the text file you should use the SQL insert command (via a method) to create a new record in the table You should provide a search box that returns all rows that match the name of a certain artist using query parameters (hint: use “LIKE” operator) You should also provide a button to show all items (records) Your program interface is simple containing: 12345- A data grid view: should be empty at the start of the program An import button: import data from text file and populates the grid view (DB) A search textArea and a search button: to return rows that match an artist A show all items button: shows the full 500 records An exit button: exits the program
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

I found the fil...

Goes above and beyond expectations!


Related Tags