public static IList<string> getTableColumnNames(string dbname, string tableName)
{
List<string> ret = new List<string>();
DataTable schema = null;
using (MySQLDAO.MySQLDAOContext con = new MySQLDAO.MySQLDAOContext(MySQLConString.getStaticConstring()))
{
con.OpenConnection();
MySQLSchemaDAO dao = new MySQLSchemaDAO(con);
schema = dao.selectTableColumns(dbname, tableName);
con.CloseConnection();
}
if (schema != null)
{
foreach (DataRow row in schema.Rows)
{
ret.Add(row["COLUMN_NAME"].ToString());
}
}
return ret;
}
private void btnReadColumn_Click(object sender, EventArgs e)
{
try
{
MySQLDAO.MySQLConString objConString = this.getObjConstring();
DataTable schema = null;
using (MySQLDAO.MySQLDAOContext con = new MySQLDAO.MySQLDAOContext(objConString.ConString))
{
con.OpenConnection();
MySQLSchemaDAO dao = new MySQLSchemaDAO(con);
schema = dao.selectTableColumns(tbxDbName.Text, tbxTableName.Text);
con.CloseConnection();
}
if (schema != null)
{
this.dataSource.Clear();
this.cmbColumns.Items.Clear();
foreach (DataRow row in schema.Rows)
{
this.dataSource.Add(new CustomDataMySQLTable(row["COLUMN_NAME"].ToString(), row["DATA_TYPE"].ToString(), "",""));
this.cmbColumns.Items.Add(row["COLUMN_NAME"].ToString());
this.cmbNullColumns.Items.Add(row["COLUMN_NAME"].ToString());
}
}
this.grid.DataSource = this.dataSource;
if (this.cmbColumns.Items.Count > 0)
{
this.cmbColumns.SelectedIndex = 0;
}
if (this.cmbNullColumns.Items.Count > 0)
{
this.cmbNullColumns.SelectedIndex = 0;
}
}
catch (Exception excp)
{
MessageBox.Show("エラーが発生しました。MySQLが起動しているかご確認下さい。");
return;
}
}