C#

JollyMansArt wrote:

1)How to create a XML file that stores the connection string
2)How to refer to that XML file to use the connection string in the application.

JollyMansArt wrote:

I am wanting in a external XML file editable to the end user

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
	<appSettings>
		<add key="MainDB" value="Data Source=127.0.0.1;Initial Catalog=MainDB;User ID=usr;Password=pwd"/>		
	</appSettings>	
</configuration>

System.Configuration.AppSettingsReader reader = new System.Configuration.AppSettingsReader();
string connString = (string)reader.GetValue("MainDB", typeof(string));

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
	<connectionStrings>
		<add name="MainDB" providerName="System.Data.SqlClient" connectionString="Data Source=127.0.0.1;Initial Catalog=MainDB;User ID=usr;Password=pwd"/>		
	</connectionStrings>
</configuration>

string s = System.Configuration.ConfigurationManager.ConnectionStrings["MainDB"].ConnectionString;

string fname = "";
if (Request.Form["customer_fname"] != null)
{ fname = Request.Form["customer_fname"]; }
Response.Write("fname value: " + fname);

public static bool CheckAccountDisabled(DirectoryEntry de)
{
        int ACCOUNTDISABLE = 0x0002;
	int flags = (int)de.Properties["userAccountControl"].Value;
	if (((flags & ACCOUNTDISABLE) == ACCOUNTDISABLE))
	{
		return true;
	}
	return false;
}