DataSource Controls :: Link To A File In SQL Server?
Apr 15, 2010I am saving different file formats as varbinary in a SQL Server 2005. The web application is VS 2005 using VB.
How can I put a link in a page to the file saved in the database?
I am saving different file formats as varbinary in a SQL Server 2005. The web application is VS 2005 using VB.
How can I put a link in a page to the file saved in the database?
Ive created a form on my website. what i want to do is when the user clicks finish at the end of the form, i want all that information to be sent to a table that is in sql server. does anyone know a) if thats possible? and b) what code i would need to put in vb?
View 4 RepliesI have been searching for some information on how to import my xml file into a series of tables using a mapping file (schema).
View 2 RepliesI 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.
On daily basis, I am saving a file in my PC. The name of the file is same but with different date including date. What I required to just there should be a gridview with hyperlink button(Download File) columns like this:
ReportDate Extent Status HostedOn HostedBy
DownloadFile 24/Mar/2010 0700 Hrs Daily Not Added --
DownloadFile 23/Mar/2010 0700 Hrs Daily Added 23/Mar/2010 James
DownloadFile 22/Mar/2010 2100 Hrs Daily Added 22/Mar/2010 Mike
DownloadFile 22/Mar/2010 0700 Hrs Daily Added 22/Mar/2010 James
When user click "DownloadFile" button then it should go to particular folder in server and download file. he task is very important and urgent for me.
How do I upload a file on the web server and save the link of the file in a database?
View 3 RepliesI 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 have created database .sql file for create schema with export database. (its .sql file size is 48.2 MB)
View 1 RepliesI am running a SP that entries that are older than 6 months. These entries have a file associated with them. Is there anyway I can delete that physical file with SQL server too? Its a Win2K3 server with sql server 2000.
View 3 RepliesI have created an aspx file using in Visual Studio. I did this by doing NEW | Website | ASP.net Website and designing it. How do I create the C# code to handle the click events
View 3 RepliesI have a requirement to fill the pdf file.
We are using Sql server and i want to transfer data from SQL server to pdf file.
i want create a file excel from sql server? how can i do?
and can i create it using also sqldatasource control?
I am following this article [URL]
The code from the article is:
[Code]....
After commenting the lines in bold..I can upload word files too...The article also has
GenerateBrochureLink method...which generates link..but when i click the link to download my word file.i get some zip file...with xml.
How can i download the word file which i have uploaded with the view brochure link in gridview.
I have to create PDF Files reading data from SQL Server where the data is in Binary format as Image data type.
View 2 RepliesI am using an sql server 2005.
I want to insert to my table a column of some date,like that the user can insert a text file.
how to do that?
and how can I make that the user can only insert an int of length 9 for id?
I have a table with a varbinary(MAX) column. I want to use the FileUpload control to save the file directly there by a stored procedure. How do you do it without using SaveAs to create a temporary file first?
View 9 RepliesI created an MDF file in VS 2008 in the Solutions Explorer window and can see the file path for this file as:
C:Documents and SettingsAdminMy DocumentsVisual Studio 2008WebSitesAddSQLRecordsApp_Data
But when I try to add this MDF file in SQL Server 2005 Express, I click the Add button but cannot find this exact path above. How do I find this? I am running this on a 32-bit XP OS.
While writing to the SQL Server database, I might encounter the below error message:
"Error 823I/O error <error> detected during <operation> at offset <offset> in file
'<file>'"This error message may occur every time when I start SQL Server and access the MDF file.
How to port the data of a SQL Server table to a excel file?
View 8 RepliesFor 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 Replieshow can i write a sql to execute the file at specific time sql server database.
View 3 RepliesI have requirement that User can Upload the Excel Sheet Data to sql server Database at once.
View 16 RepliesI am trying to Export data from SQL server table to a text file using OpenRowSet.
View 3 RepliesI have an application that uploads an Excel .xls file to the file system, opens the file with an oledbconnection object using the .open() method on the object instance. The upload and writing of the file to the file system works fine but I get an error when trying to open the file on our production server only. The application works fine on two other servers (development and testing servers).
string connectionString = ("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + fileName + ";") + "Extended Properties="Excel 8.0""
OleDbConnection connection = null;
connection = new OleDbConnection(connectionString);
connection.Open();
The exception comes on production server at connection.Open() some times, when I reset the asp.net worker process it started to work but after some hours/days It occurs again. how can I fix this issue which comes in production some times but very irritating, or there is some other work around.
I need to get the Id that matches some other piece of data for a link
example link.
http://localhost:3087/CPNCMS/visitoraccess/InitApprove.aspx?Id=5
I have this as it is now, i just cant get it to work for me
aspx file
<p align="center">
<asp:TextBox ID="TextBox1" runat="server">Case number</asp:TextBox>
</p>
<p align="center">
<asp:Button ID="Button1" runat="server" onclick="Button1_Click" Text="Submit"
[Code]....