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:

Web Forms :: How To Send Email Based On Selection Of CustomerID From DropDownList

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

Set DropdownList SelectedItem After Submit?

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

DropDownList : SelectedItem Isn't Changing?

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

Web Forms :: DropDownlist Selecteditem Not Updateing?

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

Web Forms :: FindControl SelectedItem In Dynamic DropDownList

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

Web Forms :: DropDownList Accessing SelectedItem Property After Binding It ?

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

Web Forms :: DropDownList SelectedItem Object Reference Not Set Error?

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

Forms Data Controls :: Dropdownlist Doesnt Return Selecteditem's VALUE?

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

SQL Server :: Getting A Email Deliver Status When Sending Email Using Msdb.dbo.sp_send_dbmail?

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

Visual Studio 2005 - Sending An Email To User Input Email?

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

Web Forms :: Email Text Formatting Not Changing When Sending An Email

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

Web Forms :: Sending An Email Causes Error - Specified String Not In Email Format

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

Web Forms :: Sending An Email As An HTML Email

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

Web Forms :: Sending Email With Domain Email

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

Dropdownlist In .net C# / SelectedItem.Text == "Reg" STA And STM Are Not Present?

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

Web Forms :: Populate DropDownList Based On RadioButtons And Populate GridView Based On DropDownList

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

How To Create An Email Application That Support Sending And Receive Email Application

Jan 29, 2010

I need to create an email application that support sending and receive email application.

View 1 Replies

Sending Email With Checkboxes?

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

Sending Email Not Working

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

Sending SMS Through Email But Not Web Apps?

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

Sending Email To A New Server?

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

Sending Email From Web Server

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

Sending Email Through Coding?

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

Sending Email From VB Codebehind?

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







Copyrights 2005-15 www.BigResource.com, All rights reserved