public UserMessages(string u)
{
InitializeComponent();
username = u;
UserName.Text = u;
btnSave.Enabled = false;
txtSign.Text = AccessOperation.ExecuteScalar("Select Sign From Messages Where UserName='******'").ToString();
try
{
s = AccessOperation.ExecuteScalar("Select Image From Messages Where UserName='******'").ToString();
}
catch
{
s = "";
}
try
{
Bitmap bmp = new Bitmap("D://image//" + s + ".bmp");
pictureBox1.Image = bmp;
}
catch
{
Bitmap bmp = new Bitmap("timg.jpg");
pictureBox1.Image = bmp;
}
txtSign2.Text = txtSign.Text;
txtName.Text = AccessOperation.ExecuteScalar("Select RealName From Messages Where UserName='******'").ToString();
txtOld.Text = AccessOperation.ExecuteScalar("Select Old From Messages Where UserName='******'").ToString();
cbSex.Text = AccessOperation.ExecuteScalar("Select Sex From Messages Where UserName='******'").ToString();
cbStyle.Text = AccessOperation.ExecuteScalar("Select Style From Messages Where UserName='******'").ToString();
DataSet myDataSet = AccessOperation.Query("Select * From Record Where UserName='******'", "Record");
dataGridView1.DataSource = myDataSet.Tables["Record"];
}
private void btnDelete_Click(object sender, EventArgs e)
{
if (movies != "")
{
AccessOperation.ExecuteNonQuery("Delete * From Record Where Movie = '" + movies + "' and UserName='******'");
MessageBox.Show("删除成功！");
DataSet myDataSet = AccessOperation.Query("Select * From Record Where UserName='******'", "Record");
dataGridView1.DataSource = myDataSet.Tables["Record"];
}
else
{
MessageBox.Show("未选中行！");
}
}
