word split from textbox and values pass in database

Question

3.00/5 (3 votes)

See more:

hi,
i wan to split words from textbox,

means..i search users by firstname or lastname
.

and my coding for pass textbox valu as firstname , lastname in property is here..
it show me error if i left the space
means
i enterd
manish dalwadi
in textbox
its complete work
but if i entered only
manish it show me error

C#

string data = txtsearchusers.Text;
        string[] s1 = data.Split();

        string a = s1[0].ToString();
        string b = s1[1].ToString();
        clsregisterinfo.FirstName = a.ToString();
        clsregisterinfo.LastName = b.ToString();

Posted 9-Mar-14 19:44pm

Manish Dalwadi

Add a Solution

5 solutions

Solution 2

Hi,
Why you are splitting the text box value.If u want to search users means u can do it in sql query it self. like

C#

string search = "select * from tblUsers where name like'%" + txtUsername.Text + "'%";

Then bind the value where ever u want to show.

Posted 9-Mar-14 20:31pm

SanSkun

Solution 3

You would have encountered IndexOutofRangeException, right? That is because s1[1] did not exist.
Suggest use 2 textboxes, one for firstname and another for last name. Not only does it eliminate unnecessary code, but also make your intention clearer to the users as well.

Posted 9-Mar-14 20:40pm

Peter Leow

Updated 9-Mar-14 20:41pm

v2

Solution 4

Try like this

C#

string data = txtsearchusers.Text;
        string[] s1 = data.Split();
        string fName = null, sName = null;
        fName = s1[0].ToString();
        clsregisterinfo.FirstName = fName;
        if (s1.Length == 2)
        {
            sName = s1[1].ToString();
            clsregisterinfo.LastName = sName;
        }

In the Query you can check the condition as
if Second name is null then ignore the condition(checking second name) in SQL Query. else check with the first name only....

Posted 9-Mar-14 20:45pm

Karthik_Mahalingam

Solution 5

In this case s[0] will have value.

But it is good programming practice that before getting value from any object first check the value existence of the object.

In this case you have to write

if(s[1]!= null)
{

}

Posted 9-Mar-14 20:49pm

Singh Rajan

v2

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)

nandakishoreroyal · Accepted Answer · 2014-03-09T20:22:00

Solution 1

Check th econdition and assign b value;

C#

if (s1 != null && s1.Count() > 1)
            {
string b = s1[1].ToString();
clsregisterinfo.LastName = b.ToString();
            }

Posted 9-Mar-14 20:22pm

nandakishoreroyal