void MySql_Table_GetColumns(string TableName)
{
try
{
DataTable myDataTable_TableColumns = new DataTable();
SolutionsDBTableColumnsDAL SolutionsDBTableColumnsDAL = new SolutionsDBTableColumnsDAL();
SolutionsDBTableColumnsDAL.SolutionsDBID = this.CurrentDBID;
SolutionsDBTableColumnsDAL.TableName = TableName;
SolutionsDBTableColumnsDAL.TableId = 0;
SolutionsDBTableColumnsDAL.isActive = true;
this.TableColumns_bindingSource.DataSource = null;
this.dvgTableColumns.DataSource = null;
myDataTable_TableColumns = this.mySqlDBFunctions.getTablesColumns(this.mySqlDBFunctions.DatabaseName, TableName);
if (myDataTable_TableColumns != null)
{
foreach (DataRow myRow in myDataTable_TableColumns.Rows)
{
SolutionsDBTableColumnsDAL.ColumnName = myRow["COLUMN_NAME"].ToString();
SolutionsDBTableColumnsDAL.ColumnType = myRow["COLUMN_TYPE"].ToString();
SolutionsDBTableColumnsDAL.COLUMN_KEY = myRow["COLUMN_KEY"].ToString();
SolutionsDBTableColumnsDAL.ColumnDataType = myRow["DATA_TYPE"].ToString();
SolutionsDBTableColumnsDAL.isIdentity = myRow["EXTRA"].ToString().ToLower().Contains("auto_increment") == true ? true : false;
SolutionsDBTableColumnsDAL.DataType = SQLDataTypeConversion.getType(myRow["DATA_TYPE"].ToString());
SolutionsDBTableColumnsDAL.Insert();
}
}
}
catch (Exception ex)
{
CommonClasses.Messages.GeneralError(ex.Message, " My DB SQL Connection");
}
}
void MSSql_Table_GetColumns(string TableName)
{
try
{
DataTable myDataTable_TableColumns = new DataTable();
SolutionsDBTableColumnsDAL SolutionsDBTableColumnsDAL = new SolutionsDBTableColumnsDAL();
SolutionsDBTableColumnsDAL.SolutionsDBID = this.CurrentDBID;
SolutionsDBTableColumnsDAL.TableName = TableName;
SolutionsDBTableColumnsDAL.TableId = 0;
SolutionsDBTableColumnsDAL.isActive = true;
this.TableColumns_bindingSource.DataSource = null;
this.dvgTableColumns.DataSource = null;
myDataTable_TableColumns = this.MsSqlDBFunctions.getTablesColumns(this.MsSqlDBFunctions.DatabaseName, TableName);
if (myDataTable_TableColumns != null)
{
foreach (DataRow myRow in myDataTable_TableColumns.Rows)
{
SolutionsDBTableColumnsDAL.ColumnName = myRow["column_name"].ToString();
SolutionsDBTableColumnsDAL.ColumnType = myRow["columntype"].ToString();
SolutionsDBTableColumnsDAL.COLUMN_KEY = myRow["COLUMN_KEY"].ToString();
SolutionsDBTableColumnsDAL.ColumnDataType = myRow["DATA_TYPE"].ToString();
SolutionsDBTableColumnsDAL.isIdentity = Boolean.Parse(myRow["is_identity"].ToString());
SolutionsDBTableColumnsDAL.DataType = SQLDataTypeConversion.getType(myRow["DATA_TYPE"].ToString());
SolutionsDBTableColumnsDAL.Insert();
}
}
}
catch (Exception ex)
{
CommonClasses.Messages.GeneralError(ex.Message, " My DB SQL Connection");
}
}