C#

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)

private void ReceiveMessages()
{
    //
    // This method executes in its own thread
    try
    {
        // Get the stream where responses will come from
        srReceiver = new StreamReader(tcpServer.GetStream());

        string result = string.Empty;
        
        while (Connected)
        {
            //
            // Read the next byte and convert it to a char 
            char CurrentChar = (char)srReceiver.Read();

            //
            // if the current character is one of the three Terminators, flag as such
            if (CurrentChar == RecordTerminator)      // 0x00
            {
                result += "[Record Terminator]";
            }
            else if (CurrentChar == FieldTerminator)  // 0x01
            {
                result += "[Field Terminator]";
            }
            else if (CurrentChar == PacketTerminator) // 0x02
            {
                result += "[Packet Terminator]";
            }
            else
            {
                result += CurrentChar.ToString();
            }

            if (#########) // Condition??? :confused:
            {
                //
                // Send the response back to the main thread
                this.Invoke(new UpdateLogCallback(this.UpdateLog), new object[] { result });

                //
                // Clear the result string
                result = string.Empty;
            }
        }
    }
    catch (Exception ex)
    {
        //
        // Send exception back to the main thread
        this.Invoke(new UpdateLogCallback(this.UpdateLog), new object[] { ex.Message });
    }
}

private Color forecolor = SystemColors.WindowText;
     [Category("Appearance")]
     public Color ForeColor
     {
         get { return forecolor; }
         set { forecolor = value; }
     }