DataBase

Read Local Text file and Insert in to Data Table.

balugajjala Console, CRM, DataBase, Dynamics 365

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

balugajjala CRM, DataBase, 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