I have a table (contactDetails) in my database (Sql express) with username,password, email, contactNo, bySMS and byEmail columns. I have 2 radiobuttons in my application smsRB and EmailRB, when the user registers he must select either smsRb or EmailRB. if smsRB is selected, a "Y" is inserted under bySMS column in that user's record, else if EmailRB is selected a "Y" is inserted under byEmail column in that user's record. I have another webform where I upload files in a database:
my challenge is: Everytime I upload a file I want my application to send an SMS notification to all the user who chose the smsRB when they registered and send an email notification to all the users who chose EmailRB.
Please help me achieve this task. let me know if its not clear. (using C# 2005)