Introduction:
Here I will explain how to save or insert or upload word document files into SQL Server database and download files from database in asp.net using C#, VB.NET.
Here I will explain how to save or insert or upload word document files into SQL Server database and download files from database in asp.net using C#, VB.NET.
Description:
In previous articles I explained Save/Upload files in folder and Download files from folder, Save Images in folder and images path in database and show images from folder and many articles relating to asp.net, C#, VB.NET etc…. Now I will explain how to upload word document files into SQL Server database and download files from database in asp.net using C#, VB.NET.
In previous articles I explained Save/Upload files in folder and Download files from folder, Save Images in folder and images path in database and show images from folder and many articles relating to asp.net, C#, VB.NET etc…. Now I will explain how to upload word document files into SQL Server database and download files from database in asp.net using C#, VB.NET.
To implement this first
design table in your database like below to save file details in database.
Column Name
|
Data Type
|
Allow Nulls
|
Id
|
int(set
identity property=true)
|
No
|
FileName
|
varchar(50)
|
Yes
|
FileType
|
varchar(50)
|
Yes
|
FileData
|
varbinary(MAX)
|
Yes
|
Once table creation
completed open visual studio and create new website. After
that write the following code in your aspx page like this
<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1">
<title>Upload Word Files to Database and Download files from
database in asp.net
</title>
</head>
<body>
<form id="form1"
runat="server">
<div>
<asp:FileUpload ID="fileUpload1"
runat="server"
/><br
/>
<asp:Button ID="btnUpload"
runat="server"
Text="Upload"
onclick="btnUpload_Click"
/>
</div>
<div>
<asp:GridView ID="gvDetails"
runat="server"
AutoGenerateColumns="false"
DataKeyNames="Id">
<HeaderStyle BackColor="#df5015" Font-Bold="true" ForeColor="White" />
<Columns>
<asp:BoundField DataField="Id" HeaderText="Id" />
<asp:BoundField DataField="FileName" HeaderText="FileName" />
<asp:TemplateField HeaderText="FilePath">
<ItemTemplate>
<asp:LinkButton ID="lnkDownload"
runat="server"
Text="Download"
OnClick="lnkDownload_Click"></asp:LinkButton>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
</div>
</form>
</body>
</html>
|
After
completion of aspx page design add the following namespaces in code behind
C# Code
using System;
using System.Data.SqlClient;
using System.IO;
using System.Web.UI.WebControls;
|
After
that write the following code in code behind
string strCon = "Data
Source=SureshDasari;Integrated Security=true;Initial Catalog=MySampleDB";
protected void
Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BindGridviewData();
}
}
// Bind Gridview Data
private void
BindGridviewData()
{
using (SqlConnection
con=new SqlConnection(strCon))
{
using (SqlCommand
cmd=new SqlCommand())
{
cmd.CommandText = "select
* from FileInformation";
cmd.Connection = con;
con.Open();
gvDetails.DataSource = cmd.ExecuteReader();
gvDetails.DataBind();
con.Close();
}
}
}
// Save files to Folder and files
path in database
protected void
btnUpload_Click(object sender, EventArgs e)
{
string filename = Path.GetFileName(fileUpload1.PostedFile.FileName);
Stream str = fileUpload1.PostedFile.InputStream;
BinaryReader br = new BinaryReader(str);
Byte[] size = br.ReadBytes((int) str.Length);
using (SqlConnection
con=new SqlConnection(strCon))
{
using (SqlCommand
cmd=new SqlCommand())
{
cmd.CommandText = "insert
into FileInformation(FileName,FileType,FileData)
values(@Name,@Type,@Data)";
cmd.Parameters.AddWithValue("@Name", filename);
cmd.Parameters.AddWithValue("@Type", "application/word");
cmd.Parameters.AddWithValue("@Data", size);
cmd.Connection =con;
con.Open();
cmd.ExecuteNonQuery();
con.Close();
BindGridviewData();
}
}
}
// This button click event is
used to download files from gridview
protected void
lnkDownload_Click(object sender, EventArgs e)
{
LinkButton lnkbtn = sender as
LinkButton;
GridViewRow gvrow = lnkbtn.NamingContainer as GridViewRow;
int fileid = Convert.ToInt32(gvDetails.DataKeys[gvrow.RowIndex].Value.ToString());
string name, type;
using (SqlConnection
con=new SqlConnection(strCon))
{
using (SqlCommand
cmd=new SqlCommand())
{
cmd.CommandText = "select
FileName, FileType, FileData from FileInformation where Id=@Id";
cmd.Parameters.AddWithValue("@id", fileid);
cmd.Connection = con;
con.Open();
SqlDataReader dr = cmd.ExecuteReader();
if(dr.Read())
{
Response.ContentType = dr["FileType"].ToString();
Response.AddHeader("Content-Disposition",
"attachment;filename=\""
+dr["FileName"] + "\"");
Response.BinaryWrite((byte[])dr["FileData"]);
Response.End();
}
}
}
}
|
VB.NET Code
Imports System.Data.SqlClient
Imports System.IO
Imports System.Web.UI.WebControls
Partial Class VBCode
Inherits System.Web.UI.Page
Private strCon As String = "Data
Source=SureshDasari;Integrated Security=true;Initial Catalog=MySampleDB"
Protected Sub
Page_Load(ByVal sender As Object, ByVal e As
EventArgs) Handles Me.Load
If Not IsPostBack Then
BindGridviewData()
End If
End Sub
' Bind Gridview Data
Private Sub
BindGridviewData()
Using con As New SqlConnection(strCon)
Using cmd As New SqlCommand()
cmd.CommandText = "select
* from FileInformation"
cmd.Connection = con
con.Open()
gvDetails.DataSource = cmd.ExecuteReader()
gvDetails.DataBind()
con.Close()
End Using
End Using
End Sub
' Save files to Folder and files
path in database
Protected Sub
btnUpload_Click(ByVal sender As Object, ByVal e As
EventArgs)
Dim filename As String =
Path.GetFileName(fileUpload1.PostedFile.FileName)
Dim str As Stream =
fileUpload1.PostedFile.InputStream
Dim br As New BinaryReader(str)
Dim size As [Byte]() =
br.ReadBytes(CInt(str.Length))
Using con As New SqlConnection(strCon)
Using cmd As New SqlCommand()
cmd.CommandText = "insert
into FileInformation(FileName,FileType,FileData)
values(@Name,@Type,@Data)"
cmd.Parameters.AddWithValue("@Name", filename)
cmd.Parameters.AddWithValue("@Type", "application/word")
cmd.Parameters.AddWithValue("@Data", size)
cmd.Connection = con
con.Open()
cmd.ExecuteNonQuery()
con.Close()
BindGridviewData()
End Using
End Using
End Sub
' This button click event is used
to download files from gridview
Protected Sub
lnkDownload_Click(ByVal sender As Object, ByVal e As
EventArgs)
Dim lnkbtn As LinkButton = TryCast(sender, LinkButton)
Dim gvrow As GridViewRow = TryCast(lnkbtn.NamingContainer, GridViewRow)
Dim fileid As Integer =
Convert.ToInt32(gvDetails.DataKeys(gvrow.RowIndex).Value.ToString())
Dim name As String, type As String
Using con As New SqlConnection(strCon)
Using cmd As New SqlCommand()
cmd.CommandText = "select
FileName, FileType, FileData from FileInformation where Id=@Id"
cmd.Parameters.AddWithValue("@id", fileid)
cmd.Connection = con
con.Open()
Dim dr As SqlDataReader =
cmd.ExecuteReader()
If dr.Read() Then
Response.ContentType = dr("FileType").ToString()
Response.AddHeader("Content-Disposition",
"attachment;filename="""
& Convert.ToString(dr("FileName"))
& """")
Response.BinaryWrite(DirectCast(dr("FileData"), Byte()))
Response.[End]()
End If
End Using
End Using
End Sub
End Class
|
|
Demo
 |
Download
sample code attached
|
If you enjoyed this post, please support the blog below. It's FREE! Get the latest Asp.net, C#.net, VB.NET, jQuery, Plugins & Code Snippets for FREE by subscribing to our Facebook, Twitter, RSS feed, or by email. |
|||
Subscribe by RSS
Subscribe by Email
|
|||
73 comments :
capture error "NullReferenceException" in line GridViewRow gvrow = lnkbtn.NamingContainer as GridViewRow;
nice
great man...u r genious
very useful and informative site
keep it up...laxmi
great...
Unable to cast object of type 'System.String' to type 'System.Byte[]'.
I am getting this exception. Please give any suggestions.
Sharath Kurup
hari19113@rediffmail.com
int fileid = Convert.ToInt32(Convert.ToBoolean(gvDetails.DataKeys[gvrow.RowIndex].Value.ToString()));
String was not recognized as a valid Boolean.
Help me with this error.
after uploading when user download it file is corrupted. please help me
Good post . Learning many realtime examples .
Nothing happening when clicking on Upload Button...
Simply awesome!! Thank tonnes
Unable to cast object of type 'System.String' to type 'System.Byte[]'..
getting this error...is any 1 there plz help me its imp....
You r Really Awesommmm..
hi
hi sir
Thank you once again ...
You and your articles ROCKS!!!!
Your tutorials and posts are really helpful for my Project...
Thank You very much Sir.. :) :) :)
Really more benefit thanks
Thank you!
Very useful!
Superb:)
I am getting this error
SqlException (0x80131904): Operand type clash: image is incompatible with char
The code is really nice and helpful .
But i am getting the error
"Input string was not in a correct format" in the following line....
int fileid = Convert.ToInt32(Convert.ToBoolean(gvDetails.DataKeys[gvrow.RowIndex].Value.ToString()));
Plz help me
I had problems with this line of code anyone with a solution please help
LinkButton lnkbtn = sender asLinkButton;
it did not know the "asLinkButton"
email me at lindy.jiyane@gmail.com
its not working in vs2008
pls its not working in vs2008 give solution for it
@deva prasad....
For your kind information i did this sample in vs2008 only. Please check your code i hope there is mistake in your code.
Thank you very much, it helps lot
Hi Suresh Dasari,
I'm currently doing what you have posted here. However, i'm using Microsoft Access as my database and Oledb as connection. May i know how to do it?
thank you so much
its very helpful to me.
my project point of view its really good n use full article.
i need your help
how to modify this entry with update code
can you post that code how to update same data..
Good Code
how to style the browse button of this file upload control ??? changes the text or color of browse button ???
Its Great Suresh but when I'm Downloading this Files It wont showing original data how i'll convert it
Let me Know
tahnk you
int fileid = Convert.ToInt32(gvDetails.DataKeys[gvrow.RowIndex].Value.ToString());
I got the error message such as (Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index)
Anybody pls solve my problem.
plz i want to show the Download file In Html Fromat on browser what i have to Do Plz tell me
9990185725
hello sir,
when i click on upload btn. its getting uploaded and when i click on download link its showing that."DOWNLOAD IS COMPLETED.OPEN OR SAVE?" WHEN I CLICK ON OPEN its showing a default.aspx page.
y like this?
I never post on blogs, but I just had to for this one. You saved me a ton of headache. Thanks sooooooo much!!
'Upload' is already declared as 'Protected WithEvents Upload As System.Web.UI.WebControls.Button' in this class.
what should i do with this error? thanks for answer
i need a counting code
i need a words lines and space count coding for c# pls give me today.
Thanks for help me...
It is superb. Please keep uploading new codes.
Thank you !
all your posts are very useful ...thanks
grate sir ur example are very usefull for beginners developer thanx u 1nc again
well
Thank you! It Worked !!
your work is amesing and really congratz bro...
pls help me during the runing time ,Nothing happening when clicking on Upload Button... pls tel me how to solve this problem
your work is amesing and really congratz bro...
pls help me during the runing time ,Nothing happening when clicking on Upload Button... pls tel me how to solve this problem... i am using this code in my project so reivew date tommorrow after so pls reply to ksanbutnj@gmail.com
your work is amesing and really congratz bro...
pls help me during the runing time ,Nothing happening when clicking on Upload Button... pls tel me how to solve this problem... i am using this code in my project so reivew date tommorrow after so pls reply to ksanbutnj@gmail.com
Uncast of object type system.string to type system.byte[].
Help me with dis error
How to implement this article when you want to insert other TextBox field data in the database, using a single table?
For example in your table, you add another Column with Nvarchar data type?
Hi,
I want to open this Word File created in Read Only mode, can you please suggest solution for this?
Thanx a tonn.....Always works
thanks a lot...it superb
On Con.Open() I am getting "SqlException was unhandled by user code"
Its good ,thks
Sir, Good Blog But I need Upload File Without Refreshing Page and When download Also Need without Refreshing.. Pls Write this blog completely
Its a very nice article. I have done with my stuff using this without getting any error. Thanks alot!!
hi i using your code but this error occured.
'lnkDownload_Click' is not a member of 'ASP.file_upload_aspx'
Superb ya thank u so much Bt @last the file content ll b appearing on d web page...instead i wanna download tat file to some folder...hoow it can b done??
Thanks the code works fine.But what size in MB's does it saves to database.
This worked beautifully but how can I delete the file from the folder without having to into the folder to remove the file then the table to remove the data?
to delete files from folder check this article
http://www.aspdotnet-suresh.com/2012/12/aspnet-delete-file-from-folder-using-c.html
Nice ..blog thanks for share it.
is it possible to create dbf file using C#.net
How do I incorporate your link to work in the gridview?
http://www.aspdotnet-suresh.com/2012/12/aspnet-delete-file-from-folder-using-c.html
sir, how to receive xml from URL without file upload button?plese help me and ples sent me a the file as possible..
thank you so much sir! it helped me a lot
Sir Ur Example was excellent .
but can do this using jquery ajax call .and bind the document into a html table to doownload .please if possible give me some source code am googling from lost oneday ..
database same functionality same but should be implement using ajax jquery with html table..
Sir Ur Example was excellent,
but I need additonal option to download all the files listed in the gridview on a asp:Button click,as a Zip File,
I need all files inside the zip with converted to original format from binary as stored in the database,
Note: Only a member of this blog may post a comment.