Problem in getting email id's separated by comma

[KBSK]

Hi,
I'm using VS.Net 2005
and MS Access

I'm using the following code for sending email......
the problem is I've to extract email id's from database and put them in TO or CC field separated with comma when Page is loaded

plz help me in this regard

// message elements
private string mMailServer;
private string mTo;
private string mFrom;
private string mMsg;
private string mSubject;
private string mCC;
private int mPort;



override protected void OnInit(EventArg s e)
{

base.OnInit(e);
btnSend.Click += new System.EventHan dler(btnSend_Cl ick);
}

private void MessageBox(stri ng strMsg)
{
Label lbl = new Label();
lbl.Text = "<script language='javas cript'>" + Environment.New Line + "window.ale rt(" + "'" + strMsg + "'" + ")</script>";

Page.Controls.A dd(lbl);

}



protected void btnSend_Click(o bject sender, System.EventArg s e)
{
string strMsg = null;
strMsg = txtMessage.Text ;

System.Data.Ole Db.OleDbConnect ion con = new System.Data.Ole Db.OleDbConnect ion("Provider=M icrosoft.Jet.Ol eDb.4.0;Data Source=c:/mms.mdb");
con.Open();

mTo = txtTo.Text.Trim (' ');
mFrom = txtFrom.Text.Tr im(' ');
mSubject = txtSubject.Text .Trim(' ');
mMsg = txtMessage.Text .Trim(' ');
mMailServer = ConfigurationMa nager.AppSettin gs.Get("localho st");
mPort = 25;
mCC = txtCC.Text.Trim (' ');

try
{

MailMessage message = new MailMessage(mFr om, mTo, mSubject, mMsg);

if (fileAttachment s.HasFile)
{
Attachment attached = new Attachment(file Attachments.Pos tedFile.FileNam e.ToString().Tr im(' '));
message.Attachm ents.Add(attach ed);
}

if (mCC != "" | mCC != string.Empty)
{
string[] strCC = mCC.Split(';');
foreach (string strThisCC in strCC)
{
message.CC.Add( strThisCC.Trim( ' '));
}
}


SmtpClient mySmtpClient = new SmtpClient(mMai lServer, mPort);
mySmtpClient.Us eDefaultCredent ials = true;
mySmtpClient.Se nd(message);

MessageBox("The mail message has been sent to " + message.To.ToSt ring());

}
catch (FormatExceptio n ex)
{

MessageBox("For mat Exception: " + ex.Message);

}
catch (SmtpException ex)
{

MessageBox("SMT P Exception: " + ex.Message);

}
catch (Exception ex)
{

MessageBox("Gen eral Exception: " + ex.Message);

}

}





In PageLoad I'm currently using the following code


System.Data.Ole Db.OleDbConnect ion con;
System.Data.Ole Db.OleDbCommand cmd1;
System.Data.Ole Db.OleDbDataAda pter adap;
DataSet ds = new DataSet();


string sql = string.format(" select email from emp);
adap = new System.Data.Ole Db.OleDbDataAda pter(cmd);
for (I = 0; I < ds.Tables["emp"]. Rows.Count; I++)
{
txtTO.Text = ds.Tables["emp"]. Rows[i]["email"] + ",";
}

[shweta123]

Hi,

Are you getting any error?
Otherwise ,Your code seems to be ok.
You ,can check for the null value of email before this

txtTO.Text = ds.Tables["emp"]. Rows[i]["email"] + ",";.

[KBSK]

Hi,

Are you getting any error?
Otherwise ,Your code seems to be ok.
You ,can check for the null value of email before this

txtTO.Text = ds.Tables["emp"]. Rows[i]["email"] + ",";.

Hi, I'm getting Object reference not set to an instance of an object. error in for loop

for (int I = 0; I < ds.Tables["emp"]. Rows.Count; I++)
{
txtTo.Text = ds.Tables["emp"]. Rows[i]["email"] + ",";
}







How to send email to my own system and see it ???