|
Hi,
I am using gmail smtp for sending Emails and using this code :
// For sending Mail done by Nidhi on19sep08
public bool SendMail1(DataTable dt, string path)
{
string ToMail1 = "";
string UserName = "";
bool status = false;
int count = 0;
try
{
if (dt.Rows.Count > 1)
{
for (int i = 1; i <= dt.Rows.Count - 1; i++)
{
if (count == 0)
{
if (dt.Rows[0]["email"].ToString() != "")
{
ToMail1 = dt.Rows[0]["email"].ToString();
UserName = dt.Rows[0]["username"].ToString();
count = 1;
}
}
if (dt.Rows[i]["email"].ToString() != "")
{
ToMail1 = ToMail1 + "," + dt.Rows[i]["email"].ToString();
UserName = UserName + "," + dt.Rows[i]["username"].ToString();
}
}
}
else
{
if (dt.Rows.Count > 0)
{
if (dt.Rows[0]["email"].ToString() != "")
{
ToMail1 = dt.Rows[0]["email"].ToString();
UserName = dt.Rows[0]["username"].ToString();
}
}
}
if (dt.Rows.Count > 0)
{
bool mailSent = false;
SendMail objClsSendmail = new SendMail();
DataTable dtsmtpserver = objClsSendmail.getMailSetting();
int Port = Convert.ToInt32(dtsmtpserver.Rows[0][2].ToString());
string host = dtsmtpserver.Rows[0][1].ToString();
string User = dtsmtpserver.Rows[0][3].ToString();
string Password = dtsmtpserver.Rows[0][4].ToString();
MailAddress from = new MailAddress(dtsmtpserver.Rows[0][10].ToString());
MailAddress to = new MailAddress(ToMail1);
MailMessage msg = new MailMessage(from, to);
SqlConnection myConnection = new SqlConnection(SqlConnectionString.GetConnectionString());
SqlDataAdapter ad = new SqlDataAdapter("SELECT email FROM at_user where IsAdmin=1", myConnection);
DataTable ds = new DataTable();
ad.Fill(ds);
for (int k = 0; k <= ds.Rows.Count - 1; k++)
{
string[] id = ds.Rows[k][0].ToString().Split(',');
msg.CC.Add(id[0]);
}
string[] strUser = ToMail1.Split(',');
for (int j = 1; j < strUser.Length; j++)
{
msg.To.Add(strUser[j]);
}
if (path != "")
{
Attachment atcFile = new Attachment(path);
//***************Updated Code*********************
msg.Attachments.Add(atcFile);
}
// Subject
// msg.Subject = ddlProject.SelectedItem.Text.ToString()+"Post By" + Session["FirstName"].ToString() + " " + Session["LastName"].ToString();
msg.Subject = ddlProject.SelectedItem.Text.ToString() + " : " + ddlSubject.SelectedItem.Text + " (" + Session["FirstName"].ToString() + " " + Session["LastName"].ToString() + " )";
// Html message body
msg.IsBodyHtml = true;
msg.Body="<html><head> <title>Communication</title>";
// msg.Body=msg.Body+" color: #0A246A; padding:10px 0px 10px 10px;} .Regards{ font-weight: bold;color: #0A246A;";
// msg.Body=msg.Body+" padding:10px 0px 10px 10px; } a {color:#0077bd;} td {font-size: 14px; } </style>";
msg.Body=msg.Body+"</head><body > <table cellpadding='0' cellspacing='0' align='left' style='FONT-SIZE: 11px; FONT-FAMILY: Arial;width:800px; >";
msg.Body=msg.Body+"<tr><td rowspan='2' width='10'></td><td></td> </tr> ";
msg.Body=msg.Body+"<tr><td><table cellpadding='0' cellspacing='0' width='100%'>";
msg.Body = msg.Body + "<tr><td colspan='2'><p>";
//msg.Body = msg.Body + "<tr><td colspan='2'><div class=salute>Dear " + UserName + ",<p>";
msg.Body=msg.Body+ txtMessage.Value+"</p> </td> </tr>";
msg.Body = msg.Body + "<tr rowspan='2'><td></br></br><div> <div> Posted by</div> ";
msg.Body=msg.Body+"<div>"+Session["FirstName"].ToString() + " " + Session["LastName"].ToString();
msg.Body=msg.Body+" on "+ System.DateTime.Now.ToString()+"</div> </div> </td></tr> ";
msg.Body=msg.Body+ "</table></td></tr></table></body></html>";
//assigning Priority
msg.Priority = MailPriority.High;
SmtpClient client = new SmtpClient(host, Port);//
//client.UseDefaultCredentials = false;
client.EnableSsl = true;
// System.Net.NetworkCredential theCredential = new System.Net.NetworkCredential("excellent", "m49q3r");
System.Net.NetworkCredential theCredential = new System.Net.NetworkCredential(User, Password);
client.Credentials = theCredential;
Console.WriteLine("Sending an e-mail message to {0} by using the SMTP host{1}.", to.Address, client.Host);
client.Send(msg);//Sending the mail..
}
status = true;
//**********************************************************
}
catch (Exception ex)
{
status = false;
return status;
throw ex;
}
finally { }
return status;
}
I am using this xml for getting detail about SMTP setting
<?xml version="1.0" encoding="utf-8" standalone="yes" ?>
<MailSetting id="mailSettingInfo">
<Smtpauthenticate>1</Smtpauthenticate>
<SmtpServer>smtp.gmail.com</SmtpServer>
<SmtpPort>587</SmtpPort>
<Sendusername>abc@gmail.com</Sendusername>
<Sendpassword>123</Sendpassword>
<ProxcyServer />
<ProxcyUser />
<ProxcyPassword />
<ProxcyPort />
<ProxcyAuthenticate />
<FromMailID>xyz@gmail.com</FromMailID>
</MailSetting>
Now there is no problem in sending mail but there is one problem that when mail limit exceed its limit(perhaps it is 500/day) then it block sending mail for 24 hours.
Do any one have other idea to do this.
Thanx in advance
|
|
|
|
|
try with other smtp server except google
|
|
|
|
|
How to do that,i mean is there is any surety that using other smtp server we will not get authentication problem.
|
|
|
|
|
i think so but not sure u can try by defining another SMTP.u r software developer ??
|
|
|
|
|
Yes i m s/w developer,we have our own smtp server but i am getting problem while using it ,perhaps there is some problem in network setting,or may be problem in my code,so i need code for sending mail except than gmail smtp way.
|
|
|
|
|
|
i think it is ur networking problem . contact with ur network with this issue.
|
|
|
|
|
Hi friends i have done following coding for making a simple guestbook.where i define Name,Email , Location and meesage . I want to store all the values in database when i click on button . i dont know how to do this . coz im new in programming. plz reply me on manvikaur2@gmail.com. if anyone knows .
----------------------------------------------------------------------------
<title>Guestbook.NET
----------------------------------------------------------------------------
i try to connect with SQL server 2005 after creating the table. but not able to done this .
|
|
|
|
|
jasjit 007 wrote: i try to connect with SQL server 2005 after creating the table. but not able to done this .
Why ? What problem are you getting ? Did you tried with google ?
cheers,
Abhijit
|
|
|
|
|
hi sir ,
i think u r not understanding the prob.i want to make a assignemt . when i click on button all the data will be store in SQL sever 2005 . i have created the web.config file where i define the connection string. now how to define the table.but im not able to do this .plz run the code in microsoft visual studio if u have
Thanks
Jasjit
|
|
|
|
|
I think u need to add runat="server" on input type control...
|
|
|
|
|
 hi sir ,
