asp.net mvc 4 - upload csv file to blob through c# .net and delete it after entering the data into database -
how can upload .csv file blob , read back-end , delete after data entered database?
as new this,i don't have knowledge of it. had gone through on azure website , tried code doesn't works me.
thanks in advance.
first create container in azure , accountname , access key ur blob storage.
follow link : http://azure.microsoft.com/en-us/documentation/articles/storage-dotnet-how-to-use-blobs-20/
than in visual studio create class file , follow code given below :
public class blobstorageservice { public cloudblobcontainer getcloudblobcontainer() { cloudstorageaccount storageaccount = cloudstorageaccount.parse(system.web.configuration.webconfigurationmanager.appsettings["blobsetting"]); cloudblobclient blobclient = storageaccount.createcloudblobclient(); cloudblobcontainer blobcontainer = blobclient.getcontainerreference("mycontainer"); if (blobcontainer.createifnotexists()) { blobcontainer.setpermissions(new blobcontainerpermissions { publicaccess = blobcontainerpublicaccesstype.blob }); } return blobcontainer; } public string getreaddata(string filename) { // retrieve storage account connection string. cloudstorageaccount storageaccount = cloudstorageaccount.parse(system.web.configuration.webconfigurationmanager.appsettings["blobsetting"]); // create blob client. cloudblobclient blobclient = storageaccount.createcloudblobclient(); // retrieve reference created container. cloudblobcontainer container = blobclient.getcontainerreference("mycontainer"); // retrieve reference blob named "myblob.csv" cloudblockblob blockblob2 = container.getblockblobreference(filename); string text; using (var memorystream = new memorystream()) { blockblob2.downloadtostream(memorystream); text = system.text.encoding.utf8.getstring(memorystream.toarray()); } return text; } }
controller :
[httppost] public actionresult uploaddevicestoregister11(httppostedfilebase userdetailcsvfile) { blobstorageservice df = new blobstorageservice(); if (userdetailcsvfile.contentlength > 0) { //to upload file on blob cloudblobcontainer blobcontainer = df.getcloudblobcontainer(); cloudblockblob blob = blobcontainer.getblockblobreference(userdetailcsvfile.filename); blob.uploadfromstream(userdetailcsvfile.inputstream); //to read file blob blobcontainerread = df.getreaddata(userdetailcsvfile.filename); } return view(); }
hope helps.
Comments
Post a Comment