100分,急!!!这是jmail原代码,但是一运行到中间的存储过程那里,就跳到了catch{}里了,请问怎样可以执行中间的存储过程,并可以存储所有的ema
以下是用jmail收邮件的原代码,但是一运行到中间的存储过程那里,就跳到了catch{}里了,请问怎样可以实现数据库存取所有的email内容.(请高手指点)
jmail.Message Msg=new jmail.Message();
jmail.POP3 jpop=new jmail.POP3();
try
{
jpop.Connect("**.163.com","***","pop3.163.com",110);
}
catch(Exception ex)
{
Count.Text=ex.Message.ToString();
}
int count=jpop.Count;
SqlConnection conn=new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["connectionstring"]);
SqlCommand cmd=new SqlCommand("lm_insert",conn);
cmd.CommandType=CommandType.StoredProcedure;
conn.Open();
for(int i=1;i<=count;i++)
{
try
{
Msg = jpop.Messages[i];
Sendform.Text = Msg.FromName.ToString();
Subject.Text = Msg.Subject;
Datetime.Text = Msg.Date.ToString();
Body.Text = Msg.Body.ToString();
cmd.Parameters.Add("@name",Sendform.Text.ToString());
cmd.Parameters.Add("@body",Body.Text.ToString());
cmd.Parameters.Add("@data",Msg.Date.ToString());
cmd.Parameters.Add("@title", Msg.Subject.ToString());
cmd.Parameters.Add("@fujian","d");
int aa=cmd.ExecuteNonQuery();
}
catch(Exception ex)
{
Count.Text=ex.Message.ToString();
}
}
conn.Close();
jpop.Disconnect();