how to validate datagridview cell in C# a

Question

0.00/5 (No votes)

See more:

.NET3.5

my datagridview somethink like ..this.....
sno date day
1 1/1/2005 Monday
2 7/1/2005 Monday
3 14/1/2005 Monday
4 21/1/2005 Monday
user can change date 14/1/2005 to not lessthan= 7/1/2005 and not greater= than 21/1/2005
can u help me what i have to do for this validation???????

thanks and regards
Lakhan

Posted 28-Dec-11 0:52am

Lakhan Aanjana

Add a Solution

Comments

Sunasara Imdadhusen 28-Dec-11 7:38am

Please start development and then let us know if you have any issue.

4 solutions

Solution 4

simple get the srno, of the updating row and then compare the before that srno and after that srno. and validate the date you want to update

Posted 5-Jul-12 4:06am

SubrahmanyamGurram

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Sunasara Imdadhusen · Accepted Answer · 2011-12-28T01:46:00

Hi,

You need to write a logic for validating Date like.

C#

void dataGridView1_CellValidating(object sender, DataGridViewCellValidatingEventArgs e)
{
DateTime StartDate = "7/1/2005";
DateTime EndDate = "21/1/2005"
DateTime enetedDate = dataGridView1.Rows[e.RowIndex].Cells["Date"];

if( enetedDate >=  StartDate &&  enetedDate<= EndDate)
{
//Your logic should be here..
} 
else
{
 MessageBox.Show("Invalid Date!");
  e.Cancel = true;
}
}

Note: Please use DataType conversion before use. because i haven't implemented it.

Thanks,
Imdadhusen

Monjurul Habib · Accepted Answer · 2011-12-28T03:11:00

Solution 3

Try the following links:
How to: Host Controls in Windows Forms DataGridView Cells
Walkthrough: Validating Data in the Windows Forms DataGridView Control
How to: Validate Data in the Windows Forms DataGridView Control

Posted 28-Dec-11 3:11am

Monjurul Habib

Comments

Wendelius 28-Dec-11 15:11pm

Good links, my 5.

Monjurul Habib 29-Dec-11 0:59am

thank you

RaviRanjanKr · Accepted Answer · 2011-12-28T01:26:00

Solution 1

you can use RangeValidatorcontrol where you can set minimumvalue="7/1/2005" and maximumvalue="21/1/2005"
Try
RangeValidator Control[^]

Posted 28-Dec-11 1:26am

RaviRanjanKr

Updated 28-Dec-11 1:27am

v2

Comments

[no name] 28-Dec-11 7:28am

but my dear friend i m talking about window application

RaviRanjanKr 28-Dec-11 7:56am

so you should mention about your requirement in your question.

Sunasara Imdadhusen 28-Dec-11 7:39am

You should clarify everything in your question!

[no name] 28-Dec-11 8:17am

window application

Wendelius 28-Dec-11 15:12pm

The vote of 1 was totally unnecessary and just because of OP's missing requirements, compensated.

RaviRanjanKr 28-Dec-11 15:25pm

Thanks :)

how to validate datagridview cell in C# a

4 solutions

Solution 2

Solution 3

Solution 1

Solution 4

Add your solution here

Preview 0

Existing Members

...or Join us