C# - How To Fetch Data From A Webserver Every Few Minutes
Jan 21, 2011
I need to fetch CSV file from a webserver every few minutes.
Here's what I am planning to do:
I will create a webservice "GetCSV.asmx" which will get CSV file from that webserver.
I will create another webservice "RegularCall.asmx" which will call "GetCSV.asmx" every few minutes.
Is my approach correct? Is there a better way of doing this?
I am using ASP.NET web application and JSON webservice for this.
NOTE: There will be NO user intervention and the solution I am looking for is similar to scheduling a task on the server.
View 3 Replies
Similar Messages:
Feb 13, 2011
I want to redirect the user after 2 mins if there is inactivity for 2 mins. I am not using ASP.NEt membership. And I dont want to use Sessiontimeout for this. Session timeout will logout the user even if he is working on the system. My objective is like screensaver process.
If there is no action for the specified time, the screensaver runs. Similarly, I want to redirect the user to login page.
note that i have already handled it with the following javascript:
[Code]....
Here what my problem is,
the user is working on the site...ok.. he want to see someother site.he browse someother site and works on....or even he can do some other work in his system...but he is active in his system... What this script does is, it automatically logout the user and redirect him to login page. But it should not do while he is active...IT SHOULD REDIRECT IF HE IS NOT ACTIVE REALLY (Similar to Screensaver process)
Is it possible ?
View 1 Replies
Feb 4, 2010
I have a question what's the best way to accomplish the following task:
- I have an ASP.NET application with SQL server database (hosted externally at any provider)
- There are a few dedicated client computers anywhere in the world and these client computers shall run a periodic automatic process to upload some data into the database of the webserver. So there is NO user in front of those computers to open a browser and run any kind of upload manually. (These automatic processes are not part of my question, they can be windows services or simply running applications on the desktop.)
My initial idea was to use FTP for this purpose, means: Those perodic processes on the specific clients create files and put these files via FTP in any defined folder of the web server.
But what follows then? Is it possible to have any eternally running process on the web server to process those uploaded files in the FTP folder and write their content into the database? As far as I understood until now an ASP.NET application has sessions and an application process but a session shuts down as soon as the associated client doesn't send a request for some time and even the application process shuts down when no user at all sends a request for a specific time. Isn't it? So in other words: When no user sends any requests via HTTP my application on the webserver is simply not running and therefore cannot process the FTP-uploaded files. (Or can I keep the application "artificially" alive to run a peridic lookup for new files ???)
The other option I had in mind is to program a piece of software running as a windows service which could pick up the FTP-uploaded files and process them. But I have to consider that possibly the hosting company does not allow to install any service programs on their servers aside from the ASP.NET application. So this is probably not a real option.
And now my third idea is to develop an ASP.NET web service which runs on the same web server as the ASP.NET application. The specific clients mentioned above would connect to this web service via HTTP, upload the data and the web service would immediately process the data and write them into the database.
At the moment only the last option seems to be the "most natural" (and perhaps even the only possible ?) way to me. Are there any other options and methods for my purpose? And if so, what is the recommended way?
View 6 Replies
Jan 12, 2010
I have a textfield where they can enter a date, a hour drop down and a minute dropdown.
What I would like to do is after i get the values for each to create a DateObject which has all 3. i.e 12/02/2009 15:36
But then also how dismantle the Date Object to get back my 3 individual values
View 4 Replies
Nov 9, 2010
I have a Transport Detaisl in DB , i want to dispay data on gridview with marquee scrolling up. Cabs are scheduled for drop every hour. So if drop is at 7pm i hav to dispaly on data of that hour from 6:30 to 7:15 later after 7:15 i have to display next hour data ie 8:00 pm drop data. I am able to get scrollin g data on gridview but how to schedlue it to scroll for such timings
View 1 Replies
Mar 19, 2010
I have a computed column "Time" in an SQL2005 table that contains minutes, e.g 75 that is created from datediff.
In a GridView control, how can I display it in a HH:MM format ?
I know how to format it when using a datetime field, but this is an integer field.
I can change the "Time" column to another format if required.
View 1 Replies
Feb 15, 2010
I have contact mails large than 700.000 Mails and i want to insert them in sqlserver using c# in a few minutes not hours i know that pre impossible but , i know there`s way to do it
View 4 Replies
Jan 11, 2011
here are few ways listed to get data from sql:
execute reader
execute nonquery
execute reader
give input parameter --> fetch output parametrr from stored proc.
any other way?
View 3 Replies
May 12, 2010
I have a [URL]I want to fetch QOT_ID from URL .
View 5 Replies
Oct 18, 2010
Accessing 'Window Control Library' .dll from a .aspx page on webserver
View 2 Replies
Mar 25, 2010
I've to read Excel data from my Asp.net 3.0 VB code. My Excelsheet format is like
Company Name (Heading)
Company Address
Date:
Blank Space
Column Heading
Branch name
Data
Data
& after data
Total
Grand Total
I've to read data After branch name upto Total. Even I've to fetch data from certain columns only.
View 16 Replies
Jan 19, 2010
Can I fetch data which is in an output from an ASP script and then process it and do mathematical algorithms?
View 1 Replies
Sep 24, 2010
I want to fetch data from JDEdwards and put it in Microsoft Sql Server 2005, how it is possible ?
View 1 Replies
Jun 28, 2010
last year I inherited a webapplication that seems to refuse to run on a new hosting company's servers due to a "security violation"... Our old host was bought out and now sucks...So I uploaded the code to the new company - looking forward to some sleep and found that my life was about to get more complex.. I go the good old generic security error
System.Security.CodeAccessSecurityEngine.ThrowSecurityException(Assembly asm, PermissionSet granted, PermissionSet refused, RuntimeMethodHandle rmh, SecurityAction action, Object
The biggest issue was that it didn't say where the error was.. Digging deeper (taking the code appart one block a time) the error was being triggered by the followin itemdatabound event. My host says it is because they are running under medium trust, but I am not seeing why this block should cause issues. Any help very much appreciated.
Sub dlstAlsoDish_ItemDataBound(ByVal s
As
Object,
ByVal e
As DataListItemEventArgs)
Handles dlstAlsoDish.ItemDataBound
If e.Item.ItemType = ListItemType.Item
Or e.Item.ItemType = ListItemType.AlternatingItem
Then
Dim lngDateType
As
Long = e.Item.DataItem("dateType")Dim
strEvent As
String =
"> " & e.Item.DataItem("restName") &
" :: " & e.Item.DataItem("eventName") &
" : "
Dim lnkAlsoEvent
As HyperLink = e.Item.FindControl("lnkAlsoEvent")Dim dtmStart
As DateTime = e.Item.DataItem("eventSrt")Dim dtmEnd
As DateTime = e.Item.DataItem("eventEnd")If lngDateType = 1
Then
strEvent = strEvent & Format(dtmStart, "MMM")ElseIf lngDateType = 2
Then
strEvent = strEvent & Format(dtmStart, "dd MMM") &
" TO " & Format(DateAdd(DateInterval.Day, -1, dtmEnd),
"dd MMM")Else
strEvent = strEvent & Format(dtmStart,"dd MMM")End
If
lnkAlsoEvent.Text = strEvent
lnkAlsoEvent.NavigateUrl = e.Item.DataItem("restURL") &
"/events.aspx#e" & e.Item.DataItem("eventID")ElseIf e.Item.ItemType = ListItemType.Header
Then
imgBorder.ImageUrl = strImageURLDim imgBorder
As Image = e.Item.FindControl("imgBorder")End
If
End
Sub
View 3 Replies
Dec 27, 2012
i have a details table which include detailid, custname, address, classification , pincode, telephone, remarks and classification table contain classification id & classification.i want to insert detailid & corresponding classificationid to a new table detail_classification. How to write stored procedure for that?
View 1 Replies
Aug 29, 2010
How to fetch data from textbox inside a gridview
View 2 Replies
Mar 8, 2010
I am trying to delete a row of the child gridview through a link button template field but how do I fetch the datakeys of the child gridview ?
In the code window there is no intellisense for child gridview as it is generated on runtime with respect to parent.
View 13 Replies
Sep 19, 2010
Am using two web application and one web service. My doubt is, am sending the dataset from my first application to Web service. After sending the dataset to my web service, i like to fetch the dataset using second application from the web service. How shall i fetch the dataset by using second application.
Note:
1) sending the dataset from first application to web service.
2) web service receives the dataset from the first application.
3) second application want to fetch the dataset from the web service which was sent by first application.
View 1 Replies
Jun 9, 2010
Is it possible to have a webapp/webservice to fetch data from my pc?? Can anyone give me an idea if it is possible....
View 1 Replies
Mar 13, 2010
I have a dataset that has two datatables.
In the first datatable I have EmpNo,EmpName and EmpAddress
In the second datatable I have Empno,EmpJoindate, EmpSalary.
I want a result where I should show EmpName as the label and his/her details in the gridview
I populate a datalist with the first table, and have EmpNo as the datakeys.
Then I populate the gridview inside the datatable which has EmpNo,EmpJoinDate and EmpAddress.
My code is some what as below
[Code]....
Now I have a problem, I have to bind the Details of the corresponding Employee to the gridview. Whereas the above code will display all the details of all employees in the gridview.
If we use IEnumerable we give a condition where(a=>a.eno=EmpNo), and bind that list to the gridview.
How do I do this in datatable.
I modified the program as below
Igor, instead of datarelation,(my TL did not approve of it) I used IEnumerable
[Code].....
View 1 Replies
Oct 26, 2010
i'm trying to fetch data from xml in the sql query.
DECLARE @xmlDelete xml
SET
@xmlDelete =
'<DocumentElement>
<row FSFF_FeesItemID="185" FSI_ID="104" />
<row FSFF_FeesItemID="187" FSI_ID="104" />
<row FSFF_FeesItemID="187" FSI_ID="105" />
</DocumentElement>'
;
WITH
r_set AS
(
SELECT
T1
.c1.value('(./FSFF_FeesItemID/text())[1]',
'int')
AS [id1]
,
T1
.c1.value('(./FSI_ID/text())[1]',
'int')
AS.......................................
View 2 Replies
Apr 3, 2010
Im doing selling properties website with vb.net and just begin to use datalist
I have 2 pages, first is datalist that show all available properties with brief information, 2nd is another datalist that show full description about a particular property that the user wan to view.
I got few questions here:
1) I set the selecommand on the property name, but instead of viewing it on the same page, i wan to redirect to the details page to show all the informtion. How do i do that in the code behind? I include an onclick event to use Response.Redirect in the property name which is a linkbutton, but result in "XML page cannot be displayed" when click on it.
2) My primary key is set to imageID which to indicate the particular property details to show when user wan to view the full information. But how do i assign the image ID to the session?
View 12 Replies
Apr 14, 2010
i have a database and database have 3 tables... i want the table data show in asp:table not in grid view....
like in frid view we a doing simple wizard mode to fetch data from database... But in my query i want show data in <asp:Table> ..
asp:TableCell>
<fetech
data from sql
server table>
[Code]....
View 2 Replies
Sep 27, 2010
fetch data from Nested gridview checkbox on Click button event which is present outside the gridview. I did try by creating an object of child gridview on button1_click but cannot fill the value from Gridview2 into my int i. Below mentioned is the Code i am using. The database I am using is Oracle. ==== Code =====
protected void Button1_Click(object sender, EventArgs e)
{
OracleConnection con = new OracleConnection();
[code]...
View 6 Replies
Apr 27, 2016
how can i fetch the data from different tables stored in database on the value selected of dropdownlist..for ex.
DropDownlist1.selectedValue=="HEG01"
then the data from that table will be fatched from the databse and entries are displayed in gridview.
DropDownlist1.selectedValue=="RES01"
then the data from that table will be fatched from the databse and entries are displayed in gridview.
View 1 Replies
