.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Searching plain-text files.

Posted By:      Posted Date: August 31, 2010    Points: 0   Category :ASP.Net
Hello, I was wondering if you guys could point me in the right direction toward implementing a page in my Web Form application that would be able to allow a user to search a text file which originally exists on a Window File share. Once the user searches for their text, I'd like the page to be split into two panes: One on the left that lists all the hits, each listing being a link which contains an excerpt of text around the link. And another pane on the right which shows the full text document with all the hits highlighted.Now, should I be loading the text file into a data base and be using something like Lucence .NET to search? Or is there a library of controls that can do all this for me already?By searching around the internet I've found bits and pieces of solutions to this problem, such as how to highlight result hits: http://www.knowdotnet.com/articles/highlightingsearchtext.htmlAnd how to perform database searches: http://www.asp.net/sql-server/videos/enabling-full-text-search-in-your-text-dataAm I going to have to painstakingly glue all these things together and write my own solution to this?Thanks for the help in advance.

View Complete Post

More Related Resource Links

Conversion of text files from ANSI to UTF-8

reading and writing text files in ANSI format and
writing html-files in Charset ISO-8859-1 (Western Europe).

Import Multiple Text Files

I have 150 data delimited text files that need to be imported to a text file. Each of them is named for the table for which they contain data e.g. address.txt contains data that needs to imported to the address table. So what I have done is create a SSIS package that contains a ForEach loop that iterates through the the files, and has a Load Data field object. What I haven't been able to figure out is what logic needs to be added for the Data Flow. I know I will need a Flat File Source with a connection source that is tied to file it is processing.  However, after all of that I am not sure what do because each text file contains a different table with different columns. Can someone explain to me how to handle this? Thanks, Isaiah 

Data from text files, What's wrong with my code?

Hi all, I have uploaded some tab-delimited .txt files on my web site (actually run on my computer, ie localhost, for now), and now I try to retrieve the data from those files. I do this by calling a vb file containg the sub below. Everything works great, except that the sub won't recognise unicode characters. I can split the resulting string using vbnewline and vbtab, but already in the sub in question, the string doesn't understand the Swedish letters åäö, apostrophes and more. Any help would be greatly appreciated! /Pettrer       Shared Function getTextfile(ByVal FullPath As String, Optional ByRef ErrInfo As String = "") As String Dim strContents As String = "" Dim objReader As StreamReader Try objReader =New StreamReader(FullPath) 'UTF8Encoding? strContents = objReader.ReadToEnd() objReader.Close() ErrInfo = Ex.MessageCatch Ex As Exception End Try Return strContents End Function  

Problem importing text files with binary zeros (0x00) via SSIS(SQL2005). It is all fine when using D

Hi.   There is a "text" file generated by mainframe and it has to be uploaded to SQL Server. I've reproduced the situation with smaller sample. Let the file look like following: A17     123.17  first row          BB29    493.19  second             ZZ3     18947.1 third row is longer And in hex format: 00:  41 31 37 20 20 20 20 20 ? 31 32 33 2E 31 37 20 20  A17     123.17  10:  66 69 72 73 74 20 72 6F ? 77 0D 0A 42 42 32 39 20  first row??BB29 20:  20 00 20 34 39 33 2E 31 ? 39 20 20 73 65 63 6F 6E     493.19  secon30:  64 0D 0A 5A 5A 33 20 20 ? 20 20 20 31 38 39 34 37  d??ZZ3     1894740:  2E 31 20 74 68 69 72 64 ? 20 72 6F 77 00 69 73 20  .1 third row is 50:  6C 6F 6E 67 65 72       ?                          longer          I wrote "text" in quotes because sctrictly it is not pure text file - non-text binary zeros (0x00) happen sometimes instead of spaces (0x20).   The table is: CREATE TABLE eng ( src varchar (512) )   When i upload this file into SQL2000 using DTS or Import wizard, the table contains: select src, substring(src,9,8), len(src) from eng <               src                ><substr>             <len> A17     123.17  first row           123.17                  25BB29                                493.19                  22ZZ3     18947.1 third row           18947.1                 35   As one can see, everything was importe

C# .NET using a plain text string for a DESCryptoServiceProvider KEY and IV

