private void ContainColumn(string columnName, DataTable table)
{
DataColumnCollection columns = table.Columns;
if (columns.Contains(columnName))
{
....
}
}Source: https://stackoverflow.com/questions/17706326/how-to-check-if-a-column-exist-in-a-datatable
Token based authentication using ASP.NET Web API 2
Manage Identity in Multitenant Applications
https://docs.microsoft.com/en-us/azure/architecture/multitenant-identity/
List<int> IdsToFind = new List<int>() {2, 3, 4};
db.Users
.Where(u => SqlMethods.Like(u.LastName, "%fra%"))
.Where(u =>
db.CompanyRolesToUsers
.Where(crtu => IdsToFind.Contains(crtu.CompanyRoleId))
.Select(crtu => crtu.UserId)
.Contains(u.Id)
)Source: https://stackoverflow.com/questions/418609/how-to-do-a-subquery-in-linq
Try to use the DataColumn.SetOrdinal method. For example:
dataTable.Columns["Qty"].SetOrdinal(0);
dataTable.Columns["Unit"].SetOrdinal(1); UPDATE: This answer received much more attention than I expected. To avoid confusion and make it easier to use I decided to create an extension method for column ordering in DataTable:
Extension method:
public static class DataTableExtensions
{
public static void SetColumnsOrder(this DataTable table, params String[] columnNames)
{
int columnIndex = 0;
foreach(var columnName in columnNames)
{
table.Columns[columnName].SetOrdinal(columnIndex);
columnIndex++;
}
}
}Usage:
table.SetColumnsOrder("Qty", "Unit", "Id");or
table.SetColumnsOrder(new string[]{"Qty", "Unit", "Id"});
Source: https://stackoverflow.com/questions/3757997/how-to-change-datatable-columns-order
vgak 