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("未选中行!"); } }