I want to import csv file(already uploaded in blob storage) in Azure. For example I have uploded test.csv on blob storage, now i just want to import that test.csv file in .net(azure) and after importing i will insert that data into azure database. I am using C# .net.
Creating a cvs file with all rows. Upload it as blob. Parse it with a Worker role and insert it in the sql azure db.
I am making a form to import excel sheet from local computer to azure sql database easily.
I am using [URL] ...
I have made The ID as : Identity, Not Null.
As in my Excel sheet data the ID column is empty, as normally i used to integrate whole excel to sql db so it auto generate, but its waste of my time.
So I want to ask in order to make it successful in case i have no ID numbers for my data in excel file and have Not Null at azure sql db and want to auto generate ID on sql server db after the data that is already on the sql server db.
Because the table where data will be stored is having like already 142302 records and i want to generate my uploaded excel file to there and numbering automatically for ID as 142303, 142304 .... So on.
I have a blob column in mysql database and i am inserting different kind of files like .pdf, .jpeg etc in to that database column.While retrieving that blob data, i want to know what kind of file data i am retrieving(whether it is jpg or pdf) so that i can save that in the known format.
View 4 RepliesI would like to know which is better? Storing images in BLOB or in the File System ? I've got around 400 to 5000 images.
And at run time there are chances where I'll need to retirieve about 100 - 150 images.
Is it possible to upload and Save Excel file as blob in Sql table through web application?
I do not need to query excel file, just be able to upload and download excel file as is.
I would like to be able to give my users the ability to securely upload and store files, sometimes upwards to about a gigabyte in size. I'm not quite sure what's the best way to go about doing this. I would like to have the connection between the client and the server secured, so I'm sure I will probably have to use SSL. Now, my major crux is secure storage. Being that the data is somewhat sensitive, I'm wondering if I should encrypt the file before it is stored. I guess my question is, should I open the file and encrypt each byte or encrypt the file as a whole. I'm assuming that the latter is the better option. I know that there are a number of examples of how to encrypt a file using a number of different methods (aes, des, md5 (hashing not really encrypting), etc). Currently, to encrypt text, I am using the Rijndael algorithm, sha1, 256 bit keys, a predefined passphrase, salt value, and IV.
View 2 RepliesI'm currently developing a web application whose primary user function is uploading and downloading of files. The files will be stored on the hard disk (no cloud storage yet).
Taking into consideration the possibilities of gigabytes of data and a large number of files, do I need to organize files into sub folders to account for the fetching of a file or is the file system's indexing already very efficient and I can ignore this potential bottle neck?
Update:
On a side note, I plan to store file names and any additional information in a SQL database and only query the disk when a user actually wants to download the file. This is how I plan on retrieving files:
FileStream stream = File.Open("C:file.txt");
byte[] fileContent = new byte[stream.Length];
stream.Read(fileContent, 0, fileContent.Length;
Any file information will be retrieved from the database. The hard disk will only be used for saving and fetching files.
Update 2:
Files will be saved as GUID + EXTENSION on the hard disk while the actual file name is stored in the database.
does anyone have any sample code/tutorials on processing a video file uploaded to Azure (.mov, .3gp, .avi) and converting it to flash and also creating a thumbnail file after the video has been uploaded as a blob to Azure?
View 1 RepliesWhat is the best approach to storing images in a file system. Currently I am separating the images by day, month and then year. I am also hashing file name so that no two files will be stored with the same name. Lastly, how would I go about using the image file address in a forum?
View 3 RepliesI want to use XML file as a data source for my application.
View 2 RepliesI would like to work with NLog to track my application's events.How i can configure the generated log file if my server is located on Azure?
View 1 RepliesI have a windows application that stores a file on the current user's isolated storage, lets call this user Adam. On the same machine I have a Web service (The Web Service's application pool is running with Adam's credentials) that uses the same dll to access the file on the isolated storage but it is trying to access a file on the Default User's profile instead of the real user's profile (in this case Adams Profile)
Why is it trying to look for the file on the Default User's profile Instead of Adam's Profile? How can i make it look for the file in the right profile?. I'm running it on Win 2003, C# and .Net framework 3.5
How to get the full path of the file that is selected using the fileuploader.
View 1 RepliesI would like to use HTML input file type in my aspx page to allow user to browse for a excel file and then read the content of the excel sheet programmatically.If I want to read the excel sheet I need the full path of the file to connect to the excel sheet using asp.net.I do not understand how can I get the full path of the file.I know I can get the filename using postedFile.FileName property.But I need the full path of the file.
View 2 Repliesi am uploading a file through file upload control , file size has greater then 4 MB, I have to give the proper alert msg to the user that file size exceeding the limit.how to do it , because at server side it is crashed on the IIS and not return to the server to check the file size validation.that how it is possible to validate the file size and give the proper alert messege
View 3 RepliesCurrently 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 need to calculate the file size of uploaded file in order to catch System.Web.HttpException: Maximum request length exceeded.
This is my code
[code]....
I changed the file size in web.config.
<system.web>
<httpRuntime maxRequestLength="10240" />
I want to keep the uploaded file name to make it possible to users to download the file under the same name. But how can I implement it? The one option I see is to store each file to folder with unique name (GUID, for example).
View 2 Replieshow to download the uploaded file
I have used this in .aspx page...
I have a web form that uploads files by <asp:FileUpload> control. It uploads files to any folder on the disk (path to uploads can change in web.config, for example "c:UploadedFiles"). After file has been uploaded I need to show a link on the WebPage to download this file.
How it's possible create a link to this file (or what is another solution) on the web page if my website is in completely different place!?
Can anybody gives me the codes to get the date for upload file in asp.net(vb)
View 5 RepliesI need to create a custom web control which will be a part of a class library. This custom web control implements the upload functionality. I have implemented this with a web user control where I have a fixed path to a page in the web project where the upload of files take place and it works just fine.
The created control in this class library is used in the web project. How do I post the uploaded file to a page, say SomeClass.cs, in the class library.
Actually i am trying to storing the uploaded file into database but when i run this codes:
[Code]....
I got this error: " Incorrect syntax near the keyword 'File'.Incorrect syntax near the keyword 'File'. " can anybody tell me why this error came out?I tried toi change my connection string in web config,but it still showing the same error each time i run it in my local.
Currently, I am storing images and video clips in my database as a varbinary(max).
The problem is that when my front-end goes to retrieve and play the video, it takes an excessive amount of time to download.
For example, I have a video file: test.avi (5mb). If I attempt to read from database and play avi, it takes about 40 seconds. If I attempt to play this test.avi from the filesystem, it takes about 10 seconds to load.
I have investigated compression/decompression, but those seem to be as time-consuming as just loading up the raw data from the database.
Should I scrap storing video clips in the database, and go for a file system approach. I would really like to keep everything clean, secure, and organized. Which is why I am storing images, video clips, etc. in database.
how to prevent exe file from being uploaded in a website , even if exe file is inside zip file( exe file in a new folder and new folder is then zipped and uploaded)?
View 2 Replies