I'm messing with the fileupload control.  I'm normally a big advocate for the "store it in the filesystem and keep a link in the database", but I was working on a "quick and dirty" and was going to just store it in the DB.

So, the upload works fine and binary data is in the database, but how can I capture the filename to store as well to display to the user later without them having to type it into a text box (they entered the upload filename, I'm sure there is some place I can override and use that to insert as the filename?).

Also, since I'm a SQL Server guy, is there support for 2008s filestream objects?

Thanks

1. Open smartDBtemplates\TemplatesStorage.ascx file.
2. Add the following code to the end of the two functions - btnUploadDBImage_Click and btnUploadDBFile_Click:
   

   // The new file was uploaded. Send its filename to the hosting page.
   this.SendCustomEventToContainer(btnUpload, new ValidateCustomEvent(fileUpload.FileName));
   

   
   
   In  this way when a new file is uploaded in the FileFromDB and ImageFromDB templates a CustomEvent containing the filename will be fired to the hosting page.
   
3. Open your smartDBforms.NET WebForm  where you want to propagate the newly uploaded file name to the text field.
4. Create event handler for the CustomEvent event of the SmartDBControl which represents the FILE column.
5. In the event handler add code to get the file name and set it to the value of the textbox, that is located in the text field SmartDBControl.
   For example:

   protected void ctrlThumbNailPhoto_CustomEvent(BaseSmartDBControl sender, BaseSmartDBControlCustomEventArgs args)
   {
       // Get the file name that was send by the upload template.
       ValidateCustomEvent ev = args.Event as ValidateCustomEvent;
       if (ev == null) return;
       string fileName = ev.Value as string;
   
       // Find the textbox for editing the ThumbnailPhotoFileName db column and set its text to the just uploaded filename.
       TextBox TextBoxValueString = ctrlThumbnailPhotoFileName.FindControl("TextBoxValueString") as TextBox;
       if (TextBoxValueString != null)  TextBoxValueString.Text = fileName;
   }