FileStream Creation and inserting and reading

Question

5.00/5 (1 vote)

See more:

Hi
I need to create a simple database to store files that are generated through stream readers in an application. so basically once the file has been created it has to be inserted into a table . this table already exists and therefore can only be altered to allow file streaming (which has already been done) . All I need to create a file group and add a table that will store : AutoID - FileName - file(which will be the actual file) - dateTime.

then a i need to read the file again in a C# app and compile it in a string and be able to view the file exactly as it was.

1.Alter database for filegroup (we can call the databse TESTDB) SQL
2. Create table for storing files SQl
3. create procedure to insert files SQL
4. code to read file content and store it as string C#

any examples will help. thank you.

Posted 21-Nov-12 18:56pm

Member 9374423

Updated 21-Nov-12 21:05pm

v2

Add a Solution

Comments

OriginalGriff 22-Nov-12 3:07am

And what is the problem?
What have you done? Where are you stuck?

Member 9374423 22-Nov-12 3:09am

I am stuck on starting it up.
I have no idea how this works as this is the first time using it.
I have read through numerous websites, but I still don't understand.

OriginalGriff 22-Nov-12 3:16am

So, what have you done on the first bullet point?
Have you prepped your DB?

Member 9374423 22-Nov-12 4:22am

yes, I wont need file streaming,just have to get the file into the database and out again.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

codeninja-C# · Accepted Answer · 2012-11-21T22:58:00

Hi,
try this solution,

SQL

-- First Create the database
Create Database Test_DB;
-- After execution of First command execute the following query
use Test_DB;
CREATE TABLE [dbo].[file_db](
    [file_name] [varchar](50) NOT NULL,
    [file_Content] [varbinary](max) NULL,
    )

C#

// It will help you to insert the file into the db
void insertFile()
        {
            FileStream fs = new FileStream(@"c:\file\input.txt", FileMode.Open, FileAccess.Read);
            int length = Convert.ToInt32(fs.Length);
            byte[] data = new byte[length];
            fs.Read(data, 0, length);
            fs.Close();
            string insert = "insert into file_db values('input.txt',@file_content)";
            DataSet ds = new DataSet();
            SqlConnection conn = new SqlConnection(con);
            conn.Open();
            SqlCommand cmd = new SqlCommand(insert, conn);
            cmd.Parameters.Add(new SqlParameter("@file_content", (object)data));
            cmd.ExecuteNonQuery();
            conn.Close();
        }
// It will help you to read the inserted file content from db
 void ReadFile()
        {
            SqlConnection conn = new SqlConnection(con);
            string qry = "select file_content from file_db where file_name='input.txt'";
            SqlCommand cmd = new SqlCommand(qry, conn);
            conn.Open();
            SqlDataReader dr = cmd.ExecuteReader();
            dr.Read();
            byte[] output = (byte[])dr[0];
            dr.Close();
            conn.Close();
            FileStream fs = new FileStream(@"C:\file\output.txt", FileMode.Create, FileAccess.Write);
            fs.Write(output, 0, output.Length);
            fs.Close();
        }

Regards,
Sowraaj