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(); }