i am try to make a email sending application but
there is a error will be occur
the error is bellow
ERROR:-Invalid object name 'Email'.
my code is bellow-
multiplemailsending22.aspx.cs
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Net.Mail;
using System.Data.SqlClient;
namespace csvfileupload2
{
public partial class multiplemailsending22 : System.Web.UI.Page
{
SqlDataAdapter da;
DataSet ds = new DataSet();
SqlConnection con;
SqlCommand cmd = new SqlCommand();
SqlDataReader read_Email;
protected void Page_Load(object sender, EventArgs e)
{
}
protected void btn1_Click(object sender, EventArgs e)
{
ArrayList list_emails = new ArrayList();
int i = 0;
string email;
string str = "Data Source=ANIRUDDHA-PC;Initial Catalog=sark;Integrated Security=True";
con = new SqlConnection(str);
con.Open();
SqlCommand cmd = new SqlCommand("Select email from Email", con);
SqlDataReader read_Email = cmd.ExecuteReader();
while (read_Email.Read())
{
email = read_Email.GetValue(i).ToString();
list_emails.Add(email); //Add email to a arraylist
i = i + 1 - 1;
}
read_Email.Close();
con.Close(); //Close connection
foreach (string email_to in list_emails)
{
MailMessage mail = new MailMessage();
Attachment attach = new Attachment(fileAttachement.PostedFile.FileName);
mail.To.Add(email_to);
mail.From = new MailAddress("[email protected]");
string Bcc = txtBcc.Text;
string cc = txtcc.Text;
mail.Subject = txtsubject.Text;
mail.Body = txtbody.Text;
SmtpClient smtp = new SmtpClient("SMTP Server");
smtp.Send(mail);
}
}
}
}
and my design page code is bellow-
multiplemailsending22.aspx:-
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="multiplemailsending22.aspx.cs" Inherits="csvfileupload2.multiplemailsending22" %>
|
please help me
Manas MohapatraPosted Jul 17, 2015, 8:46 AM
Manas MohapatraPosted Jul 17, 2015, 8:58 AM
Posted Jul 17, 2015, 8:52 AM
The specified string is not in the form required for an e-mail address.