comparing multiple strings with the database

Joginder Banger sir answer will work..Please don't use split logic from code behind..Handle it back end

Hi Krishna,


        I guessed that, you want to retrive the places that is existing in a table using that string(goa&hyderabad) , and displayed that particular place as a label text if that is exist in atable. Right?  

Try this:



 string names = textbox2.Text().toString().Replace("&","','");
 string query = "select [YourColumnName] as ExistingPlaces from  [tableName] where [YourColumnName] in ('" + names + "')";
 cmd =new SqlCommand(query,connection); 
 SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;  da.Fill(dt);
if(dt.Rows.count > 0)
 {   string s = string.Join(",", dt.AsEnumerable() .Select(x => 
                                        x["ExistingPlaces"].ToString()));
         Label4.Text =  TextBox2.Text;
}
else
{
 Label4.Text =  "Not Found";
}

  I hope this will help you.  Bcz I check the logic from your code which you post at 1st... If I'm wrong, correct me with your exact need and requirment.

Hi Krishna,

your question is not clear yet. plz create a table and enter the data. I have no idea what type of data you comparing

Hi sathish
               yes i would like to retrieve the records based on the string(separated by &) matching with the database

Hi Krishna,

        Comparing with database in the sense.. what did you mention here. can you please elaborate.

Are you want to retrive the records using that string(seperated by '&') or do something over that using that string. 

Its just display the text but comparing with the database  @sathish kumar

Hi Krishna,

        You wanna compare and select the places from the given string. Right?, then You can use this.

way 1:

        string places=TextBox2.Text.ToString().Replace( ' & ' , ' , ' );
          scom.CommandText = "Select * from places where names in ('"+ places+"')";
 


Way 2

        You can use the above way otherwise, you have to create the parameters as you required based on the string you have passed.

        string[] myArray = TextBox2.Text.Split('&');
        // Based on myArray's length we've to add the parameters.
        scom.Parameters.AddWithValue("@Name1", myArray[0]);
        scom.Parameters.AddWithValue("@Name2", myArray[1]); 
        scom.CommandText = "Select * from places where names = @Name1 or names = @Name2";


        I Hove this will help you.

Hi Krishna your logic may be wrong, if you send the value with & operator then why are you split here. Simply make a function in Sql server and then split here. 


I have already written one article regarding sql function. Plz check this link 
http://www.c-sharpcorner.com/UploadFile/5b3fc9/split-string-value-behalf-on-special-character-in-sql-server/