I want to create a 'news' excerpt for the front page of my site. So I get the first news item ordered by date and then I want to display it but cut down to a number of words.How would I do this with vb.net?
View 4 Replies
I am using ContainsTable() to perform a full text search on a field (of type varbinary()) and am I wondering if there is a good way to return an excerpt of text around at least one location where the keyword matched the text in the field.Example:User searches for "computer science".The following sentence exists in the varbinary() field: "This book is about computer science and other IT related fields."I would like to return an excerpt around the words "computer science", something like: "...book is aboutcomputer science and other IT..."
View 1 RepliesI have an access DB created in 2007 and saved in 2003 (.mdb). The tables contain links to a file server on my internal network. I'm trying to import the db into Expression Web 4 and keep the links intact. Currently, I can get the import to work, but the links get stripped out and displayed as plain text.
View 5 RepliesI created a simple search form which populates a gridview from sql server. I use 'contains' on a varchar(max) field which has a full text index. I find if I do a search for "Mexico Argentina", I get multiple results, which is good.One thing my sql server stored procedure is doing is inserting the word 'AND' between words. I do this because I want all words to be found. So if the user inputs "Mexico Argentina", I am converting that to "Mexico AND Argentina"But if I have even one 'noise word' in the search string, I get no results at all. For instance, there might be a sentence in my database table saying "I prefer Mexico to Argentina" but if I put that sentence in, I get no results at all. The database is seeing my converted string:I AND prefer AND Mexico AND to AND ArgentinaAnd finds nothing.I also have another form, which does a more advanced search that allows 'exact phrase'. If the user chooses 'exact phrase', then I don't insert AND anywhere. Instead, I surround his phrase with 4 apostrophes - 2 before the phrase, and 2 after.So now the database sees:' ' I prefer Mexico to Argentina ' ' (I've put a space between apostrophes here to make it clearer to view.Now I not only get no results, I get an error message.
View 1 RepliesSetting the .Net trust level to Medium on a site will ensure that no code can access files outside the application directory.
I have an ASP.Net site that must run in Full Trust. I have configured my website in IIS to use its own Application Pool Identity [URL].
Currently it is possible for scripts/code in this app to read files outside of the application directory. This occurs because by default, accounts that are a member of the BUILTINusers group are able to read most files on the system, including c: and c:windows. It appears that Applicaion Pool Identity accounts are also members of BUILTINusers.
Is it possible to prevent file access outside the website folder while keeping Full Trust?
I need to search my sql database using full text search.
My question is: How do I create the stored procedure and query?
The full text is already created and I ma using asp.net and c# in my application?
Do I need to include the name of the full text index in the stored procedure and query?
I am unable to get it done as i have huge data in my table which is spoiling the standard look and feel of grid view..
if (row.RowType == DataControlRowType.DataRow) {
ViewState["description"] = e.Row.Cells[10].Text;
if (e.Row.Cells[10].Text.Length >= 25){
e.Row.Cells[10].Text = e.Row.Cells[10].Text.Substring(0, 30) + "...";
e.Row.Cells[10].ToolTip = ViewState["description"].ToString();} }
Currently we are saving files (PDF, DOC) into the database as BLOB fields. I would like to be able to retrieve the raw text of the file to be able to manipulate it for hit-highlighting and other functions.Does anyone know of a simple way to either parse out the files and save the raw text on save, either via SQL or .net code. I have found that Adobe has a filtdump utility that will convert the PDF to text. Filtdump seems to be a command line tool, and i don't see a way to use a file stream. And what would the extractor be for Office documents and other file types?-or-Is there a way to pull out the raw text from the SQL Full text index, without using 3rd party filters?Note i am trying to build a .net & MSSql solution without having to use a third party tool such as Lucene
View 5 RepliesI have a pretty basic search feature on a site that queries a sqldb with a sqldarasource, and then displays the results on a page, in a panel within a Repeater. I'd like to figure out if it's possible to somehow highlight the words the user searched on as they are displayed in the search results. The code below is my repeater. Do you know of any way to manipulate the Title or Description if the words in it's body match the words searched?
<asp:Panel
ID="pnlExperience"
runat="server"
Height="500px"
ScrollBars="Auto">
[code]...
I am using FTB on my aspx page. is there any way I can have Toggle Full screen feature in FTB, is this feature availble in FTB? it is available on TinyMCE, but I don't want to switch to TinyMCE since I am already using FTB in most of the pages in my application.
View 1 Repliesi have a text file but we require some words startting from
<ul id="myMenu">
<li><a href="#edit">FileDownLoad</a></li>
Start Me aaaa[code]....
I am having some text boxes in my webform. I need to set numbers of words for each textbox. if i put more than defined no of words it should show msgs or popup msgs whatever it may be.
View 2 RepliesI displayed some words in text box.. The words are,
performcontextEmpRecordhostcontextEmpRefertlcontextEmpdatadatascontextEmpofficemain
contextEmppersonalhardwarecontextEmpsalaryhighcontextEmptype
Now, I want to store these words into database table using asp.net with c#..
each word should be stored into new row..(i.e words spilit into space)..
I need to search some words or text in word document through programming.
View 1 RepliesHow to add different text with different colour in bitmap image using wpf.i have written the code it will take only one colour in text line but i want different colour in bitmap
SolidBrush brush = new SolidBrush(System.Drawing.Color.White);
System.Drawing.Brush brush1 = new SolidBrush(System.Drawing.Color.Blue);
// draw your rectangle below the original image
System.Drawing.Font font = new System.Drawing.Font("Arial", fontsize, System.Drawing.FontStyle.Bold, GraphicsUnit.Pixel);
SizeF textSize = new SizeF();
graphics.DrawString(multiLineString, font, brush1, position);
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 have a "search page" where the user enter some search criteria and a gridview where I display found records. When selecting "edit" on a row I open a second form to allow editing the found data. When the user click close button on the second form I want to go back to the search page. From the beginning I did just return (redirect to page 1) to the page but now the users also want to retain the search form with the serach criteria and found rows (also refreshing the found rows with possible changed data).
I can not just use a javascript with "history.back()" since the edit page might have done postbacks so that will not return to search page.Of course one solution would be to call the search page with a query string (or other ways to pass data between pages) containing the original search data but that solution might get messy.
What is the most efficient way to extract part of a url stored as a string?
Examples
~/admin/default.aspx
~/home.aspx
~/forum/private/page.aspx?Testid=12
In each of these cases all I need is the page part. I.e. default.aspx, home.aspx or page.aspx.
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 would like to insert text in sql server that contains words like select and a single quotation mark but sql server gives errors like if i wanna insert this :
View 1 RepliesI am filling a dropdownlist and sometimes the value (text) is much longer than what is viewable. Is there an easy way to have user see the full text. I am currently using "ASPNET_MsgBox(Message)" and it works but looking for a better solution.
View 3 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 Repliessuppose 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...
I am using the following code for full text search
[Code]....
but I got the following error:
[Code]....
so what is wrong with me?
