public void Test()
{
try
{
SqlHelper.connectionString = fConnection_Connection.Text;
SqlHelper.GetDataTable("SELECT 0");
SharedFunc.ShowError("Succeed", MessageBoxIcon.Information);
}
catch (Exception ex)
{
SharedFunc.ShowError(ex.Message);
}
}
public override void Save()
{
gvf.CloseEditor();
gvf.UpdateCurrentRow();
DataTable dt = (DataTable)gdf.DataSource;
if (dt.GetChanges() != null)
{
List <Sys_Schema> Sys_Schemas = EntityHelper.GetEntities <Sys_Schema>(dt);
if (Sys_Schemas.Where(s => s.IsIdentity.Equals(true)).Count() > 1)
{
SharedFunc.ShowError("To Much Identities", "Please Check Input");
return;
}
string tableName = gvl.GetFocusedRowCellValue("Table_Name").ToStringEx();
if (!string.IsNullOrEmpty(tableName))
{
string script = ScriptHelper.GenerateTable(tableName, Sys_Schemas);
memoEdit1.Text = script;
//return;
if (!string.IsNullOrEmpty(script))
{
List <MyParameter> myParameters = new List <MyParameter>();
myParameters.Add("@Script", DbType.String, script, null);
BaseService.Execute("SystemDataBase_Script", myParameters);
dt.AcceptChanges();
string tableNick = gvl.GetFocusedRowCellValue("Table_Description").ToStringEx();
if (!string.IsNullOrEmpty(tableNick))
{
gvl.SetFocusedRowCellValue("Table_Description", tableNick);
gvl.CloseEditor();
gvl.UpdateCurrentRow();
}
}
}
}
base.Save();
base.Open();
}
