C# Dataset Dynamically Add DataColumn
- by Wesley
I am trying to add a extra column to a dataset after a query has completed. I have a database relationship of the following:
Employees
/ \
Groups EmployeeGroups
Empoyees holds all the data for that individual, I'll name the unique key the UserID.
Groups holds all the groups that a employee can be a part of, i.e. Super User, Admin, User; etc. I will name the unique key GroupID
EmployeeGroups holds all the associations of which groups each employee belongs too. (UserID | GroupID)
What I am trying to accomplish is after querying for a all users I want to loop though each user and add what groups that user is a part of by adding a new column to the dataset named 'Groups' which is a string to insert the values of the next query to get all the groups that user is a part of. Then by user of databinding populate a listview with all employees and their group associations
My code is as follows; Position 5 is the new column I am trying to add to the dataset.
string theQuery = "select UserID, FirstName, LastName, EmployeeID, Active from Employees";
DataSet theEmployeeSet = itsDatabase.runQuery(theQuery);
DataColumn theCol = new DataColumn("Groups", typeof(string));
theEmployeeSet.Tables[0].Columns.Add(theCol);
foreach (DataRow theRow in theEmployeeSet.Tables[0].Rows)
{
theRow.ItemArray[5] = "1234";
}
At the moment, the code will create the new column but when i assign the data to that column nothing will be assigned, what am I missing?
If there is any further explination or information I can provide, please let me know.
Thank you all