Based on the code below..How do I stop the execution of the codes at a certain lines if a certain condition is fulfilled? Private Sub Button1_Click_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
[Code]...
We are working on a VB.Net project to execute a SQL Stored Procedure and passing it parameters. We have the execution up and working as expected, however the application will only successfully execute once. On the second execution, it throws the following error: Login failed for user NT AUTHORITYANONYMOUS LOGON..For readability I have broken the code down into relevant 'chunks'.[code]As mentioned, on first run - this works without issue. However future executions fail with the error noted above. To clear the error we have to open the stored procedure in Ms SQL Management Studio, click to modify it, then chose execute from the tool bar. Obviously this doesn't actually execute the stored procedure or return results, but for some reason seems to clear the error.the stored procedure does collate data across several SQL servers, so I am guessing its the 'hop' between them that's causing the issue.
View 2 RepliesI have to execute a stored procedure. When I execute that, I have to keep on check (ping) whether that execution is completed or not. The I will update a label.
View 2 RepliesI got a stored procedure that reads a table and insert those data to antoher table. That's the way how it works because the first table imports data from excel using a package with SSIS.In EF4 I imported the SP and create function import:This SP has 2 IN variables and 2 OUT varibales.The IN varibales are parameters and OUT variables are a message and the number of records created.[code]
View 1 Repliesi am trying to complete a project. My task is to read large TXT files (300 files, 2.2 GB in total) read the customers inside, perform some data calculation and write each customer data to a separate txt file.
I made a code in VB6, it runs fine, however it takes 8 days to run on a quadcore processor, utilizing 20-30% of the CPU. Now I upgraded the code and am running on VB.NET 2008, the latest version. The speed still remains the same, and the CPU usage is also about the same.
Anyway I can make this process faster. I have a quadcore PC with 8GB of ram, possible to maybe make VB utilize all the CPU say 100%? so it executes atleast 2 to 3 times faster.
[Code]...
how to get rid of this prompt for three files I'm executing through my VB code? Here is the code that is calling the three files to run after they've been copied locally to the workstation.[code]
View 1 RepliesI am using Visual Basic 2008 and currently having a coding problems. I have coded a simple game in which I have energy that I can upgrade by 1 point on each click of a button. And so, when i start my program, it always loops this same coding without the need of another click on the button. It keeps looping until it gets to 999 then it stops sending the messagebox and lets me continue using my program. This is an (.exe) execution file programming.
Coding :
Private
Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
[CODE]...
I have an application in which I save transactions. So I have a datagridview populated with records and i test for changes in the datatable when saving.then i loop through the changed rows and save in the following order:I have a command that saves a wage.then a command that saves interest.I use this to save as a transactiondate:
acccmd.Parameters.AddWithValue("@TransactionDate", tdate.Date + Date.Now.TimeOfDay)
then the other command :
intcmd.Parameters.AddWithValue("@TransactionDate", tdate.Date + Date.Now.TimeOfDay)
but sometimes the code is executing the two commands on the exact same time. Now I have a query that displays a running total and on order for the running total to work properly no two transactions should have the same datetime for a particular person.how can I add a delay between the two commands to ensure the datetimes are saved differently?
For some reason, .NET applications that I've written seem to have issues if they're launched when Windows starts (by being in the Startup folder for instance). An application that can finish in 3/10 of a second if one launches it normally may seriously take 45-90 seconds to finish if it was launched when Windows loads. Even if I just manually wait 30 seconds after login and launch the program, it'll complete virtually instantly while a copy launched at startup is still struggling along, so it isn't just that Windows is still loading...this continues AFTER that finishes and all HDD activity stops.Writing something to disk using an IO.anything goes at about 20KB/s during this event.
View 7 RepliesThe 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.
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 RepliesWell i ran into some problems changing my getfwt to a independant sub procedure. This stuff is so confusing to me.[code]...
View 14 Repliesi 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 RepliesIs 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 RepliesI 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]...
I have some code that executes in several keydown procedures.Trouble is, how do I keep these procedures from running?
Private Sub Form1_KeyUp1(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyEventArgs) Handles Me.KeyUp
If e.KeyCode = Keys.D1 Then
PictureBox1.Visible = False
[code]....
When I'm elsewhere in the program (it has different "modes" when operating), I DON'T want lowbit0 true.How do I ignore these subs in code? Also -- from what I've seen, you can only use the key events from within a procedure?Like If KEYX.event = true then do this?
Im executing a stored procedure which saves some data to the database. once this is done im then trying to refresh a datagrid which has all of the records in.
The problem im having is the datagrid doesn't show the newly added record but if I wait a second or so and then refresh it does.
[Code]...
The "RefreshLog bit works but only If I manually do it after a second or so
I have a vb.net project. I have used the GUI and wizard to create a DataSource pointing to a SQL Server Stored Procedure. It works great! However, a new column has been added to the stored procedure.In the GUI if I right click the data source name and refresh, nothing happens.If I right click the stored procedure name and refresh, nothing happens.If I preview data I can see the new column returned.If I choose edit with wizard there is a red exclamation point next to the name of the stored procedure and red X be each column name.
When I hover over the field name it says "Column ABC in the DataSet references a column missing from the Database".When I hover over the stored procedure it says "STORED_PROCEDURE is mapped to STORED_PROCEDURE in the DataSet. Element STORED_PROCEDURE in the DataSet contains columns that do not exist in the Database".I can't figure out how to get the new columnd in the dataset.
I have a small question about stored procedures and the DateTime2 datatype in SQL Server 2008.
I got several stored procedures using the DateTime2 datatype and I want to insert the date 0001.01.01 00:00:00 but this won't work with VB.net and I cannot find the reason why.
I use this code fragment:
Dim sqlStatement As New SqlClient.SqlCommand
Dim sqlTransaction As SqlClient.SqlTransaction
sqlStatement.CommandType = CommandType.StoredProcedure
[Code]....
to call the stored procedures from my program (the stored procedure is a simple INSERT statement nothing else and works fine with actual dates). But when I enter the date 0001.01.01 00:00:00 it always comes up with the error that I cannot insert dates before '01.01.1753' when I want to execute the stored procedure.
Now I already know that the DateTime2 datatype in SQL Server should support this.
So my question is it possible that this is a driver problem and updating the SQLClient would solve this, or is this a general problem and I can finally stop searching and just use 1753.01.01.
How to switch off the annoying (to me anyway) horizontal line that seperates procedures in Vb?
I've setup a new Dev machine for myself and for the life of me I can't figure out how to switch it off in VS2008.My mind is obviously failing with age, I know I did it on the old machine!
How do I configure VB.Net to only show one Subroutine or one procedure at a time rather than Full Code View. Right now I see all code with separator lines between subs and functions. The was and Option in VB6 but can't find it in VB.Net.
View 5 RepliesI try to run a custom sub procedure from the form load event. It keeps crashing. I believe it is because all of the controls are not loaded and the sub procedure makes use of some controls. How can I make sure everything is loaded before the sub procedure is run?
View 10 Repliesso as to open an MySQL connection how can i have a procedure to open a connection to an MySQL server duly passing my connection variable name in to my procedure as a parameter like some thing the fallowing one is not opening the connection
[Code]...
I've been looking through some of my predecessors code and in all of this data level classes, he's defined all his stored procedure names as constants at the top of the classif there's really any benefit of doing this, other than to have all the procedure names at the top of the class?
View 6 Repliesknow in 2008 if you have procedures or functions. that there's a little "-" or "+" that lets you expand and collapse that procedure or function? I was wondering if anyone knew how to create a section so I could collapse it within the procedure? The only way I know it will do it between functions or procedures and things like that but not within the procedure.
[Code]...
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]...
In my old VB6 app, I defined fields such as:
CODE:
As I am trying to rewrite this procedure as a project in vs 2008, all of the OutLook references are being flagged.
In project properties/references I added the reference: Microsoft Outlook 11.0 Object Liberary, but still flagged as error.
Is there another namespace or something I need?
I'm trying to manipulate something that is in a different thread, and I know I need to do something by the way of Invoked procedure, but I'm unclear on how. I looked up some examples here on the forums and tried to follow the basic template, but I continue to have the same problem. how to use invoke correctly.
Private Sub getMessage()
For Me.infiniteCounter = 1 To 2
'Try
[CODE]...........................
If I run a SQL statement or execute a stored procedure from SQL Mgmt Studio, I will get two tabs: Results and Messages.I am lookig to return EXACTLY whats in the messages (the tab I'd see in SQL Mgmt Studio)window to a string variable. Is there a property in ADO.NET (maybe in the command object?)that contains the messages returned from a stored procedure? I am using VB 2008.
View 1 RepliesHow would i go about checking a file extention to see if it is either
'.exe' or '.ex_'
What i need to be able to do is that if the extention of the file is '.ex_' then that file is copied to another folder, or if the file extention is '.exe' then it is passed onto another routine that will compress is.
Baring in mind that there could be a number of files in that folder.
I already have a routine that will compress the files, just need the above.