i think u r not understanding the prob.i want to make a assignemt . when i click on button all the data will be store in SQL sever 2005 . i have created the web.config file where i define the connection string. now how to define the table.but im not able to do this .plz run the code in microsoft visual studio if u have
Thanks
Jasjit
|
|
|
|
|
What is your code for make connection,where did u get problem
|
|
|
|
|
Hi nidhi ,
im sending u code for connectivey. plz tell me whr is the prob . i want to submit all the data in databse when i click on button . i define web.config .but prob is not solved.
public partial class _Default : System.Web.UI.Page
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["cn"].ConnectionString);
SqlCommand cmd = new SqlCommand();
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
conn.Open();
cmd.Connection = con;
cmd.CommandText = "insert into guest values(@Name ,@email ,@location,@Message)";
}
|
|
|
|
|
Could you pls send me web.config code also,one more thing is there have u debug ur code,i think when u'll click on button it will not go to your this event:
protected void Button1_Click(object sender, EventArgs e)
{
conn.Open();
cmd.Connection = con;
cmd.CommandText = "insert into guest values(@Name ,@email ,@location,@Message)";
}
pls debug ur code and then let me know that ur debugger is going to this event or not.
|
|
|
|
|
no nidhi this is not the prob. it goes to that event. i m sending u my web.config file
<configuration>
<appsettings>
<connectionstrings>
<add name=" cn" connectionstring="server=192.168.0.4/ver2005;database=test_jasjit;uid=jasjit;pwd=jasjit;">
<system.web>
<compilation debug="true">
<authentication mode="Windows">
|
|
|
|
|
You r trying to fetching connectino from web.config using this code
:
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["cn"].ConnectionString);
but you have not define connection in web.config.
please write this code in your web.config and update :you sql server name,
your database name,userid for accessing database,password for accessing database
<connectionStrings>
<add name="cn" connectionString="Data Source=you sql server name;Initial Catalog=your database name;User ID=userid for accessing database;pwd=password for accessing database;Max Pool Size = 8000; Pooling = true;"
providerName="System.Data.SqlClient " />
</connectionStrings>
|
|
|
|
|
Hello fellow developers,
I am currently using .NET 3.5, C#...
I have searched the forums and google for a match on this one and no one seems to hit the mark. I have found close answers, but they are just missing one aspect. So here goes:
Simple question:
How can I set an Image to a FileUpload stream without first saving that Stream to a file or a DB?
Read below for more "Background info"
I am currently using a FileUpload control to allow the user to upload an image to be attached to a "Profile". I want the user to be able to preview that image before they save the form and it gets streamed to the DB and stored. Basically, once they hit the upload button, I want that Stream from the FileUpload control to be "Loaded" into the Image Control. I want to do this all without writing to disk as a temporary preview image and then pointing to that url... I just don't like that solution.
Currently I just save the image to the DB with the Profile data and then use an HTTP Handler file to read the image data I saved and stream it back to the image using image property ( IE: ImageURL="DisplayImage.ashx?id=133" ) which works great.
I tried to store the image data in a session variable, but then found out that the session data is not available to my HTTP handler DisplayImage.ashx, although the context.Session is there in Intellisense and in the debugger, but it is null, so the Session from the page calling it is not available.
I will gladly post any code requests if you need more information on what I am doing.
Kind Regards,
Ryan
|
|
|
|
|
well, looks like I posted this just a bit soon, my next researching effort netted me the solution.
I simply had my HttpHandler inherit the System.Web.SessionState.IRequiresSessionState interface and the Session was available for me to use.
public class DisplayImage : IHttpHandler, IRequiresSessionState {
Regards,
Ryan
|
|
|
|
|
I see many site have for each user own libary
ex: www.somedomain.com/users/newUser
My question is how can i do that? how can i create for each user
his/her own libary not using IIS ofcourse because
what if i'd have 10000 users...
than  x
|
|
|
|
|
|
Adding to the other reply,
You can also use ASP.NET MVC which will produce URLs like what you said. But it is still in beta
|
|
|
|
|
Hey Navaneeth Congrats For MVP !!!
cheers,
Abhijit
|
|
|
|
|
That was unexpected. Congratulations to you too!
|
|
|
|
|
N a v a n e e t h wrote: That was unexpected.
Not At All  !!!.
cheers,
Abhijit
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
