For my web application I need to allow the user to upload a word document to the database. I've searched the forums and I've only been able to find with uploading to a server. Can anyone one give me a link to a tutorial or step by step guide on how to do it? I'm not even sure what data type to set the attribute to in the database.
View 4 Replies
trying to upload from an .xls file to microsoft sql server.What i did was i upload the file to a folder in server and pick the record from the folder. This work on development machine but on getting to a iis server to test the application i got an error that was saying the root folder for the www root for the folder was not found.
<pre lang="msil">protected void btnUpload_Click(object sender, EventArgs e)
{
string FileName = FileUpload1.PostedFile.FileName;
string saveDir = @"";
string appPath = Request.ApplicationPath;
string savePath = appPath + saveDir + Server.HtmlEncode(FileUpload1.FileName);
String fileExtension = string.Empty;
String path = Server.MapPath("~/Uploads/");
[Code]....
i am using visual stdio 2005 and sql server 2005 for making a apllication
i want to save user's doc,docx file in database and show the uploaded user doc ,docx file in asp page
I have a problem, I have created a website that is run on local host database is make in 2005 sql server
now i am using sql 2008 and visual studio 2010 , I attach the sql 2005 mdf file in sql 2008 server and run it working correctly when we host it then it is not working
problem gives "NT NETWORK SERVICE FAILED "
how we can convert the sql 2005 mdf file to sql 2008 file.
I have 5 GB data, when I move from SQL server 2000 to 2008 with Import and Export wizard, my LDF size is increased to 30 GB, Can I reduce my LDF file or move. In my one of the table contain around 20 Lakh data which i have normalized in 2008 and create 4 tables, so my data is entering in normalized form in 2008. But due to size by hard disk is full. I have used shrnik command but it reduce to only 1 GB.
View 5 RepliesI am facing the problem to acess the Data Base. some time ago i am easily acess the data base by typing the server name(like 127.80.1.7) and type the user id and password from web.config file but now i am find the error.like Login failed for user 'NSAdmin' (Microsoft Sql Server, Error:18456).
View 3 Replieshow to install microsoft sqlserver 2005 or 2008 on window 7 with x64 bit.It works perfectly on vista but on getting a new system which comes with window 7 and x64bit i was unable to load the software onit except my visual studio 2008.
View 1 Repliesi want to insert doc/docx file into database and after that i want to retrive that file in lable
View 10 Repliesi was trying to created a gridview table that you will be able to upload a .docx documents and then when the user use it , he or she can click on the ID then the words documents will show up .
View 6 RepliesI have built a website using Visual Studio 2008 asp.net 3.5, and data is retreive from a database that is made by SQL Server Management Studio 2008.
The question is: How can I upload the database files to the server? Can you give me a step by step description?!
[Code]....
and i found it, here http://forums.asp.net/p/1480079/3451771.aspxi can fairly easily code for a general dbase (name, address, etc..)my question here with this code is...where does my dbase info go?
my dbase info
dbase name = files
tablename = fileTable
column names = fileOne, fileTwo, fileThree
the file upload object is called "fileupload1" and this all goes with a "submit" button
also, that is pretty much for one file, what if the user is uploading more than one file? do i just add more if/then statements, one for each fileupload object?
how can i transfer complete database from sql server 2008 to sql server 2008 without loosing relationship intigrity.
View 9 Repliesis there any difference between sql express and sql client. Actually I have been told to install a sql client using which i will connect to the sql server installed remotely. Also I have sql express edition 2008 installed on my machine. So is it the same. Will I be able to connect to the sql server using the sql server express edition.?
View 2 RepliesWhen i tried to attach 2008 database in sql server 2008 it is throwing the error-
"The database 'actitle' cannot be opened because it is version 655. This server supports version 611 and earlier. A downgrade path is not supported.Could not open new database 'actitle'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 948)"
When i execute 'select @@version' it gives 'Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Workgroup Edition on Windows NT 5.1 (Build 2600: Service Pack 3) 'How the version still be 2005 when im in 2008 ..How can i attach my 2008 database back up.
I got the following error message on my web app and am trying to figure out what I need to do to fix it. :S
Could not load file or assembly 'Microsoft.AnalysisServices.AdomdClient' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)
I have the application running on the live server now, but we are migrating to a new server and they asked that I load this application on that server. I loaded the files and am working my way though the asembly errors (the new server is 64 bit so I had to tell the application pool to allow for 32 bit applications)
But then this happend and I got the error above and didn't know what to do.
I had this dll set to copy local, but after I got this I set that back to false. It works on both my dev server and my live server. Both running windows server 2008 and IIS7.
I creating a page where our clients can view advertising images and then able to download the images in different file formats. So I need the images and the different download types all saved into the same row in the database so that when I go to display them on the page when they select a picture the right download links will be there. So here where my problem comes in, I don't know how to code it so that I can insert mulitiple file paths into the database at once. The images are saved in a table called images. The downloads are saved in a table called Image Downloads.
Here is the code for the page I have it coded to submit the images to the database but not sure how to add the rest. I have got three different sql datasources for each table not sure if that's the way to go.
[Code]....
I am using DocX Reference and there is problem in generating image in the header ..how to add Image Header??
// Create the document in memory:
var doc = DocX.Create(fileName);
using (MemoryStream ms = new MemoryStream())
{
//if(Branch=="SFA"|Branch=="SSA")
//System.Drawing.Image myImg =Properties.Resources.SerbaAntik;
//if(Branch=="SBA"|Branch=="SMA")
//System.Drawing.Image myImg = Properties.Resources.Sarana;
//if(Branch=="SPA"|Branch=="SSG")
System.Drawing.Image myImg = Properties.Resources.Kharisma;
[code]...
What's the different between "Microsoft SQL Server Express 2008" and "Microsoft SQL Server Express 2008 R2"?
I will use my Visual Web Developer (or Visual Studio 2008 or trial 2010) in my laptop to make a website. Which version of Microsoft SQL Server Express 2008 that is suitable for my laptop? My laptop specification is meets for both of versions.
I have written a website and let the user upload their photo. It also resizes the picture to 400 x 400 and crops automatically to the center part of the picture. All of this works good but each file is about 355K each for JPG and PNG file formats. I just tried GIF and it is 49K but the picture is grainy when saved this way. Is there any way I can get the picture to a smaller file size with keeping it at 400 x 400? I really thought PNG would be the way to go and was surprised by it being the same as jpg. I don't want to lower the quality either for JPG files.
View 1 RepliesMicrosoft sql server error 18456 in sql server 2008 r2login failed for user sasql server was working properlyi just restarted the system and then i started getting the above errorhow do i resolve iti am able to login with windows authentication but not sql authentication....
View 1 RepliesI am having an issue that I do not quite understand. I had an ASP project that I built using
Code:
<add assembly="Microsoft.Office.Interop.Word, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71E9BCE111E9429C"/>
while I still had Office 2007 still on my development PC. I recently upgraded to Office 2010 and even though the web.config file still remains with the above assembly reference, when I publish it and run it now i keep getting the following error ...
Quote:
Could not load file or assembly 'Microsoft.Office.Interop.Word, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' or one of its dependencies. The system cannot find the file specified.
I also have installed the PIA for Version=14.0.0.0 on the server but I still get the same result.
We have developed apllication in Microsoft VS 2008 and when we opening this same application with Microsoft VS 2010. Then it's asking to convert.
So can anybody tell me what it is converting exactly. Means it's open application in Microsoft VS 2010 and running properly also. But i am understanding whats happning while converting.
Visual Studio 2008. I've done a page to upload images in asp.net web application.. . Now I need to create a web service which would be able to convert the image by our given height and width before uploading.........
View 1 RepliesWith the ajax file uploader, would it be possible to check the size of the image before uploading?Currently, it uploads the file to the server and then lets me know that it's bigger than the limit size.
I have a web app, can upload images when running it on the local development machine, but when runnign it on WebServer 2008, it gives me an error saying "access is denied". I konw it is something to do with security, but how do I make it such that an internet user can have acces to it. The folder is located in: c:inetpubsiteimages494
View 4 Replies
