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(); }