1-) C# Athena - XML'e Connection Ekleme
public void MyUpdateXML() {
try {
string W_Config_Path = Directory.GetParent(Directory.GetParent(System.Reflection.Assembly.GetExecutingAssembly().Location).ToString().ToString()).ToString() + "\\Config";
string AthConnNames = W_Config_Path + "\\AthConnNames.xml";
string W_xmlStringPre= System.IO.File.ReadAllText(AthConnNames); // sistemdeki xml
string xmlString = W_xmlStringPre; // güncellenmiş hali
string W_HedefVT = HVeriTabanları.Text;// HVeriTabanları.Text -> yeni açılan DATAGC2018
string W_HedefDBX = H_SIRKET_KOD.Text;
string W_XmlEklenecek = " <connection-unit name=\"" + W_HedefVT + "\">\n <description>Athena " + W_HedefDBX + "</description>\n <properties>\n <property name=\"dbx\" value=\"" + W_HedefDBX + "\" />\n <property name=\"url\" value=\"Server=" + txt_servername.Text + ";Database=" + W_HedefVT + ";User Id=myUsername;Password=myPassword;\" />\n <property name=\"jdbc.driver\" value=\"com.microsoft.sqlserver.jdbc.SQLServerDriver\" />\n <property name=\"jdbc.url\" value=\"jdbc:sqlserver://localhost;instanceName=ATHENA;databaseName=" + W_HedefVT + ";user=myUsername;password=myPassword\" />\n </properties>\n </connection-unit>";
xmlString = xmlString.Substring(0, xmlString.IndexOf("</connection>")) + W_XmlEklenecek + "\n\n</connection>";
if (!W_xmlStringPre.Contains(W_HedefVT)) {
if (File.Exists(@"" + AthConnNames + "")) {
File.Delete(@"" + AthConnNames + "");
}
System.IO.File.WriteAllText(W_Config_Path + "\\AthConnNames.xml", xmlString);
}
} catch (Exception ex) {
MessageBox.Show("HATA->MyUpdateXML->" + ex.Message);
}
}