ASP.NET

       [ConnectionConsumer("Input Values")]<br />
       public void GetValues(ITransformableFilterValues values)<br />
       {<br />
           foreach (string val in values.ParameterValues)<br />
               {<br />
                   //this.Provider_Values += this.Provider_Values != " " ?","+ "'" + val +"'" : "'" + val + "'" ;<br />
                   this.Provider_Values = val;<br />
                   this.Provider_Name = values.ParameterName;<br />
                   ds = new SqlDataSource();<br />
                   ds.ID = "Source ID";<br />
                   ds.ConnectionString = cString;<br />
                   ds.SelectCommand = this.SQLSelectCommand;//"select distinct " + cName + " from " + tName + " where " + this.Provider_Name+ " = '" + this.Provider_Values+ "';";<br />
                   cBList.DataTextField = cName;<br />
                   cBList.DataValueField = cName;<br />
                   cBList.DataSource = ds;<br />
                   cBList.ID = "List ID";<br />
                   cBList.Attributes.Add("onclick", "FindSelectedItems(this," + tB.ClientID + ");");<br />
                   cBList.DataBind();<br />
               }<br />
           <br />
       }<br />
        public void BuildControls()<br />
           {  <br />
           try<br />
           {<br />
               cBList = new CheckBoxList();<br />
               this.Controls.Add(cBList);<br />
           }<br />
           //Sql exception cought.<br />
           catch (Exception ex)<br />
           {<br />
               ex1 = ex.Message;<br />
           }<br />
       }<br />
<br />
       protected override void CreateChildControls()<br />
       {<br />
           this.BuildControls();<br />
           base.CreateChildControls();<br />
       }<br />
<br />
       protected override void OnInit(EventArgs e)<br />
       {<br />
           this.Page.LoadComplete += new EventHandler(Page_LoadComplete);<br />
           base.OnInit(e);<br />
       }<br />
       <br />
       void Page_LoadComplete(object sender, EventArgs e)<br />
       {<br />
           if (this.Page.IsPostBack && !String.IsNullOrEmpty(this.Provider_Name) && String.IsNullOrEmpty(this.Provider_Values))<br />
           {<br />
               ds.SelectCommand = "select distinct " + cName + " from " + tName + " where " + this.Provider_Name + " = '" + this.Provider_Values + "';";<br />
               <br />
           }<br />
        <br />
       }