C#

private void WndSearchResults_FormClosing(object sender, FormClosingEventArgs e)
{
    if (bgDatabaseSearcher.IsBusy)
    {
         if (MessageBox.Show(Resources.msgSearchActive_WindowClosing, "Question",
 MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
         {
             e.Cancel = true;
             return;
         }
         else
         {
             bgDatabaseSearcher.CancelAsync();
             while (bgDatabaseSearcher.IsBusy) 
                  Thread.Sleep(500);
         }
    }
}

private void bgDatabaseSearcher_DoWork(object sender, DoWorkEventArgs e)
        {
            VFS virtualFS = new VFS();

            foreach (ListEntry entry in imagesToSearch)
            {
                try
                {
                    virtualFS.OpenConnection(Path.Combine(AppSettingsManager.ImagesDirectory, entry.imageDbPath));
                    foreach (VFSSearchTerm searchTerm in termsToSearch)
                    {
                        virtualFS.SearchVFS(searchTerm, searchOptions, SearchResultProcessor, entry.imageID);
                        if (bgDatabaseSearcher.CancellationPending) /* The control 
doesn't reach this point if a call to CancelAsync() has been made from the form closing event. */
                        {
                            virtualFS.CloseConnection(true);
                            return;
                        }
                    }
                }
                finally
                {
                    virtualFS.CloseConnection(true);
                }
            }
        }

NpgsqlCommand com = new NpgsqlCommand("SELECT tablee AS Table, columnn AS Column, sort AS Sort, " +                " criteria AS Criteria, or1 AS ColOr1, or2 AS ColOr2 FROM queryfilters "+                " WHERE category='" + category + "' AND queryname='" + descr + "' AND modifier='"+modifier+"'", mycon);            NpgsqlDataAdapter da = new NpgsqlDataAdapter(com);            DataTable dt = new DataTable();            BindingSource bs = new BindingSource();            da.Fill(dt);            bs.DataSource = dt;            if(dt.Rows.Count != 0)            {                qDesigner.dgvFilters.AutoGenerateColumns = false;                qDesigner.dgvFilters.DataSource = bs;                qDesigner.dgvFilters.Columns["dgvColTable"].DataPropertyName = dt.Columns[0].ColumnName;                //qDesigner.dgvFilters.Columns["dgvColColumn"].DataPropertyName = dt.Columns["Column"].ColumnName;                //qDesigner.dgvFilters.Columns["dgvColSort"].DataPropertyName = dt.Columns["Sort"].ColumnName;                qDesigner.dgvFilters.Columns["dgvColCriteria"].DataPropertyName = dt.Columns["Criteria"].ColumnName;                qDesigner.dgvFilters.Columns["dgvColOr1"].DataPropertyName = dt.Columns["ColOr1"].ColumnName;                qDesigner.dgvFilters.Columns["dgvColOr2"].DataPropertyName = dt.Columns["ColOr2"].ColumnName;            }

User Name              User
Alias                  Alias
Income                 Income
Gender                 Gender
Age                    Age

public void GetUserMatch(XmlNode usersNode, string CritBody, string CritAgeFrom, string CritAgeTo, string CritHeightFrom, string CritHeightTo)
      {
         XmlNodeList userNodes = usersNode.SelectNodes("Clients");
         Users[] users = new Users[userNodes.Count];
         MatchUsers[] matchUser = new MatchUsers[users.Length];
         for (int i = 0x0; i < users.Length; i++)
         {
            XmlNode userNode = userNodes[i];
            string userName = userNode.SelectSingleNode("Username").InnerText;
            string alias = userNode.SelectSingleNode("Alias").InnerText;
            string bodyType = userNode.SelectSingleNode("BodyType").InnerText;
            string strheight = userNode.SelectSingleNode("Heightft").InnerText;
            string displayheight = userNode.SelectSingleNode("DisplayHeight").InnerText;
            string strage = userNode.SelectSingleNode("Age").InnerText;
            string gender = userNode.SelectSingleNode("Gender").InnerText;
            string income = userNode.SelectSingleNode("Income").InnerText;

            int intHeight = Convert.ToInt32(strheight);
            int intAge = Convert.ToInt32(strage);

            users[i] = new Users(userName, alias, bodyType, intHeight, displayheight, intAge, gender, income);
         }
            
         
                     
            MatchUsers[] matchUsers = new MatchUsers[0];
            int ii = 0;
               foreach (Users mUser in users)
               {
                  

                  string Bodytype = mUser.BodyType;
                  if (string.Compare(Bodytype, CritBody) == 0)
                  {
                     int intAge = Convert.ToInt32(mUser.Age);
                     if (intAge >= Convert.ToInt32(CritAgeFrom) & intAge <= Convert.ToInt32(CritAgeTo))
                     {
                        int intHeight = Convert.ToInt32(mUser.Height);
                        if (intHeight >= Convert.ToInt32(CritHeightFrom) & intHeight <= Convert.ToInt32(CritHeightTo))
                        {
                           string userName = mUser.UserName;
                           string alias = mUser.Alias;
                           string bodyType = mUser.BodyType;
                           string height = mUser.DisplayHeight;
                           string age = mUser.Age.ToString();
                           string gender = mUser.Gender;
                           string income = mUser.Income;

                           matchUser[ii] = new MatchUsers(userName, alias, bodyType, height, age, gender, income);
                           ii++;
                        }
                     }
                  }
                  
               }
              
         DataSet ds = new DataSet();
         DataTable dt = new DataTable("UserMatch");
         ds.Tables.Add(dt);

         DataColumn dc1 = new DataColumn("User Name");
         DataColumn dc2 = new DataColumn("Alias");
         DataColumn dc3 = new DataColumn("Body Type");
         DataColumn dc4 = new DataColumn("Height");
         DataColumn dc5 = new DataColumn("Age");
         DataColumn dc6 = new DataColumn("Gender");
         DataColumn dc7 = new DataColumn("Income");

         dt.Columns.Add(dc1);
         dt.Columns.Add(dc2);
         dt.Columns.Add(dc3);
         dt.Columns.Add(dc4);
         dt.Columns.Add(dc5);
         dt.Columns.Add(dc6);
         dt.Columns.Add(dc7);

         int iii = 0;
         foreach (MatchUsers mUsers in matchUser)
			{
            DataRow dr = dt.NewRow();
            if (mUsers != null)
            {
               dr["User Name"] = mUsers.UserName;
               dr["Alias"] = mUsers.Alias;
               dr["Body Type"] = mUsers.BodyType;
               dr["Height"] = mUsers.Height;
               dr["Age"] = mUsers.Age;
               dr["Gender"] = mUsers.Gender;
               dr["Income"] = mUsers.Income;

               dt.Rows.Add(dr);

               iii++;
            }
            
			}
         this.UserBindingSource.DataSource = ds;
         //Check count of bindingsource.. last checked 1
         int asdf = this.UserBindingSource.Count;

         // Bind the CompanyName field to the Label control.
         this.lblMatchUserName.DataBindings.Add(
             new Binding("Text",
             this.UserBindingSource,
             "UserMatch.User Name",
             true));
         this.lblMatchUserAlias.DataBindings.Add(
             new Binding("Text",
             this.UserBindingSource,
             "UserMatch.Alias",
             true));
         this.lblMatchUserBody.DataBindings.Add(
             new Binding("Text",
             this.UserBindingSource,
             "UserMatch.Body Type",
             true));
         this.lblMatchUserHeight.DataBindings.Add(
             new Binding("Text",
             this.UserBindingSource,
             "UserMatch.Height",
             true));
         this.lblMatchUserAge.DataBindings.Add(
             new Binding("Text",
             this.UserBindingSource,
             "UserMatch.Age",
             true));
         this.lblMatchUserGender.DataBindings.Add(
             new Binding("Text",
             this.UserBindingSource,
             "UserMatch.Gender",
             true));
         this.lblMatchUserIncome.DataBindings.Add(
             new Binding("Text",
             this.UserBindingSource,
             "UserMatch.Income",
             true));
         
      }

private void button1_Click(object sender, EventArgs e)
      {
         if (this.UserBindingSource.Position + 1 < this.UserBindingSource.Count)
         {
            this.UserBindingSource.MoveNext();
            this.fnDisplayPosition();
         } 

      }

      

      private void button2_Click(object sender, EventArgs e)
      {
         this.UserBindingSource.MovePrevious();
         this.fnDisplayPosition();

      }
      private void fnDisplayPosition()
      {
         this.lblPostion.Text = this.UserBindingSource.Position +
              1 + " of " + this.UserBindingSource.Count;
      }

if (this.UserBindingSource.Position + 1 < this.UserBindingSource.Count)