/****** Object: Table [transact].[TestImageStore] Script Date: 04/30/2007 11:50:40 ******/
In Application :
Downloading and Binding the image to grid
1. Add a DataGrid to the aspx page.
2. Create TemplateColumn to place a Html image Control in it.
3. Set the attributes "ID" and "runat" and remove the attribute "src" from the Html image Control in the grid .
4. Get the result set values from database by executing the query statement.
5. Bind the result set to DataGrid.
6. In the Item Data Bound Event of the grid , get the binary value of image for each unique Id from result set .
i. Write the binary value into memory stream and store it in the temporary internet folder of the system.
ii. Set the url to attribute "src" of the Html image Control in the grid.
<asp:DataGrid ID="dgBindImage" runat="server" AutoGenerateColumns="false" >
<asp:Label ID="lblCode" Text='<%# Server.HtmlEncode(DataBinder.Eval(Container, "DataItem.imgID").ToString())%>' runat="server" />
<img id="imgPic" width="120" height="100" runat="server" />
Uploading to Image to DB
1. Using the asp:fileUpload Control browse the image file.
2. Attach file (of any type .gif,.Jpg,.Doc) event read the uploaded file to binary data .
3. Store the binary value in a session object to make it persist across page's postbacks.
4. Get the extention of the image file and register it to hidden page control to make it persist across page's postbacks.
5. Set the values to parameters of the command object and insert into Database.
1. Click browse button to select a image file.
2. Click Attach link to attach the file .(You can find the attached file path at the below)
3. Click Save button to store it to the Database.
4. Click the view button to download and see the image in the grid.
(Note: the download file can be seen in the folder C:\Documents and Settings\<<UserName>>\Local Settings\Temporary Internet Files
class UIUtilities provides methods
1.To insert and retrieve the data into/from database.
2. Read the Image into binary data
3. To get the temporary internet folder name.
I hope these sample will help you in handling the Image files in your web pages. The same can be used in case of .rtf,.doc & etc.