如何在DataGridView中使用验证

本文关键字：验证 DataGridView | 更新日期: 2023-09-27 18:03:47

在我的程序中，当我单击DataGridView中的特定行时，如果该行包含"'"，它应该弹出一个错误消息，"' is not allowed in name or in path"。我不知道该怎么做。

代码如下:

namespace OVF_ImportExport
{
    public partial class Form1 : Form
    {
        string sName = "";
        string sPath = "";
                public Form1()
        {
            InitializeComponent();
        }
        private void dataGridView1_CellMouseClick(object sender, DataGridViewCellMouseEventArgs e)
        {
            foreach (DataGridViewRow row in dataGridView1.SelectedRows)
            {
                 sName = row.Cells[0].Value.ToString();
                 sPath = row.Cells[1].Value.ToString();
            }
        }
        private void BtnCreate_Click(object sender, EventArgs e)
        {
            richTextBox1.Text = "";
            StreamWriter file = new StreamWriter("Export.bat");
            file.WriteLine("c: ");
            file.WriteLine("cd ''");
            file.WriteLine("cd Program Files ");
            file.WriteLine("cd VMware");
            file.WriteLine("cd VMware OVF Tool");
            foreach (DataGridViewRow row in dataGridView1.SelectedRows)
            {
                 sName = row.Cells[0].Value.ToString();
                 sName = sName.Trim();
                 sPath = row.Cells[1].Value.ToString();
              file.WriteLine("start ovftool.exe --powerOffSource vi://" + TxtUsername.Text + ":" + TxtPassword.Text + "@"
                   + TxtIP.Text + sPath + " " + "'"" + TxtBrowsepath.Text + "''" +  sName + "''" + sName + ".ovf" + "'"" + Environment.NewLine);

            }
            file.WriteLine("pause");
            MessageBox.Show("Batch File Created","Batch File");
            file.Close();
        }

如何在DataGridView中使用验证

试试:

// Attach DataGridView events to the corresponding event handlers.      
 this.dataGridView1.CellValidating += new DataGridViewCellValidatingEventHandler(dataGridView1_CellValidating);

方法:

private void dataGridView1_CellValidating(object sender,
        DataGridViewCellValidatingEventArgs e)
    {
        // Validate the CompanyName entry by disallowing empty strings.
        if (dataGridView1.Columns[e.ColumnIndex].Name == "CompanyName")
        {
            if (String.IsNullOrEmpty(e.FormattedValue.ToString()))
            {
                dataGridView1.Rows[e.RowIndex].ErrorText =
                    "Company Name must not be empty";
                e.Cancel = true;
            }
        }
    }
相关文章：