How Can I Set A Particular Column Accepts Only String Not Numeric Values.

Question

1.00/5 (3 votes)

See more:

VB

make it quick.please i need answer in simple format.

Posted 25-Apr-14 6:55am

Member 10775385

Add a Solution

Comments

Richard C Bishop 25-Apr-14 13:00pm

That is not how it works here. Besides, are all search engines broken?

Kschuler 25-Apr-14 13:50pm

Particular column of what? What kind of project are you working on? What have you tried so far?

Member 10775385 25-Apr-14 14:04pm

student name column working in student details project plz help.

Kschuler 25-Apr-14 14:06pm

I have no idea what student details project is. If you really want help you need to explain further. We have no background knowledge of your project or your setup or anything. What code do you have so far? How is it failing to work? Are you getting any error messages and if so, what are they?

Member 10775385 25-Apr-14 14:12pm

particular column as studentName in a project should not to allow the numeric values it should allow only alphabets.this is what i want...

Member 10775385 25-Apr-14 14:15pm

i have a gridview in that i want to validate the particular column StudentName should allow only alphabets no numeric values.

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)

OriginalGriff · Answer 1 · 2014-04-25T08:00:00

Solution 1

Try:

^[^\d]+$

Quick.
Simple.
Works - the version with the code to actually use it in your VB app is up to you, since you were so rude in the original question.

Posted 25-Apr-14 8:00am

OriginalGriff

Comments

Member 10775385 25-Apr-14 14:03pm

plz send in a vb.net format..

[no name] 25-Apr-14 14:14pm

Who is "plz"? How is this not "vb.net" format?

Member 10775385 25-Apr-14 14:36pm

.Columns("StudentName").valuetype = decimal.actually it allows numbers.but i need to allow only alphabets not numbers.please send solution for this.

Rakesh Agarwal1984 · Answer 2 · 2014-04-25T08:22:00

Solution 2

for that you can write some javascript function to validae that before submiting the form to server
or can use regular expresession on the server side like

C#

function isString(s)
{
  return s.match("^[a-zA-Z\(\)]+$");
}

Posted 25-Apr-14 8:22am

Rakesh Agarwal1984

Comments

Member 10775385 25-Apr-14 14:31pm

iam a gridview in that i need to set a particular column should allow only alphabets not to allow
numbers.this is for allow numbers .Columns("StudentName").Valuetype =decimal.but i need to allow alphabets only .what to do please help me..