Below is the code I use to store file into database but there are a few problems.
1. couldn't store file larger than 4mb
2. couldn't store doc,docx,xlsx but only .txt
my table column are:
[code]....
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...
View 1 RepliesHow to upload Power Point Presentation in sql server using asp application and
also how to show the PPT to user
i like to create a web application,in that i need to get the resumes from the user,then i need to publish that resume to the manager in date wise..
View 5 RepliesI 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 m reading a text file. After reading all the lines, I want to insert those records into respective fields in database.
So how to store the 1 or 2 or 3 or 4 or 5 lines of records until I read the last record.?
[code]....
first 9 number is emp id, next is name and next is salary.
While I m reading, I can store only last record. How to store all the records in a array to store in the database after reading all the lines.
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
View 5 Replieshow 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
View 4 RepliesI 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 ...
(I use sql server 2012) ...
What data type in SQL should i use to store an XML file? And how do i do it?
View 5 Replies1. How to store I ZIP file in Database using FileUpload in ASP.NET C#
2. Also need to downloading it from database by gridview
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?
Which is the better alternative when allowing file uploads on a page (through a Gridview populated by a coded DataSet)? Store the image itself in the database or to store only the path name to the saved file in file system. If it matters, I do not expect to have more than a few dozen images stored in the database at any given time.
View 7 RepliesI need a place to store images. My first thought was to use the database, but many seems to recommend using the filesystem. This seems to fit my case, but how do I implement it?
The filenames need to be unique, how to do that. Should I use a guid?
How to retrieve the files, should I go directly to the database using the filename, make a aspx page and passing either filename or primary key as a querystring and then read the file.
What about client side caching, is that enabled when using a page like image.aspx?id=123 ?
How do I delete the files, when the associated record is deleted?
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 dont know iam placing my query correct place or not but i need ur's help, Iam Reading and storing one single excel file Successfully But
tring Path = @"E:checkinkkk.xls";
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.
View 4 RepliesI am working on a journal website where user submit manuscripts , pdf files , is it good idea to store pdf files on directory or on database.
View 1 RepliesI am working on a project (asp.net web application) that takes files from users, stores them and retrieves or shows them back to the user when needed. I am saving files on my file system (drive). When I save images and refer to them in iframes, images are being displayed in iframes. But when I save .html file and refer it in an iframe it is not displaying the html file. I want to store a .html file on my file system using file upload and store on my local drive, display it in an iframe.
View 1 RepliesI have to open a batch file automatically in sql. So i have used the below command.EXECUTE master.dbo.xp_cmdshell 'D:Databasesatch123.bat'Its worked for few times. After that its not working.One time i have stopped before the process is complete.May be this is the issue.Now its returns null value.
View 4 RepliesI have a file delete option for the files uploaded by the user, user can upload many files at a time.The uploaded files will be stored in a folder in server and when its is deleted its is moved to trash folder from where it will be manually cleared.
when a user tries to delete many files in the web page IIS get hangs and all session is expired. This case only present in server,in local host this issue is not available.
ALL the operations is carried out completely ie
Database gets updated. Files is moved from upload folder to trash folder in server.
I cannot determine what is going wrong,I just tried to delete many files totally around 35-36 MB. Is the issue with process taking long or is there any changes have to be made in order to perform large files operation, my project is done on VS2005 which is running in 2008 server.
how to store into sql data base and and how to retriew xls file as xls file from database in the form form of byte[] using c# in asp.net application.
View 1 RepliesIts related to datatable in gridview store in session and then session retrive and store to database. basically i am using gridview here creating new row for button click and these row adding untill user's last entry then submit all these entry to database. so i want to use session variable to store this data temporarily and after final entry user click on submit button and all data shold be save in db.
View 9 RepliesWeb service error response (code/message etc) would you store it in a database? or would you keep the error response in a method.By the time I'm done with this, there will be hundreds of error response, maybe in the future, thousands? (I dont know yet, depends how large this web service grows).EDIT: error response is the response returned back to the application via the web service, (not to be confused with error logging).
View 1 RepliesI'm implementing version control system using WCF service and client application. I can not figure out, how to store files on the server side to easily access different versions.
View 6 Replies