private void btnSubmit_Click(object sender, EventArgs e)
{
List <string> resault = DBChecker.ExecuteSQL(TestDB.GetDBinfo().DefaultOperate, _lstSql);
StringBuilder sbRet = new StringBuilder();
foreach (string res in resault)
{
sbRet.AppendLine(res);
}
txtOut.Text = sbRet.ToString();
}
/// <summary>
/// 检查并更新数据库结构
/// </summary>
/// <returns></returns>
public string UpdateDataBase()
{
List <string> sql = DBChecker.CheckDataBase(this);
List <string> res = DBChecker.ExecuteSQL(DefaultOperate, sql);
StringBuilder sbRet = new StringBuilder();
foreach (string str in res)
{
sbRet.AppendLine(str);
}
return(sbRet.ToString());
}
private void btnSubmit_Click(object sender, EventArgs e)
{
DBConfigInfo dbcinfo = FrmDBSetting.GetDBConfigInfo(DesignerInfo, "");
DBInfo dbInfo = dbcinfo.CreateDBInfo();
rtbOutput.Text = "";
if (_lstSql == null || _lstSql.Count == 0)
{
return;
}
List <string> resault = DBChecker.ExecuteSQL(dbInfo.DefaultOperate, _lstSql);
StringBuilder sbRet = new StringBuilder();
foreach (string res in resault)
{
sbRet.AppendLine(res);
}
rtbOutput.Text = sbRet.ToString();
}