public void Bind()
{
SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["Connection"]);
Sqlselete ss = new Sqlselete();
DataSet dsa = ss.SelectEmp("");
ListBox1.DataSource = dsa.Tables[0];
ListBox1.DataTextField = "Name";
ListBox1.DataValueField = "Employeeid";
ListBox1.DataBind();
con.Open();
string strSql1 = "select * from Employee where Employeeid in (select UserID from FlowStepPerson where StepID=" + Request.QueryString["stepid"] + ")";
SqlDataAdapter daa = new SqlDataAdapter(strSql1, con);
DataSet dss = new DataSet();
daa.Fill(dss);
this.ListBox2.DataSource = dss.Tables[0];
this.ListBox2.DataTextField = "Name";
this.ListBox2.DataValueField = "Employeeid";
this.ListBox2.DataBind();
con.Close();
}
public void Bind()
{
Sqlselete ss = new Sqlselete();
DataSet dsa = ss.SelectEmp("");
ListBox1.DataSource = dsa.Tables[0];
ListBox1.DataTextField = "Name";
ListBox1.DataValueField = "Employeeid";
ListBox1.DataBind();
string strSql1 = "select * from Employee where Employeeid in (select UserID from FlowStepPerson where StepID=" + Request.QueryString["stepid"] + ")";
this.ListBox2.DataSource = OperateDB.ExecuteDataSet(strSql1).Tables[0];
this.ListBox2.DataTextField = "Name";
this.ListBox2.DataValueField = "Employeeid";
this.ListBox2.DataBind();
}
