Search More Then 2 Keywords In C#.net?
Dec 17, 2010i want to Search more then 2 item with one TEXTBOX field using with , Eg. item1,item2.
Result should be shown for both in one gridview i am using SP with one Parameter.
i want to Search more then 2 item with one TEXTBOX field using with , Eg. item1,item2.
Result should be shown for both in one gridview i am using SP with one Parameter.
this is naresh.i have some query.in google search engine while typeing any letter based on letter some support keyword is getting.
View 8 RepliesI saw on the google when search "code project", some keywords and a text field and a button to search that google has generated for "code project" keyword also for "manchester university" in the same way.
How is it possible to show key words and text field/button for our website on google? As it shows for "code project" and "manchester university" etc.
visit google and search "manchester university" u'll see:
StudentNet Job Opportunities
PostGraduate StaffNet
etc..
and
textfield/ and a button
I want this kind of result for my site from Google!!
I want to create a seach textbox for users to enter a few keywords in ,..and then my sql query will display the results......( basically a little search engine for my website)Ok so im thinking of using the Containstable with ranking on how close these keywords are to eachother... so the closer the keywords are to each other... the higher their ranking will be.... but I also want to seach for these keywords in 4 columns in one Datatable how can I do this
View 7 RepliesI build a serach function just using SelectCommand and SelectParameters, i.e.
<asp:SqlDataSource ID="SqlDataSource2" runat="server"
ConnectionString="<%$ ConnectionStrings:mprojectConnectionString %>"
SelectCommand="SELECT * FROM [publication] WHERE ((([character] LIKE '%' + @character + '%') AND ([type] = @type))
OR(([f11623] LIKE '%' + @f11623 + '%') AND ([type] = @type))
OR (([f1character] LIKE '%' + @f1character + '%') AND ([type] = @type))
OR(([nortonoxfordnumber] LIKE '%' + @nortonoxfordnumber + '%') AND ([type] = @type))
OR (([nortonoxfordtext] LIKE '%' + @nortonoxfordtext + '%') AND ([type] = @type)))">
<SelectParameters>
<asp:ControlParameter ControlID="TextBox1" Name="character" PropertyName="Text"
Type="String" />
<asp:ControlParameter ControlID="TextBox1" Name="f11623" PropertyName="Text"
Type="String" />
<asp:ControlParameter ControlID="TextBox1" Name="f1character"
PropertyName="Text" Type="String" />
<asp:ControlParameter ControlID="TextBox1" Name="nortonoxfordnumber"
PropertyName="Text" Type="String" />
<asp:ControlParameter ControlID="TextBox1" Name="nortonoxfordtext"
PropertyName="Text" Type="String" />
<asp:ControlParameter ControlID="DropDownList1" Name="type"
PropertyName="SelectedValue" Type="String" />
</SelectParameters>
</asp:SqlDataSource>
I am also using a dropdown box and a textbox for people to search within a particular area from the dropdown list.
Now, I would like to be able to highlight the keywords in my gridview table. I searched around on the Internet and found a lot of samples, but they are all related to the Gridview <templates>, however, I am using <BoundField> and sqlDataSource.
I just cound not figure out how can I add this highlight function to my current search function?
What's the best method to allow a user to search in a specific field for a record(s) containing the keywords they enter into a textbox? I am considering using the streamreader to obatin the values from textbox into an array, so I can build dynamic query using the stringbuilder. Is there a cleaner or more efficient method to approach this common search functionality?
View 1 RepliesCan anyone guide me to a website where I can see the list of all the keywords available in a windows installer like [TargetDir] and [ProductVersion].
Can anyone also show me a very detailed tutorial of customizing the windows installer?
Can I add Keywords for Seo in every HTML tag?
View 7 RepliesHow can one dynamically add Keywords & Title to a page. I had created one table called Meta table for URL rewritting in which in addition to url details, i had stored keywords & title of Product page. I had done URL Rewriting of the page but I just couldn't make out how can one associate a Product page with Keywords & title at runtime.
View 11 RepliesOk my website I built for fun effeduptxt.com I am trying to take all the posts that are displayed and have the keywords for the page be auto generated at page load.
Now I know how to add keywords from code behind I just never tried to scrape the data in the database for what would be the best keywords to use.
Has anyone ever done this and or know where something like this is on the web.
I can create the SQL Query and the C# code how to determine what is a bogus word that should not be included such as I could count how many times each word is shown and go for the most common words as the keywords but that would include words like "And", "Or", "It" etc... and that would not be good.
I have no problem with studying more detail about it and expect to do so I just need to get set onto the right path....
I was trying to figure out difference between keywords like Internationalization, Localization etc. and publish paper on best practice. But I got confused even on basic definitions which are so varying on internet. Following are 2 theories I found, so far. please advise which is correct?
Theory - 1
Globalization is a plan tom implement Internationalization and Localization
Internationalization - It is not implementing multiple languages, but it include activities so that Application can be made to support multi-languages and cultures in future. Like doing activities such as:
- Using nVarchar instead of varchar
- Avoiding Satic text and instead storing data to display in resource/text files
Localization - This is actual process when an internationalized application is updated with multiple languages and localization settings. For example, continuing with Internationalziation I would say activities like:
- Formatting Date, Numbers, Currency etc. using CurrentCulture class
- Adding text for different languages in files (we created during internationalization process) and customizing UI
- Using CurrentUICulture class for language conversions
- Providing user an interface to set their preferences
- Regional Settings in Administrative Panel of Windows is actually Localization
Theory - 2
Globalization - same as above Internationalization - First part of aforesaid Localization definition - Number. Currency etc. formatting (General Tab in Regional Settings)
Localization - Second part of aforesaid Localization definition - Language Translation (Language Tab in Regional Settings)
QUESTION: Which one is correct theory? If both above are wrong, what is right?
1- how to extract keywords from text and where collect them?
2- how to find search engine keyword that redirect to my site?
3- best solution for collect keywords, tag and how work wtih them and where save them?
I have a longer text and some keywords. I want to highlight these keywords in my text. That is no problem with this code:
private static string HighlightKeywords2(string keywords, string text)
{
// Swap out the ,<space> for pipes and add the braces
Regex r = new Regex(@", ?");
keywords = "(" + r.Replace(keywords, @"|") + ")";
// Get ready to replace the keywords
r = new Regex(keywords, RegexOptions.Singleline | RegexOptions.IgnoreCase);
// Do the replace
return r.Replace(text, new MatchEvaluator(MatchEval2));
}
private static string MatchEval2(Match match)
{
if (match.Groups[1].Success)
{
return "<b>" + match.ToString() + "</b>";
}
return ""; //no match
}
But when the word"tournament" is in the text and the keyword "tour" it becomes <b>tour</b>nament. I want to it to highlight the complete word: <b>tournament</b>.
I m retrieving a text from SQL DB based on the Search criteria i give and displaying in the Textbox in asp.net. I need to highlight the words given in the search criteria in the displayed text.
For example : If i give "need" all the word "need" in textbox that is retrieved and displayed should be highlight in yellow color.
what is best tutorial to implement dynamic title, meta keywords and description in a mvc2 application.
View 1 RepliesI want to find the keywords/products in text block and link them to my products.
Is a algorithm or sample code somewhere i can start with?
I have the following code:
[Code]....
As you can see, I have two variables @total and @euclidDist, and I have declaring them and defining them using DECLARE and SET respectively. This query works in VB and MSSQL and returns the required results, however when I try to great a Gridview, and I paste the above query in the query builder, it asks me to input the values to @total and @euclidDist, ie it ignores the fact that I already defined them in the statement itself...how do I get around this?
i have seen your article to display value in title and keyword tag from database. then i want to know to display value in META Description tag from database .
View 1 RepliesI have a webforms (framework 3.5) site with a TON of dynamic content. Depending on the url, one or many content items will be sent to the client. I need a way to generate meta keywords for SEO based on the contents of the page (or part of the page, if possible).
I've done a little research and am not really turning up anything that addresses my problem directly. I have, on the other hand, found some interesting stuff that might get me there with considerable work. One idea I have is to intercept the response buffer at Application_BeginRequest (global.asax), parse out some meaningful keywords, and inject them back into the response buffer. However, this seems like a pretty expensive process and I don't even know if it's possible. I also feel like there could be a way to do this with an HttpModule.
I'm interested in what the community has to say about this. Is there already an existing and accepted way to do this that I'm just missing.
In my website i have some users these users have their own page that they can put their product on it.
their page name is Store.aspx
and i have users table i want my users insert their keyword in DB after that thier keyword fetch to meta tag i want all my users have differrent mete tag in their page how i can do it ?
this is my users table
Id
Name
Tell
Keyword1
Keyword2
Keyword3
This is my first time using autocomplete. I have everything up and running, but I want to return a list of more relevent keywords or phrases from my full text catalog, or the table that I search against. I have no idea where to start as far as my getcompletionlist goes.
So If I type in knee
a list appears
kneepads
here's my getCompletionList
Public Function GetCompletionList(ByVal prefixText As String, ByVal count As Integer) As String()
Dim items As New List(Of String)
Dim myConnectionString As String
myConnectionString = GetSQLConnString()
Dim mySelectQuery As String = "SELECT ShortDescription FROM ProductInfo WHERE FREETEXT(ShortDescription, @prefixText) OR FREETEXT(LongDescription, @prefixText) OR FREETEXT(ProductHTML, @prefixText) OR FREETEXT(PartNumber, @prefixText) ORDER BY RANK()
OVER (Order BY PartNumber, ShortDescription, LongDescription)"
[Code]....
I use these code to show keyword from my data base in metatag
SqlCommand _cmd = new SqlCommand("select Keyword1,Keyword2,Keyword3 from House_info", _cn);
_cn.Open();
SqlDataReader _dr = _cmd.ExecuteReader();
while (_dr.Read())
[Code].....
in my page meta tag show above keyword not my keywords from database
I want a word search i doing the search like this , but it is giving character wherever there is in the string,if i give two character like ok it is searching for a full string where ever Ok is there select * from table1 where textfield like '%word%' this query would match word but also wordabc how can i make it aware of delimitions
View 3 RepliesI am trying to write a simple search form for our site. Here is my delima... I am trying to figure out that if there is nothing to search for in one textbox then search in the next textbox. The problem is that I dont know how to format my search string: For Example:
[code]....
how to Add Search Control for Detailsview for search page... simple solution required.?
and is it possible to give field names to each page numbering?