How Do I Allow Only Numbers To A Column Cells In A Datagriview Without Any Spaces

Question

0.00/5 (No votes)

See more:

I have a datagridview with five columns. all the columns must accept the letters beside one column. I want my second column to accept only one number or two numbers with no spaces and it must no even allow the users to type other characters than the numbers only.

What i have tried. the problem is that i don't know how i can point it to my gridcolumn which is my index 2

C#

private void Gridview_Output_EditingControlShowing(object sender, DataGridViewEditingControlShowingEventArgs e)
        {

            e.Control.KeyPress += new KeyPressEventHandler(Gridview_Output_KeyPress);

        }

C#

private void Gridview_Output_KeyPress(object sender, KeyPressEventArgs e)
      {
          if (!char.IsControl(e.KeyChar)
          && !char.IsDigit(e.KeyChar)
          && e.KeyChar != '.')
              {
                  e.Handled = true;
              }
      }

Posted 9-Mar-15 22:52pm

Bacanzela

Add a Solution

Comments

Adrian Vaideanu 10-Mar-15 6:53am

Are the DataGridView cells editable or you just bind to a model?
How are you binding to the data grid cell ?
What exactly do you mean by "point it to my gridcolumn which is my index 2"?

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Bacanzela · Answer 1 · 2015-03-10T01:15:00

I manage to find a solution using this method

C#

private void Gridview_Output_CellEndEdit_1(object sender, DataGridViewCellEventArgs e)
        {
            try
            {
pre lang="cs">int RowIndex = e.RowIndex;
               int columnIndex = e.ColumnIndex;
               if (e.ColumnIndex == 2)
               {
                   bool validation = true;
                   if (Gridview_Output.Rows[RowIndex].Cells[columnIndex].Value != null &amp;&amp; Gridview_Output.Rows[RowIndex].Cells[columnIndex].Value.ToString().Trim() != &quot;&quot;)
                   {
                       string DataToValidate = Gridview_Output.Rows[RowIndex].Cells[columnIndex].Value.ToString();
                       foreach (char c in DataToValidate)
                       {
                           if (!char.IsDigit(c))
                           {
                               validation = false;
                               break;
                           }
                       }
                       if (validation == false)
                       {
                           MessageBox.Show(&quot;Font must be numbers only&quot;, &quot;Error Message&quot;, MessageBoxButtons.OKCancel,MessageBoxIcon.Warning);
                           Gridview_Output.Rows[RowIndex].Cells[columnIndex].Value = &quot;&quot;;</pre>

How Do I Allow Only Numbers To A Column Cells In A Datagriview Without Any Spaces

1 solution

Solution 1

Add your solution here

Preview 0

How Do I Allow Only Numbers To A Column Cells In A Datagriview Without Any Spaces

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us