/// <summary>
/// 连接数据库
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btOpenDb_Click(object sender, EventArgs e)
{
OleDbConnection conn = SqlHeper.connectDatabase();
SqlHeper.openDbConnection(conn);
if (conn.State == ConnectionState.Open)
{
tsslParaDbStatus.ForeColor = Color.Green;
tsslParaDbStatus.Text = "数据库打开成功";
comm = SqlHeper.openDbCommand(conn);
btOpenDb.Enabled = false;
}
else
{
tsslParaDbStatus.ForeColor = Color.Red;
tsslParaDbStatus.Text = "数据库打开失败";
}
}
private void btParaQuery_Click(object sender, EventArgs e)
{
lbParaName.Items.Clear();
string queryKeyValue = "'%" + tbParaName.Text.Trim() + "%';";
string queryStr = "select * from para where parameter_name like " + queryKeyValue;
dt = SqlHeper.dataTable(comm, conn, queryStr);
if (dt.Rows.Count > 0)
{
lbParaName.Enabled = true;
}
else
{
lbParaName.Enabled = false;
}
for (int i = 0; i < dt.Rows.Count; i++)
{
lbParaName.Items.Add(dt.Rows[i]["parameter_name"].ToString());
}
}
