Posted on April 21, 2007 by abhimjoshi
1. Send Simple Mail in Asp.Net without any credentials (Host, Username or password)
========================================================================
using System.Net.Mail;
public static void SendMail(string From, string To, string Body, string Subject)
{
SmtpClient objSmtpClient = new SmtpClient();
// Given SMTP Server name here.
objSmtpClient.Host = ConfigurationManager.AppSettings["SmtpServer"].ToString();
objSmtpClient.Port = 25;
MailMessage objMailMessage = new MailMessage();
MailAddress objMailAddress = new MailAddress(From);
objMailMessage.From = objMailAddress;
objMailMessage.To.Add(To);
objMailMessage.Subject = Subject;
objMailMessage.IsBodyHtml = true;
objMailMessage.Body = Body;
objMailMessage.Priority = MailPriority.High;
objSmtpClient.Send(objMailMessage);
}
2. [...]
Filed under: Uncategorized | Leave a Comment »
Posted on April 21, 2007 by abhimjoshi
Generate Excel File from Datagrid or GridView in Asp.Net
=================================================
private void GenerateExcelFile(DataSet dsData)
{
DataTable objDataTable = new DataTable();
objDataTable.Columns.Add(new DataColumn(“PageTitle”));
objDataTable.Columns.Add(new DataColumn(“MetaData”));
objDataTable.Columns.Add(new DataColumn(“Title”));
objDataTable.Columns.Add(new DataColumn(“Price”));
objDataTable.Columns.Add(new DataColumn(“PriceRetail”));
objDataTable.Columns.Add(new DataColumn(“StyleNumber”));
objDataTable.Columns.Add(new DataColumn(“DescShort”));
objDataTable.Columns.Add(new DataColumn(“DescLong”));
objDataTable.Columns.Add(new DataColumn(“SmallImage”));
objDataTable.Columns.Add(new DataColumn(“LargeImage”));
objDataTable.Columns.Add(new DataColumn(“DateDownload”));
foreach (DataRow dr in dsData.Tables[0].Rows)
{
DataRow ObjDr = objDataTable.NewRow();
ObjDr["PageTitle"] = dr["PageTitle"];
ObjDr["MetaData"] = dr["MetaData"];
ObjDr["Title"] = dr["Title"];
ObjDr["Price"] = dr["Price"];
ObjDr["PriceRetail"] = dr["PriceRetail"];
ObjDr["StyleNumber"] = dr["StyleNumber"];
ObjDr["DescShort"] = dr["DescShort"];
ObjDr["DescLong"] = dr["DescLong"];
ObjDr["SmallImage"] = dr["SmallImage"];
ObjDr["LargeImage"] = dr["LargeImage"];
ObjDr["DateDownload"] = [...]
Filed under: Asp.Net | Leave a Comment »