Keywords Search Results From Multiple Columns Using C# With SQL Server?
Mar 26, 2009
We are maintaining the profile information's (like profile first name, last name, address, city, state, age, religion, occupation, education, etc....) from tbl_profie table.
The users can search profiles using any keywords like
Example 1: MBBS, Delhi, India
Example 2: MBA, Delhi, cricket
Example 3 : London, Hindu
Tbl_profile table defending some parent table like Tbl_city, Tbl_state, Tbl_country, Tbl_occupation, Tbl_education tables, etc.So how to fetch user search results from Tbl_profile and profiles related tables using user's keyword with easiest way.
I 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!!
im trying to write a query. for my ui ,i have 3 text boxes for firstname,flightno,sequencenumber.
i input search value on particular textbox it has to be searched on particular column of my db in a single stored procedure.
im using this procedure but it retrives only one column at atime. so like this i need to write three procedures.
but i have only one GO button.
ALTER PROCEDURE [dbo].[spp_searchUsers3] @lastname nvarchar(50), @Value varchar(50) AS DECLARE @SQL nvarchar(500) SET @SQL = 'SELECT firstname,flightnumber,lastname,status FROM tbl_pregister WHERE ' + @lastname + ' LIKE ''%' + @Value + '%'''
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?
I have an arraylist holding objects. i have a textbox and button which searches arraylist using keyword (entered in textbox) . But when i entered the value in text box using keyword i am getting only one value from arraylist added to my listbox.
for example if i type brazil in textbox it sould display the 1 and 2 in the listbox. how to do that ?
this is my code
ArrayList info = new ArrayList(); info.Add(new main("pop", "email@example.com", "Brazil")); ---------main class has constructor with 3 parameters.--------------------1 info.Add(new main("popup", "firstname.lastname@example.org", "Brazil")); ------------2 info.Add(new main("top", "email@example.com", "mexico)); info.Add(new main("sop", "firstname.lastname@example.org", "australia"));
VWD 2008 Express. Where and how do I place keywords that I want search engines to use to index our pages. For instance, I want to place "jail ministry" and "prison ministry" and a host of other terms so that search engines find our pages. I do not want to embed these terms in the page text, but in a header or something. Frontpage made this easy. How do I do it in VWD?
I'm not sure this is the right area exactly but here goes:
I have been using Dreamweaver 8 in a University project to develop a mock ECommerce site. I've also used an Access database to provide the source with some good results so far.
However I've just developed the catalogue page which works fine, and will show up to ten records at a time on the page. I then added the paging functions from the Server Behaviours panel to no avail, once clicking any of the links will show no records at all.
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
I 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?
As a newbie coming from a Java background with tag libraries I wonder if there is a simple possibility to render areas depending on backend values.For example if I have search form I do not want to render the table for the search results as long as the user hasn't pressed the search button. Of course I can iterate over the model containing an empty list but this does not allow to suppress rendering the whole table.Using web forms I would just control the visibility of the affected tag(s) in the code behind file but how do I do this with ASP.NET MVC?Can I use a partital view for a case like this? But I think I would have the same problem. How can I determine if a partial view is rendered (e.g. the whole result table with header)?
I am developing the Home page of a Client. Apart from various things on this home page I have a text box and search button. Having said that, I have a database in which I have almost 12 tables with varying number of columns. Now my question is,Is there anyway to search a word typed by a user in the textbox to search it in all the tables(all columns) of the database.
i have some text boxs in a page and in the same page there will be a table 'grid' like for holding the search result.When the user start editing and of the textbox above, the search must start by sending all textboxs values to the server 'ajax', and get back with the results to fill the below grid.
Notes:This grid should support paging, sorting by clicking on headers and it will contains some controls beside the results such as checkboxs for boolean values and links for opening details in another page.
I know many ways to do this some of them are:1- updatepanel around all of these controls and thats it "fast dirty solution"
2- send the search criteria using ajax request using JQuery post function for example and get back the JSON result, and using a template will draw the grid "clean but will take time to finish and will be harder to edit later".
3- ....My question is:What do you think will be the best choice to implement this scenario? because i face this scenario too much, and want to know which implementation will be better regarding performance, optimization, and time to finish.
I am working on a website hosted with GoDaddy, SQL Server 2005. I have a table in my SQL Server database with a full-text index. On my website, a user can type in search terms and the terms are then passed to a stored procedure in the database which performs the search. The first search takes about 45 seconds to get results. Subsequent searches return results immediately. I found a description of this problem in a Microsoft knowledgebase article:http://support.microsoft.com/kb/915850/en-usGoDaddy tech support says I need to purchase a dedicated server to make the changes suggested in this article.Surely there is some other solution. Does anyone know how to avoid this delay without changing the server configuration?
I have a gridview that shows, for example, a baseball team's statistics. It's a standard sports stats grid - the rows show statistics for each player and the columns show the specific stat for the each player.
Easy enough so far. But what I would then like to do is style (highlight or bold) the Max or Min (the team leader) of each stat column. For example, Player A may only lead in one or two categories, so we cannot style the entire row. If Player A just leads the team in strikeouts, I just want to style the number of strikeouts he had (THAT cell only).
What's the best way to handle this? Make SQL Server do all the work and in effect, rank EVERY stat of each player, effectively doubling the number of columns (e.g. col: AB, col: ABRank). Or do I let the rowdatabound event of the gridview handle this?
If I chose the latter, I think I would get the Max of every statistical category from the datatable before binding (e.g. store them in a local variable) then on rowdatabound, if they match the value, apply the style.
I'm a novice in .NET programming. I was trying to figure a way to make a MULTI TABLE search via a stored procedure for my website. I've written a SP to select records from one table, which isn't working for some unknown reasons:
Whatever I search for, the datagrid is displaying all records from my table.
I am trying to make an asp site where someone types in a search term, then google (or any search engine) is searched for that search term and the resulting urls are compiled into a database.
Is this possible? How would i access the search results?I have seen other websites that do something similar - for example on one site you type in your search term and your website, and it comes back with which page your site is for that search term - how does it access the search results?
I have a ASP.NET (VB) Dynamic Data Project in ASP.NET 4.0. It works great - and offers filtering - but now I want to add searching to it. What is the best way to accomplish this in ASP.NET 4.0? Is there any built-in functionality for performing searches declaratively?
I need to concatenate several columns of a table into a single value, then show that value in an asp dropdownlist. The SQL code I'm issuing is as follows:
SELECT UserID, CustomerNum, UserName + ' - ' + UserAddress + ',' + UserCity + ' ' + UserState AS UserInfo FROM Users WHERE (CustomerNum = @CustomerNum) ORDER BY UserName
I then set 'UserInfo' as the text field in the dropdownlist.This generally works, except occasionally one of the columns in the database is null (for example, UserState). When that happens, the entire concatenation is null, and I get an empty entry in the dropdownlist.
Is there something in SQLServer that will allow me to ignore those NULL results, or will I have to code something up in the DataBind event?
In my web form I have a search box. The user enters a string, and once the search button is clicked, I pass the value from my .js file to my .cs file and do some processing to get the results. Up to this point everything is fine, but now I dont know how to get my results back to my .js page. The serach results at this point are in a dataset, and also in an multidimensional array. I have a multi array because I need to pass back the code and description of the items found.
At this point I have used the passed string 'value' to get my required code/descriptions, but i'm not sure how/if I can get either the Dataset or multidimensional array back to my .js page