I want to upload files from fileupload control and save them as varbinary Filestream in the database.
First of all, does this make sense? Would you recommend this?
Then, how does it work? I want to be able to upload Imagefiles as well as .doc and .xls.
so when i have uploaded a .xls, how would i save it to the Database(i'm going to use Linq2Entities).
I am in process of sending the file along with HttpWebRequest. My file will be from FileUpload UI. Here i need to convert the File Upload to filestream to send the stream along with HttpWebRequest. How do i convert the FileUpload to a filestream?
View 3 RepliesI have
byte[] a = HashEncrypt("a");
with
public byte[] HashEncrypt(string password)
{
SHA512Managed sha = new SHA512Managed();
byte[] hash = sha.ComputeHash(UnicodeEncoding.Unicode.GetBytes(password));
return hash;
}
I want to save byte[] a to my database. My database field is a varbinary(64). I'm using SQL Server 2008. I want to know the insert query with C# code. I am using ADO.NET
I have a function that will take a file uploaded by a user of my system and store the contents of the file into a varbinary(max) field in a sql server database. I then display the filename of the file in a data grid for the user to see as a link button. When the user clicks on the link button, I want the file to be read from the database and served out to the user as a prompt to download the file. How can this be accomplished? The upload is fine, it is the download I can't figure out. Here is what I have so far.
[Code]....
I get the download to prompt, but it is showing the name of my .aspx page as the file to be downloaded.
Can we get the doc type and contenttype of a file from the filestream field?
View 2 RepliesI've got a vb.net page that when a user clicks a button in a gridview, it copys the file (row seleted) in the gridview as "Label2" from the webserver to the users pc. (We had to setup a lot of security to get it so the webserver could copy to the users pc). I have that all working fine, but now, I'm trying to see if FileStream will then open the file that was just downloaded on the users PC. I'm not familiar with FileStream, and could use a little push in the right direction. (Disclaimer, yes I know downloading the file directly to the pc is a crazy thing to do, but it's a really long story. :-)
For the FileStream portion, I found this sample, but don't quite understand if I can incorporate it into my button click event. Here's the sample [URL]
[Code]....
[Code]....
[Code]....
In of my application I am using the database to store and retrive images. The table stores the documents and the datatype of the field is IMage.
Now with Sql Server 2008, i would like to upgrade this to use this new feature. WHat changes do I have to make in terms of code and also in the database.
I was thinking about the fastest way to retrieve a "set" of objects related to a specific user. For instance, if I was to create a website similar to Flickr where people upload lots and lots of photos(jpegs) what would be the fastest way to be able to retrieve those photos from the SQL Server database. Scenario 1: You store metadata about each file they upload to the website as a single row in a database table. Then when you want to retrieve a specific users uploaded files you simply scan the database file for every row matching the UserID and store them in memory.
SELECT PictureId, UserId, PathToFile, Caption, (etc.)
FROM Photos
WHERE UserId=@UserId
This, of course, gets all the information about all the photos a single user has uploaded. My concern with this approach is when the user activity goes from a few thousand to being in excess of a million.
This approach seems fine for a small website but does this method work for a million plus user website like Flicker or MySpace? When you have a million users and millions more photos does this approach still perform at acceptable speeds?
create a collection in memory of "ALL" the PictureIds' for a single user and store them in-memory, in a collection and then save this collection as a single VARBINARY(MAX) field in the SQL Server Database. So instead of having to find multiple records in the Photos database you would simply need to find one, which would include all the PhotoIds' that belong to the user. In essence, translating into the phrase, "If you find one, you have found them all". And improving server performance by leaps and bounds. I only have about a year experience in working with SQL Server and ASP.NET so Im not sure if this solution is practical, if its already been tried, if it can be done.
I have a problem which I have not been able to find an answer to in months. I store word doc resumes as varbinary(max). I can retrieve the resumes based on a full-text search - no problem. But the resumes are retrieved as word documents in a .ashx file with the following code. I really need to implement hit highlighting on the site so that users can see if the returned resume is a good fit or not. I don't think this can be done from an .ashx file, so I think I need to be able to open the resume as html in an aspx page and maybe use javascript to do the hit highlighting or perhaps return the text only content of the word document somehow and manipulate the text before display with html tags. I cant find anything anywhere which addresses the problem.
[code]....
I am looking to get varbinary data, that looks similar to this in the database, 0x640009002B007A... etc converted back into a string and then into the EnDeCrypt function to regain the sensitive data.
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter returnValue = new SqlParameter("@ccdata", SqlDbType.VarBinary, 500);
cmd.Parameters.Add(returnValue);
cmd.Parameters.Add(new SqlParameter("@reCustId", CustomerId));
cmd.Parameters.Add(new SqlParameter("@CoDiv", CoDiv));
cmd.Parameters.Add(new SqlParameter("@Email", CustomerEmail));............
i am use this code for download..download is correct but after downlaod when open file type zip file or pdf see this error..jcoverflip-1.0.2.zip: The archive is either in unknown format or damaged
protected void LAtt_Click(object sender, EventArgs e)
{
string str = String.Empty;
Conn = new SqlConnection(ConfigurationManager.ConnectionStrings["bakerConnectionString"].ToString());
Cmd = new SqlCommand();
Cmd.CommandText = "SELECT * FROM Tcomplaint where id_complaint=@id_complaint";
[code]....
I am storing an image file into Access database using access form. I am trying to read it out and render it on a webpage using ASP.Net 3.5 and C# but it has read error message.
But if I store the same image to Access using ASP.NET and C# and then retrieve it using ASP.NET and C# and has no problem at all.
Is Access store varbinary difference that ASP.NET store varbinary?
i want to pass null value into varbinary(max) column n to by table
if i do like this i have this function in my app_code .vb class
Public Function Remove_Attachment(ByVal Id As Integer) As Integer
Try
Dim db As New dbAccess
db.commandText = "SP_RemoveAtt_DML"
db.commandType = CommandType.StoredProcedure
db.addParameter("@InOutVal_Id", Id)
db.addParameter("@Document", System.Data.SqlTypes.SqlBinary.Null.Value)
db.executeQuery()
Catch ex As Exception
Throw ex
End Try
End Function
i got this error. Data is Null. This method or property cannot be called on Null values.
I am retrieving a word 2010 document that has been uploaded to a sql 2005 database. When I subsequently download and open the document in a word window it states the file is corrupted and gives the user the option of repairing the file for display. This always works fine but the corrupted message is always presented for all DOCX files. The DOC files from an older Word version work fine without incident. the section of code, VB.NET, for streaming the document out to display in Word is:
Dim bytes() AsByte = CType(dt.Rows(0).Item(2), Byte
())
Response.Buffer = True
Response.Charset =
""Response.Cache.SetCacheability(
[Code] ....
Where the content type value, in this case, is "application/vnd.openxmlformats-officedocument.wordprocessingml.document" (rather than "application/vnd.ms-word").
The filename is simply the full name of the document and the data itself is loaded into the Bytes var. I got some time back... it just doesn't like the new and improved word 2010 files.
Here are my codes:
[Code]....
And here's the error I got:
Implicit conversion from data type sql_variant to varbinary is not allowed. Use the CONVERT function to run this query.
Description:
An unhandled exception occurred during the execution of the current web request. review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Implicit conversion from data type sql_variant to varbinary is not allowed. Use the CONVERT function to run this query.
I need a working example of SQL 2008 File Stream example for overwriting the existing file contents.
View 2 RepliesI am trying to get a FileStream from a relative path. The file is in my project, but when I try to do that it automatically appends C:\ in front of that.
1. Does the FileStream only works if the file is on a local Hard Dive?
2. Also if it works from the local hard drive, then does my application needs some permission to read the file from C Drive?
I have Fileupload control in my page
1-i want delete the text that is beside of fileupload button text: no file choesn
2-i want change text of file upload button( I want change Choose file text)
How to get data (read file) chosen in FileUpload control without FileUpload.SaveAs Method on the server? Is it possible write it at once to some object?
View 2 RepliesI have a FileUpload control in an UpdatePanel and when user select a file, the full file path will will be stored in a hiddenfield, and during postback, i would like to assign the full file path in the hiddenfield back to the FileUpload control textbox, possible to achieve that?
View 1 RepliesI m using FileUpload Control , when i click the fileupload text box , Choose file window have to open.
View 6 RepliesWhat is the difference between :enable filestream for t-sql statement and enable filestream for file i/o streaming access in sql 2008 when and how both feature works?
View 3 RepliesI'm a little green when it comes to streaming and serialization...but what i wanna do is make the Upload method on the server return a serializable object to the client (it is void right now). I have a public class ServiceResult that i decorate with [Serializable], and a public class FileTransferService that implements IFileTransferService
[ServiceContract()]
public interface IFileTransferService
{
[OperationContract(IsOneWay = false)]
string Upload(FileTransferRequest request);
}
The implementation does its thing, and then at the end i create and serialize the object and try to return the string
return ServiceResultSerializer.SerializeAnObject(result);
On the client side i call this service using this class
[System.CodeDom.Compiler.GeneratedCodeAttribute("System.ServiceModel", "3.0.0.0")]
[System.ServiceModel.ServiceContractAttribute(ConfigurationName = "IFileTransferService")]
public interface IFileTransferService
{
// CODEGEN: Generating message contract since the wrapper name (FileTransferRequest) of message FileTransferRequest does not match the default value (Upload)
[System.ServiceModel.OperationContractAttribute(IsOneWay = false, Action = "http://tempuri.org/IFileTransferService/Upload")]
string Upload(FileTransferRequest request);
}
I'm basically taking this project found on this blog: [URL] And trying to make it return a value that the client caller can use I get an error right now that says: The operation 'Upload' could not be loaded because it has a parameter or return type of type System.ServiceModel.Channels.Message or a type that has MessageContractAttribute and other parameters of different types. When using System.ServiceModel.Channels.Message or types with MessageContractAttribute, the method must not use any other types of parameters. Which i have no idea what it means :P I think cuz im trying to change the Service paramaters.
I'm trying to implement the SQL Filestream feature so that I can store the physical PDF on hard disk, while still allowing full-text searching. I've set up my database to allow filestreaming, and as far as I know, have made the table correctly (I set it up based on this article: http://msdn.microsoft.com/en-us/library/cc949109(SQL.100).aspx). I'm just a bit confused about how it's supposed to work, and what steps I need to manually perform.
My understanding is that I convert the PDF to binary and store the binary data in the varbinary(max) field designated as the "Filestream" field, and once the data is stored, the physical PDF file will automatically be placed in the directory I specified when I set up the Filestream option in SQL server. I can also store the file name and extension for retrieval purposes, but the file must be streamed, rather than accessed directly. Is this all true?
What's currently happening is that I save the binary data to the table, but nothing else happens - a file never shows up on the server. The only contents of the directory are two empty folders named: $FSLOG, and, 9953ffec-7c59-41ce-943d-98073853ba0d, and a HDR file named "filestream". Do I need to manually save the file to disk, in addition to saving the binary data?
Hopefully someone can give me some pointers to get this working properly.
I have a webpage which I would like the ability to upload files to be stored in a database. Here's the layout of the page:
[code]....
The update panel is configured as such:
ChildrenAsTriggers="True" EnableViewState="True" RenderMode="Block" UpdateMode="Always" Visible="True" Runat="Server"
The reason I have the update panel outside the Tabcontainer is so that when switching between tabs, the screen doesn't flicker with refreshes, etc. But as a result, I can't get the FileUpload working properly. The FileUpload1.Filename is blank, so it errors out.
Is there anyway to get this working properly? I've tried the latest AsyncFileupload within the control toolkit, but this caused all kinds of problems with my pages so that's out of the question. I tried an iFrame too, but this also didnt work properly.