public txtDatabase()
{
InitializeComponent();
settings = settings1.ReadSettings();
//SqlCommand cmd = new SqlCommand();
//SqlDataReader reader;
dbinfo1.ServerName = settings.serverName;
dbinfo1.DBName = settings.dbName;
dbinfo1.DBPort = settings.dbPort;
dbinfo1.DBUser = settings.userName;
dbinfo1.DBPWD = settings.password;
//connectionString = "Data Source=localhost;Initial Catalog=eplus040_data;User ID=root;Password=metalic";
//connectionString = "Data Source=serverName;Initial Catalog=settings.dbName;User ID=root;Password=metalic";
connectionString = dbinfo.getConnectionString(dbinfo1);
//connectionString = "Data Source=mserver;Initial Catalog=eplus030_data;User ID=admin;Password="******"Connection Open ! ");
MessageBox.Show("Connection Open!\n", "Connection", MessageBoxButtons.OK, MessageBoxIcon.None);
dbinfo.createLogFile(dbinfo1);
}
catch (MySqlException ex)
{
MessageBox.Show("Can not open connection ! \n" + ex.ToString());
//MessageBox.Show(ex.ToString());
}
//DataSet ds = new DataSet();
//MySqlDataAdapter adapter = new MySqlDataAdapter("SELECT brcode from branchstore",cnn);
adapter.SelectCommand = new MySqlCommand("SELECT code from branchmaster", cnn);
try
{
adapter.Fill(ds, "branchmaster");
}
catch (MySqlException ex)
{
MessageBox.Show("No Branches Available!\n" + ex.ToString());
}
//this.lstBranch.DataSource = ds.Tables[0];
//this.lstBranch.DisplayMember = "Branch";
//this.lstBranch.DisplayMember = "brcode";
// int i = 0;
foreach (DataRow row in ds.Tables[0].Rows)
{
for (int i = 0; i < ds.Tables[0].Columns.Count; i++)
{
lstBranch.Items.Add(row[i].ToString());
/*lstBranch.Items.Add(ds.Tables[0].Rows[i][0].ToString());
* i++;*/
}
}
}
public xmlSettings ReadSettings()
{
xmlSettings settings = new xmlSettings();
if (!File.Exists(xmlSettingsFile))
{
settings.success = false;
settings.errorMessage = "File not found (" + xmlSettingsFile + ")";
return(settings);
}
string xmlElement = "";
XmlTextReader reader = new XmlTextReader(xmlSettingsFile);
while (reader.Read())
{
switch (reader.NodeType)
{
case XmlNodeType.Element:
xmlElement = reader.Name;
//MessageBox.Show(objXmlTextReader.Name);
break;
case XmlNodeType.Text:
switch (xmlElement)
{
case "SERVER":
settings.serverName = reader.Value;
break;
case "DATABASE":
settings.dbName = reader.Value;
break;
case "PORT":
settings.dbPort = reader.Value;
break;
case "USER":
settings.userName = reader.Value;
break;
case "PWD":
settings.password = reader.Value;
break;
case "TIMER":
settings.timer = reader.Value;
break;
}
break;
}
}
reader.Close();
settings.success = true;
settings.errorMessage = "";
return(settings);
}
public txtDatabase()
{
InitializeComponent();
settings = settings1.ReadSettings();
dbinfo1.ServerName = settings.serverName;
dbinfo1.DBName = settings.dbName;
dbinfo1.DBPort = settings.dbPort;
dbinfo1.DBUser = settings.userName;
dbinfo1.DBPWD = settings.password;
connectionString = dbinfo.getConnectionString(dbinfo1);
cnn = new MySqlConnection(connectionString);
try
{
cnn.Open();
//MessageBox.Show("Connection Open!\n", "Connection", MessageBoxButtons.OK, MessageBoxIcon.None);
//dbinfo.createLogFile(dbinfo1,null);
cmd.Connection = cnn;
//cmd.CommandText = "UPDATE " + dbinfo1.DBName + ".setup SET `DBTYPE`='DistributedServer' WHERE `CODE`='01'";
//cmd.ExecuteNonQuery();
//cmd.CommandText = "update databasemaster set logdbname = '" + dbinfo1.DBName.Replace("_data", "_log") + "' , logservername = '" + dbinfo1.ServerName + "' , logport = '" + dbinfo1.DBPort +"' where code = '01'";
// cmd.ExecuteNonQuery();
}
catch (MySqlException ex)
{
MessageBox.Show("Can not open connection ! \n" + ex.ToString());
}
adapter.SelectCommand = new MySqlCommand("SELECT code from branchmaster", cnn);
try
{
adapter.Fill(ds, "branchmaster");
}
catch (MySqlException ex)
{
MessageBox.Show("No Branches Available!\n" + ex.ToString());
}
/* foreach (DataRow row in ds.Tables[0].Rows)
* {
* for (int i = 0; i < ds.Tables[0].Columns.Count; i++)
* {
* lstBranch.Items.Add(row[i].ToString());
* }
* }*/
this.lstBranch.SelectedIndexChanged -= new System.EventHandler(this.lstBranch_SelectedIndexChanged);
lstBranch.DataSource = ds.Tables["branchmaster"];
lstBranch.DisplayMember = "code";
lstBranch.ValueMember = "code";
this.lstBranch.SelectedIndexChanged += new System.EventHandler(this.lstBranch_SelectedIndexChanged);
}
