how to validate the textbox in asp net

Question

1.00/5 (1 vote)

See more:

I want to validate the textbox using my data table.

i want to validate text box value all ready in data table.

EX-001,002 in my table Any one reEnter the 001 .i want to vaild it??

Posted 11-Feb-13 19:18pm

Hasitha Wijesooriya

Add a Solution

Comments

Nandakishore G N 12-Feb-13 1:22am

block using Stored procedure

Ankur^\m/ 12-Feb-13 1:47am

[moved from direct comment]
breaker-code - 20 mins ago
i Need a how to write a method.

breaker-code - 12 mins ago
Help me plz

[no name] 12-Feb-13 1:24am

i Need a how to write a method.

Ankur^\m/ 12-Feb-13 1:48am

Use the 'Reply' link against a comment to reply to it. Direct comment doesn't notify the user.

[no name] 12-Feb-13 1:49am

k .am sry

Ankur^\m/ 12-Feb-13 1:56am

It's okay, you are new to the site. And I see you have already started using the link correctly. :thumbsup:

[no name] 12-Feb-13 1:35am

Help me plz

Nandakishore G N 12-Feb-13 1:56am

ok....you can use...datatable.select() method...for reference...

How-to-Copy-Data-from-SqlDataSource-to-Datatable

2 solutions

Solution 2

hi,

You can check using Lambda expression as below.

C#

if(objdt.AsEnumerable().Where(c => c.Field<string>("Col1") == txtbox1.Text.Trim()).Count() > 0)
{
   //valid text
}
else
{
  //invalid text
}

//Col1 is the column in your datatable.</string>

this will check the existence of the textbox value in datatable, if count > 0 , then that value exists in table else not.

More on lambda expression[^]

hope it helps.

Posted 11-Feb-13 19:39pm

Karthik Harve

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)

Avik Ghosh22 · Accepted Answer · 2013-02-11T19:39:00

C#

protected void Button1_Click(object sender, EventArgs e)
    {
         using (SqlConnection con = new SqlConnection("----"))
        {
            con.Open();
            SqlCommand cmd = new SqlCommand("Select * FROM TEST WHERE ID='"+TextBox1.Text+"'", con);
            SqlDataAdapter da = new SqlDataAdapter(cmd);
            DataTable DT = new DataTable();
            da.Fill(DT);
            con.Close();
            if (DT.Rows.Count > 0)
            {
                Response.Write("ALREADY HAVE");
            }
            else
            {
                //YOUR CODE//
            }
            
        }
    }