private void FormMain_Load(object sender, EventArgs e)
{
try
{
SQLExecute excute = new SQLExecute();
DataSet ds = new DataSet();
ds = excute.GetMailDomain();
publicIntDomainCount = ds.Tables[0].DefaultView.Count;
for (int i = 0; i < publicIntDomainCount; i++)
{
publicStraMailDomain[i] = Convert.ToString(ds.Tables[0].Rows[i][0]);
}
//如果已经在本地保存了图片, 就直接到保存图片的文件里面去加载, 否则从数据库中读取
try
{
PicUserAvatar.SizeMode = PictureBoxSizeMode.Zoom;
//PicUserAvatar.Image = Image.FromFile(Environment.CurrentDirectory + @"\Pic\LoadingPic.png");
PicUserAvatar.LoadAsync(Environment.CurrentDirectory + @"\Pic\LoadingPic.png");
}
catch (Exception)
{
ds = excute.GetAvatarLoadingPic("LoadingPic");
MemoryStream ms = new MemoryStream((byte[])ds.Tables[0].Rows[0][0]);
PicUserAvatar.Image = Image.FromStream(ms);
Directory.CreateDirectory(Environment.CurrentDirectory + @"\Pic");
PicUserAvatar.Image.Save(Environment.CurrentDirectory + @"\Pic\LoadingPic.png");
}
//为了在开始就能够连接, 为了后续的连接能够快一点, 在load事件里面就连接,
//但如果没有一个messagebox的话, 后续的连接依旧是异常的慢, 所以...
MessageBox.Show("已连接数据库!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception ex)
{
MessageBox.Show("FormMain_Load:" + ex.Message, "警告", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
private void FormRegister_Load(object sender, EventArgs e)
{
SQLExecute excute = new SQLExecute();
DataSet ds = new DataSet();
try
{
//似乎只要定义了为zoom之后, 只要不更改, 后续加载的图片还是zoom的
PicAvatar.SizeMode = PictureBoxSizeMode.Zoom;
PicAvatar.Image = Image.FromFile(Environment.CurrentDirectory + "\\Pic\\LoadingPic.png");
}
catch (Exception)
{
ds = excute.GetAvatarLoadingPic("loadingPic");
MemoryStream ms = new MemoryStream((byte[])ds.Tables[0].Rows[0][0]);
PicAvatar.Image = Image.FromStream(ms);
Directory.CreateDirectory(Environment.CurrentDirectory + "\\Pic");
PicAvatar.Image.Save(Environment.CurrentDirectory + "\\Pic\\LoadingPic.png");
// MessageBox.Show(ex.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
ds = excute.GetMailDomain();
intMailDomainCows = ds.Tables[0].DefaultView.Count;
try
{
for (int i = 0; i < intMailDomainCows; i++)
{
straMailDomain[i] = Convert.ToString(ds.Tables[0].Rows[i][0]);
LstMailAddress.Items.Add(straMailDomain[i]);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "警告", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