Can someone please give me a solution to my problem below: I have this file encryption / decryption code which I found in the help docs... Well, all I want to do is use a custom 8 char password with the code... But I keep on getting this error: An unhandled exception of type 'System.ArgumentException' occurred in mscorlib.dll Additional information: Specified key is not a valid size for this algorithm. What encoding should be used for the string to work? This line gives the error: DES.Key = ASCIIEncoding.ASCII.GetBytes(sKey); Please help me with a solution: using System; using System.IO; using System.Security; using System.Security.Cryptography; using System.Runtime.InteropServices; using System.Text; namespace CSEncryptDecrypt { class Class1 { // Call this function to remove the key from memory after use for security [System.Runtime.InteropServices.DllImport("KERNEL32.DLL", EntryPoint = "RtlZeroMemory")] public static extern bool ZeroMemory(IntPtr Destination, int Length); // Function to Generate a 64 bits Key. static string GenerateKey() { // Create an instance of Symetric Algorithm. Key and IV is generated automatically. DESCryptoServiceProvider desCrypto = (DESCryptoServiceProvider)DESCryptoServiceProvider.Create(); // Use the Automatically generated key for Encryption. return ASCIIEncoding.ASCII.Get

How to create a SSIS package to import records form SQl Server 2008 tables to text files

I am a newbie to SSIS and would like to create a package to accomplish the task referenced in the above title. Will appreciate any links and pointers in the right direction.   Thanksakoranteng

Send a workflow email as plain text


I'm using a (SP designer) workflow to send e-mail alerts. I need to be able to send the e-mail in plain text because the recipient is an e-mail-to-SMS service that cannot handle HTML messages. I tried adding <pre> tags to my message, this causes the message to look like plaintext in Outlook, but is still sending the message as text/html type which isn't compatible with the aforementioned SMS service. Any ideas how I can make sharepoint send the messages as true plain text?

Mail server is Exchange 2003 SP2.


How do I send a workflow email in plain text

I'm using sharepoint designer to setup a workflow. My action is 'Send an Email'.  I have no problems sending the email, the problem is the email is always sent as HTML and I need it sent as plain/text as the application receiving this email only takes plain/text.  How do I send emails in plain text or is there an easy 2 step workaround?

Can't full text search pdf files


I have a MyDocuments table that has the following columns: ID, Document varchar(max), and DocumentType

I'm only able to get HTML and TXT results from my full text search queries -- but I know that I should be getting PDFs as well.

What am I doing wrong?

FYI: I did install the iFilter.

Form Services 2010 - potential bug in plain text - multi-line boxes



Just wondering if anyone else has found the following and perhaps a resolution.  (Blog post with image examples here: Click)


An InfoPath Form created in Microsoft InfoPath Designer 2010 and is installed as an Administrator approved template.

  • Form Control: Text Box


  • Read-only – No
  • Enable spelling checker – Yes
  • Enable AutoComplete – Yes
  • Multi-line – Yes


  • Height: Auto

Compatibility Settings:

  • Form Type: Web Browser Form (2010)


  • Browser: Internet Explorer 7, 8, Google Chrome

When running the Form in the web and a user types into the multi-line text box; after 20 characters the text box gets bigger by 1 row.

On evaluation using the IE8 development toolbar.  It would appear that the control is rendered as a <textarea> HTML element and JavaScript runs on the 22<sup>nd</sup> character and adds 1 to the “rows” attribute of the <textarea> element.

For example:

Can PackageStart and PackageEnd events be disabled when logging to text files


Hi All,

I have a package which runs periodically. I have setup the logging to log only OnError events, but everytime the package runs it registers a "Beginning of package execution" and "End of package execution" line in the log file.

As a result of this the log file grows in size and is difficult to open and analyze in the case of an actual error.

Is there a way i can prevent these events from logging into the text file.

text files



  I have 10 .txt files in my folder.I want pull the data into sql table.

my requirement is


1) text1--->pull into sql table A(here Meta data is same)

2)text2---->pull into  Sql table B(here also meta dat same)




like this


plz let me know


how can i develop package

Full Text Searching



Sorry if this question sounds a little basic but SQL isn't my forte by any means.

I have a website that effectively contains 2 types of data - stores and products.  There are many other associated tables such as table_store_profile, a text description which is stored separately, and lots of little tables that might link via an ID and provide a product_type_description or similar.

Because my data size is fairly small and doesn't change, I'm able to cache it in memory as is - so all frequently used tables are cached.  Some less frequently used tables are not cached and are accessed via stored procedures on request.

The main area to focus on though is the cached data.  To populate pages and lists with store and product data I use Linq and the cached datsets.  This provides an extrememly quick and easy method of making those final selections prior to presenting data.  For instance I might store 1000 store records but I'm able to select a page worth of data via a Linq query and bind to a listing page.

I now need to produce a site search.  Initially I was toying with the SQL Full Text Index search but I'm not sure it's the right thing to do in my scenario and am looking for advice.

Out of my cached datasets, lets say I have 2 main tables:


How to move the SQL Server SQLFT log files created by the full text catalog process.


I need to move the location of the SQLFT text log files from it's current location %ProgramFiles%\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\LOG folder to another larger drive to accomodate the log file growth.  I cannot find anything on how to make this change.  Does anyone have an answer?  I have found this is a default at install - but during install did not find how to change this. 

Thank you.



Embedding plain-text passwords



I'm looking to create my application as secure as possible. Now I have following line of code:

DirectoryEntry entry = new DirectoryEntry("LDAP://", "domain\username", "password", AuthenticationTypes.Secure | AuthenticationTypes.Sealing | AuthenticationTypes.Signing);

As you can see, my password is in plain-text in the code. Now, I presume it's easy to decompile a code using a tool and getting your hands on the password. Since these are my AD Admin-credentials this is not that good.

The AuthenticationTypes are secure, I think. They encrypt the data before sending it to the network.
So there's just the problem of the plain-text password. I've searched for it on Google but can't find the proper solution. I've found alot about encrypting passwords in the web.config. Is this the solution to my problem? 

Searching for a unused number in Text file


Hello :)

I have a text file which looks like this :

Item 1
item 2
item 3
item 4
item 5
item 7
item 8
item 10 

(the text file exceeds 1000 lines, this is only a small part of it)

What I want to do is to find the first unused number( in this example it's 6) and let's say I want to print it in a text box.

The code I wrote for it, causes the program to freeze for maybe a half minute , so I hoped someone here could show me how they would solve this problem with
a less time consuming manner :)

Thanks on advance.

Clean Web.Config Files (VS 2010 and .NET 4.0 Series)

.NET 4 includes a new version of the CLR, and a new .NET 4 specific machine.config file (which is installed side-by-side with the one used by .NET 2, .NET 3 and .NET 3.5).

The new .NET 4 machine.config file now automatically registers all of the ASP.NET tag sections, handlers and modules that we've added over the years, including the functionality for:

.ASP.NET Dynamic Data
.ASP.NET Routing (which can now be used for both ASP.NET WebForms and ASP.NET MVC)
.ASP.NET Chart Control (which now ships built-into ASP.NET V4)
What this means is that when you create a new "Empty ASP.NET application" project in VS 2010, you'll find that the new default application-level web.config file is now clean and simple:
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend