private void btnDBList_Click(object sender, EventArgs e)
{
AccessPostgreSQL post = new AccessPostgreSQL(txtPostgreSQL.Text);
List<string> list = post.getDatabaseListInServer();
if(list.Count > 0){
cboDatabaseList.Items.Clear();
foreach(var name in list)
cboDatabaseList.Items.Add(name);
}
}
private void btnConvert_Click(object sender, EventArgs e)
{
if(clTables.CheckedItems.Count > 0 && cboDatabaseList.Text.Length > 0){
string ConnectionString = txtPostgreSQL.Text;
string DatabaseName = cboDatabaseList.Text;
string[] conArr = txtPostgreSQL.Text.Split(';');
for(var i = 0; i < conArr.Length; i++)
if(conArr[i] == "database=template1")
conArr[i] = string.Format("database={0}", DatabaseName);
ConnectionString = string.Join(";", conArr);
AccessPostgreSQL psql = new AccessPostgreSQL(ConnectionString);
foreach(string tablename in clTables.CheckedItems)
{
MessageBox.Show(tablename);
psql.putDataToServer(tablename, getDestinationTable(tablename));
}
}
}
