C# - Sync Database To Uploaded File Using Windows Service Or Website Code?
Sep 10, 2010
I have a website that occasionally needs to have a handful of the tables in its database updated. The updates come from another system that exports to comma delimited text files. I can then either FTP the text files to the web server, send them in through an admin upload page, or manually log in to Remote Desktop to download the text files. I have all my C# code written to parse the files, check the database contents, and decide what to do.
Should I code the sync logic to be part of a file upload page, protected in the admin section of the site or should I create a Windows Service that constantly looks for files to process in a particular directory that I can drop files in through FTP?
I have used Windows Services in the past and they have worked great, but if I ever have to make a change to the code it can take longer than it would if I just had to modify an ASPX.
Are their security benefits one way or another?
Performance benefits?
ASPX page wins the "ease of maintenance" category.
View 1 Replies
Similar Messages:
May 11, 2010
how to prevent exe file from being uploaded in a website , even if exe file is inside zip file( exe file in a new folder and new folder is then zipped and uploaded)?
View 2 Replies
Feb 25, 2011
How to programmatically download a CSV using Windows Service into my website?
View 1 Replies
Jul 16, 2010
Can a windows service and a IIS site share the same dlls?
And maybe the configuration (web.config)?
View 3 Replies
Oct 16, 2010
im tryin to upload files to the database using the FileUpload. the upload take place. when i download the file again ( word document, excel document.. a text document (.txt), a winzip file) , it turns that the file is corrupted and cannot be opened.. an image file or an mp3 file doesnt present this problem. my application is developped usin vb.net 2010 and sql server 2005 as the database..
[Code]....
[Code]....
View 2 Replies
May 7, 2015
I have 1 fileupload control that I can upload file from it below is code :
int count = 0;
if (this.fuppdf.HasFile && !string.IsNullOrEmpty(this.txtarticle.Text))
{
string[] validext = { ".pdf" };
//string ext = System.IO.Path.GetExtension(fuppdf.PostedFile.FileName);
string ext = Path.GetExtension(fuppdf.PostedFile.FileName);
[code].....
and with below code I want save filename (uploaded filename) in database
SqlCommand _cmd = new SqlCommand("Fileuppdf", _cn);
_cmd.CommandType = CommandType.StoredProcedure;
string data = Session["behcode"].ToString();
_cn.Open();
_cmd.Parameters.AddWithValue("@pdf", filename);
_cmd.Parameters.AddWithValue("@Behcode", data);
_cmd.Parameters.AddWithValue("@id", Convert.ToInt32(ViewState["Id"]));
but it make error in this line
_cmd.Parameters.AddWithValue("@pdf", filename);
error===>("The name 'filename' doesn't exist in the current context")
I know that I define filename in
foreach (string s in files)but I don't know how I can save it name in database
View 1 Replies
Mar 13, 2011
We've got an enterprise ASP.NET/VB.NET application that has multiple clients running on different versions (websites) of the product code.
I am trying to make a windows service that runs on our server to execute long running tasks. This service needs to run the correct version of code for each client and I had originally thought about calling a WCF Service that would be deployed as part of the web version.
The problem is that our IIS pools recycle each night and this opens up the possibility of a job getting aborted. A job that went over 24hrs would never get an opportunity to finish.
Our server is running Windows Server 2003, IIS 6.0, .NET Framework 3.5, SQL Server 2005.
Is there a way to load assemblies dynamically to use without having to restart the service?
Edit: I ended up using System.AddIn detailed in this step by step example
View 2 Replies
Apr 26, 2010
how can we save the uploaded file path in to database and then retrieve it in gridview as a link so when user click on that it will open that file in browser.
View 8 Replies
Dec 15, 2010
I am working on the application that allows user to upload a file (from their local machine) and store the uploaded file in database.Then,the content of the file (such as ContentType,FileSize etc)can be view in a DetailsView control.
View 1 Replies
Nov 6, 2010
I have a visual studion 2010 solution with two projects
1 . A class libarary
[Code]....
2. A windows service application
[Code]....
The service application is used to convert .dbf files to xml. The convertion is done using the classlibary project wich is called by the windows service application. This class library project has some values hard coded. like the path to look for the .dbf file
const string sourcePath = @"F:forms";
const string pathToDbfStructure = @"F:formsstructure.dbf";
const string pathToBackupFile = @"F:ackup";
I want to make these hard coded values changable. like moving them to an app.config file. To which project I have to add the app.config file (classlibary or windows service)? How can I use the value from configuration file in classlibrary ?
View 3 Replies
Jan 8, 2010
i have made one web site which is generating screensaver(MSI) dynamically.So to generate the MSI file i have to build a WIX project.So i executed using batch file which will use MSBuild.exe and cmd prompt. so its gave me an error "Access is Denied". i have also tried by making a windiws service but still the same error occurs.
View 1 Replies
May 3, 2010
I have an ASMX Web Service that has its code entirely in a code-behind file, so that the entire contents of the .asmx file is:
<%@ WebService Language="C#" CodeBehind="~/App_Code/AddressValidation.cs" Class="AddressValidation" %>
On my test machine (Windows XP with IIS 5), I set up a virtual directory just for this ASP.NET 2.0 solution and everything works great. All my code is separated nicely and it just works.However, when we deployed this solution to our Windows Server 2003 development environment, we noticed that the code only compiled when all of the code was dropped directly into the .asmx file, meaning that the solution didn't work with code-behind. We can't figure out why this is happening.
One thing that's different about our setup in our development environment is that instead of creating a separate virual directory just for this solution, we dropped it into an existing directory that runs a classic ASP application. So here we have a folder with an ASP.NET 2.0 application within a directory that contains a classic ASP application. Granted, everything in the ASP.NET 2.0 application works if all of the code is within the .asmx file and not in code-behind, but we'd really like to know why it's not recognizing the code-behind files and compiling it correctly.
View 3 Replies
Jan 16, 2011
I've returned again to my problem of trying to connect to the SQL database on my website from a Windows forms application. I had some success but then I was playing around with some things and deleting stuff etc to see what would happen. I deleted the Database that I successfully connected to and added a new database for reasons I won't go into. Now when I try to connect to the new database I don't have success.
View 39 Replies
Nov 11, 2010
I am new to web programming. I am developing a web program using asp.net(vb) that scrapes data of a certain website. I am using System.Net.HttpWebRequest and System.Net.HttpWebResponse to read the HTTP codes.My problem is I can not retrieve the codes of certain frame/container where the data that I needed is located in the website.I understand that iframe has its own URL or link aside from the main URL of the website
View 1 Replies
Aug 9, 2010
I m accessing another application by consuming webservice of that application. I m sending file to store and retrieving file from other dabatase. Web service is the only to access another application.Now, I want to delete the file using the same web service where I stored that file in the another database.I m getting exception and I m unable to figure it out.
View 2 Replies
Aug 20, 2010
I Have this architecture:
WebSite ASP.NET <------> WCF Service <--------> DataBase DAtabase gathering very big files. User request a big file in aspx page, through WCF Service. Service call database, and get the big file.
Now, my entity (datacontract) has those fields:
string Data1
string Data2
string Data3
byte[] FileBigger
How to send big file throught WCF Service to Website ? which best practices for do it ?
View 2 Replies
Mar 24, 2011
I've created a page which dynamically creates an .ics file based on data from our database, that customers can download to add the events to Outlook and iCalendar. This file is sent through the Response, so I don't actually store the file on the server. Since I can provide a webcal:// address to this file, it can also be synced whenever someone changes the settings for an event in our system.
Example .ics: [URL]
However, since our customers sync with a dynamically generated file, this forces our server to generate the file every time their calendar application wants to sync. And since this will cause a couple of hundred thousand requests every hour, the server will take quite a bit of punishment.
So my actual question is: How does Outlook and other calendar applications know when an ics-file has been updated and needs to fetch the updated file? I need to manage this to only generate a new file when there has been an actual update, and not on every single request. The main problem is that we do not wish to store the actual files on the server.
View 2 Replies
Jan 19, 2011
Web service error response (code/message etc) would you store it in a database? or would you keep the error response in a method.By the time I'm done with this, there will be hundreds of error response, maybe in the future, thousands? (I dont know yet, depends how large this web service grows).EDIT: error response is the response returned back to the application via the web service, (not to be confused with error logging).
View 1 Replies
Dec 13, 2010
Iam using ftp client wrapper class for accessing ftp.
iam able to download files from ftp when used in windows application
when i try to use the same code with windows service i get an error
the error is
"The underlying connection was closed: An unexpected error occurred on a receive. "
this error i get on directory listing
the stack trace is:
[Code]....
Note:
FTP is getting connected throgh service
FTP is getting connected throug FileZilla, internet explorer
soruce code:
[Code]....
View 5 Replies
Mar 7, 2010
in my case, It is the windows service which in running the long running insert/update on a table and I need to cancel the operation from my ASP.NET application. In the above link Burnsys suggests that one should kill the Sql server session. Is that really only way and a goood practice to do this? Also, in the same poset can use SqlCommand.Cancel to cancel. However, I am not sure how can I cancel the command from the windows service from ASP.NET application.
View 1 Replies
Jul 28, 2010
When i create a Windows Service for getting information from a Web Application(ASP.NET c#) for scheduling some task in the client machine.
To consume WCF from the web application. I added WCF reference to Window Service project as a service reference, everything seems fine. It updated app.config file, added service reference etc.
it was not working.
[Code]....
View 1 Replies
Dec 30, 2010
I have been trying to avoid the windows login userid and password window when I use the Windows Authentication mode for a web site. I need to capture the the windows logon user name without prompting for the user id and password and display that on the web site. I had tried almost everything... changed authentication,security setups on IE and IIS etc... still not being able to avoid the window...
View 1 Replies
Mar 24, 2011
I'm trying to enable automatic Window authentication working on our ASP.NET Intranet. I've changed the Authentication on our IIS 7.5 server from Anonymous to Windows Authentication Enabled only, and changed the Web.config file for the website to:
<authentication mode="Windows" />
<authorization>
<deny users="?" />
</authorization>
The Windows login box appears when accessing the website via IE 8, I enter valid credentials, but the login window keeps reappearing as if it does not accept my credentials. By repeatedly cancelling the login box it disappears, and my login name can be viewed on the website. Is there any possible reason for the login box to keep popping up even though valid credentials are being entered? I've restarted the servers / cleared browser cache etc. Also, ideally I would like the user to enter the login details once in the login box and not be required to reenter login details whenever he reopens the browser.
View 3 Replies
Jul 17, 2012
How to get the full path of the file that is selected using the fileuploader.
View 1 Replies
Mar 31, 2010
I created a Website and i upload it using the asp.net development server.
So on the explorer the address is something like this http://localhost:port
The problem is that i can't access the Website(while its uploaded) using my internal IP from within the network.
So if i type http://10.0.0.180:port i get an error "Internet explorer cannot display the webpage".
I disabled my firewall(windows 7).
View 2 Replies
