C#

falles01 wrote:

if (adoDR["TechnicalSkillsID"])

falles01 wrote:

if (techSkillsCheckListBox2.Items.Equals(adoDR["TechnicalSkillsID"].ToString()))

... generate and execute the query for returning the techskills for the given employee
DataTable techSkillsTable = myDataSet.Tables[0];

//Query should return only one row, but we'll go with a foreach
foreach(DataRow row in techSkillsTable.Rows)
{
    foreach (DataColumn column in techSkillsTable.Columns)
    {
        string techSkillName = column.ColumnName;
        bool userHasSkill = false;

        try
        {
            userHasSkill = Convert.ToBoolean(row[column]);
        }
        catch
        {
            //Do nothing here as userHasSkill is initialized to false.
        }

        techSkillsListBox.Items.Add(techSkillName, userHasSkill);
    }
}

Pete O`Hanlon wrote:

You could always do a select before you do the insert, but this is no guarantee that the data isn't being inserted by another user at the same time.

DanB1983 wrote:

**Edit - basically what I would like to be able to do is ask any pixel inside a control its colour and also to set its colour

... in the method where you process your dataset data ...
DataTable table = yourDataSet.Tables[int tableindex]; //with one table you'd use yourDataSet.Tables[0]
int rowCounter = 0;
foreach(DataRow row in table.Rows)
{
   //Retrieve the data from the various columns in the row through row[int columnindex]
   //or row["columnname"], or iterate over the columns too and create them generically.
   //Example of latter one
   foreach(DataColumn column in table.Columns)
   {
      TextBox textBox = CreateValueTextbox(
         column.ColumnName + rowCounter,
         row[column.ColumnName]);

      this.Controls.Add(textBox);
      rowCounter++; //increase rowcounter by 1
   }
}
...
//I'll create a helpermethod for creating the textboxes.
private TextBox CreateValueTextbox(string textBoxName, string value)
{
   TextBox textBox = new TextBox();
   textBox.Name = textBoxName;
   textBox.Text = value;
   return textBox;
}

Image backupImage = Properties.Resources.backupImage;
bool equal = image == backupImage;