public void SetCredentialOData(string url, string userName, string password) { DataSource dataSource = new DataSource("OData", url); if (userName == null) { DataSourceSetting dataSourceSetting = new DataSourceSetting("Anonymous"); CredentialStore.SetCredential(dataSource, dataSourceSetting, null); } else { var dataSourceSetting = DataSourceSetting.CreateUsernamePasswordCredential(userName, password); CredentialStore.SetCredential(dataSource, dataSourceSetting, null); } return; }
public void SetCredentialSQL(string sql, string userName, string password) { DataSource dataSource = new DataSource("SQL", sql); if (userName == null) { DataSourceSetting dataSourceSetting = new DataSourceSetting("Windows"); CredentialStore.SetCredential(dataSource, dataSourceSetting, null); } else { var dataSourceSetting = DataSourceSetting.CreateUsernamePasswordCredential(userName, password); CredentialStore.SetCredential(dataSource, dataSourceSetting, null); } return; }