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
View 7 Replies
Similar Messages:
Jun 13, 2012
how to send an email based on selection of customer id from combo box the body of the mail is similar for all
View 1 Replies
Dec 9, 2010
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--")%>
View 3 Replies
Sep 28, 2010
I am populating a DropDownList control as follows -
public partial class UserControls_PMS_Send2DeliveryTeam : System.Web.UI.UserControl
{
protected void Page_Load(object sender, EventArgs e)
[code]...
View 4 Replies
Mar 29, 2011
I have a dropdownlist in a Usercontrol defined in a table as:
<asp:DropDownList
runat="server"
id="lstDIDFCM"
Width="135px"
AutoPostBack="true"
></asp:DropDownList>
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?
View 5 Replies
Jun 5, 2010
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.
View 5 Replies
Oct 28, 2010
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.
[Code]....
here is my aspx code:
[Code]....
View 3 Replies
May 27, 2012
Object reference not set to an instance of an object.
if((drpdept.SelectedItem.Text != "--Select--")|| (drpdept.SelectedItem.Text !=null))
{
}
i hve above line but i get Object reference not set
View 1 Replies
Jan 18, 2011
I am using the following code :
Protected Sub DropDownList1_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles DropDownList1.SelectedIndexChanged
Response.Redirect("memberlogin.aspx?d=" + DropDownList1.SelectedValue.ToString)
[code]...
View 3 Replies
Aug 24, 2010
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 ?
View 2 Replies
Feb 23, 2011
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.
View 1 Replies
Jul 18, 2010
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.....
View 7 Replies
Feb 12, 2010
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.
[CODE]
View 1 Replies
Jun 1, 2010
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?
View 4 Replies
Aug 5, 2012
I want to the code/procedure to send mail to clients using email provideed by domain or website hosting eg; abc@domain.com this my email id.....
I want to use this feature to send password to upon registration to user ..
View 1 Replies
Nov 16, 2010
I have two dropdownlist's.DropDownList2(not bound to a datasource) and DropDownList3(bound to a datasource)
On change on input in one dropdownlist some content in the other Dropdownlist should change. For that i had used the logic as.
Autopostback is enabled for both this controls.
protected void DropDownList2_SelectedIndexChanged(object sender, EventArgs e)
{
if (DropDownList2.SelectedItem.Text == "Stamp")[code]....
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 ?
View 2 Replies
Oct 5, 2012
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.
View 1 Replies
Jan 29, 2010
I need to create an email application that support sending and receive email application.
View 1 Replies
Jun 30, 2010
I am trying to figure something out, on this page:
[URL]
I have the following code:
PHP Code:
[code]....
View 8 Replies
Mar 28, 2010
using
public
class MailHelper [code]......
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].....
View 8 Replies
May 28, 2010
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?
View 7 Replies
Mar 7, 2011
I have a simple asp page that sends the email when the user clicks on the submit button which is working fine in one server.
Now I moved this asp file to new server. Now in the asp file everything works except sending email programatically.
I know that I need to enable the server to send emais how can I do that?
(windows server 2008, iis 7)
View 4 Replies
Nov 4, 2010
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.
View 4 Replies
Feb 19, 2011
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)
{
try
{
[code]...
View 2 Replies
Jun 2, 2010
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?
View 1 Replies