protected void GridViewTables_SelectedIndexChanged(object sender, EventArgs e)
{
columnButtons.Visible = true;
columnMessage.Visible = false;
string selectedTable = GridViewTables.SelectedValue.ToString();
selectedGVTable.Value = selectedTable;
string pageInfo = "viewTable.aspx?con=" + conID + "&tbl=" + selectedTable;
string window = "window.open('" + pageInfo + "'); return false;";
viewTable.Attributes.Add("onclick", window);
if (selectedTable != "")
{
ConnInfo connInfo = ConnInfo.getConnInfo(conID);
string connectionString = "";
string providerName = "";
//Set drop down box accordingly
if (connInfo.getDatabaseType() == ConnInfo.MSSQL)
{
connectionString = "Data Source=" + connInfo.getServerAddress() + ";Initial Catalog=" + connInfo.getDatabaseName() + ";Persist Security Info=True;User Id=" + connInfo.getUserName() + ";Password="******"SELECT COLUMN_NAME FROM information_schema.COLUMNS WHERE (TABLE_NAME = '" + selectedGVTable.Value + "')";
ColGen.DataBind();
}
else if (connInfo.getDatabaseType() == ConnInfo.MYSQL)
{
connectionString = "server=" + connInfo.getServerAddress() + ";User Id=" + connInfo.getUserName() + ";password="******";Persist Security Info=True;database=" + connInfo.getDatabaseName();
providerName = "MySql.Data.MySqlClient";
ColGen.ConnectionString = connectionString;
ColGen.ProviderName = providerName;
ColGen.SelectCommand = "SELECT COLUMN_NAME FROM information_schema.COLUMNS WHERE (TABLE_NAME = '" + selectedGVTable.Value + "')";
ColGen.DataBind();
}
else if (connInfo.getDatabaseType() == ConnInfo.ORACLE)
{
connectionString = "Data Source=" + connInfo.getServerAddress() + ";Persist Security Info=True;User ID=" + connInfo.getUserName() + ";Password="******";Unicode=True";
providerName = "System.Data.OracleClient";
ColGen.ConnectionString = connectionString;
ColGen.ProviderName = providerName;
ColGen.SelectCommand = "SELECT COLUMN_NAME FROM dba_tab_columns WHERE (OWNER IS NOT NULL AND TABLE_NAME = '" + selectedGVTable.Value + "')";
ColGen.DataBind();
}
else //Default set to SQL
{
}
Mapping conMapping = Mapping.getMapping(conID, selectedTable);
string dbTable = conMapping.getTableName();
int dbFormat = conMapping.getFormat();
string dbLat = conMapping.getLatFieldName();
string dbLong = conMapping.getLongFieldName();
//No information about the table yet
if (dbTable == null)
{
mapUpdates(ColGen);
}
else
{
mapUpdates(ColGen, dbLat, dbLong, dbFormat);
}
//Garbage collection
connInfo = null;
}
else
{
iColFNBox.Items.Clear();
UpdateFieldCol.Update();
}
}
protected void iTableINBox_SelectedIndexChanged(object sender, EventArgs e)
{
string selectedTable = iTableINBox.SelectedValue.ToString();
if (selectedTable != "")
{
ConnInfo connInfo = ConnInfo.getConnInfo(conID);
string connectionString = "";
string providerName = "";
//Set drop down box accordingly
if (connInfo.getDatabaseType() == ConnInfo.MSSQL)
{
connectionString = "Data Source=" + connInfo.getServerAddress() + ";Initial Catalog=" + connInfo.getDatabaseName() + ";Persist Security Info=True;User Id=" + connInfo.getUserName() + ";Password="******"SELECT COLUMN_NAME FROM information_schema.COLUMNS WHERE (TABLE_NAME = '" + selectedTable + "')";
iColINBox.DataSource = temp;
iColINBox.DataValueField = "COLUMN_NAME";
iColINBox.DataTextField = "COLUMN_NAME";
iColINBox.DataBind();
UpdateFieldCol.Update();
}
else if (connInfo.getDatabaseType() == ConnInfo.MYSQL)
{
connectionString = "server=" + connInfo.getServerAddress() + ";User Id=" + connInfo.getUserName() + ";password="******";Persist Security Info=True;database=" + connInfo.getDatabaseName();
providerName = "MySql.Data.MySqlClient";
SqlDataSource temp = new SqlDataSource();
temp.ConnectionString = connectionString;
temp.ProviderName = providerName;
temp.SelectCommand = "SELECT COLUMN_NAME FROM information_schema.COLUMNS WHERE (TABLE_NAME = '" + selectedTable + "')";
iColINBox.DataSource = temp;
iColINBox.DataValueField = "COLUMN_NAME";
iColINBox.DataTextField = "COLUMN_NAME";
iColINBox.DataBind();
UpdateFieldCol.Update();
}
else if (connInfo.getDatabaseType() == ConnInfo.ORACLE)
{
connectionString = "Data Source=" + connInfo.getServerAddress() + ";Persist Security Info=True;User ID=" + connInfo.getUserName() + ";Password="******";Unicode=True";
providerName = "System.Data.OracleClient";
SqlDataSource temp = new SqlDataSource();
temp.ConnectionString = connectionString;
temp.ProviderName = providerName;
temp.SelectCommand = "SELECT COLUMN_NAME FROM dba_tab_columns WHERE (OWNER IS NOT NULL AND TABLE_NAME = '" + selectedTable + "')";
iColINBox.DataSource = temp;
iColINBox.DataValueField = "COLUMN_NAME";
iColINBox.DataTextField = "COLUMN_NAME";
iColINBox.DataBind();
UpdateFieldCol.Update();
}
else //Default set to SQL
{
}
//Garbage collection
connInfo = null;
}
else
{
iColINBox.Items.Clear();
UpdateFieldCol.Update();
}
}
