OK, I have this loop I want to perform which involves the serial port. Not to get too specific I'm actually sending data to an external device within a loop The loop involves a Start number, increments by a Step and ends when it gets to Stop This repeats until I click a STOP button.
View 15 Replies
I have a stored procedure that when I run it within my application it times out, but when I use Management Studio and pass in the same exact parameters, the stored procedure executes under a second. I had this exact same issue with the same stored procedure before, and all I did was recompile it, and it fixed the problem, but I do not want to keep having to recompile this stored procedure every few days or so. Has anyone else ran into this issue before?
Another note I would like to mention, is that I'm currently working on a test database, so I'm not inserting, deleting or updating any of the records that the Stored Procedure is using. So the database itself is not changing, but for some reason the Stored Procedure is showing degradation, and at the most we have 2 users in the database at a time.
Below is the code I use to call the Stored Procedure from my app.
cmd.CommandText = "sp__RECAP_SELECTION_GET_GRID_RECORDS_RECAP_TYPES"
cmd.Parameters.Add("@FK_KitchenID", SqlDbType.SmallInt).Value = cmbKitchenCustomer.KitchenID_SelectedPrimaryKey
[Code]....
As I mentioned, if I run the Stored Procedure within Mangement Studio, it runs with no problems. Also if I recompile the stored procedure, it runs fine within the app, but after a few days, the stored procedure starts to timeout again within the app and I need to recompile it again.
The program operates a board and activates relays when the buttons are pressed, the code works fine and i have published it to use on a PC however, after about 2 days the port times out and it stops operating the port, am i missing any code such as close port anywhere.
Public Class Form1
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
[Code].....
I use combo boxes with the Autocomplete turned on (Source = ListItems and Mode= SuggestAndApplend). The problem is that if the user stops typing for two seconds and then continues typing, the Autocomplete starts matching only on a new characters being typed. For example, I have a list with two items: "apple" and "please". I type "ap", then pause for a couple seconds and then continue typing "ple". I want the list to match on "apple" but instead it matches on "please". I'm looking for a property or some way to set the length of time the control resets the matching. Do you know if one exists?
View 6 RepliesI am a complete noob at programming, so I need all the help I can get with my new program.I am building a web-browser which is linked to one webpage. The content of this page is constantly changing, so I need the web-browser to auto-refresh after 2 minutes. But if it refreshes while NOT connected to the Internet, the browser will show an error message, so that is why I have build in an Internet check. This check is working. The browser also have to be in the same place at the screen every time the software is loaded. This code is also working.
But the timer and the refresh is bugging me. I cannot get it to work. The code is not responding.
[Code]...
I need access to very precise timing in a .NET application. I need microsecond precision. Is there an easy way to do this in .NET?
View 5 RepliesIm trying to check to see if a value of a label changes over time. however I can't seem to get it right.
dim val1 as string
dim val2 as string
private sub form1_load()
dim val1 = label1.text
end sub
[Code]...
problem is it will only check it once after ten seconds when the timer is set to 10 seconds i need to to check it every 10 seconds becuase these values display altitude, and if the server freezes the altitudes dont change. I need to make sure they are updated and not frozen.
I am using VB2008 SerialPort to communicate with a device. My problem is, using RTS handshake I am missing the first 50 or 60 chars, after that everything is intact. I tried to change the buffer size - Has no effect, used standard, bigger, smaller and no change.
The device timing says when it sends CTS signal, it will start listening 100ms after that. I have no clue how to delay the write to test this. Should I first write to the buffer then write to the port after a a 100ms timer event?
I am using LINQ to SQL and a third party SDK that supports distributed transactions. When I realize that a pending update will be updating both SQL records and records in the third party SDK, I am creating a TransactionScope with a 0 (presumably infinite) timeout (although I've also tried 12 hours as a timespan parameter). Then I use GetDtcTransaction on the ambient transaction (created by transactionscope) to get a DTC transaction to link to the third party SDK. Things work nicely for about 10 minutes, but after 10 minutes, the transaction disappears and an error occurs. How do I determine why the transaction is disappearing. I suspect it's a timeout because it regularly occurs after 10 minutes even though slightly varying degrees of work have been done at that point. But I'm at a loss about how to determine what terminated the transaction, why, and how to extend its life.
[Code]...
I'm currently struggling on how to make a comparison between a timespan value and the current time.I went up to here, but the comparison totaal with the current time doesn't work .
[Code]...
So, I got an SSD drive for my computer the other week, and decided to have a little fun. I wrote a program which starts every single program in the Windows Programs folder in the Start Menu, via clicking the "Go" button on my Form. It works beautifully. Only thing I would like to add to it is some sort of timer, which I have never tried in any programming language. I would basically like for a timer to be running, counting in real time (seconds), until my loop ends, and then display the total time taken at the end. I was thinking about setting a variable equal to the current time, before the loop starts, and then another equal to the time right after it ends, and then taking the difference of the two.
View 7 RepliesIs it possible to hide some control on timer event. Initially when the page loads, i am label control on the form. So after some seconds, can i able to hide that label?
View 5 RepliesOur production database as grown to a size where several of our longer running stored procedures are taking more than the default 30 seconds to complete. I've programatically set some of the CommandTimeouts on the command objects but the calls to the store procedures still appear to be timing out after 30 seconds.
Here's what I did:
In web.config set this property
add key="CommandTimeOut" value="180"
Added this to the top of my class that needs the timeout set:
Dim COMMAND_TIMEOUT As Integer = ConfigurationManager.AppSettings("CommandTimeOut")
After creating the command object set the timeout property on the object.
cmd.CommandTimeout = COMMAND_TIMEOUT
Unfortunately my stored procedures still seem to be timing out when they take longer than 30 seconds to execute.
I have a timer routine (basically just a timing loop) that moves shapes around the screen. The problem is that it isn't in sync with Windows (Vista). If a Windows background program runs (like an antivirus) the screen goes gray. The timing routine still runs but the display is shut off. Only when the shapes are done moving does the screen return to normal (but I didn't actually see the shapes move). Another good example of my issue is when I finish debugging and press the Start button, again I don't see the shapes move, I just see a grayed out screen with the cursor in "busy" mode.
All the other VB.NET programming I've done doesn't assume so much control as this timing loop. I've never had to worry about coordinating a routine with other windows functions. What's the trick to getting this stuff to work together smoothly?
Why does this code works for the first few then gives timeout on all the rest ? VB removed, resolved like when i run it with say 50 threads, the first few work fine but then the rest after that all time out, i have tryed moving the ones that work to the bottom of the list but they still timeout after the first few are done.
View 2 RepliesI added a web reference to my VS 2005 console application [Code] The call to this WS times out with :"The CLR has been unable to transition from COM context 0x1a3008 to COM context 0x1a3178 for 60 seconds. The thread that owns the destination context/apartment is most likely either doing a non pumping wait or processing a very long running operation without pumping Windows messages.
This situation generally has a negative performance impact and may even lead to the application becoming non responsive or memory usage accumulating continually over time. To avoid this problem, all single threaded apartment (STA) threads should use pumping wait primitives (such as CoWaitForMultipleHandles) and routinely pump messages during long running operations."
I used WCFStorm to call this WS and the result comes back in an instance, so I don't think the WS is a problem. I deleted the web reference a few times and added it back again. did the clean and rebuild operations.
MVC3 vb.net. In my app I have a point where 500+ emails with attachments are sent out using a for each loop to accomplish this.. Nothing is returned to the browser the entire time this is running so eventually the browser think it has timed out... I tried just having it redirect to another actionresult function after every email and that function just passes it back to the email function. This is not working and I feel the reason is that nothing is actually being sent to the browser window its self.. Is there a way to fix this issue??
[Code]...
I am having an issue with serial port timing when using it to read large flash content. If I slowly step through the code the program works as expected. If I let it runs by itself it only shows part of the result. The problem is not related to displaying the data on the form but mainly the "Serialport.BytesToRead".
Here is the code
Private Sub MemoryReport_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MemoryReport.Click
Me.BackgroundWorker1.RunWorkerAsync()
'Memory_Report()
'SerialPort.DiscardInBuffer()
[Code] .....
I'm trying to measure the performance of seven sorting algorithms in a single VB 2008 program. I've tried using a Timer componend, the Stopwatch, and DateTime.Ticks but nothing works. The following simple code produces a result of about 500 (milliseconds), which is correct, but when I change 500 to 1000, I get a ridiculous result like 0 or 8.
[Code]...
I understand that there are several ways of Inserting, Updating and Deleting records in a database such as DataAdapters, DataSets, TableAdapters, SqlCommandBuilders, Parameterized SqlCommands, StoredProcedures, etc, etc,etc. According to David Sceppa Sprocs are the most preferred. Ok, I go with him on this one (who am I to challenge him anyway?).
My question is, apart from Sprocs, which of these options is the BEST for a large commercial database application and why, taking performance into account? What are the benefits and drawbacks of each option?
I am writing a program to assist Paramedic students in learning the Drugs that they have to know in order to pass their classes. I have created an Access database to hold all the information on these drugs, but not every student that will use this program will need to learn all the drugs contained within this database.
Right now I have 43 drugs in the database and still growing.
What I want to do is to present to the student the drugs and have them say "Y" or "N" as to whether its on their required list to learn. That way they only work on the ones that they need to.
I've two BGW with similar coding but different approach, My second BGW shows me "NOT RESPONDING" whenever i try move/click/focus to form while the BGW is running.
VB
RichTextBox2.AppendText("Some Text")
process2.ReportProgress(inc)
My.Computer.Network.DownloadFile(andpic, "pics/" & spliti(0) & nnum & ".png")
My.Computer.Network.UploadFile("pics/" & spliti(0) & nnum & ".png", "ftp://ftp.mywebsite.com/domains/mywebsite/public_html/Pics/" & spliti(0) & nnum & ".png", "users", "password")
WebBrowser1.Navigate("Mywebsite")
I've taken out number of things that i think is causing this error Are they the cause of "NOT RESPONDING" ?
To write a effecient Active Directory library to ease the work of technicals who are responsible to create access models into the domain controller's Active Directory. This library must allow the following:Basic operations: Add, Modify, Delete, List entries;An entry may either be an organizational unit, group or user (no further need required as of now);I thought about having a class which would represent the domain with which we want to work with.
public class Domain {
public Domain(string root) {
Root = root;
[code].....
I have a database with three tables:
stock
orders
order_details
Stock and Orders are self explanatory. Order_details is a lookup table, holding basically just the orderID, stockID and quantity for each item in the order. That's not very friendly for the user however, so what I want to show is a DataGridView with some elements from order_details, and some from stock, i.e.:
Part_Code, Item_Name, Description, Quantity, Price
I can create a database view for this easily enough, and bind it to a datagridview. It shows existing items in the order fine, but the problem is the view doesn't update when I add new elements to order_details in the dataset. It appears that it's bound to the main database, and so won't update until I save the record. That also has the problem that it's now much harder to update the database. A simple datagridview bound to order_details would make it easy for the user to enter quantities and for me to save the record, this one now needs a custom update statement.
In summary:
- I want to show data from two tables
- I want the datagridview editable (well, the quantity column anyway)
- I want the datagridview to update when I add entries in the dataset
What is the best/easiest way to do this? Is my current approach of a view in the database and custom update statements sensible? How can I get the datagridview to refresh whenever there's a change to the local dataset?
I recently started a project and needed to do some integration with LDAP via DirectoryServices. I've done this in other apps so I went into one of them to see how I did it -- why reinvent the wheel right? Well, while this wheel works, it was developed years ago and kinda smells (it's wooden, firmly attached to the previous vehicle, hard to repair and produces a potentially bumpy ride).So I thought to myself, this is the perfect time to refactor this puppy and make it more portable, reusable, reliable, easier to configure etc. Now that's fine and dandy, but then I started feeling a tad overwhelmed regarding to where to start. Should it be a separate library? How should it be configured? Should it use IoC? DI?
So my [admittedly subjective] question is this -- given a relatively small, but quite useful class like the one below, what is a good approach to refactoring it? What questions do you ask and how do you decide what to implement or not implement? Where do you draw the line regarding configuration flexibility? [Note: Please don't bash this code too much okay? It was written a long time ago and has functioned perfectly well baked into an in house application.]
Public Shared Function AuthenticateUser(ByVal id As String, ByVal password As String) As Boolean
Dim path As String = GetUserPath(id)
[code]......
I'm working on a system where there can be 2 level of users "Admin" or "Researcher".We have the requirement to allow the researcher to change fields for a record a record, but they want the original values to stay in the record and have an admin "accept" or "approve" the changes before the real record gets updated.Has anyone run into this scenario before? I'm trying to think of the best way to do this.
View 3 RepliesTrying to implement a recordset approach in VB.NET and have gotten to the point where things almost run. :)
Code:
Dim strSQL As String
Dim rsMaster As New ADODB.Recordset
strSQL = "select * " & "from tblDQ " & "order by xid, xcode, xDOS"
[Code].....
I'm currently working on a system that requires monthly, quarterly and annual reports. I have no problem in generating/retrieving the data, my problem is the presentation. What is the best way to do it? I need the report to be:
View 3 RepliesI have a wierd problem with threading in an ASP.NET application. For some reason, when I run the code in the request thread, everything works as expected. But when I run it in a separate thread, nothing happens.This is verified by calling the below handler with the three flags "on", "off" and "larma" respectively - in the two first cases everything works, but in the latter nothing happens.[code]
View 4 RepliesWhat is the optimal approach to a WithEvents Collection - VB.NET?Have you any remarks on the code bellow (skipping the Nothing verifications)?The problem is when I obtain the LinkedListNode(Of Foo) in a For Each block I can set myNode.Value = something, and here is a handlers leak...
-Could I override the FooCollection's GetEnumerator in this case?
-No. :( cause NotInheritable Class LinkedListNode(Of T)
Class Foo
[code]....
