I would need to make a SSIS package which must to watch all the day long if a file come and then save into a variable that path+file.
FileWatcher task do that for me or better totally focusing this requirement in a conventional .NET Script using IO classes and all that sort of stuff?
OK, what about this here: http://www.sqlis.com/default.aspx?23HTH, jens Suessmeyer.
http://www.sqlserver2005.de
|||anyone got any sample on how to use the File Watcher Task component?
I am trying to use the FileUpload control to save a filename to a SQL database. I'm using the OnUpdating event for my SQLDataSource to add the filename to the UpdateParameters. The OnUpdating event is firing but the FileName doesn't get added to the database. Any pointers as to why that might be would be very helpful.
Here's the code. Thanks much.
<%
@.PageLanguage="VB"MasterPageFile="~/MasterPage.master"Title="File Upload Testing" %><
scriptrunat="server">Sub Page_Load()Response.Write(
"UpdateParameters(0)=" & dsLabel.UpdateParameters(0).Name &"<br />")Response.Write(
"UpdateParameters(1)=" & dsLabel.UpdateParameters(1).Name &"<br />")EndSubSub dsLabel_OnUpdating(ByVal senderAsObject,ByVal eAs System.Web.UI.WebControls.SqlDataSourceCommandEventArgs)Dim FileUploadControlAs FileUpload = DetailsView1.FindControl("FileUpload1")Dim strFileNameAsString = FileUploadControl.FileNamedsLabel.UpdateParameters(0).DefaultValue = strFileName
dsLabel.UpdateParameters(1).DefaultValue = Request.QueryString(
"rgstnID")Response.Write(
"dsLabel.UpdateParameters(0).DefaultValue = " & dsLabel.UpdateParameters(0).DefaultValue &"<br />")Response.Write(
"dsLabel.UpdateParameters(1).DefaultValue = " & dsLabel.UpdateParameters(1).DefaultValue &"<br />")EndSub</
script><
asp:ContentID="Content1"ContentPlaceHolderID="ContentPlaceHolder1"Runat="Server"><
h1>File Upload</h1>This page should allow me to use the FileUpload Control to save a filename to an MS SQL Database.
<br/><br/> <asp:DetailsViewID="DetailsView1"runat="server"AutoGenerateRows="False"DataSourceID="dsLabel"Height="50px"Width="125px"><Fields><asp:TemplateFieldHeaderText="File"SortExpression="labelName"><EditItemTemplate><asp:FileUploadID="FileUpload1"runat="server"/></EditItemTemplate><ItemTemplate><asp:LabelID="Label1"runat="server"Text='<%# Bind("labelName") %>'></asp:Label></ItemTemplate></asp:TemplateField><asp:CommandFieldButtonType="Button"ShowEditButton="True"/></Fields></asp:DetailsView><br/><br/><asp:SqlDataSourceID="dsLabel"runat="server"ConnectionString="Data Source=FILESERVER1;Initial Catalog=IM;Integrated Security=True"OnUpdating="dsLabel_OnUpdating"ProviderName="System.Data.SqlClient"SelectCommand="SELECT labelName FROM tblProductRegistration WHERE (registrationID = @.registrationID)"UpdateCommand="UPDATE tblProductRegistration SET labelName = @.LabelName WHERE (registrationID = @.registrationID)"><UpdateParameters><asp:ParameterConvertEmptyStringToNull="True"Name="LabelName"/><asp:QueryStringParameterType="Int64"Name="registrationID"QueryStringField="rgstnID"/></UpdateParameters><SelectParameters><asp:QueryStringParameterName="registrationID"QueryStringField="rgstnID"/></SelectParameters></asp:SqlDataSource></
asp:Content>Everything in the code seems to be ok. The code is to update an existing row in database but not insert. So make sure you have a rowwith the rgstnID in your databasae when updating.|||Thanks very much for the quick reply,Iori_Jay. That's what's puzzling me, I only want to support UPDATE and the code looks good to me. Am I missing anything that would cause the Updating event to fire but prevent the UPDATE command from actually executing?
Thanks.
Charlie
Please refer to this article, which contains a sample about how to deal with BLOB data in SQL Server:
http://forums.asp.net/thread/1254026.aspx
i dont like it, but i figured it out and have written about in my blog
http://weblogs.asp.net/hpreishuber/archive/2006/02/17/438498.aspx
|||
string fileName = FileUpload1.PostedFile.FileName;
byte[] lc_ByteFile = new byte[FileUpload1.FileContent.Length];
lc_ByteFile = ReadFileToByteArray(fileName, FileUpload1.FileContent.Length);
if (FileUpload1.FileName.EndsWith(".jpg") || FileUpload1.FileName.EndsWith(".jpeg") || FileUpload1.FileName.EndsWith(".gif") || FileUpload1.FileName.EndsWith(".bmp"))
{
System.Drawing.Image newImage;
MemoryStream stream = new MemoryStream(lc_ByteFile);
newImage = System.Drawing.Image.FromStream(stream);
newImage.Save("D:\\NewImage.bmp");
}
Try this out it works
