Use A DB Queue To Make Http Calls And Update Status In Db?
Feb 28, 2012
I want to use a database table as a a queue...but the processing of these messages cannot be done from the database.I have a table that stores the requests i get from a .Net component. I now have to read the data from these tables and make http calls to 2 webservices. Based on the response received from the webservices, the data gets archived or deleted.I had a few specific questions:
1. How do i make sure that if i pick a record for processing and the http call fails I should be able to go on to the next record, and then come back to this record at the end of the run
2. Is there an alternative to using the database as a queue(like MSMQ etc.), which option is better
3. I want to maintain an audit trail of the record status. Is creating a trigger to log the changes before the edit the best way to do it?
View 1 Replies
ADVERTISEMENT
Feb 12, 2010
I have done the PING part, you click a button the it ping's the server IP Address, then return's the result via a label. I want to make one so it check's the HTTP status of the server and if it's on it display's a green circle with a label next to it saying HTTP Status is OK.
[Code]...
View 7 Replies
Jul 3, 2009
I have a gridview in which when I click edit, update, and cancel button comes. I have a variable named status. If status=false then update should change to insert and if status=true then update should be update itself.
<asp:TemplateField >
<ItemTemplate>
<asp:LinkButton ID="lnkEdit" runat="server" CommandName="Edit" Text="Edit">
</asp:LinkButton>
[code].....
View 2 Replies
Mar 10, 2010
I am working on fax component that manage some operation of XP fax service by using VB.Net and using FXSCOMEXLIB.DLL, I want to register events by fax queue status (job added, changed, removed, ... etc.), I am reading the article on this link: [URL] but the events not work (not called).
View 6 Replies
Jun 9, 2012
Im attempting to make a Facebook app, but i cant seem to find the name to the status update box and the post button, if someone could help me that would be great. this is what i have so far.
i do have the name to the [CODE]WebBrowser1.Document.GetElementById("xhpc_message_text").SetAttribute("value", KryptonRichTextBox1.Text)[CODE] but it some reason wont work. im coding in visual studio.
Code:
Public Class Form11
Private Sub KryptonButton1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles KryptonButton1.Click
[code]....
View 1 Replies
Apr 27, 2011
I have a asp.net mvc route that is taking a url and doing a simple get and return the status code from the request.
<AcceptVerbs(HttpVerbs.Post)> _
Public Function ValidateUrlStatusCode(ByVal url As String) As ActionResult
Dim code As Integer = 0
[Code]....
Now if I use firefox (using Firebug) and go to the url http://www.facebook.com/blah.html, I get the expected 404 returned. However if I use my application to call the mvc route via an ajax call, I get 200. If I set the request object's AllowAutoRedirect to false, I get 302. I never get a 404. I am verifying this once again through Firebug.
View 1 Replies
Mar 19, 2010
I have a asp.net mvc route that is taking a url and doing a simple get and return the status code from the request.
<AcceptVerbs(HttpVerbs.Post)> _
Public Function ValidateUrlStatusCode(ByVal url As String) As ActionResult
Dim code As Integer = 0
[code].....
View 26 Replies
Apr 23, 2012
I have a very long running task I need to take from my website and put into a web service however every time I try call the web service I get this error message The request failed with HTTP status 401: Unauthorized.
View 1 Replies
Jul 15, 2011
I have a (presently) single threaded application written in VB.Net The major processing steps are 12 checked list items in a treeview control. The program executes the steps (functions, and stored procedures) in turn and checks the result before continuing.The steps (greatly simplified) are:
1. Import data from a txt file
2. Bulk Insert it into a database
3. Do some processing
4. Use that data to retrieve a lot more related data across a network in a complex join from a linked server.
5. Update the local database with the results
6. Do more processing
7. Insert the final results into a different database on a different server.
I won't go into all the reasons it had to be done this way like (different server owners within the company, lack of trust between servers, read only access to certain databases, etc.) but the problem is Step 4.Depending on the processing load on the (foreign) server and the amount of data in the import file, this step can take 1-1/2 hours to execute. Since this is a single threaded app the gui freezes waiting for the data to be retrieved from the linked server.Aside from the grey block on the desktop (due to no gui updates) the program runs perfectly.
Attempted solutions:
1) I tried the suggestion of a timer to refresh the form with no success.
2) I have tried using the background worker process but could not get the application to wait for a result before the program continued.
3) I also tried different examples of threading with no success. All the other steps complete so quickly that the gui never freeses, but I wouldn't be averse to threading all my sql calls in this app.
Imports System.Runtime.InteropServices
Imports System.Threading
Imports System.ComponentModel[code].......
View 1 Replies
Sep 22, 2010
I'm trying to make a program that will allow people to queue certain tasks at certain intervals. (i.e. the task is done every 15 minutes, etc.) They can make as many tasks as they want, at whatever intervals they want. How can I possibly make a task queue? Like, how can I queue up code that I already have made to be run every so and so often, according to what the user inputs? And, if 2 tasks are started at the same time, they will both still be done, it's just that one will be done as soon as the first one is complete.
View 4 Replies
Jun 29, 2011
I am writing an application that calls data collectors (via ip or modem), collects data from them and reformats it. I had this much written when I was asked to make it multi-threaded so that I can collect from multiple sites at one time. I have that written using backgroundworkers and it appears to be working well. On my UI I have a text box that needs to update with status details like, dialing, collecting, reformatting, etc. I planned to simply write the status updates to the text box from an UpdateStatus routine. Found that had all sorts of nasty threading issues, so I added a delegate to call the status update routine. Problems seem to be fixed except that the updates to the UI are coming in chunks instead of one by one as they really occur. Can anybody tell me how to force the status update in the text box to update more asynchronously?
View 4 Replies
Mar 31, 2011
I am trying to write some simple functional code that will be added to an existing large scale project. I used the TweetSharp sdk to get and Access Token & SecretToken, and the stored them, and I can them use those with my API key and secret to post to twitter with no issue. I now need to do the same thing but with a facebook status update. (Someone correct me if I'm wrong), but Facebook doesn't user an Access Token & secret Token, but instead they just use an Access Token. I've written the authorization part of the app that launch the browser, user logs in, click Allow, and then I obtain the Access Token from listening to the URL. I have looked at the documentation for three different SDK/API's and don't see anything specifically related to.. This is how you post a status using the user's Access Token. I have tried a number of API documented methods from the Facebook C# SDK, but they all seem way to complicated compared to how I got this done with Twitter... maybe Facebook just made this more complicated, or maybe the SDK just doesn't offer the functionalityCan someone point me to an example for Facebook API code that functions like this after getting the AccessToken(The following is a twitter example)[code]or maybe the workflow for using Tokens in completely different with FB..
View 1 Replies
Feb 20, 2012
Trying to make a call to another forum to chance some text boxes on it and update it. I had it working I thought but the values were not holding when I closed the box so I came up with this solution but Im getting null exceptions.[code]....
View 11 Replies
Jan 28, 2010
Once I click Sign in, I want the application to test to see if the user has internet. If it does I want it to call another sub. If the network is not available I want a message to come up and say Error, no internet connection.
This is what I tried but can get it to work If My.Computer.Network.IsAvailable Then Call testnet()
else Messagebox.show("Error", "Truoble connecting to data base")
View 2 Replies
Jan 11, 2009
i wanna make a program with vb that can make pc to phone calls and i wanna know if it is possible with vb or if i need another program because im new to this programing thing
i added a tool in toolbox called phonecall but however i cant use it i dont know why
View 6 Replies
May 8, 2010
What the Win32 API is? I have looked around but no where really outlines what it is. Is it basically a set of procedures, outlined by Microsoft for programmers in order to get services from the operating system? In essence is it the equivalent to making system calls abd and library calls in UNIX? And yes I now Windows makes library calls too.
View 2 Replies
Aug 6, 2009
i wanted to update my status to indicate e order is delivered or progress in my database and the form itself. so i decided to use progressbar. but im not sure how the coding going to works. or is there other alternatives suggestions on how im going to update my status?
View 13 Replies
Jul 12, 2011
The scenario is that an ASP.NET webforms page will call a web service in an async manner to make about 8 web service calls to various providers for data. I would like to run them in parallel to speed things up. I also need to wait for them all to come back before moving on.
View 1 Replies
Mar 27, 2012
Company's software: MS Access User Interface and SQL Server backend. Visual Studio VB Express Edition.
I received an assignment to automatically update the job status in a drop down list from "In Progress" to "Finished" after the 3D printer has printed succesfully and "Crashed" if not successfully.
I was thinking to do the following:
New project/Class library/the code:
Public Class Class1
Private Sub PRINT_JOB_Click()
Dim myjob As Job
[Code].....
View 1 Replies
Dec 17, 2010
I'm fairly new to .NET programming. I am trying to check if there are settings in a database table and if not, create some default settings. The problem is that when there are no settings I need to make two calls with the datareader and it keeps giving me problems. I originally was only using one datareader but made two to attempt resolving my issue, didn't work. Then I tried closing the datareader and I get errors because it returned a nullreference.
[Code]...
View 3 Replies
Dec 16, 2009
I am trying to create an application that will make calls to an API. I want this process to be fully automated to run a few times a day. What kind of application in vb.net can be automated? I've created windows applications in the past, but never automated anything.
View 8 Replies
Jan 26, 2012
Using the code example on the Twitterizer website I am trying to post a tweet to twitter with this code:
Dim asyncResult As IAsyncResult = TwitterStatusAsync.Update(
tokens.Tokens,
Tweet.Text,
[Code]....
View 1 Replies
Mar 4, 2010
I have been using DBTransaction for my current projects that access a single database. However, I read some documentation on TransactionScope and was wondering in which scenario would using TransactionScope be better? Or should I be replacing DbTransaction calls with calls to TransactionScope?
View 2 Replies
Sep 20, 2011
[URL]
In my program, I created a list of a class that contains 5 picture boxes, a button, a label, an identifier, and some other stuff. I've got roughly 65 of these in this list. I'd be stupid to hard code all that in. The identifier is a 2nd way of identifying which specific location I'm working on.
Anways, all this is created at compile time. Works perfectly fine.
I then manually start a background worker that pings a collection of components. Based off the success of those pings, the picture boxes are enabled or disabled. Basically a proactive way to see if a collection of devices over multiple locations are actually working.
It's the background worker that fails because of thread-safe calls.
Private Sub bgwStatus_DoWork(ByVal sender As Object, ByVal e As System.ComponentModel.DoWorkEventArgs) Handles bgwStatus.DoWork
Dim status As Integer
[Code].....
View 1 Replies
Dec 23, 2009
what libraries can i use to make http connections in visual basic? like cURL library for VB ?i am looking for something like cURL for visual basic.
View 1 Replies
May 12, 2012
how I can control the tool tip popup or make calls to the text that displays based on a integer value. I'm wanting it to display a text based on a interger value inside an if statment for a picture box. So if the ingteger = 1 then tooltip.text = "" else tooltip.text = "" but that is not the correct syntax.
View 2 Replies
Jun 6, 2010
I'm trying to make a simple program that keeps track of a list of phone directories. It offers the option of adding new names to the directory and deleting names already stored.I want the program to display a small unobtrusive message when a name is added or removed.For example, a label that shows "James Potter added to directory..."and then disappears after a few secondsGoing through th file mentions the timer but it seems like an awfully long winded way involving a new control and a new subroutine for every single timed event. I was wondering if there's an easier way, perhaps a single command like:
View 16 Replies
Feb 13, 2012
I have in MDI parent this code to close MDIchild:
Private Sub ToolStripButton3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ToolStripButton3.Click
Dim activeChild As Form = Me.ActiveMdiChild
activeChild.Close()
Try
[code].....
But condition activeChild Is Nothing is not working properly. And Status ToolStripButton stay in True value. How can I setting change status ToolStripButton after all MDI child is closed?
View 1 Replies
Feb 21, 2011
How can i make http Connection in vb.net? what is the method call used?
View 1 Replies
Aug 19, 2011
Private Sub MDIForm_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
DateLbl.Text = System.DateTime.Now
End Sub
i used this code to show date and time in the status strip but time stands still how do i make it run ????
View 3 Replies
