Cellvalidating in datagridview

Question

0.00/5 (No votes)

See more:

Hello everyone,

Is it to possible to validate cells of datagridview using regular expression? Also i am loading datagridview using combo box i.e table names are provided in the combo box depending on the selection corresponding tables data will be loaded on to the grid view. And all the tables do not have same number columns. How to validate this. Please provide the solution

Thank you

Posted 15-Oct-11 5:32am

manu g m

Add a Solution

2 solutions

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)

**theanil** · Answer 1 · 2011-10-15T07:15:00

Solution 1

http://msdn.microsoft.com/en-us/library/7ehy30d4.aspx[^]

http://stackoverflow.com/questions/4742960/datagridview-validation-changing-cell-value[^]

Posted 15-Oct-11 7:15am

theanil

Comments

RaviRanjanKr 16-Oct-11 17:28pm

Comment by- manu g m
I need like suppose there are 4 columns in first table say, id,ename,ph,addr,email so i need to validate each cell of DGV against a regular expression and also when user loads second table which contians say ordeid,product, quantity even this table shld be validated when user changes cell data in DGV. i.e tables are loaded dynamically to DGV the corresponding DGV cells needs to be validated.

And assume there are 10 tables in a database and each have different column name and different number of columns. One table will be loaded at a particular time. How to validate the cells of all these tables. Please help.

donaldrichardson · Answer 2 · 2011-11-04T05:21:00

Hi,

I assume you not looking for another architectural answer so.
Each table creates its own set of templates on the fly so there's no easy way to use the template to define your validations.

However each row has a rowdatabind method which is fired when things get bound.
You could intercept this add a validation control progammatically to the cell (linking it properly of course), you would need to source the regular expression from somewhere and databind that in.

Basically your rowdatabind method would become quite heavy with code to create your validations.

Another possiblity may be to loop through your grid after its bound and add the validation control in.

Hope this helps...