Read Local Text file and Insert in to Data Table.

For the below method pass the file path and it will returns the data-table which contains text data. #region Load Data into Data Table public DataTable GetDataSourceFromFile(string fileName) { DataTable dt = new DataTable("opportunity"); string[] columns = null; var lines = File.ReadAllLines(fileName); // assuming the first row contains the columns information if (lines.Count() > 0) … Continue reading Read Local Text file and Insert in to Data Table.

Assign Admin Role through Database Query For On Premise

Assign Admin Role through Database Query For On Premise : By Default , we can assign the admin role to a user through customizations. (Settings > Security> Users > Manage roles. For Assigning a role to new user, logged user must have the admin privileges.¬† So for any CRM Instance, atleast one user¬† must has … Continue reading Assign Admin Role through Database Query For On Premise