Shuffle/ReOrder DataTable Columns

private void ShuffleDataTableColumns(DataTable dt,string columnList)
{
int columnIndex = 0;
foreach (var columnName in columnList.Split(','))
{
if (dt.Columns[columnName] != null)
{
dt.Columns[columnName].SetOrdinal(columnIndex);
columnIndex++;
}
}
}

Comments

Post a Comment

Popular posts from this blog

Difference between Parse/TryParse/ParseExact/TryParseExact

Parse ===== //int.Parse("12.44"); //Exception : Above code will generate the exception "Input string was not in a correct format", just because you are trying to cast float/real value in int[Integer]. //Only it is parsing if your parameter value must match the desire type in which you are trying to parse. TryParse ======== //case #1 int.TryParse("14.55",out a); //case #2 int.TryParse("14", out a); //Above code(case 1) will return 'false', just because parsing operation gets failed and value for variable 'a' would be 'zero' //here consider 'a' is output type of parameter like we have in oracle/sql server(not exactly same but behavior is same). //if parsing get succeeded than it will return true and target variable (i.e. 'a') will have the...
Read more

Benefits of Test Driven Development (TDD)

1: Developer plays the role of user and developer while writing code, hence customer centric approach throughout the development 2: Reduces real time issues because of code written with end user mindset 3: Initially takes time but overall less-n-less debugging time 4: Identify cascading code break early or related change in other modules 5: Regression fix early 6: Help avoiding over engineering code which we don’t need actually 7: Avoid Scope Creep, helps in design and create high possibility of acceptance
Read more

Setup Hangfire in visual studio solution | Hello World Application

Image
Step 1: Open Visual Studio and Execute below command in Package Manager  Install-Package Hangfire After installation ensure highlighted reference added in project Step 2: Make sure SQL Server/Express or any edition reachable from your application - as Hangfire create set of tables Step 3: class Startup | Initialize hangfire Step 4: Register class|method that you want set as cron job Step 5: Run the application, hit the index url to register method - watch d:\ after a minute
Read more