Developing a full featured search in my web application. so that in search for data in grid view or data list control and also for search for pages containing search text.
View 1 RepliesI'm quite new to asp and have run into a bit of trouble with a website that I am creating. This website that I am creating is relatively similar to the website created in the tutorial athttp://www.asp.net/general/videos/how-do-i-create-a-full-featured-customer-login-portal. When I paste this code:
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs)
If Not Page.IsPostBack Then
Session("CustomerID") = Nothing
[code]...
I am having with the a full text index I am developing for a product catalog. It does all work to a degree I am just seeing some strange things happening.
From the database side I have a Products table that is being indexed on both the PartNumber and Description columns because I would like the users to be able to search either or using the search function.
Problem 1:
whenever I use multiple words in the search I don't always get the results I am looking for, this happens most notably when I am attempting to say put in a full part number (which for in this case would look like "I 10-9.2")
Problem 2:
I am not 100% sure that this is the most efficient way of completing what I am attempting to accomplish here since I have 2 columns that I need to perform the search on
Here is an excerpt from the click even when the user clicks the search button on the page:
[Code]....
And here is the search functions called from the click event to firstly check if there are any results and the second to display the results in a custom gridview:
[Code]....
how to do a search using a Full Text Search Catalog. I would also like to have the results on the page highlighted?
View 1 Repliesi know how do the paging with normal return query using row number in sql server, but i'm looking how to do the paging , sql server full text search returning result.
Can i use the same row number function or any good perfomance way?
whcih sql server full text search(FREETEXT,CONTAINS and etc) is best article site?
suppose i have column values:
3
6
3,6
36
363
i want to display column which contain "6" means
6 and 3,6 not 36 and 363
so i am using full text search:
use PMS
go
EXEC sp_fulltext_database 'enable'
go
CREATE FULLTEXT CATALOG pmscatalog
go
CREATE FULLTEXT INDEX ON PMS.dbo.emp_project
(
empid
Language 0X0
)
KEY INDEX PK_emp_project ON pmscatalog
WITH CHANGE_TRACKING AUTO
SELECT empid
FROM emp_project
WHERE CONTAINS(empid, '"6"')
but it is not returning anything...
So i'm currently designing a site ( ) and i've made my skeleton master page.What i've noticed is that the gridview must be cut down a little to fit my 1024x768 design.
Now i have taken a note in the past to look at this but i couldn't find the time so i guess the time is now.
What i have problem with is shrinking the columns.If i have a name, say "jack R" and i make a gridview column,say width 15 then the name is included and all is ok.However if i have another name,say "jack the 3rd" then the column will expand to fill the name.So all the grid will expand to the right.I have tried in the past some stuff but it seems that if a value is longer than the column then i expands whatever i do.Also i was surprised to see that only the dates will not expand and go "down" instead of right.At least in the gridview i have.
So the 2 questions.How do i make the gridview columns NOT to expand and if the data needs to show in full then how do i make the data go DOWN and not expand right.I have no problem of the grid expanding downwards but i have a problem of the grid expanding to the right.
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 using SQL Server 2008 and Full Text search.
Its working fine for PDF / doc files but not working for .JPG files.
Basically i have some document scanned and stored it in varbinnary datatype in DB.
I am able to search for .doc /.xml /.pdf files .. but not able to search .jpg.
also i am not getting ".jgp" extension in result of following query
SELECT document_type, version, manufacturer
FROM sys.fulltext_document_types order by document_type
Does anyone has a idea how to write code for a search box to look for keywords,etc inside the website or sitemap?
View 11 RepliesI would like a site that offers the users the possibility to search over 2 datasources but as i tried to indicate in the subject title the searches are one after another where the result of search 1 is used as a parameter for searching the second datasource. The order of the search would depend for what you search (ideally). Some "fields" or "data" of course appear in both datasources.
To get more specific: datasource 1 contains chemical structures and the associated "id" for this structure + additonal properties. You can search for chemical structures here. (chemically intelligent system). datasource 2 contains documents which are indexed (full text) and have metadata fields one of them beeing above id. No chemical search possible.
The idea is now that i perform a search by chemical structure on datasource 1. As as a result I get a list of id's. These id's are then past into datasource 2 as parameter + also all additionaly parameters entered. There are API's available to perform above searches on the 2 datasources. Is this a reasonable approach? Would it be better to create somekind of a simple datawarehouse, eg a table with all numbers linked to all documents they appear in? (would't know how to achievie this actually since it's the 2 datasoruces are not the same rdbms).
How i can make the normal search string to sql server full text search parse, because when we are user enyer search text "how to run windows schedule in C#", in database we have article to to this, but data not returning and sometime is say error in key word and etc.
View 1 RepliesI've created a filter textbox for searching my data in gridview..
ex: i've 3 columns in gridview : ID, NAME, DATE
I ask, how to create a dynamic search for 3 columns in gridview using a textbox?
without writing a query repeatedly :(ID like '%" + search + "%') OR Â (NAME like '%" + search + "%') OR Â (DATE like '%" + search + "%')
protected void btnCariConnStrSubmit_Click(object sender, EventArgs e) {
string search = ((TextBox)GridView1.HeaderRow.FindControl("txtCariConnStr")).Text;
string sql = "select * from report where (ID like '%" + search + "%') OR (NAME like '%" + search + "%') OR (DATE like '%" + search + "%') ";
reader = mda.GetData(sql, connStr).CreateDataReader();
if (reader.Read()) { dt = mda.GetData(sql, connStr).Tables[0]; BindGridView(dt); lblRecordNotFound.Visible = false; }
else { Bindemptydt(); lblRecordNotFound.Visible = true; }
((TextBox)GridView1.HeaderRow.FindControl("txtCariConnStr")).Text = search;
}
I have a few columns in the table. (E.g. Name, ID, Phone, Address, Father name) and I have a text box where user can type in and the system will show match result on the page. User will only key in Name and Father name in the text box. I do not want to implement a full text search or indexing.
View 4 RepliesI want to implement full text search in C# using linq.
View 1 RepliesI want to implement full text search using Entity framework in C# 2010. Is there any way to implement this ? I have searched a lot but unable to find the solution.
View 5 RepliesI am using the following code for full text search
[Code]....
but I got the following error:
[Code]....
so what is wrong with me?
I have created procedure for full-text search and it works in SQL Management Studio 2008 (SQL Server 2008 Express) but in Visual Studio 2010 not - I have error:Full-Text Search is not installed, or a full-text component cannot be loaded.I have read somewhere that only admin can use full-text indexes - so how I can use full-text search in VS2010 ?
View 2 RepliesI have three text boxs
1.txtname
2.txtage
3.txtmobile
and one dropdownlist
1.ddlcity
for search client information.
My requirement is when search button click the client information will bind in gridview based on data filled in textbox and dropdown list.Â
The difficulty is user can enter any combination for search. E.g.
1.age only
2.name and city
3.city only etc.
I am creating a web app to search thousands of records for past 60 days. I am using SQL stored proc to do the full text search and return the results order by RANK and insert datetime.
I am using custom paging in stored proc to receive 10 results at a time. Each time a page of 10 record is returned it comes up with few records that were added recently and others which were added 40,50 or 60 days ago. This happens because full text search find those results more relevant than the recently added ones.
What would be the best way to sort the results by rank as well as by date time. I am using SQL Server 2008.
I have one gridview, a dropdown list where I can search the users table or a group name table, a textbox for inputting the search and a button to search.How could I overwrite the users table that is binded in the gridview when I search through the groupname table? Using C#.
View 2 Repliesi have in my asp.net page a textarea where users type an article="long text" to be saved in the database. In another page i display these articles(textarea) in a :
<p class="p-article">
the text of the article goes here.
</p>
I'd like to filter these articles by search keywords .for example when a user search for "Startup Marketing".
I want to apply the keywords as a filter and get articles and bring those that contain "Startup" or "Marketing" or "Startup Marketinbg".And this in client side by jquery if possible.
I´m currently programming a web search application in ASP.Net and having problem with full text searching. My requirements are:
1. Save a byte array from SQL server to word document as a temp file in a server side?
2. How to highlight the string I am currently searching in the Word document and return to the user the sentence with the highlighted string (like on Bing or any other search engines)? Is it possible to fullfill this requirement with full-text search integrated in SQL Server 2008?
I'm new with all stored procs - but I have a very basic Full Text Search going on...I created a stored proc, and linked it up to my application using Linq to SQL. If I use Linq to SQL to call the stored proc without any parameters (hard coded search string) i get results back, as soon as I add a parameter - the result set is 0 for some reason.
The funny thing is that I run Profiler and execute both queries its trying to do - and it looks identical
Here is the working parameterless query:
[Code]....
and according to Profile this is what it looks like when its called as a stored proc
[Code]....
I get 2 results as expected.
Here is the NON-working stored proc that takes in 1 string parameter
[Code]....
and here is the query that gets called when profiling
[Code]....
declare @p4 int
I have a website which uses full text search. It was working fine on my web host. LAst month, I changed hosting to godaddy.com. They dont support full text search and now my website is not working properly. what change should i make in my stored procedures that they work same as they work with full text. what is alternative to full text search. I tried using LIKE but it doesnt work same way.
View 1 Replies