ASP.NET

Haridas.R wrote:

While uploading excel file. it is getting error also.

Blumen wrote:

Could someone point me in the right direction

Blumen wrote:

Does tableless html design means using DIVs with the help of CSS?

Steve Echols wrote:

I've personally found going table-less involves a lot of pain, suffering

Steve Echols wrote:

I choose the route that makes sense to me (grids) and what I know works

 protected void Page_Load(object sender, EventArgs e)
    {
        try
        {
            SqlConnection _oSqlconn;
            SqlCommand _oSqlCmd;
            SqlDataAdapter _oAdapt = new SqlDataAdapter();
            DataTable DT;
            DT = new DataTable(); 
            string Sqlstr;

            
            _oSqlconn = new SqlConnection(ConfigurationManager.AppSettings["Test"]);
            _oSqlconn.Open();
             Sqlstr = "select cEmail_id1 from Master_Contacts";
            _oSqlCmd = new SqlCommand(Sqlstr, _oSqlconn);
            _oSqlCmd.CommandType = CommandType.Text;
            _oAdapt.SelectCommand = _oSqlCmd;
            _oAdapt.Fill(DT);  
            _oSqlconn.Close();

            if (DT.Rows.Count>0)
            {

                for (int i = 0; i <= DT.Rows.Count - 1; i++)
                {
                    string Body;
                    AlternateView htmlIV;
                             

Body = "<table cellpadding="0" cellspacing="0" bgcolor="#c1c1c1" align="center" width="100%" border="0">";
Body += "<td align="center">";
Body += "<table cellpadding="0" cellspacing="0" align="center" width="600" height="703" border="0">";
                    Body += "<tr>";
                    Body += "<td align="center"><img alt="" hspace="0" src="cid:imageId" align="middle" border="0"></img></td>";
                    Body += "</tr>";
                    Body += "</table>";
                    Body += "</td>";
                    Body += "";
                    Body += "</table>";

                    htmlIV = System.Net.Mail.AlternateView.CreateAlternateViewFromString(Body, null, "text/html");


                    System.Net.Mail.LinkedResource imagelink = new System.Net.Mail.LinkedResource(Server.MapPath(".") + "\\images\\S.jpg", "image/jpeg");


                    imagelink.ContentId = "imageId";

                    imagelink.TransferEncoding = System.Net.Mime.TransferEncoding.Base64;

                    htmlIV.LinkedResources.Add(imagelink);


                    System.Net.Mail.MailMessage mail = new System.Net.Mail.MailMessage("sathimailin@yahoo.com", Convert.ToString(DT.Rows[i]["cEmail_id1"]), ConfigurationManager.AppSettings["Subj"], Body);
                    mail.AlternateViews.Add(htmlIV);
                    System.Net.NetworkCredential mailAuthentication = new System.Net.NetworkCredential(ConfigurationManager.AppSettings["MailID"], ConfigurationManager.AppSettings["Pass"]);
                    System.Net.Mail.SmtpClient mailClient = new System.Net.Mail.SmtpClient("smtp.gmail.com", 25);
                    mailClient.EnableSsl = true;
                    mailClient.UseDefaultCredentials = false;
                    mailClient.Credentials = mailAuthentication;
                    mailClient.Send(mail);
                }
                
            }
  
           
        }
        catch (Exception a)
        {
            a.Message.ToString();
        }


    }