🙂 İNSANLARIN EN HAYIRLISI INSANLARA FAYDALI OLANDIR 🙂

Ramazan HABER / C# Athena / XML’e Connection Ekleme

 

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);

 

            }

 

        }

 2021 Ocak 18 Pazartesi
 446