Let's say I have items in my WinForms application which have an expiration date. I have more different conditions than this one but let's do it simple. I'd like to trigger an event when an item comes to expiration. What is the ideal way to do so? Checking every X minutes?
View 3 RepliesIs it possible to get an asp.net code (preferably vb.net) to query a sql server for results, but for it to somehow wait for a response from the server when a change is found in the records without resorting to server intensive loops?For example, I want to write a query which checks the date of a record, if the date is different from last known date, only then should the query return the results.
View 2 Replieswith vb.net exp08 + access03
i want to check if the user not triggering any events in the application for => 30 min then i want the application to log off
how to do it ?
i am using two timers for the purpose to elapse the time but it is hard to call the function for every control + event
hence i am looking for a universal code which detects any kind of event and activate / deavtivate my timers
I am using vb .net and office 2007 with Microsoft.Office.Interop.Excel.Application loaded in a vb net project.I have this excel file filled with buttons and drop down objects... i need to change the value of the drop downs and then click a button, all this inside vb .net.I have my workbooks, sheets and ranges all setup, i just need a headstart to, for example, change a drop down value, to say... item number 2.
View 1 Repliesdeal with ever changing SQL queries based on various conditions? i am using Cmd.BindByName = True so it doesn't need to be in an ordered way when adding parameters. Just that this is the hectic way of doing the update SQL ..or even worse insert SQL/I favor doing parameters instead of using stored procedure bcoz i find it faster by using parameters .
SQLStr.Append("Update Table set col1 = :time ")
Cmd.Parameters.Add("time" , OracleDbType.Varchar2)
Cmd.Parameters("time").value = "xxx"
[code]....
I have a ListView that I populate with running processes and would like to highlight specific rows based on the amount of memory consumption. After I add the processes to the list and and call the WorkingSet64 property of the process, I tried this:
vb.net For Each lvi In ListViewProcess.Items If proc.WorkingSet64 >= 2000 Then lvi.BackColor = Color.Yellow End If Next
Processes is the variable I used to grab the collection of processes. proc is defined as a variable and then used to loop through the processes.
lvi is of course the ListViewItems in the ListView.So, by the code I have above, I loop through the ListViewItems, and if any of the processes are above or equal to 2000, then I set the background color to Yellow.
However, it sets every line to yellow, and I can't seem to figure out to set only those processes that have a WorkingSet64 above 2000.
Would I need to loop through the processes and then set the background color of the ListViewItem based on that? That kind of makes sense to me, but if I do that, I'm not sure how to set it just for those processes. Maybe by setting a separate variable?
I have to create buttons at rum time based on database records and implement their events.
View 5 RepliesI want a context menu strip to have 4 specific items. For testing purposes, we call them Item1, Item2, Item3, and Item4.I've set up a context menu strip like this, and I am using it for about 20 different controls. I want these four items to do different things based on what control the user right clicks. The only way I could think of doing this, was to make 20 context menu strips and create a click event for each item. This obviously, seems like a really bad way of doing it.Does anyone have any suggestions or another way of making the click events for the individual Items based on what control is right clicked?
View 6 RepliesI'm creating a Process Control application that will save various data fields to SQL Server 2005. Part of the data will be input via a VB hand-held application which was created on the CE 5.0 - we are running VB.NET 2.0 on Visual Studio 2005. The rest of the data will be collected via plant equipment which will interface will PLCs on the production floor. There are approximately 25 different attributes which will be stored in a SQL server table.
The user wants me to create 3 alert levels that will involve:
1) Checking to see IF a reading was manually input.
2) Checking to see if the value passed or failed.
The FIRST alert involves notifying the operator via the hand-held or some other technique. The SECOND alert involves checking back after a set time interval (15 minutes, 30 minutes, etc.) to see if the attribute passed or failed and then taking a higher action - such as an email, text message or phone call to a higher level manager. If the second check fails, the same escalation process continues with the THIRD alert level - and another action takes place such as a message being sent to yet a higher level manager.
Presumably, once the status check passes, the alert level is re-set back to 0. But I'm thinking that the process that checks for the failed attributes will need to continue to run in the background - probably at set intervals. I'm not sure if the functionality for this is something that would be best handled by VB.NET or SQL Server...
HOW TO GET FACEBOOK ALERTS FROM WEBBROSWER I have web webbrowser i want get the elerts
if i have new messege or new elerts then icon change
For testing purposes, I write a lot of alerts and error messages into a .txt file (some 15 entries per second). At the end of the day, the txt file becomes very large. I am now getting confronted with data loss in my application (threads indicated as being busy). Could it be that my entries in the Log.txt are slowing down my application to the point that the latter becomes unstable ?
View 2 Repliesif no one can answer the below question can you please let me know how to get in contact with someone at Microsoft?
i need to have a code that keeps javascript window.alerts from popping up.
does the .silent command work? and if so how? or is it just bull$t?
An action that I'm trying to automatically complete on a web page requires me to click "Yes" on a JavaScript alert box. Obviously the entire process cannot be automated unless the program clicks "Yes" or "No" for the user. Is there any way that I can capture this alert box and click "Yes" programmatically?
View 4 RepliesI have a form that is bound to a table of data. I have a typical binding navigator. When I go to a different record such as next, previous, first or last I need a subroutine named "LayoutAdjust()" to execute "after" the new next record data is loaded on form. I tried calling the subroutine in the "BindingNavigatorMoveNextItem_Click" action but it executed the procedure before the next record data was loaded
View 1 RepliesI currently creating a form to read .csv from floppy and show the data into textbox. But my problem is after i ran the application my pc not stop triggering the floppy drive. The indicator always light up even after i close the application. there any additional code i need to add to my existing code.Im using VB Express 2005 and This is all the code i use.
Dim oXLApp As Microsoft.Office.Interop.Excel.Application
Dim oXLbook As Microsoft.Office.Interop.Excel.Workbook
Dim oXLSheet As Microsoft.Office.Interop.Excel.Worksheet
[code].....
I am using a Combo box control to select from a list of Databases, and when one entry is selected I display a listbox of certain objects in the database.Other controls are then used to filter the list based on either name or content.Now, I want to know how to Re-load the original list based on the current combo box selection by using a 'Reload' button.In the button code I am setting focus back to the combo box, but whatever I try I cannot make the list refresh again. I've tried Select, SelectedItem, Text and Find methods but nothing works.How do I reload the listbox without having to manually use the drop-down and select the same item again?
View 7 RepliesI have two richtextboxes, richtextbox1 and richtextbox2 on top of richtextbox1 with richtextbox2.visible = false on form load. Whatever is input in richtextbox1 is placed in an array when rictextbox1 loses focus. Now I have a checkbox that when enabled, hides richtextbox1 and shows richtextbox2. On the first time richtextbox2 is shown, i want it to display the contents of richtextbox1. This is achieved by setting a boolean flag (firsttime=true) on form load, then in the checkbox code if firsttime = true, it displays content of richtextbox1 and sets firsttime to false.
[Code]...
I have a checkbox X1 that if checked it will check a column of checkboxes.What i'm trying to do is if the user unchecks at least one checkbox from the column it will uncheck checkbox X1. But I don't want it to run the event from checkbox X1 again because that will cause the whole column of checkboxes to be unchecked.
View 2 RepliesI want to make something like an alarm clock. So, I want my programe to trigger a certain event at lets say, 8:00 AM and 16:00 PM.
I was thinking something with timers ticking every second and checking if the time I want is equal to the system time. But....I didn't manage to make it work. So, how do I make this work ?
Have created a few stand alone projects but nothing major... Using a trial of VB Studio 2010 (.net 4)
a) I have two networked pc's ("PC1" and "PC2") with a solution on each which has a "textbox" and a "send" button. Just want to type "hello" in textbox on PC1 then hit send and it appears in PC2 textbox so that I can base if statements etc. on it.
something like:
//PC2.App2.textbox2.text = textbox1.text
on a button would be perfect but i'm guessing that's far too simple.
b) Video Triggering over network - pretty well sames as above, just want to hit button1 on PC1 and it plays "1.wmv" in "axwindowsmediaplayer1" on "PC2".
c) How can I play a .mov/vob/avi/mpg/flv in an "axwindowmediaplayer1" ? if not possible how do I go about playing videos of all types in my programs?
I have a TreeView object on my form, with check boxes. By the way, I'm working with vb.NET. I want it to perform a few different things with the aftercheck event:
If you check a node, check all its children
If you uncheck a node, uncheck the parent node
If you uncheck a node, uncheck all its children
The problem is when you uncheck a node, it unchecks its parent node, which triggers the event again and unchecks all its children.
Would there be a way to prevent the event from triggering a second time? Or will I have to give up on one of those two points?
Here's the code, if it helps any:
If e.Node.Level > 0 Then
If e.Node.Checked = False Then
If e.Node.Parent.Checked = True Then
[code]....
While I'm at it, is there a way to check if a folder is accessible? I've toyed with FileAttributes, but can't seem to find out how to make it work...
I need to trigger a submit when saving my image file in SQL 2005 database. A user will upload their image file.My application will then check to see if the image file size is within specific requirements.If so, then save the image into a table where the field is image data type. (if size does not meet requirements, display error message and exit sub). The issue is if I save the image file to the database, the value is saved correctly (however, I have not checked the image size).
If I check the image file size first, THEN save it, the value saved is corrupted (incorrect). Is there a way that I can check the file size, then save the file while doing a submit in code-behind?
My code is below:
Dim iRequiredImageHeight As Integer = 80
Dim iRequiredImageWidth As Integer = 280
Dim imgBytes(FileUpload1.PostedFile.InputStream.Length) As Byte
[code]....
I need a simple system that allows one process to check if another process is running (I think I can do that fine using Process.getProcessByName or similar) and then trigger an event in that process assuming it is.When I say trigger an event I do not mean that literally. I simply need to trigger a sub in the first process from the second.I know that IPC like this would normally be done with pipes or remoting or something like that but I have no experience with these and am looking for a quick solution, so unless these can be used relatively easily to solve this I am looking for an alternative.
View 2 RepliesI have a number of textboxes on a form, and I want them all to accept the ENTER key. When the ENTER key is pressed, I want it to trigger the validating event. I know it will look something like this:
Private Sub Textbox1_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles Textbox1.KeyPress, Textbox2.Keypress
[Code].....
What code can I use to cause the validating event to fire? I'd prefer the focus to stay in the textbox.
I've got a piece of code that inserts a row into a table - the kind of thing I've done in dozens of other apps - but the end result is nothing happens on the database end, and no errors are generated.
Here's my code:
Partial Class MyDatabaseDataContext
Public Sub CreateEnrollee(subId, depId)
dim newEnrollee = New enrolee With {.subId = subId, .depId = depId}
[Code]....
After SubmitChanges is called, no new row is created, and "test" is zero. No errors are generated. I have no idea why it's not trying to insert the row.
[URL]
I'm using FileSystemWatcher to monitor a file on a windows server which links into a news ticker on our desktops. The ticker watches the file and updates accordingly. I've successfully got the ticker to watch for a creation and deletion which is great but the changed function doesn't seem to trigger. Out of interest, I tried this function on the network drive AND a local disk with the same results.
I've upped the buffer but I can't see what else I can do to change it! In the short term, we can probably live with just deleting and recreating the file with any changes that are required, but it would be nice if the ticker would just watch for file changes.
I am still in the conceptual(planning) stage so I do not have a code to show as an example.[code]...
Example: A user visits the form, the cursor by default(Tab Order) is in the first TextBox. If the user tries to leave the box without
entering any information an error is displayed. The user cannot leave the TextBox(MaskTextBox) unless they enter valid data.
If the user enters valid data the error message goes off and the user is able to leave to the next TextBox.
I also have a bunch of RadioButtons, CheckBoxes and NUD that I would like the user to play with without trigger the error messages on the TexBoxes. If the user click a check box or radio button, I need the error message to stay off, the error message should only trigger if a user click in a text box and a: Decides to leave without entering data or b: enters a wrong data.
I know other ways to do this, example using a submit button to do this. However is my idea possible? Can you have a field(controls) the validate on leave and click other fields(controls) without triggering it?[code]...
I have only started using VB yesterday and have managed to make some very basic programs run. What I am trying to do now is design a program that will play 4 different sound files depending on the position of a joystick. I am not looking for any kind of gradient to be involved. Any kind of forward position should play the file associated with "forward". Any kind of left position should play the file associated with "left". And the same for "back" and "right".
View 2 RepliesI have inherited a control and added the Validating and Validated events to it, the validation works when the I set focus on another control but somehow it is not being triggered when a StatusStrip button is clicked hence I need to be able to trigger the validation.
[Code]...