DataTable
demoTable;
///
Function to define table structure
demoTable = CreateTableStructure();
foreach (SearchResult result in
searcher.FindAll())
{
UserDisplayName = GetProperty(result, EmpDisplayName);
Designation = GetProperty(result,
EmpDesignation);
Department = GetProperty(result,
EmpDepartment);
EMail = GetProperty(result, EmpEMail);
///
Create rows in the table & insert values in every column.
DataRow row1 = demoTable.NewRow();
row1["userdisplayname"] = UserDisplayName;
row1["designation"] = Designation;
row1["department"] = Department;
row1["email"] = EMail;
demoTable.Rows.Add(row1);
}
///
Function to read values from data table one by one & perform further
operations
UpdateList(demoTable);
///
Function to read value of a specified property from Active Directory
private string GetProperty(SearchResult
searchResult, string PropertyName)
{
if
(searchResult.Properties.Contains(PropertyName))
{
return
searchResult.Properties[PropertyName][0].ToString();
}
else
{
return string.Empty;
}
}
///
Function to create table structure
public DataTable CreateTableStructure ()
{
DataTable demotab = new
DataTable();
DataColumn displayname = new
DataColumn("userdisplayname");
DataColumn designation = new
DataColumn("designation");
DataColumn department = new
DataColumn("department");
DataColumn email = new
DataColumn("email");
displayname.DataType = System.Type.GetType("System.String");
designation.DataType = System.Type.GetType("System.String");
department.DataType = System.Type.GetType("System.String");
email.DataType =
System.Type.GetType("System.String");
demotab.Columns.Add(displayname);
demotab.Columns.Add(designation);
demotab.Columns.Add(department);
demotab.Columns.Add(email);
return demotab;
}
///
Function to perform Operations on List by reading each row of table
public void UpdateList (DataTable
demoTable)
{
string UserDisplayName;
string Designation;
string Department;
string EMail;
if (demoTable.Rows.Count > 0)
{
for (int i = 0; i
<= demoTable.Rows.Count - 1; i++)
{
UserDisplayName =
demoTable.Rows[i]["userdisplayname"].ToString();
Designation =
demoTable.Rows[i]["designation"].ToString();
Department =
demoTable.Rows[i]["department"].ToString();
EMail =
demoTable.Rows[i]["email"].ToString();
//Perform
List Update Operation
}
}
}
