+- LCKB (https://lckb.dev/forum)
+-- Forum: ** OLD LCKB DATABASE ** (https://lckb.dev/forum/forumdisplay.php?fid=109)
+--- Forum: Programmers Gateway (https://lckb.dev/forum/forumdisplay.php?fid=196)
+---- Forum: Coders Talk (https://lckb.dev/forum/forumdisplay.php?fid=192)
+---- Thread: [C#]Doubt (/showthread.php?tid=891)
- TheEvilAnt - 06-15-2012
I got a problem with a piece of code I want to modify the app.config with a textbox so I use this but it doesnt work it update but doesnt change the values:
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using MySql.Data.MySqlClient;
using MySql.Data.Types;
using System.Configuration;
namespace MySql
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
Update_ConData();
}
private void button2_Click(object sender, EventArgs e)
{
Set_ConData();
Update_ConData();
}
public void Update_ConData()
{
//Read parameters App.config
string server = ConfigurationManager.AppSettings["server"];
string db = ConfigurationManager.AppSettings["db"];
string user = ConfigurationManager.AppSettings["user"];
string pass = ConfigurationManager.AppSettings["pass"];
//Put the variables in the textboxes
textBox1.Text = Convert.ToString(server);
textBox2.Text = Convert.ToString(user);
textBox3.Text = Convert.ToString(pass);
textBox4.Text = Convert.ToString(db);
}
public void Set_ConData()
{
Configuration config = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None);
string mito = "[CeNsOrEd]";
config.AppSettings.Settings["server"].Value = Convert.ToString(textBox1);
config.AppSettings.Settings["user"].Value = Convert.ToString(textBox2);
config.AppSettings.Settings["pass"].Value = Convert.ToString(textBox3);
config.AppSettings.Settings["db"].Value = Convert.ToString(textBox4);
config.Save(ConfigurationSaveMode.Modified);
}
}
}
- someone - 06-15-2012
Open the configuration file:
ExeConfigurationFileMap configMap = new ExeConfigurationFileMap();
configMap.ExeConfigFilename = "mysql.config";
Configuration config = ConfigurationManager.OpenMappedExeConfiguration(configMap, ConfigurationUserLevel.None );
Reading data from the configuration file:
string server = config.AppSettings.Settings["server"].Value;
string user = config.AppSettings.Settings["user"].Value;
string pass = config.AppSettings.Settings["pass"].Value;
string db = config.AppSettings.Settings["db"].Value;
Saving the configuration file:
config.AppSettings.Settings["server"].Value = server;
config.AppSettings.Settings["user"].Value = user;
config.AppSettings.Settings["pass"].Value = pass;
config.AppSettings.Settings["db"].Value = db;
config.Save();
To add or remove Data would be something like this:
config.AppSettings.Settings.Add("NewKey", "NewValue");
config.AppSettings.Settings.Remove("NewKey");
This is the configuration file mysql.config
<?xml version="1.0" encoding="utf-8" ?>
And a code example:
string server = "", user = "", pass = "", db = "";
ExeConfigurationFileMap configMap = new ExeConfigurationFileMap();
configMap.ExeConfigFilename = "mysql.config";
Configuration config = ConfigurationManager.OpenMappedExeConfiguration(configMap, ConfigurationUserLevel.None );
//checks if file exists
if (!config.HasFile)
{
//generates a file
XmlTextWriter writer = new XmlTextWriter("mysql.config", null);
XmlDocument doc = new XmlDocument();
doc.LoadXml("");
doc.Save(writer);
writer.Close();
config = ConfigurationManager.OpenMappedExeConfiguration(configMap, ConfigurationUserLevel.None);
//saves a basic configuration
config.AppSettings.Settings.Add("server", server);
config.AppSettings.Settings.Add("user", user);
config.AppSettings.Settings.Add("pass", pass);
config.AppSettings.Settings.Add("db", db);
config.Save();
}
//reds the file
server = config.AppSettings.Settings["server"].Value;
user = config.AppSettings.Settings["user"].Value;
pass = config.AppSettings.Settings["pass"].Value;
db = config.AppSettings.Settings["db"].Value;
//Processs the data
//save data
config.AppSettings.Settings["server"].Value = server;
config.AppSettings.Settings["user"].Value = user;
config.AppSettings.Settings["pass"].Value = pass;
config.AppSettings.Settings["db"].Value = db;
config.Save();
- TheEvilAnt - 06-16-2012
Lot of thanks
- roseon - 06-16-2012
xD this Code cause me so mutch anoying Problems lmao but i found a nother way to read around that xD