private void btnAccept_Click(object sender, EventArgs e) { if (!NameTool.ValidFieldName(txbFieldName.Text.Trim().ToLower())) { MessageForm msgForm = new MessageForm("非法的字段名!", "错误", MessageBoxIcon.Error, true, false); msgForm.StartPosition = FormStartPosition.CenterParent; msgForm.ShowDialog(); return; } this.FieldName = this.txbFieldName.Text.Trim().ToLower(); this.FieldType = this.cmbFieldType.Text.Trim().ToLower(); this.DialogResult = DialogResult.OK; this.Close(); }
private void btnCreateTable_Click(object sender, EventArgs e) { string tabName = txbTabName.Text.Trim().ToLower(); if (!NameTool.ValidTableName(tabName)) { MsgBox.ShowError("非法的表名!"); return; } StringBuilder sbSql = new StringBuilder(); sbSql.Append(" CREATE TABLE "); sbSql.Append(tabName); sbSql.Append("("); for (int i = 0; i < DGVFields.Rows.Count; i++) { if (i == DGVFields.Rows.Count - 1 && DGVFields.Rows[i].Cells[0].Value == null && DGVFields.Rows[i].Cells[1].Value == null) { break; } if (DGVFields.Rows[i].Cells[0].Value == null) { MsgBox.ShowError("字段名为空"); return; } if (DGVFields.Rows[i].Cells[1].Value == null) { MsgBox.ShowError("字段类型为空"); return; } sbSql.AppendFormat(" {0} {1},", DGVFields.Rows[i].Cells[0].Value, DGVFields.Rows[i].Cells[1].Value); } //去掉最后的逗号 sbSql.Remove((sbSql.Length - 1), 1); sbSql.Append(")"); CreateTable(sbSql.ToString()); }