Comments by Mohandas_Kulasekaran

Mohandas_Kulasekaran 23-Jun-11 3:56am View

Your suggestion to use parameterized query worked. Thanks Patel,

Mohandas_Kulasekaran 23-Jun-11 2:33am View

Hi,

Thank for your response. I have already tried Replace() as said by you. The query throws no exception, but it neither returns rows because the parameter values changes to "Icom 20'' Extension Cable f/COMMANDMIC" whereas the value in CSV is "Icom 20' Extension Cable f/COMMANDMIC".

I was not sure about using parameterized query for ODBC hence i didn't thought of that way. Thanks for throwing light on that. I will try that as well.

Thanks again.

Mohandas_Kulasekaran 23-May-11 3:30am View

In real time excel sheet, there are over 60000 rows with 40 columns. I want only the column names without having to waste my system resource taking the excel data to a dataset or datatable.

Mohandas_Kulasekaran 21-Apr-11 8:34am View

Aahhhhhh....... I just noticed that being redirected to another url...

Apart from the URL issue, do you find anywhere I am doing wrong in the coding???

Mohandas_Kulasekaran 21-Apr-11 7:34am View

Deleted

Following is the code I tried which I worked out based on your inputs. But it doesn't download the dynamically generated file, instead, the source file which the URL refers. Following is the code

Uri myuri = new Uri("http://dropshipdirect.com/warehouse/vendor_export_speedup.php?use_link=on&ve_sid=fal9vgtv5hg3yo4ofhiqhiuogmy3dbji");
string localFolder = @"f:\Temp\DownloadedData.txt";
HttpWebRequest request = (HttpWebRequest)HttpWebRequest.Create(myuri);
HttpWebResponse response = (HttpWebResponse)request.GetResponse();
StreamReader sr = new StreamReader(response.GetResponseStream());
StreamWriter sw = new StreamWriter(localFolder);
string feedContent = sr.ReadToEnd();
sw.WriteLine(feedContent);
sr.Close();
sw.Close();

Mohandas_Kulasekaran 21-Apr-11 7:09am View

Deleted

response.Headers[1] returns the ContentType text/HTML and not the file as we expected !!!

Mohandas_Kulasekaran 21-Apr-11 6:26am View

I am using WebClient object where URLs has file names. I have no problem downloading them. But there are few links which don't have file name in it, hence I don't the know the file name unless the save as dialogbox appears.

Mohandas_Kulasekaran 21-Apr-11 6:22am View

This is an automated process and will run background without the user's interference. Hence the save as dialog box should not be displayed. Can HTTP response be use in WinForm ????

Mohandas_Kulasekaran 21-Apr-11 6:16am View

Deleted

Following is a test link:-
http://dropshipdirect.com/warehouse/vendor_export_speedup.php?use_link=on&ve_sid=fal9vgtv5hg3yo4ofhiqhiuogmy3dbji

Mohandas_Kulasekaran 19-Apr-11 2:30am View

Thanks for the info Karthik. I am looking for that automation process which will trigger another process to download files through given FTP server and a given point of time. There could be several FTP servers which has to accessed only at a given time relevant to that FTP server. In Task Scheduler, the minimum interval between the repeating a task is 5 mins, whereas there could be some FTP servers which would be required to access within that 5 mins of interval. So the "Task Scheduler", will always run the process atleast few mins delayed than the expected time of execution of my required task.

Thinking out of the box, rather than depending on Task Scheduler, can we develop an windows application, that can run at the background, hiding itself in the task bar just like another application which run hiding and showing only it icon at the right side of task bar beside time / date (like instant messengers, antivirus, etc.,) ? If yes can you please advise me how can it be done ??

Mohandas_Kulasekaran 19-Apr-11 1:15am View

@ Karthik -
Thanks for your reply.
As advised by you I can foresee the issues of using a Windows Service.
Can a console application add tasks to the Schedule Task dynamically without human interference? For example, every time when I add a new record in my table with FTP details and time to pull data, can we add this task corresponding to this record on the schedule task without having to execute the console application every time while adding new record?

Comments by Mohandas_Kulasekaran (Top 11 by date)