Runnig A Procedure Daily?
Sep 13, 2010
I want to run a procedure every day on 5PM.I made an application which in different thread runs a loop all the time, and on a specific time starts a procedure.The loop looks like that:
Private Sub Petla()
Dim wykonany As Boolean = False
Do[code].....
Application works fine, but the problem is that it use 50% of my processor all the time.How should it be done better?
View 4 Replies
ADVERTISEMENT
Jun 8, 2012
I have written a small program to allow our employees to submit work orders. I want to have each computer on our network to be able to open the program, run it, and have the files (which are actually jpeg's of the form) saved on the server. This part works fine.
I have it loaded on the server and have tried to run it from several computers. While the program does run ok, it does not load the My.Settings items that are on the server. On each computer the program has, or appears to have its own set of my.settings.
If I go to the form in the program that allows me to add items to my.settings, and make changes they are saved, but when I go to the next computer they are not there. It only reflects the my.settings that were put directly in during program construction. (opened my.setting, clicked on the setting and added them there)
My question is,, how to get the program to stay on the server when running it so that the settings are there no matter which pc is running it? This is a windows forms program, I am using Visual Basic 2010 Express.
View 12 Replies
May 14, 2012
In VB.NET (Not ASP.NET) what can I use for a daily calendar. I have done extensive DuckDuckGo and Google search and I have came up with no viable options.The purpose of the calendar is to create a appointment system with multiple dentists therefore appointments also can run in parallel. However having it in parallel isn't required as I may have the end-use select what dentist the appointment is for (creating a appointment, therefore got to select a date/time).The project is only a university/college project therefore having it perfect isnt a requirement (but I'd prefer it). I'd use anything, otherwise I'm going to have to use a ListView.
View 1 Replies
Jan 19, 2011
I'm very unfamiliar with this, I've heard about running sql automated jobs, but how Can I run an aspx page daily?? Basically When the page loads up, it constructs an email and sends it out..
View 1 Replies
Feb 16, 2012
I am a newbie at VB.net and would like for you to review my code in order to improve its performance.My objective is to append a bunch of ".csv" files into daily data sets. Within a directory I have about 2500 individual text file (.csv). Each file represents minute intraday stock market data for an individual stock covering 5 days or one week of data. This means that each symbol has 1950 string lines..Here is an example of what a string line looks like: "2011-06-27,10:07,48.15,48.15,48.02,48.02,25421". Not that is relevant but these represent Date, time,Open, High, Low, Close & Volume. Since I have 2500 files within a directory; doing some math, I am processing 2500*1950 = 4,875,000 lines. This process takes me about 16 hrs to run.[code]
View 7 Replies
Mar 15, 2012
How to create dailytimerecord system in php please please help me...our defense will be on Friday march,16...
View 1 Replies
Jun 23, 2010
I am using SSIS Package to Load Daily a file of 8GBs. If the free Disk Space is more than 100GBs.. Everything goes fine. Problem Starts when we have less free Disk Space. I tried to Load a 8GB file with 60 GB Free Disk Space it Inserted 1658 records,Then I deleted SQL Logs and made space more than 100GBs free. For same file it inserted 60,000 records. I am not able to Understand how it happened and It have happened many times.
View 1 Replies
Aug 25, 2010
I am trying to come up with a way to store 3 pieces of information for each employee in the company on a daily basis. So for instance:
Day 1: Joe, 8, 80
Day 2: Sam, 10, 90
Day 3: Bill, 5, 40
Day 4: Bob, 8, 40
Day 5: Sue, 2, 50
I am very new to collections and most of the applications that I build are Create, Read, Update and Delete type applications that don't really need arrays so I have almost no experience with either.
This is what I have so far.
VB
'
Dim iDays As Integer = NumberDaysPerMonth(Date.Now)
Dim DayNumber(iDays) As Integer
Dim EmployeeRecords As List(Of String) = New List(Of String)
For i = 1 To DayNumber.Count - 1
[Code] .....
View 4 Replies
Aug 21, 2010
I was just thinking what is the best way to make daily update system? I have a perfectly work system that checks for updates and downloads the latest files and all that. But one problem the user has to click check for updates button first. I think the real question is how can i add 3 hours to let say 10:00. I also think using the 24 hour system would probably be easier.
View 3 Replies
Jun 9, 2011
i wan set a timer in my program to execute a certain function daily,weekly or monthly(which will decide by the user)!User also can execute manually the certain function at anytime!any1 can teach me how 2 do these 2 function in my program?
View 10 Replies
Jul 1, 2011
how can i open a csv file in which part of its name changes daily, mainly the date (including seconds)?
View 3 Replies
Jul 28, 2010
I have problem on my project on vb.net I'm using visual studio 2008. May I know how to do to show all my sales everyday. I have sale almost 5 items every day I want to have list for this. I'm new on vB.net..
View 22 Replies
Feb 27, 2006
I am trying to come up with a way to store 3 pieces of information for each employee in the company on a daily basis. So for instance
Day 1: Joe, 8, 80
Day 2: Sam, 10, 90
Day 3: Bill, 5, 40
Day 4: Bob, 8, 40
Day 5: Sue, 2, 50
most of the applications that I build are Create, Read, Update and Delete type applications that don't really need arrays so I have almost no experience with either.
VB
'
Dim iDays As Integer = NumberDaysPerMonth(Date.Now)
Dim DayNumber(iDays) As Integer
[code]....
View 19 Replies
Dec 1, 2011
The instructions are as follows:
1. Write a Visual Basic Console Application.Inside the main procedure call a function procedure to input and return a value for a double variable called x, the width of a right triangle.Inside the main procedure call the same function procedure a second time to get a value for a double variable called y, the height of a right triangle.
2. From the main procedure call a function procedure which calculates and returns a value for the hypotenuse equal to the square root of (x squared + y squared).You will have to pass the values of x and y to this function procedure.The procedure should calculate and return a double type value.The value that is returned by this function procedure should be equal to the square root of (x squared + y squared).
3. Also from the main procedure call a sub procedure to display the values of x, y, and the hypotenuse.
View 4 Replies
Feb 23, 2010
In a tic tac toe game I am making there are two blocks of code that are identical except that they access different arrays:[code]Arrays plyrTaken and plyrPairs are used in the first block and cmptrTaken and cmptrPairs are used in the second. Is it possible to wrap these blocks into one Sub Procedure passing the different arrays when the procedure is called?
View 5 Replies
Aug 10, 2007
Well i ran into some problems changing my getfwt to a independant sub procedure. This stuff is so confusing to me.[code]...
View 14 Replies
Mar 11, 2010
i able to get data then i click second time i got error Procedure or function "procedure name" display has too many arguments specified" why this error. [code]
View 2 Replies
Nov 29, 2011
Is there a way to terminate calling procedure from the callep up procedure? I tried 'Stop' from a called up procedure in an executable; it has gone stuck; I am not able to remove it(the form) from the screen!
View 18 Replies
Apr 15, 2010
I finished coding an application for converting Celsius to Fahrenheit, and vice versa. I used the Sub Procedure to convert them. What I need now is to modify it. I would have to use the Function Procedure instead of my Sub Procedure.
[Code]...
View 11 Replies
Mar 30, 2012
Im a student doing an assignment, how do i pass the value from a sub procedure to a function procedure....i want to pass the value from decSubtotal to a function procedure named CalculateDiscount; check out my code--
[Code]...
View 1 Replies
Sep 11, 2009
The store procedure which give me the information I need is:
USE [UCSMIS]
GO
SET ANSI_NULLS ON
[Code].....
When I try to add it to my report it gives an error, is it because of the temp table and how should I go about it?
View 2 Replies
May 4, 2010
I have to get a value in $.I have 2 radio buttons:
-Residential Customers
-Business Customers
I have 2 List boxes:
-Premium Channels
-Connections
I also have a total Text Box and a calculate button..My goal is to get a cost given the information from the user. the list boxes will have preassigned numbers in them..The residential Customers have to pay a $4.50 Processing fee, a Basic service fee of $30 and 5$ for ever Premium Chanel they buy. The Business Customers have to pay a processing fee of $16.50, a basic service fee of $80 for the first 10 connections (4$ for any connection after that) and 50$ per Premium Chanel (no limit)
View 1 Replies
Aug 29, 2011
I have a stored procedure to update a table, but needs a couple of values from another table.
the first two selects get the value from the table and then are used in the update statement.
The select statments:
Select @iStatusDropDownValueID = iDropDownValueID
From DropDownValue
Inner Join DropDownValueType On DropDownValue.iDropDownValueTypeID =
[Code].....
First, the values that are retrieved by the first two select statements are always the same. So they could be passed in by the code itself. I don't know that this will speed things up at all, just make the entire stored procedure better and easier to read.
Second, if the "Value Name" should change this store procedure will break (which is possible, but not often).
I am looking for any insight into the Best Practices for this situation.
View 2 Replies
Sep 7, 2009
I want use a stored procedure in my project but I have no idea about it. Please could you tell me a little bit about how to use I can use one in my vb.net application ?
View 2 Replies
Jul 9, 2009
OK. So I have a class-level array:
Dim terrain()() As Double and I want to add the bounds in a procedure:
Dim terrain()() As Double = New Double(divisions + 1)() {}I can't add the bound for the seconds dimension.
Then I want to assign a value to any element of the array inside the procedure.
terrain(0)(0) = 0.5 This gives the error: Object reference not set to an instance of an object You can see my problem. What solution can there be to this problem that involves one array.
View 6 Replies
Aug 19, 2011
I have tried ADO, now I've moved to SQLClient and I still cannot retrieve the return value from my procedure.
Here is my VB code:
cmd.CommandText = "usp_executeMerge"
cmd.CommandType = CommandType.StoredProcedure
Dim retparm As New SqlClient.SqlParameter
[code]....
My mergeResults table shows the return value of 99 but I cannot get any value back to my VB program.
View 1 Replies
Dec 22, 2011
I have noticed the following but unable to understand why.Whenever a procedure is called in .net it takes more time than when it is called subsequently.Even if a procedure is called after some interval it takes more time than it takes if it is called quite frequently. i am not asking about sql query or sql command. any user definded function or user defined method takes much more time to finish when it is called occasionaly. but when the same procedure is called quite often it finishes a lot faster. why?
View 1 Replies
Oct 24, 2010
how to create a procedure?In VB6 it was through Insert Menu > Add Procedure.Also (just out of interest) is it possible to read from a database and copy the data in to an array?I've not used Visual Express for a while and have forgotten how to do theses.
View 6 Replies
Aug 5, 2010
I have been creating a little utility to generate random alpha-numeric username and password combos so I don't have to input this stuff by hand. A time saver. Whenever I clickbtnGenerate it generates a new set of random numbers, adds them where directed but only generates one ne set per click. I can't seem to figure out how to get it to loop the number of times I have typed into txttotal. So, if for example I needed 1000 uniqueusernames/passwords I'd like to, in the runtime, input "1000" into
View 2 Replies
Mar 16, 2010
I'm working on a project where an application requires to show 50 US state names. When User enters the abriviation in the text box, I want it to convert into Upper case. I made an attempt and coded like this:
strAbriviation = strAbriviation.ToUpper(txtAbriviation.Text)
but that didn't work !! it gives me that blue swigly line How do I fix this?
Private Sub btnDisplay_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnDisplay.Click
Dim strAbriviation As String
[code]....
This code works fine when user enters Capital letters. It's just that i want it to work if user enters small letters.
View 17 Replies