how to find variable count in textbox

i want to match first name nad last name of person to textbox value...
i got this code for this use array means first split that code and then match in select query but now i want to check in textbox only first name then differnt query and firstname &lastname then differnt query so how can i identify one word or two word in textbox????
plz help me..


my code is:-

String Name = txtname.Text;
        String[] Spilted = Name.Split(new string[] { " " }, StringSplitOptions.RemoveEmptyEntries);
        String firstname = Spilted[0];
        String lastname = Spilted[1];


        SqlCommand cmd = new SqlCommand("Select PROFILE_ID,FIRST_NAME,PROFILE_REQUEST_STATUS from DSProfile.HDR_PROFILE  where FIRST_NAME='" + firstname + "' and LAST_NAME='" + lastname + "'  and PROFILE_REQUEST_STATUS='" + false + "'", con);
       // SqlCommand cmd = new SqlCommand("Select p.PROFILE_ID,g.FRIEND_ID,p.FIRST_NAME,g.ACCEPT_STATUS from DSProfile.HDR_PROFILE p,DSMailBox.HDR_GROUP g where p.FIRST_NAME='" + friendname + "' and p.PROFILE_ID=g.FRIEND_ID and ACCEPT_STATUS='" + false + "'", con);
        SqlDataAdapter sda = new SqlDataAdapter(cmd);
        DataSet ds = new DataSet();
        sda.Fill(ds);
        int cnt = ds.Tables[0].Rows.Count;
        DT = ds.Tables[0];
        GridView1.DataSource = ds;
        GridView1.DataBind();

[edit]Code block added - OriginalGriff[/edit]

Tags: ASP.NET