private void 测试工程设置ToolStripMenuItem_Click(object sender, EventArgs e)
{
string strFilePath = "Provider=Microsoft.ACE.OLEDB.12.0;Data source=" + Application.StartupPath + "\\makemoney.mdb";
System.Data.OleDb.OleDbConnection conn = new OleDbConnection(strFilePath);
try
{
FormSetpara FormSetparaDig = new FormSetpara();
OleDbDataAdapter adapter = new OleDbDataAdapter();
string sqlstr = "select * from 工程参数表";
DataSet ds = new DataSet();
conn.Open();
adapter.SelectCommand = new OleDbCommand(sqlstr, conn);
adapter.Fill(ds, "工程参数表");
DataTable dt = ds.Tables["工程参数表"];
DataRow[] dr = dt.Select("1=1");
conn.Close();
for (int i = 0; i < dr.Length; i++)
{
Label lb = new Label();
lb.Location = new System.Drawing.Point(75, 60 * (i + 1) - 30);
lb.Text = dr[i]["参数名称"].ToString() + ":";
lb.Name = "lable" + i.ToString();
lb.AutoSize = true;
TextBox tx = new TextBox();
tx.Location = new System.Drawing.Point(75, 30 * 2 * (i + 1));
tx.Size = new System.Drawing.Size(400, 25);
tx.Tag = dr[i]["ID"].ToString();
tx.Name = dr[i]["参数名称"].ToString();
Button bt = new Button();
bt.Location = new System.Drawing.Point(500, 30 * 2 * (i + 1));
bt.Text = "浏览";
bt.Name = dr[i]["参数名称"].ToString() + "Add";
bt.Click += (se, a) => addFile(tx);
FormSetparaDig.Controls.Add(lb);
FormSetparaDig.Controls.Add(tx);
FormSetparaDig.Controls.Add(bt);
}
Button btok = new Button();
btok.Location = new System.Drawing.Point(500, 30 * 2 * (dr.Length + 1));
btok.Text = "确定";
btok.Click += (se, a) => SelectOk(FormSetparaDig);
FormSetparaDig.Controls.Add(btok);
FormSetparaDig.ShowDialog();
}
catch (Exception exc)
{
throw (new Exception("数据库出错:" + exc.Message));
}
}
private void 工程设置ToolStripMenuItem_Click(object sender, EventArgs e)
{
FormSetpara FormSetparaDig = new FormSetpara();
FormSetparaDig.ShowDialog();
}
private void SelectOk(FormSetpara FormSetparaDig)
{
FormSetparaDig.Close();
}