Please I need your help concerning a program of mine, I have a database with a table in which a list of words on my site, and the page they appear in is, a page with a textbox, a button and a datalist. The purpose is to enter a group of words in the textbox, separated by a space, then each word is searched in a table in my database, and the page(s) where the words appear is returned, and saved into a List<className> I created for this, now my problem is how do I return only the page where all words in the textbox appears in order to populate the datalist.

cc: Raypawer, ilekky, satindersingh1, dmayor7, avosoft, basbone, xtremrules, gimakon, blenyo11, francis164

Pass your URL list and search term to this function
public List<string> Search(List<string> allUrls, string searchTerm)
{
var result = new List<string>();
var wordList = searchTerm.Split(' ');
//loop through all the urls
foreach (var url in allUrls)
{
//lets create a flag for tracking
var addUrl = true;
//loop through the word list
foreach (var word in wordList)
{
//if this word is not in the url; don't add this url
//so let's set our flag to false
if(!url.Contains(word)) addUrl = false;
}
//if addUrl is true then all the words are in the url. so add the url to our result
if(addUrl) result.Add(url);
}
return result;
}

osarcho:
Please I need your help concerning a program of mine, I have a database with a table in which a list of words on my site, and the page they appear in is, a page with a textbox, a button and a datalist. The purpose is to enter a group of words in the textbox, separated by a space, then each word is searched in a table in my database, and the page(s) where the words appear is returned, and saved into a List<className> I created for this, now my problem is how do I return only the page where all words in the textbox appears in order to populate the datalist.

cc: Raypawer, ilekky, satindersingh1, dmayor7, avosoft, basbone, xtremrules, gimakon, blenyo11, francis164

You have to bind your grid view to a data source, and a text box too. Then ask your text box to search. From the database, when it does it should return your data to the asp.net page.

Learn data binding

blenyo11:
Pass your URL list and search term to this function
public List<string> Search(List<string> allUrls, string searchTerm)
{
var result = new List<string>();
var wordList = searchTerm.Split(' ');
//loop through all the urls
foreach (var url in allUrls)
{
//lets create a flag for tracking
var addUrl = true;
//loop through the word list
foreach (var word in wordList)
{
//if this word is not in the url; don't add this url
//so let's set our flag to false
if(!url.Contains(word)) addUrl = false;
}
//if addUrl is true then all the words are in the url. so add the url to our result
if(addUrl) result.Add(url);
}
return result;
}

Nice, it works, but it is being affected by the position of the word

osarcho:
Please I need your help concerning a program of mine, I have a database with a table in which a list of words on my site, and the page they appear in is, a page with a textbox, a button and a datalist. The purpose is to enter a group of words in the textbox, separated by a space, then each word is searched in a table in my database, and the page(s) where the words appear is returned, and saved into a List<className> I created for this, now my problem is how do I return only the page where all words in the textbox appears in order to populate the datalist.

cc: Raypawer, ilekky, satindersingh1, dmayor7, avosoft, basbone, xtremrules, gimakon, blenyo11, francis164

Assuming you are using Linq to Query your database and the Table name is Pages with a column called PageContents where the content of each page is saved and its Class representation is called Page, you will something like this:
if The data in the textbox is saved in a variable called searchData;

string[] searchArray = searchData.Split(); //Returns a substring using the default space separator

//Assuming Pages is a List of pages data from Database

var result = Pages.Where(x => searchArray.All(y => x.PageContents.ToLower().Contains(y.ToLower()))).ToList();

//The Above variable returns is collections of Pages( List<Pages> ) that has exactly all search strings.
you can manipulate the collection the way you wish.
replace .FirstOrDefault() if you want just want a Page class result

xtremrules:

Assuming you are using Linq to Query your database and the Table name is Pages with a column called PageContents where the content of each page is saved and its Class representation is called Page, you will something like this:
if The data in the textbox is saved in a variable called searchData;

string[] searchArray = searchData.Split(); //Returns a substring using the default space separator

//Assuming Pages is a List of pages data from Database

var result = Pages.Where(x => searchArray.All(y => x.PageContents.ToLower().Contains(y.ToLower()))).ToList();

//The Above variable returns is collections of Pages( List<Pages> ) that has exactly all search strings.
you can manipulate the collection the way you wish.
replace .FirstOrDefault() if you want just want a Page class result

Tanx, dat should work...Ill try it

xtremrules:

Assuming you are using Linq to Query your database and the Table name is Pages with a column called PageContents where the content of each page is saved and its Class representation is called Page, you will something like this:
if The data in the textbox is saved in a variable called searchData;

string[] searchArray = searchData.Split(); //Returns a substring using the default space separator

//Assuming Pages is a List of pages data from Database

var result = Pages.Where(x => searchArray.All(y => x.PageContents.ToLower().Contains(y.ToLower()))).ToList();

//The Above variable returns is collections of Pages( List<Pages> ) that has exactly all search strings.
you can manipulate the collection the way you wish.
replace .FirstOrDefault() if you want just want a Page class result

to my surprise, it only works for one word searches

xtremrules:

Assuming you are using Linq to Query your database and the Table name is Pages with a column called PageContents where the content of each page is saved and its Class representation is called Page, you will something like this:
if The data in the textbox is saved in a variable called searchData;

string[] searchArray = searchData.Split(); //Returns a substring using the default space separator

//Assuming Pages is a List of pages data from Database

var result = Pages.Where(x => searchArray.All(y => x.PageContents.ToLower().Contains(y.ToLower()))).ToList();

//The Above variable returns is collections of Pages( List<Pages> ) that has exactly all search strings.
you can manipulate the collection the way you wish.
replace .FirstOrDefault() if you want just want a Page class result

This was wha I came up with at first, dunno why it's not workin:

foreach (eachWord PageData in Page)
{
string url = PageData.url;
string word = PageData.word;
foreach (string text in txtSearch.Text.Split())
{
// if word is not in url set flag as false and stop loop
if (!word.Contains(text)) break;
searchQuery += 1; // (globally created integer)

}


if (searchQuery == txtSearch.Text.Split().Length) Response.Write(url + "<br />";


}
}

It still brings out result according to the position of the word in the text box even though I tried to cater for that in

if (searchQuery == txtSearch.Text.Split().Length)

osarcho:


to my surprise, it only works for one word searches

I don't think it should. Try running this code:


var searchString = "what a cool momnet here";
var stringArray = searchString.Split();
var PagesContents = new List<string>(){
"what a day to take to", "within attraction",
"cool day down here", "really hot here",
"Flying is easy",
"Zincoxide for... none for them",
"what a cool momnet with her here",
"for all persons in a given house"
};
var result1 = PagesContents.Where(x =>
stringArray.All(y => x.ToLower()
.Contains(y.ToLower()))).ToList();

var result2 = PagesContents.Where(x =>
stringArray.Any(y => x.ToLower()
.Contains(y.ToLower()))).ToList();

Console.WriteLine("From Result 1";
result1.ForEach(x => Console.WriteLine(x));
Console.WriteLine("\n\nFrom Result 2 \n";
result2.ForEach(x => Console.WriteLine(x));

result1 has only one result due to the .All() Linq Extension, but using .Any() returns any string that has at least one character match.
so use result1 method if you want exact match and two if you want any character match.
if this doesn't do want you expected you might have to explain what you really wish to do in details.
You might want to download the program code.