How To Store File In SQL DataBase

May 8, 2007

please tell the steps

How to store File in SQL DataBase

View 1 Replies


ADVERTISEMENT

Store The Data From A Database Into A File.

Mar 22, 2008

how to use class iDataReader's function getbytes(...............) to read binary data? 
 
using System;using System.Data;using System.Configuration;using System.Collections;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Web.UI.HtmlControls;using System.Data.SqlClient;using System.Data.Common;using System.IO;
public partial class uploadFileToDatabase : System.Web.UI.Page{    string strUser;    protected void Page_Load(object sender, EventArgs e)    {      strUser=Request.QueryString["download"];      if(strUser!=null)      {        string strConn="Data Source=hao-pc;Initial Catalog=simpleBBS;Persist Security Info=True;User ID=sa;Password=123;Pooling=False";                SqlDataAdapter sda=new SqlDataAdapter();        DbProviderFactory dbProviderFactory=DbProviderFactories.GetFactory("System.Data.SqlClient");        DbConnection dbConn=dbProviderFactory.CreateConnection();        dbConn.ConnectionString=strConn;        dbConn.Open();        DbCommand dbComm=dbProviderFactory.CreateCommand();        dbComm.Connection=dbConn;        dbComm.CommandText="select * from userFiles2 where fileisn='"+strUser+"'";        IDataReader myReader=dbComm.ExecuteReader();        int strFileLen=0;         if(myReader.Read())        {        strFileLen=Convert.ToInt32(myReader.GetString(3));        FileStream afs;        string fPath;        fPath = Server.MapPath(Request.ApplicationPath) + "\upLoadFiles\" + myReader.GetString(1);        afs = new FileStream(fPath, FileMode.OpenOrCreate, FileAccess.Write);        Byte[] filedata = new Byte[strFileLen];                afs.Write(filedata, 0, strFileLen);                 BinaryWriter abw;                  int iBufferSize=1000;          Byte[] outbyte=new Byte[iBufferSize-1];          long retval;          long starIndex=0;                    abw=new BinaryWriter(afs);          starIndex=0;          int itemNum=4;          retval=myReader.GetBytes(itemNum,starIndex,outbyte,0,iBufferSize);  //when i store  large data into a file it display an error such as "Buffer offset '0' plus the bytes '82452' is greater than the length of the passed in buffer.            abw.Write(outbyte);                        starIndex+=iBufferSize;            retval=myReader.GetBytes(itemNum,starIndex,outbyte,0,iBufferSize);          }              abw.Write(outbyte);            abw.Flush();            abw.Close();            afs.Close();            myReader.Close();            dbComm.Dispose();                   }      }                                      }    protected void Button1_Click(object sender, EventArgs e)    {      string strFileName;      string strFileType;      int strFileLen;      Random ran=new Random();      string strFileISN=DateTime.Now.ToString("yyyyMMddhhmmss")+ran.Next(0,999);      if(FileUpload1.PostedFile.FileName!=null)      {        strFileName=FileUpload1.PostedFile.FileName;        strFileType=strFileName.Substring(strFileName.LastIndexOf(".")+1);        strFileName=strFileName.Substring(strFileName.LastIndexOf("\")+1);        strFileLen=FileUpload1.PostedFile.ContentLength;        string strConn="Data Source=hao-pc;Initial Catalog=simpleBBS;Persist Security Info=True;User ID=sa;Password=123;Pooling=False";                SqlDataAdapter sda=new SqlDataAdapter();        DbProviderFactory dbProviderFactory=DbProviderFactories.GetFactory("System.Data.SqlClient");        DbConnection dbConn=dbProviderFactory.CreateConnection();        dbConn.ConnectionString=strConn;        dbConn.Open();        DbCommand dbComm=dbProviderFactory.CreateCommand();        dbComm.Connection=dbConn;        string dateTime=DateTime.Now.ToString();        Stream fs=FileUpload1.PostedFile.InputStream;        Byte[] filedata=new Byte[strFileLen];        fs.Read(filedata,0,strFileLen);                dbComm.CommandText="insert into userFiles2 (fileisn,filename,filetype,filesize,filecontent,uploadTime) values (@fileisn,@filename,@filetype,@filesize,@filecontent,@uploadTime)";        dbComm.Parameters.Add(new SqlParameter("@fileisn", (object)strFileISN));        dbComm.Parameters.Add(new SqlParameter("@filename",(object)strFileName));        dbComm.Parameters.Add(new SqlParameter("@filetype",(object)strFileType));        dbComm.Parameters.Add(new SqlParameter("@filesize",(object)strFileLen.ToString()));        dbComm.Parameters.Add(new SqlParameter("@filecontent",(object)filedata));        dbComm.Parameters.Add(new SqlParameter("@uploadTime",(object)dateTime));        dbComm.ExecuteNonQuery();        fs.Close();        dbConn.Close();        dbComm.Dispose();        dbConn.Close();      }      }  }
 

View 3 Replies View Related

Images - Store In A Database Or File System?

Jun 19, 2007

I have recently designed and built my first database using SQL server 2005 express. I have included an image (BLOB) column in one of the database tables. This is a bad idea according to some experts, and some say it is OK!


I am currently carrying out a trial with just 3 pictures via Visual Basic 2005 express forms, and there is no problem so far as the images are displayed for each record. But I anticipate between 300 - 1000 images for the table, and this could pose real problems for SQL server 2005 express and Visual Basic 2005 express, I guess.


I have just been reading that the cost of storing large images in the database is too high! I have also read it's better to store images (BLOB) into the file system because it is cheaper to store them no matter how many there are.


But the question is how I can reference an image in this path: C:PictureProductGrocery0052745.jpg in the database table, so that when I select a record Visual Basic 2005 forms the image is displayed accordingly, similar as when stored directly in the database table? Your help very much appreciated.

View 3 Replies View Related

Store Blog Post Content In Text File Or Database?

May 21, 2006

    Hi. I am currently building a blog application, and I need some advice... I have the post title, post date, post by, etc stored in a database table, however I was wondering whether I should store the actual post content in the database as well or in a text file. For example, if the posts get really long would it slow down database performance or would there not be much of a difference? Furthermore, if I wanted to keep the posts private, a text file would not be ideal as it can be accessed easily by surfers... What do you recommend?Thanks a lot

View 1 Replies View Related

Mirroring :: Store Transaction Log File / When Create Mirror Database

Nov 27, 2008

When Create Mirror Database Server, Where need to store the Transaction Log backup file?I took FULL Backup of my Primary Database, and I restored at my Mirror Server also. When I try to create a Mirror Database."The remote copy of database "<db_name>" has not been rolled forward to a point in time that is encompassed in the local copy of the database log. (Microsoft SQL Server, Error:1412)".I am misplacing the Transaction Log backup file. Where I need to store that file?

View 10 Replies View Related

An Attempt To Attach An Auto-named Database For File (file Location).../Database.mdf Failed. A Database With The Same Name Exists, Or Specified File Cannot Be Opened, Or It Is Located On UNC Share.

Sep 2, 2007

Greetings, I have just arrived back into the country (NZ) and back into ASP.NET.
 I am having trouble with the following:An attempt to attach an auto-named database for file (file location).../Database.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
It has only begun since i decided i wanted to use IIS, I realise VWD comes with its own localhost, but since it is only temporary, i wanted a permanent shortcut on my desktop to link to my intranet page.
 Anyone have any ideas why i am getting the above error? have searched many places on the internet and not getting any closer.
Cheers ~ J
 

View 3 Replies View Related

SQL 2012 :: Max Size Of File Which Store To DB By File Stream

Dec 5, 2014

is there limitation for size of file to store in db by filestream in sql server 2008?or it accept all sizes?

View 1 Replies View Related

The Database File May Be Corrupted. Run The Repair Utility To Check The Database File. [ Database Name = SDMMC Storage Cardwinp

Oct 9, 2007

yes,I have an error, like 'The database file may be corrupted. Run the repair utility to check the database file. [ Database name = SDMMC Storage Cardwinpos_2005WINPOS2005.sdf ]' .I develope a program for Pocket Pcs and this program's database sometimes corrupt.what can i do?please help me

View 4 Replies View Related

How To Store And Retrive .DOC File In Sql

May 28, 2007

Hi frds,
 
My question is how should i store a .DOC file in sql 2005 as image field and how to retrive the Doc stored in Image format
 
Thanks & regards
Sithender.s

View 3 Replies View Related

Store A File Upload Into DB

Sep 10, 2007

Can someone please direct me to a discussion on which version of SQL Server allows a file to be stored in a db field and how this is accomplished as well as how the file is then retrieved with asp.net VB from the DBthanksMilton

View 16 Replies View Related

I Want A Suggestion How Store This File

May 11, 2008

Dear all,,
I used a program that convert from powerpoint to flash
the output of this program is a folder that contain 2 folders and a HTML page
How can I store those in my database?
note: I have to use all of these folders to preview the flash
Thanks in advance

View 5 Replies View Related

Store DOC/PDF File In SQLServer Using ASP.NET(with Vb.net)_

Jan 21, 2004

Hi!
I want to store doc/pdf/image file in my SQL server2000 database. I have taken the field datatype in SQL SErver2k as "text".

Now I want to select a file in my project & want to store it in the DB using asp.net commands.

Can anybody tell me the procedure with a small example?

I have used FileInput to select the file .


thnx.....

View 3 Replies View Related

Store HTML File In Sql

May 11, 2006

How to store the html file in sql server data.
 
 

View 2 Replies View Related

Converting SQL Qry Into XML And Store As XML File

Nov 22, 2001

Hi There,
My requirement is to read from a table in SQL 2000 and need to export the
data in a XML format with .XML in a flat file.

I don't want to do to use ADO or VB or any other external tools to do this. I want it to be purely done using SQL server within enviroment.

How to generate this kind of XML files from
SQL server?.

Kindest regards,
Chris.G

View 1 Replies View Related

What Directory Would Be Best To Store The .SDF File In?

Jan 13, 2006

I am creating some applications for Windows Mobile 5.0 devices to be used internally at our company. Each device will run several home grown applications that will all share the same common SQL Mobile database.

What I am wondering is whether or not there is a standard path where such a database is typically stored in Windows Mobile 5.0. I see a folder called Application Data. Is that what it is for, or is that one for something else? I'm not real familiar with the layout of the Pocket PC in general. Could someone tell me where vendors normally put their database file(s)?

Thanks,

Brad

View 1 Replies View Related

How Can I Store A Text File Into SQL Server?

Apr 6, 2004

Hi,
Can some one give me some suggest?
Thanks!

View 2 Replies View Related

How To Store And Read .doc File In A Table

May 10, 2006

I would like to store and read .doc file in a table of sql server using C#.
Can some body help me on this? my id is padam76@gmail.com.
Thanks & Regard,Padam Kumar Tripathi

View 1 Replies View Related

Store Proc & File System

Dec 21, 2001

I was wondering if anybody can help me in a storeProc for SQL 7 which can get the realational tables frm a database and put them into filesystem...

Cheers
--Nik

View 1 Replies View Related

Store File Prirefix With Date Value.

Sep 22, 2005

Hi,
I need to export data from sql server into flat file. The file sould be generated with current date and table anem.

for example yyyymmddhhmmsstablename.txt.

Do you have any solution for this.
Thanks,

View 1 Replies View Related

Which File Store Startup Parameters?

Jul 20, 2005

or in registry? where?

View 8 Replies View Related

How To Store File Binary Content

Dec 3, 2007

Hi,

I have never use sql server to store binary data. Now, I need to store a .doc file into it. Which column type I should adopt?

In addition, could you provide me related articles to study?

Thanks,
Ricky.

View 3 Replies View Related

Store T-SQL Messages Inside A File

Nov 24, 2006

Hi All,

I am writing a automated backup script using job scheduler of the management studio and would like to know how can i copy the output messages given by the SQL Server to an external file automatically.

Thanks in Advance

Mitesh

View 1 Replies View Related

Import A Store Xml File Which Has Dtd Into Sql 2005

Jan 22, 2008

I am trying to import a store xml file which has dtd into sql. The file is 97,211 kb. I want to get the data and columns into sql 2005. So far I have tried this:


DECLARE @xml XML;

use yahoostore

CREATE TABLE Products(xmlCol XML)

INSERT INTO Products(XmlCol)

SELECT

CONVERT(XML, BulkColumn, 2)

FROM OPENROWSET (BULK 'C:databasexmldtdyahoostore.xml', SINGLE_BLOB)AS X

This creates the table and only one column which takes a while to open, but I do not see anything in it.

Could someone please help with this problem. I have used openrowset and openxml and I am getting no where.

Thanks
Dee

View 38 Replies View Related

Granting Permission To Object In X Database From A Store Procedure In Y Database

May 16, 2000

I need to grant select, insert, update, and delete permission to an object residing in Database "X" from a store procedure in database "Y". I have already tried USE database statement. Any suggestion.
Thanks
Maroof Khan

View 1 Replies View Related

Whats The Best Way To Store Filename / File Path?

Jan 20, 2004

I'm guessing the best way / only way to store a filename is to store it as a varchar?

I'm using it as a reference to pictures wefor a gallery

View 2 Replies View Related

How To Store File Attachments (text And Binary).

Nov 9, 2006

I need to store several different types of documents (text, MS Word, PDF, etc.) in SQL Server 2005. What is the best way to store file attachments that have different MIME types?

Currently I'm using a table with a varbinary(max) column which works for binary files but not for text files. Do I need to have multiple columns in the table for different file types? Thanks in advance for your help.


CREATE TABLE dbo.[CM_Attachment] (
[Id] int IDENTITY (1, 1) NOT NULL ,
[Change_Request_Id] int NOT NULL ,
[Attachment] varbinary(max) not null,
[Created_Date] datetime NOT NULL DEFAULT GetDate() ,
[Created_By] varchar(30) NOT NULL ,
[Modified_Date] datetime NOT NULL ,
[Modified_By] varchar(30) NOT NULL
)
GO


INSERT INTO CM_Attachment(Change_Request_Id, Attachment, Created_By, Modified_Date, Modified_By)
SELECT 6, BulkColumn , '', GetDate(), ''
FROM Openrowset( Bulk 'C:TestingTest Doc #1.txt', SINGLE_CLOB) -- Does not work
-- FROM Openrowset( Bulk 'C:TestingTest Doc #2.xls', Single_Blob) -- Works
-- FROM Openrowset( Bulk 'C:TestingTest Doc #3.jpg', Single_Blob) -- Works
as ChangeRequestAttachment

View 8 Replies View Related

IS There A Way To Store List Of Errors In Text File

Apr 4, 2007

I want to attach a error list to my email task and i want my email task to send email only if there is an error...IS this possible..

View 8 Replies View Related

Store Webservice Task Output To File

Feb 14, 2007

Hi

I have designed a package that reads in rows from an Excel file into a recordset then loops through the recordset sending two parameters to a webservice task. This works fine however I now need to output the results of the webservice task to a file or recordset - I have tried outputting to a file however it only stores the last result as the file is overwritten each time - I am new to SSIS and am sure there must be a really simple way to do this but cannot find an help on how to do it !

Thanks in advance K



View 4 Replies View Related

Importing Text File Store Procedure

May 27, 2008



hi guys..

i need some assistance.. i have couple of .txt file to import into database.. @ the moment i am doing by improting process in sql management.. but it's realy pain and time taking.. i got a stander file format that i import,. and the destination table if exist then ookay otherwise i just create one ..

Is it possible that i can write a Store procedure so that i can use that .... Please help me.. i dont' a single clue about this..


Thanks

View 1 Replies View Related

How To Read And Store A Large File From SQL Server 2000?

Feb 23, 2006

hi..
   I want to store a RMVB file to SQL SERVER 2000 ,and read from it,iwant to play the RMVB file in web,the size of the RMVB file is more than 300MB less 1G.the  SQL Field Image can include it.
Now My Quesstion is How can i Store and Read the RMVB file from SQL Server2000?
I used SqlInsertCommand.ExecuteNoquery()  in my program,but it Too slow,ao make a unknown error.
Thank you for your help.

View 6 Replies View Related

How To Store Column's Value From A Flat File Into A Package Variable?

Oct 7, 2007

I have a few flat files that will be retrieved from some SFTP server. One of the flat file will act as a terminal file where it will specify the total number of records expected in each other the flat file.

Data in the terminal.txt
FileName TotalRecords
File1 1000
File2 1500
File3 2000

So, before transforming the data from the flat file sources into the target destination, i wish to do a row count checking for each of the flat file source to make sure that the number of records in the flat file source is tally with the number of records specify in the terminal.txt file. I'm able to get the number of records in each of the flat file by using the RowCount component but don't know how to get the data out from the terminal.txt file in order to make a rowcount comparison.

Can any1 help me on this? Or is there any other way we can do to make sure that the flat file source is alright before proceeding with the data transformation task?

Thanks!

View 3 Replies View Related

Transact SQL :: Can Store File Data Without Streaming On Server

Oct 14, 2015

I need to store file(s) to SQL without streaming / reading at Server. I have created a Web API with AngularJS and SQL. e.g. 

var fileType = httpRequest.Files[file].ContentType;
        var fileStrm = httpRequest.Files[file].InputStream;
        var fileSize = httpRequest.Files[file].ContentLength;
        byte[] fileRcrd = new byte[fileSize];
        var file_Name = Path.GetFileName(filePath);
        fileStrm.Read(fileRcrd, 0, fileSize);

Is it possible to send file data to SQL (in bytes) without streaming / reading at server?I don't want to put a load on server for large files. just read  the data and send them to SQL where SQL will do the streaming and store data as varbinary.

View 4 Replies View Related

Multi Connection To .sdf File Store On Network Share

Feb 22, 2007

Hi

In the "Choosing Between SQL Server 2005 Compact Edition and SQL Server 2005 Express Edition" white paper, i can read that: "SQL Server 2005 Compact Edition support data file storage on a network share" and "Number of concurrent connections = 256"

But when i try to connect with two different PC at the same time to a .sdf file store on a network share, i have an error message : "File is locked by an other processus"

The firsth PC is connected but the secondth can't

";Mode=Read Write" in the connection string don't change anything.

anybody have an idea ?

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved