getting error to save a file in a SQL databese

Question

3.00/5 (2 votes)

See more:

I have created a table in SQl.
The table is like this..

SQL

Create table filee
(
id varchar(5),
filee nvarchar(max)
)

After that I want to save a (.doc) file in filee column.
I have written a code but this code give error.
The code is like this.....

C#

    FileStream fs = new FileStream(flname, FileMode.Open, FileAccess.Read);
            byte[] data = new byte[fs.Length];
            fs.Read(data, 0, System.Convert.ToInt32(fs.Length));


            SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=Mith;Integrated Security=True");
            SqlDataAdapter da = new SqlDataAdapter("Select * from filee",con);
            con.Open();
            DataSet ds = new DataSet();
            da.Fill(ds, "filee");
            DataRow dr = ds.Tables["filee"].NewRow();

            dr[0] = textBox1.Text;

            dr[1] = data;

            try
            {
                ds.Tables["filee"].Rows.Add(dr);
                da.Update(ds, "filee");
                MessageBox.Show("Data Inserted");
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
          finaly
{
con.close()
}

Posted 21-Jul-11 16:39pm

Mithlesh Shaw

Updated 21-Jul-11 16:42pm

walterhevedeich

v2

Add a Solution

Comments

Sandeep Mewara 21-Jul-11 23:10pm

What error?

2 solutions

Add a Solution

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

Tajuddin_HYD · Answer 1 · 2011-07-21T17:44:00

HI,
In the above code nowhere ur creating any file, and from nowhere ur reading any file.

Here is the solution :

C#

protected void btnCreate_Click(object sender, EventArgs e)
    {
        FileStream createFile = new FileStream(@"C:\Docs\file2.docx", FileMode.OpenOrCreate, FileAccess.ReadWrite);
        createFile.Close();
        StreamWriter sw = new StreamWriter(@"C:\Docs\file2.docx");
        sw.Write("Tajuddin............");
        sw.Close();
        StreamReader sr=new StreamReader (@"c:\docs\file2.docx");
       string fileData=sr.ReadToEnd ();
       sr.Close();
       //after this u can write insert query to store in file column
       string sqlquery = string.Format("insert into filee values('{0}','{1}')", "123", fileData);
       SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=Mith;Integrated Security=True");
       con.Open();
       SqlCommand cmd = new SqlCommand(sqlquery, con);
       cmd.ExecuteNonQuery();
       

    }

AshishChaudha · Answer 2 · 2012-05-11T02:34:00

Solution 2

make your datatype text in place of nvarchar(max)

Posted 11-May-12 2:34am

AshishChaudha

getting error to save a file in a SQL databese

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

getting error to save a file in a SQL databese

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us