Databases :: Use Text File As Database To Store Data?
Feb 14, 2011
website using text file to store data and display it using html codings. The requested website must be able to do the following functions:
1) Browse for template using txt file and select the txt file as template. (Font-styles, headers, tables....etc)
2) Browse for txt file that stores the data and display them in a so called table format categorized properly.
3) Able to do a search function and store the search results in a new txt file. (Which means a new txt file is created everytime someone performs a search and the search results is stored in the new created txt file)
Is there any website with informations/tutorials on these?
I am facing problem..how to read Excel file from the 5th row onwards and how to store the all records into Database Note: More over i do want store few coloumns records(3 out 8) only in my database. consider this point.
I am reading a word file and saving the contents into the database and retrieving it. One issue is that if word document contains a bold text or underlined text it is not getting saved into the same format. Is there any possible way to save and retrieve the rich text.
Is it better to store images directly in a database or to just store the name of the file in the db and display that file? I would think that just storing the filename of the image would keep the db size low...
I am trying to store data from an XML file to a table in my database, but I keep getting the same error.
This is my code from the cs file:
[Code]....
And this is my error:
Violation of PRIMARY KEY constraint 'PK_Areas'. Cannot insert duplicate key in object 'dbo.Areas'.
The statement has been terminated.
In my XML file I have both existing rows and new rows for the database table. I'm guessing I have to do something to sort out the the rows that are not already in the database, but so far I have been unsuccessful to figure this out.
I have some code in my default.apsx.cs file that all works except one very small but important piece.. I have the same code in c# consoleapp and it works fine on my local machine.
Here is the code...
[code]...
When i try and run it through visual web developer it seems to feel the file doesnt exits so evaluates the if statement to false and moves. on... I havent specified a path and have the file in the same folder as the default.aspx.cs file.
I'm trying to read data from a text file into a DataReader object using the following code but I get an exception:
OleDBException was unhandled.
Cannot update. Database or object is read-only.
Also, I would like to know if it is efficient to read data of a text file into a datatable instead of using StreamReader object and traversing through the recordset.
I want to store a doc file [say its a resume.docx file] into a database like sql server 2005 and i want the file to be displayed into my aspx page if the file has been updated to the database And also is there some means by which by pressing some link he can get a edit window so that he/she can edit his/her document file.
I have a text file stored in my sql DB. in that .txt file I have certain numbers like:
99435 87889 33455 33555 34556
How to get the count of these numbers from the txtfile stored in the database? Also to read the file and fetch the number one by one in a string? I am using asp.net (C#)
Is it possible to store an Image file (.jpg, .gif, etc) in MYSQL database? Or do it just stores in system and takes reference path of image? I am using ASP.NET C#, so if you have sample code
how to store files (pdf and word files) into sql database and how to display that files with an option of "save" , "open" from sql data base when user click. i am doing project using c# + asp.net web application
I am working with one project like software corner !in which i upload my all software and end-user can download that software but my problem is how i store my software's(>25MB.exe files) in database ...
