111,125
社区成员
发帖
与我相关
我的任务
分享 private void button1_Click(object sender, EventArgs e)
{
string strconn = "Provider=Microsoft.Jet.OLEDB.4.0;Data source=Addresslist.mdb";
OleDbConnection myconn = new OleDbConnection(strconn);
try
{
if (textBox15.Text != "")
{
myconn.Open();
string strcomm = "select * from record where xm='" + textBox15.Text.Trim() + "'";
OleDbCommand mycomm = new OleDbCommand(strcomm, myconn);
OleDbDataReader myreader = mycomm.ExecuteReader();
if (myreader.Read())
{
textBox1.Text = myreader.GetString(1);
textBox2.Text = myreader.GetString(4);
textBox3.Text = myreader.GetString(5);
textBox4.Text = myreader.GetString(6);
textBox5.Text = myreader.GetString(7);
textBox6.Text = myreader.GetString(8);
textBox7.Text = myreader.GetString(9);
textBox8.Text = myreader.GetString(10);
textBox9.Text = myreader.GetString(2);
if (myreader.GetString(11) != "")
pictureBox1.Image = Image.FromFile(myreader.GetString(11));
else
pictureBox1.Image = Image.FromFile("7.jpg");
MessageBox.Show("不存在此记录", "提示信息");
}
else
{
MessageBox.Show("不存在此记录", "提示信息");
textBox15.Text = "";
textBox15.Focus();
}
}
else
{
MessageBox.Show("查找信息不能空", "提示信息");
textBox15.Focus();
}
}
catch (OleDbException ex)
{
MessageBox.Show(ex.Message, "提示信息");
MessageBox.Show(myconn.State.ToString(), "提示信息");
}
}