|
Hi
Sorry to bother you guys but this is driving me nuts. I'm trying to retrieve a list of email addresses from a database, and send an email to all those addresses. For testing purposes, the database contains 1 address, mine. Code below (with senstivie bits *** out)
Protected Sub btnSend_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnSend.Click
If Page.IsValid Then
Dim strSQL As String
Dim MyConn As Data.SqlClient.SqlConnection
MyConn = New Data.SqlClient.SqlConnection(ConfigurationManager.ConnectionStrings("ConnectionString").ConnectionString)
Dim strBody As String
Dim Msg As New System.Net.Mail.MailMessage
Dim MailObj As New System.Net.Mail.SmtpClient()
'retrieve list of email address,IDs etc
strSQL = "Select * From vwNewsLetterList"
Dim objDR As Data.SqlClient.SqlDataReader
Dim Cmd As New Data.SqlClient.SqlCommand(strSQL, MyConn)
MyConn.Open()
objDR = Cmd.ExecuteReader(System.Data.CommandBehavior.CloseConnection)
'loop thru data, construct the message and send it
While objDR.Read()
strBody = txtMessage.Text
Msg.IsBodyHtml = True
Msg.Subject = "Test email"
MailObj.Host = "mail.*****.net"
Msg.From = New System.Net.Mail.MailAddress("*@*.net")
Msg.To.Add(New System.Net.Mail.MailAddress(objDR("Email")))
Msg.Body = strBody
MailObj.Send(Msg)
End While
MyConn.Close()
End If
End Sub
The code excutes with no errors, but... immediately afterwards I see my virus scanner going, and when I check my mail I get an "Undelivered Mail Returned to Sender" message from my virus checker, with the following info:
I'm sorry to have to inform you that the message returned
below could not be delivered to one or more destinations.
-------------------------------------------------------------------
*******@*****.com: sorry, that domain isn't allowed to be relayed thru this MTA (#5.7.1)
-------------------------------------------------------------------
Your e-mail message is being returned to you in the next part of this
message. Try to send the message again.
It seems as if the code is trying to send the message through my personal email server rather than the smpt client specified in the code. What am I doing wrong? Oh, and by the way... if I use "traditonal" ASP and specifiy this Smtp client, it works perfectly.
|
|
|
|
|
try this
Try
Dim smtpserver As Web.Mail.SmtpMail
Dim mesg As New Web.Mail.MailMessage
smtpserver.SmtpServer=strsmtpserver
mesg.From = mailFrom
mesg.To = mailto
mesg.Subject = subj
mesg.Body = messg
smtpserver.Send(mesg)
i = "Mail Sent"
Catch
i = "Failed to send Mail"
End Try
Remember that ur mail id should be a part of the smtp server e.g if ur id is xzy@yahoo.com then smtp server should be of yahoo else u will get the relay error message
|
|
|
|
|
OK, it's sorted - and I didn't have to change any of the code. It turns out my webhost wants the SMTP server bit called "localhost". Thats all that was required. Thank you for the reply though, smita_roy.
|
|
|
|
|
hey ,
well i'm a beginner in ASP.Net & i've leanrt something abt the latest ASP.Net 2.0 & i wanna walk to be an expert one day
i just tried to build ma first web page that enter to the database but i had a problem
ma web page doesn't shown , i see in the browser an other page that tells me that i can't open this database because it is already opened & stuffs & it gives me thecode i wrote in the maapp.aspx.vb & it stops in the first line
Connection.Open
i hope you understood me i really need that help i wanna make it work  thank you very much
try to be good if you can't be the best
|
|
|
|
|
most likely you have a invalid connection string to your database. make sure your premissions to the db are set correctly.
|
|
|
|
|
nop , everything is correct i think something in the configuration of the IIS server or something please i really wanna make this sh*t work so can you send me something or write me some steps to follow to get the result wanted ??
thank you very much
try to be good if you can't be the best
|
|
|
|
|
Hi,
I made a project with ASP.NET (C#) and SQL Server Express 2005. After I finished the project in my PC, I wanted to upload the project in the remote server. In my project folder, I had App_Data folder. So, I also created App_Data folder in my remote server. Then I transferred the .MDF file in from my App_Data folder to remote App_Data folder. My Reomote server (Lunarpages) has SQL Server 2005. My Web.Cnfig contains the connection string like this,
(add name="rBMain" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\rBOnline.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient")
But I was given error saying , Remote connection is not allowed. I am new in ASp.NET, would anyone please help me.
Thanks and regards
EMRAN
-- modified at 15:09 Monday 19th June, 2006
|
|
|
|
|
emran834 wrote: My Reomote server (Lunarpages)
probably doesn't use integrated security. Ask there tech support
|
|
|
|
|
So I have a Web.sitemap file like this:
<br />
<siteMapNode url="Default.aspx" title="Home" description="Start Page"><br />
<siteMapNode url="Profile/Default.aspx" title="Profile Settings" description="Profile Stuff"><br />
<siteMapNode url="Profile/Register.aspx" title="Register" description="Register your account"/><br />
<siteMapNode url="Profile/RetrievePassword.aspx" title="Retrieve Password" description="Retrieve your password"/> <br />
<siteMapNode url="Profile/EditProfile.aspx" title="Edit Profile" description="Edit your profile" roles="User"/><br />
<siteMapNode url="Profile/ChangePassword.aspx" title="Change Password" description="Change your password" roles="User"/><br />
</siteMapNode><br />
Note the last two options have Roles="User". As I understand it that means when a Menu control is configured to get its data from SiteMap provider it will only display those options to users in the role of "User". Also, I understand it that unauthorized users have no roles. That being said when I navigate to the page with that menu on it without being authenticated all 4 nodes show up in the menu.
Now just to test I put this code in the codebehind:
this.Label1.Text = Context.User.IsInRole("User") ? "true" : "false";
And it does indeed print false on the page (and true when I do log in) so I know for a fact that as an anonymous user I am not in the "user" role. What am I doing wrong here?
-- modified at 14:51 Monday 19th June, 2006
EDIT: Fixed < and >
|
|
|
|
|
|
Ok I read this page and added this to Web.config
<br />
<siteMap defaultProvider="XmlSiteMapProvider" enabled="true"><br />
<providers><br />
<add name="XmlSiteMapProvider"<br />
description="Default SiteMap provider."<br />
type="System.Web.XmlSiteMapProvider "<br />
siteMapFile="Web.sitemap"<br />
securityTrimmingEnabled="true" /><br />
</providers><br />
</siteMap><br />
Set roles="User" in one of the siteMapNode's and nothing changed. So I really don't know whats wrong here.
|
|
|
|
|
|
I have click event on button. It works fine after clicking the button twice it doesn't do anything on first click. After clicking it aging it works fine.
Any idea why???
Thanks
|
|
|
|
|
Whats the code in the Button_Click event handler?
Also do you already have focus on the window for the first click?
|
|
|
|
|
button is not dead ... when i click it first time it posts back ... goes to page load and comes back and doesn't do anything when i click it again it goes to the page load and then goes to event function and works fine ... but i don't why it doesn't go to click event on first click
Thanks
|
|
|
|
|
What exactly is it that it doesn't do on the first click? Is the button totally dead, or does it seem to react to the click? Perhaps it even causes a postback?
---
b { font-weight: normal; }
|
|
|
|
|
I have a main datagrid with three nested datagrids. These three are all child tables of the main table. I am wondering if you can create an edit (update/cancel) button that will enable the edit for all four datagrids. Is this possible?
Thanks!
|
|
|
|
|
It is possible. You only need to change the EditItemIndex and rebind each grid you need to edit. You can't do this automatically unfortunately.
My Blog
|
|
|
|
|
Another question then...If the parent table has one row, and nested data grid has 3 rows (example tblAnimal: Cat tblFood: canned, bag, tablefood) and I want to enable editing for all four of those items is that possible?
|
|
|
|
|
Hi,
What are the advantages of ASP.NET over J2EE?
Thanks.
|
|
|
|
|
|
I want to be record more information about a user then their email address, but I am having a lot of trouble finding out how to do this. I assume I have make a custom MembershipProvider and/or extend MembershipUser. The big problem is that, while every .net site in the work mentions you can write your own provider, the only article I can find about actually writing your own is for making it work through webservices which I have no interest in. So if anyone can point me in the right direction that would be great.
|
|
|
|
|
|
Hi,
IIS is not getting started!Even the World Wide Web Publishing!When I'm trying to create a web application,I'm getting an error as that the appln cannot be opened or created as Web Server is not running!I tried to connect from MMC!But I'm getting a message that The Connection couldn't get started!
What might be the workarounds for this problem?
Thank you!
Deepa!
Be the Change you want to See!
|
|
|
|
|
try Start-> CMD -> IISReset /start
That should return some info if it can't start it, or start the lil bugger if it can....
Check in services to see if its properties specify Auto-Start with OS. (Oh - bit silly, but you have INSTALLED it haven't you? Not installed by default with windoze)
"Now I guess I'll sit back and watch people misinterpret what I just said......"
Christian Graus At The Soapbox
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
