Sending Email Based On Dropdownlist.SelectedItem From 2 SQL Tables?
Mar 15, 2011
I don't know how to go about this. I have web form with two dropdown lists. one named Recruiter and the other Account manager. I have two two SQL tables named Perm_Commision_Lookup & UserList. The Perm_Commision_Lookup table does not contain recruiter's email, so I decided to Inner Join it with UserList table which contain recruiter emails. The LookupValue column from the Perm_Commision_Lookup table is what's displayed to the end user and the pk_LookupID column is the one that's inserted into the database. What I want to achieve is this: When a user select let's say "John Doe" from the Recruiter dropdown list, I want to send out an email to John Doe and at the same time insert the selected value (pk_LookupID) into the database. I set the DataTextField="LookupValue" and DataValueField="pk_LookupID but how to get the User_Email is another problem. Below is my SQL select...
SELECT Perm_Commision_Lookup.pk_LookupID, Perm_Commision_Lookup.LookupValue, UserList.User_Email FROM Perm_Commision_Lookup INNER JOIN UserList ON Perm_Commision_Lookup.LookupUserName = UserList.GM_Username
I have a dropdownlist is set to '--Select Item--' when the form is loaded first time. I don't see the Selected Item getting selected after I submit the form. It is set to '--Selected Item--' again.
<%= Html.DropDownList("lstDetails", new SelectList((IEnumerable)ViewData["DetailList"], "ID", "Details"), "--Select Item--")%>
i have the AutoEventWireup="True"; I have a breakpoint in the code behind on the SelectedIndexChange event. The event does fire but the index is not changing. No matter what item in the list I select, the SelectedIndex always = 0. The list is bound to a dataset and the DataTextField and DataValueField are both set to the same value. Why is the index and SelectedValue not updating?
First post here, I usually try not posting until I am completely lost. I have a webform that gets a dynamic dropdownlist added to a placeholder in a method during pageload. During a submit of the page, I want to be able to get the selectedItem in the DropDownList that was also added dynamically from a DB. I know the ID of the DropDownList, and I know the Value of all the ListItems. Although when I am trying to use FindConrol(ID), and assign it to a DropDownList, the Control comes back Null and I get an error saying "Object Reference not set to and Instance of an Object", I believe because its not finding the control.
[Code]....
Can anyone show me how to use this to get access to the properties of the dynamic DropDownList properties, especially the ListItems within.
So here is the problem , Is it possible to get the "SelectedItem.Text" of a binded dropdownlist? because everytime I'm getting null Even though I'm having items in the dropdownlist.
I'm getting the items that I want in the dropdownlist but I can't find out which one is selected.
Protected Sub DropDownList1_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles DropDownList1.SelectedIndexChanged Response.Redirect("memberlogin.aspx?d=" + DropDownList1.SelectedValue.ToString)
I have set a job in sql server 2008 to send reminder emails for product expiration. Now I want a report which will specify the list of the emails sent with the email status details like queued ,sent,delivered, failed.
I can fetch the emails that are sent by querying the like following
select * from sysmail_mailitems SM inner join sysmail_profile SP on SM.Profile_Id = SP.Profile_Id and SP.Name ='ReminderProfile'
The problem is only getting a perfect status of email whether it is delived or failed. How I can get those status ?
i have an aspx page, that takes in user data (name, number & email) after that information gets submitted to me, I need to send an email to their input email, with a message of confirmation.
I am sending an email for forgot password to the user. i have formatted the body text of Email but when i have checked that email, it is coming without any formatting.
here is the formatting code which i am sending as a string.....
have code on a web form -- when you hit the button "send emails", it executes this sub which reads an SQL database table and sends emails one by one -- however I get this error above -- anyway to check it and skip to the next email? Some emails in my table have name@test.co.il for example, so it seems this causes this error.
I have the below script to get a Web Page's html and add it as a string to the mail.body property of the mail message that I have created. However, if the webpage is larger then several KBs, it cause a StackOverflowException to fire.
[Code]....
Is there a simple way to just tell the mail message to use a link like "a.com/default.aspx" for the mail message body?
Now the problem is when i select DropDownList2.SelectedItem.Text == "Reg" STA and STM are not present. I want STA and STM values back in the dropdownlist on selection of 'Reg'.
When i first load my page and select 'Reg' all the values in DropDownList3(including 'STA' and 'STM') are present and than when i select 'Stamp' the values 'STA' and 'STM' are lost(as shown in the code). Now again when i select 'Reg' this values are not there, i want this values to be present again. What do i have to do?? Do i have to bind it again to database?
Is there any other logic for it to be used in a different way ?
there is a radio button, a dropdownlist. radiobuttons are OY, OTY,VDA ( in my database there are fields named OY.OTY,VDA) if i select OY in my radio button the data should be displayed from field OY in dropdownlist and if i select OTY in my radio button the data should be displayed from OTY field in dropdownlist is it possible. there is a sqldatasource for dropdownlist .
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:MS16ConnectionString %>" SelectCommand="SELECT DISTINCT OY FROM COURSE_INTAKE"> </asp:SqlDataSource>
THE SELECTED DROPDOWNLIST DATA IS REQUIRDE TO BE DISPLYED IN A GRIDVIEW.
but am still getting an error (System.Net.Mail.SmtpException: Mailbox unavailable. The server response was: bosauthsmtp05: Host 66.96.128.60: No unauthenticated relaying permitted at System.Net.Mail.MailCommand.CheckResponse( [code].....
I'm wondering why I can send sms messages from any one of my email accounts. But if I create a web app that sends emails, the email/message won't get to my phone. Why is that? Do all email providers use SMS gateways?
We have been experiencing a strange problem with emails being sent from our web server. We send out reminder emails once a month to our customers, it seems that not every one gets these emails. They have checked their spam folders etc and to no avail. Is there anything I can tweak on the server that may be causing certain people not to get the emails.
I want To send Mail On button click But getting Error Failure sending mail.(smtpException was Catched) public string SendEmail(string strTo_Email_Id, string subject, string strMail_Message)
So i have an emal that sends from the code behind, it creates an HTML table with stats from a database for the end user to see. Is there a way to insert graphics into the email, so i can make a table that actually looks good and not a table created from basic html?
