private void btnconfirm_Click(object sender, EventArgs e) { string sql = "delete from T_OPER_LEVEL_RELA"; Sqls.Add(sql); //包删除语句添加进去集合 ffding.getInsertSql(ref Sqls); //添加一条等级是丁的sql语句 ffbing.getInsertSql(ref Sqls); //添加一条等级是丙的sql语句 ffyi.getInsertSql(ref Sqls); //添加一条等级是乙的sql语句 ffjia.getInsertSql(ref Sqls); //添加一条等级是甲的sql语句 string[] strsqls = new string[Sqls.Count]; //定义个string数组 个数等于sqls个数 for (int i = 0; i < Sqls.Count; i++) { strsqls[i] = Sqls[i].ToString(); //把sqls的每一项赋值给strsqls } if (App.ExecuteBatch(strsqls) > 0) //一起执行 { App.Msg("操作已经成功!"); } }