I 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 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 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 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.
Not sure if this is the correct section to ask this but this is regarding storing datatype problem.im trying to convert an image file retrieve from a folder and convert it to Byte so that i can save into database
In below function i retrieve and convert the image from a folder to byte
[Code]....
Then i set ImageUrl in PageLoad
[Code]....
My image datatype in database is image
I try to construct a membership system using Walkthrough: Creating a Web Site with Membership and User Login. The membership system is going to be added to umbraco cms. I should admit that I am still in the learning process and need your guidance for my question.On my registration page other than standard fields which comes with CreateUserWizard, I need to add some extra fields in addition to that and those fields should be saved to database along with standard fields. Is it possible? If it is, how can I manage to do that?
View 3 RepliesI need to take a byte array and save as pdf. How can I do that?
View 4 Repliesi 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 have implemented the following functionality that connects to webservice and downloads a favicon from a given site and saves it to a byte[] which I store in our database. I now want to set it up so that it saves the icon to the disk. However I am getting a "Parameter is not valid" when I try and create the image from the byte[].My code is as follows..
stream.Write(imageByteArray, 0, imageByteArray.Length);
Image i = Image.FromStream(stream); // EXCEPTION HAPPENS HERE.
i.Save(@"C: mp" + filename + ".ico");
The exception occurs on the middle line. This code works perfectly 9 times out of ten, but for some favicons, even thought the icon is a valid image (or at least it appears to be and it shows in the browser when point at it) I get this exception. Does anyone have any ideas? I am pulling my hair out here!
I am getting a FaultEvent when trying to send form fields through HTTPService that contain more than 542 chars.
Initializing the HttpService:
httpServ = new HTTPService();
httpServ.method = 'POST';
httpServ.url = ENDPOINT_URL; //http://localhost:3001/ReportError.aspx
httpServ.resultFormat = HTTPService.RESULT_FORMAT_TEXT;
httpServ.contentType = HTTPService.CONTENT_TYPE_FORM;
httpServ.addEventListener(ResultEvent.RESULT, OnErrorSent);
httpServ.addEventListener(FaultEvent.FAULT, OnFault);
Sending the request:
var params:Object = {};
//params["stack"] = e.stackTrace.slice(0, 542); //length 542 = works
//params["stack2"] = e.stackTrace.slice(1, 543); //length 542 = works (just to show that it's not about the content itself)
params["stack3"] = e.stackTrace.slice(0, 543); //length 543 = fails
I also seem to be able to create many form fields (with 542 length) so that it's not a limit of the request itself but of the form field:
var params:Object = {};
params["stack"] = e.stackTrace.slice(0, 542); //length 542
params["stack2"] = e.stackTrace.slice(1, 543); //length 542
params["stack3"] = e.stackTrace.slice(2, 544); //length 542
// Length > 1600 chars
The receiving party is an ASP.NET 4 site on the same domain and port.
I hope someone already came across a similar restrictions or has some general advice on how to trace this problem down further.
Is it possible to convert a datatable into binary data and save it into on a binary field on database?
View 2 RepliesI am develping an application that integrates with an RFID kit. The problem is, the kit comes with an .cs class that accepts data stored in a byte array however, each information stored in the array respresents an int. I wanted to store String information in each array but, my research suggest that a String itself can be converted to a byte array and not a byte....here the code from the .cs class:
byte BlockNo = 0;
byte[] BlockData = new byte[16];
byte ReturnCode = 0;
[code]....
Each t_b*.text respresents an int. Is there a way I can stored a String in a single byte block?
ArrayList lstEndPoints
0 element "0x01"
1 element "0x82"
byte b = (byte)(lstEndPoints[0]); //Error cannot convert
I have a custom user control which contains a asp hiddenfield object. The value of this hidden field is being set using javascript and I have verified that the value is being set properly. When a postback occurs the new value is not being saved and I cannot access it in my code.
I believe the problem is because the user control is not saved in viewstate and therefore the hidden field value is not saved accross postback. How can I make the hidden field save its value? I tried accessing it from the early page cycles and still no luck.
if (Session["image"] != null)
{
ImageButton1.ImageUrl = "~/IMAGE/pic.jpg?" + DateTime.Now.Ticks.ToString();
}
The session key image is from another aspx page
{
string strPhoto = Request.Form["imageData"]; //Get the image from flash file
byte[] photo = Convert.FromBase64String(strPhoto);
FileStream fs = new FileStream(Server.MapPath("~/IMAGE/pic.jpg"), FileMode.OpenOrCreate,
[Code]....
The issue is
Operand type clash: nvarchar is incompatible with image.
How To Save Video files into folder and save path only into database in asp.net using c#.
View 1 Repliesone button i use to save form entity.and other is to navigate to next pagwhen i click on save button i use jquery to save form entity in database. and form remains as it is
<script type="text/javascript">
How can I save image in db as byte array and show the saved image as slide show in my web page with C# asp.net 3.5
View 1 RepliesDim query as String = "Select * from openquery (devbook, 'SELECT wb.arrival_time FROM web_bookings wb ')"All I need is to convert my arrival_time into a datetime field in the query
View 1 RepliesI'm building an ASP web app that stores appointment times; it'll be used in different timezones. I'm currently saving an appointment in the database as a datetime field. Do I also need to add a field to save the timezone ? What's the best option to solve these multi-timezone issues?
View 1 Replieshow 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 Repliesin my webapp I've created and populated a stringbuilder for a csv file. Normally I write it directly to the response object for the user to download through the browser.However, now I want to save it to a SQL DB image field. Is there a direct way to stream it in? Or do I have to save it to file first, then read it back in?
View 3 RepliesI use a ntext data type for all kind of data save in one field, but when i save byte (that converted from image) follwing message is shown "Operand type clash: varbinary(max) is incompatible with ntext". Is ntext suitable for all kind of data type or what will be compatible for all data type support?
View 2 RepliesI'm going to ask a user to login first, then when I'm going to save information I'm going to have to save the information and associate it with the logged in user.How should I handle this with session?
View 4 RepliesI 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]....