Comments by tek001 (Top 20 by date)

I did this to get the chlidNode of the node <listeners>

<add name="... traceOutputOptions=" none"="" ...=""> :

public void getListeners(string appName)
{
try

{


string FILE_NAME = string.Concat(appName, ".config");

XmlTextReader reader = new XmlTextReader(FILE_NAME);

XmlDocument doc = new XmlDocument();

doc.Load(reader);

reader.Close();

string nodeRoute = string.Concat("loggingConfiguration");


XmlNodeList elemList = doc.GetElementsByTagName(nodeRoute);

{
foreach (XmlNode elem in elemList)
{

foreach (XmlNode elemChild in elem.ChildNodes)
{
if (elemChild.Name.ToString() == "listeners")
{
int cpt = 0;

foreach (XmlNode item in elemChild.ChildNodes)
{
MessageBox.Show(item.OuterXml.ToString());

cpt++;
}

}
}

}



}





}
catch (Exception ex)
{

errorHandler(ex);

}


}
Now how can I get the different attributes separately?
And since the OuterXml property is read only, how can I do to set values?


Thanks for your help.

Best regards,
Tek001

Now I've tried this:

void showListeners()
{

Configuration MyConfig = ConfigurationManager.OpenExeConfiguration(ConfigurationManager.AppSettings["configFileExe"]);
var section = (AppSettingsSection)MyConfig.GetSection("loggingConfiguration");
string results = section.Settings["name"].Value;
MessageBox.Show(results);

}

but I get the ConfigurationErrorsException below at the second line - var section = (AppSettingsSection)MyConfig.GetSection("loggingConfiguration"); :

An error occurred creating the configuration section handler for loggingConfiguration: Could not load file or assembly 'Microsoft.Practices.EnterpriseLibrary.Logging, Version=5.0.414.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies.


I don't understand, I just want to read information...

Best regards,
Tek001

Hi,

Thanks for this reply but how can I access to a third party configSections since the targeted app.config doesn't belong to my application?

I've tried this but there's no result: which is a regular behavior cause I'm looking in my own app.config!



class LoggingConfiguration : ConfigurationSection
{


private static readonly ConfigurationProperty Name;


private static readonly ConfigurationPropertyCollection ConfigurationProperties;

static LoggingConfiguration()
{
// configuration properties here
Name = new ConfigurationProperty("name", typeof(string), null, ConfigurationPropertyOptions.IsRequired);

ConfigurationProperties = new ConfigurationPropertyCollection { Name };
}

[ConfigurationProperty("name", IsRequired = true)]
public string name
{
get { return (string)base[Name]; }
}

protected override ConfigurationPropertyCollection Properties
{
get { return ConfigurationProperties; }
}
}



and then in my main program:



void showListenersName()
{
var loggingConfiguration = ConfigurationManager.GetSection("loggingConfiguration") as LoggingConfiguration;
if (loggingConfiguration != null)
{
MessageBox.Show(loggingConfiguration.name);
}

}

PS: I can read a third party app.config from my application by using this:

public static Configuration configFile = ConfigurationManager.OpenExeConfiguration(ConfigurationManager.AppSettings["configFileExe"]);

with this in my application app.config:

<add key="configFileExe" value="C:\Users\Tek001\Desktop\TestConfig\Test.exe">

Best regards

done for appSettings section:
List<string> values = new List<string>();
for (int cpt=0; cpt < TabKeys.Length; cpt++)
{

string value = configFile.AppSettings.Settings[TabKeys[cpt]].Value.ToString();
values.Add(value);


}

string[] Values = values.ToArray();

Actually I did this for keys :
Configuration configFile = ConfigurationManager.OpenExeConfiguration(@"C:\Users\teka001\BiLauncher\BiLauncher\bin\BiLauncher.exe");
string[] TabKeys = configFile.AppSettings.Settings.AllKeys.ToArray();
Now I have to find a way to retrieve associated values from this third party "BiLauncher.exe.config"

There’s nothing done yet. I'm looking for the fastest and the securest way to read an app.config file belonging to another application by a C# win32 application (WinForm or WPF) and put the collected information into labels and textboxes in a dynamic way (It doesn’t matter how many keys there’re in the file) so I can change the values of these keys and save them back to the original app.config file.

done

ok.

The 2 fields used to join the 2 tables exist in both of them. I’ve got the same error with your query. Sorry to insist but this is definitively not an SQL issue.
PS : Oracle does not accept "as" as table's alias. 575 records returned on Toad for Oracle

Yes, I'm sure.I'm working with oracle 11.2. Both querries give same result on Toad for Oracle (571 records) and i've got almost the same InvalidOperationException in C#:

"The Dynamic SQL code's generation Failed . No key information was found."

Best regards.
Tek001

the 2 tables are already joined :
and i.num_int_int = u.num_int_int
and i.cod_soc = u.cod_soc

=> this is not an SQL issue.

I'm an SQL Developer and the query works fine on SQL+ or Toad

Ok, I'm sorry.

done

No actualy the SQL query works only if it contains a single table (second example) whatever the arithmetical sign is (<>, =). Using more than one table (2 in the first example) rises the InvalidOperationException!