Hi Guys

I am trying to get my user viewer webpart to read users details from the whole table CMS_Users but it always retreives data from the current site i am working on. I modified this code in my the SetupControl method of userviewer web part

string strConnString2 = "Persist Security Info=False;database=NMMUWeb-S;server=blaze;user id=kentico-admin;password=ka2010;Current Language=English;Connection Timeout=240;";
                SqlConnection conn = new SqlConnection(strConnString2);
                SqlCommand sqlCom = new SqlCommand("select * from CMS_User ", conn);
                SqlDataAdapter da = new SqlDataAdapter(sqlCom);
                DataSet ds = new DataSet();

                da.Fill(ds);

                conn.Open();

                SqlDataReader reader = sqlCom.ExecuteReader();


                repUsers.DataSource = ds;
                repUsers.DataBind();

With this it fixed the issue and read all the users in the database when i initially load the page, now when i try to use the filter control (filterUsers.FilterName) it doesn't work.

Please help