/// <summary>
/// 该方法用于编辑数据库
/// </summary>
public void EditDatabase(string table0)
{
WinFromEditTable myform = new WinFromEditTable(table0);
if (myform.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
string table1 = myform.table1;
Setting._currentdb = table1;
string str_sql = $"rename table {table0} TO {table1}";
_mycon.CreateCommand(str_sql).ExecuteNonQuery();
System.Windows.Forms.MessageBox.Show($"数据表 {table1} 改名已成功!");
}
}
/// <summary>
/// 该方法用于编辑数据库
/// </summary>
public void EditDatabase(string table0)
{
WinFromEditTable myform = new WinFromEditTable(table0);
if (myform.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
string table1 = myform.table1;
Setting._currentdb = table1;
string str_sql = $"ALTER TABLE {table0} RENAME TO {table1}";
mysqliter.ExecuteRow(str_sql, null, null);
System.Windows.Forms.MessageBox.Show($"数据表 {table1} 改名已成功!");
}
}