I 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?!
I have a picture that i would like to upload to a database. I am really new to this so i am not sure what to do. I have been using the following code below to upload and retrieve the picture, looks like its uploading ok, but i cant retrieve it. The code i am using comes from this site,
http://www.dotnetcurry.com/%28X%281%29S%28e2mwozemizhla24555f41uzz%29%29/ShowArticle.aspx?ID=129&AspxAutoDetectCookieSupport=1.
Uploading Content to database
try
{
if (cmboTopic.Text == "Blu-Ray Movie")[code].....
post the C# source code for uploading images to a database, and then showing it to the user?? I have tried now for 3 weeks with no luck... Maybe we should recommend to Microsoft to add a file upload html helper method to MVC 3?
View 4 Replies[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?
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 RepliesI 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]....
this is my 1st time uploading any database to Host Server. I have purchase DiscountASP's domain and MS SQL 2005 database addon. I can make my website to copy to DiscountASP's domain using the Visual Web Developers copy website wizard and it works great.
Now i have a database in my website which i wanna upload to DiscountASP's MS SQL 2005 database that i have bought, but i dont know how to upload it and then how to make the connection between my Website and the uploaded database. Is it that i have to copy the website(containing app_data folder containing database) to the host and it will work, or i need to copy the database separately and then make a connection in my website and then copy the website?
I am creating an application on my test machine at home. It will require logins, roles, memberships etc.
Just a quick question, will there be any problems when uploading database to my host as its has all my asp.net configurations in the database? Is there anything I need to specifically?
I have few questions regarding MySql database.
First one will be: I've installed MySql, Query broswer, and ODBC connector (not sure what this one does. Can anyone explain?)
Now, when im dragging a new DataGridView into the form, and try to connect it to a MySql database, i can't seem to find MySql in the databases list... why is that?
Second question, assuming everything works fine, how can i upload the database to a server and use it there?
I can think of two problems trying to do this : (1) Im not sure where my Database files are stored at... (for some reason, they are not found in MySql/Data... this folder is completly absent)
(2) While working with ACCESS, all i had to do is to point the .aspx page that did the connecting to the location of the .mdb file, but now, each time i want to reach my database, i need to send the page to the server (localhost). How will i create a connection to my database, when its on another server, in the code page ? (small code example would be nice).
I am sorry to ask this general question. But I could not find any comments sharing about real world experience when it comes to uploading photos. I knows a little bit about uploading photos to SQL database. One is uploading the photos insidea folder and the link to the photos will be stored inside the imagemap (not sure about this datatype??) column and perhaps the other way is to store the photos inside the database itself. Which one is the common and best practice?Any links that I can refer to?
View 2 RepliesFirstly, here is the software I am using locally (which runs my program perfectly): vista home premium sp2vs2008 sp1sql server 2008 enterprise edition sp1iis 7 The server is using: sql server 2008 enterprise edition rtmiis 5.1 I encountered a problem days ago that I have so far been unable to fix. The project runs an asp.net web app perfectly locally. However when I uploaded the solution and the database to the server, it will not connect to the database.
I get the following error:
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Shared Memory Provider, error: 40 - Could not open a connection to SQL Server) 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. SQLExpress database file auto-creation error: The connection string specifies a local Sql Server Express instance using a database location within the applications App_Data directory. The provider attempted to automatically create the application services database because the provider determined that the database does not exist. The following configuration requirements are necessary to successfully check for existence of the application services database and automatically create the application services database:
If the applications App_Data directory does not already exist, the web server account must have read and write access to the applications directory. This is necessary because the web server account will automatically create the App_Data directory if it does not already exist. If the applications App_Data directory already exists, the web server account only requires read and write access to the applications App_Data directory. This is necessary because the web server account will attempt to verify that the Sql Server Express database already exists within the applications App_Data directory. Revoking read access on the App_Data directory from the web server account will prevent the provider from correctly determining if the Sql Server Express database already exists. This will cause an error when the provider attempts to create a duplicate of an already existing database. Write access is required because the web server accounts credentials are used when creating the new database.
Sql Server Express must be installed on the machine. The process identity for the web server account must have a local user profile. See the readme document for details on how to create a local user profile for both machine and domain accounts. I thought that the problem was the connection string so I changed the connection string locally to connect to the server database, and it works. But whatever I try I cannot get the program to connect to the server database from the server's wwwroot.
This will be my first time trying to upload a ASP.NET site. I would like to upload my site by simply using ftp and transferring the contents of the project directory so that the site will be easy for me to make future updates. Where can I find directions for uploading a ASP.NET site via ftp? I am assuming that I will need to edit the connection string in the web.config file. However, my hosting company told me to just make a full backup of of the database into .BAK file format and upload it via FTP to your the "private" folder. Anyone have any experience with something like this and can tell me how this would affect the connection string? Can I back up the database to a .BAK file from within Visual Studio 2008 or do I have to use Management Studio? I am using Visual Studio 2008 with ASP.NET 3.5, C#, and SQL Server 2008 Express Edition.
View 1 RepliesI have some data which is in mySQL, i am not familier with mySQL, i would like to transfer all the data from MySQL to SQL Server database,
View 11 RepliesI'd like to allow users to upload a .pdf file via the file upload control (if that's the best method), save the file to the db and then retrieve it so they can click on a link and open the .pdf they've uploaded. I've been looking for a tutorial on how to do this but keep running into methods of saving the file directly on the server in a directory, not in SQL server (using Linq and VB by the way)
View 4 RepliesI have created a sdf database in a mobile application.Now I want to synchronize that database to a sql server database.
View 1 RepliesI have created web pages using VS Web Developer that use a local Developer Edition of SQL server database on my PC with LINQ to SQL. When I deploy my website to a remote web host SQL server, I need for my web pages to be able to use the remote database instead of the local database. So, how do I get the Server Explorer to connect with a remote SQL Server database?
View 6 RepliesI want to copy a database on a development server to my local server. I am not the server administrator but I have rights to the database. Soon after the wizard Executes the SQL Server Agent Job it fails and the error message says:
The job failed. Check the event log on the destination server for details.
Where do I find this log? Also what could be the problem?
I have created database .sql file for create schema with export database. (its .sql file size is 48.2 MB)
View 1 Replieshow to copy data from one SQL Server database to other SQL server database using two connection string...
View 4 RepliesI want to host my web site on an ISP hosting provider because my upload speed is not sufficient, however I want the database to be hosted locally.1) Is this possible?2) Does SQL server require good upload bandwidth?3) How much data (just an estimate) would it use to retrieve 20 rows of 10 columns?4) I realise this is not an ASP question so can you direct me to where I should post this if noone wants to answer it?
View 1 RepliesI've got a bit of a problem that I can't figure out. I've got a SQL data source on a create user page that uploads the user data to a SQL database when the person creating the account clicks the "Next" button. One of the columns in the DB is an "image" data type and I'm using the FileUpload control to do that. Here is the ds and its info on the actual page:
[Code]....
In the code-behind I have the following (it's something I found elsewhere on the web):
[Code]....
The problem is that the following is being thrown when I try to assign 'data' as the 'DefaultValue':
Compiler Error Message: BC30311: Value of type '1-dimensional array of Byte' cannot be converted to 'String'.
I've looked all around the web to try and figure this one out, but all I'm finding are examples of how to do it when a sqldatasource isn't being used. There's gotta be something simple I'm missing, but I'm just not able to figure it out. Incidentally, I don't need to do all that resizing that's in there, I just need to get the image uploaded.
how to Take External Database Backup file into Local HardDrive.
If I have the appropriate permission, is their a way to access a sql server database on two different servers?
For example if I have a Table A on server 1 and Table B on a different server. How would I join the two tables together, if they each have a column named "PonyId"
I'm able to upload and read any excel file to my server prior 2007, when I try an 07 Excel file, i'm getting the following error message:
'microsoft.ace.oledb.12.0' provider is not registered on the local machine'
do I need anything specail on the web server to allow for Excel 07 files? I'm running IIS6 and a Win 2003 server
If i have created 1 database. then what would be the max size of that database in sql server 2000 & Sql server 2005?
View 3 Replies