private void FillcmbWorkingProcedureID()
{
try
{
if (m_myConnection==null)
{
m_myConnection=new SqlConnection(ConnectionString);
}

string SqlTxt="select WorkingProcedureID,WorkingProcedurename from WorkingProcedure where WorkingProcedureID <>'A1' order by Sequence ";
System.Data.SqlClient.SqlDataAdapter com=  new System.Data.SqlClient.SqlDataAdapter(SqlTxt,m_myConnection);
System.Data.DataSet ds= new System.Data.DataSet();System.Data.DataSet ds1= new System.Data.DataSet(); com.Fill(ds,"WorkingProcedure" );com.Fill(ds1,"WorkingProcedure" );

this.cmbStartWorkingProcedure.DisplayMember="WorkingProcedurename";
this.cmbStartWorkingProcedure.ValueMember="WorkingProcedureID";
this.cmbStartWorkingProcedure.DataSource=ds.Tables["WorkingProcedure"].DefaultView;
this.cmbEndWorkingProcedure.DisplayMember="WorkingProcedurename";
this.cmbEndWorkingProcedure.ValueMember="WorkingProcedureID";
this.cmbEndWorkingProcedure.DataSource=ds1.Tables["WorkingProcedure"].DefaultView;
}
catch(Exception e1)
{
MessageBox.Show(e1.Message,"错误",MessageBoxButtons.OK,MessageBoxIcon.Error);
}
finally
{
m_myConnection.Close();
}
}