When i use the below function its showing the error message but still it give a error saying that the exception not unhandled. why is it?
Public Function DepartmentDelete(ByVal DepartmentID As Integer) As DataTable
Try
Using con As New SqlConnection(CMClass.GetConnectionString())
[Code]....
If a stored procedure execution takes 10 minutes does it mean that windows app will wait till the stored procedure finishes or will it continure while the stored procedure is running on the server?
View 1 RepliesI am trying to run several stored procedures from my code and I get the error message that my sp's can't be found, but if I remove all of them but one, my code executes fine.
I've tried this way to run my sp's:
Dim oCmd2 As System.Data.SqlClient.SqlCommand
Dim oDr2 As System.Data.SqlClient.SqlDataReader
[code]......
I want to execute a sql server stored procedure in vb using a button. The stored procedure as one variable that is read from a text file.I got it to read the variable from the text file but don't know how to execute the stored procedure.
View 1 RepliesI have a button that runs a stored procedure when i click it. is there a way for me to show progress on the window while the stored procedure is executing.
View 4 RepliesWhat i am trying to achieve is relativly simple but for some reason i cannot get it to work. I would like on form loads for the contents of a textbox to set the value of a parameter @CustID and the Stored Procedure to be used to return the result into a DataGridView.My datagrdview1.datasource= "StoredProcedure1" but how to i set the parameter value and tell my app to execute.
View 29 Replies'I am trying to create a public class for handling stored procedures
'Class declarations
'1) Mode (delete, insert, edit)
'2) Stored procedure Name (sp_insert_MyTable, sp_delete_MyTable)
'3) Stored Procedure Parameter Count ( 10 or 5 depends) (need to avoid this)
'4) Stored Procedure Parameters (Here I need to declare as Structure, use dynamic array)
'5) How I can call this in Form
'My Study Code, Please correct it...
Public Class clsTest
Public Structure spParameters
Public varPara As String
Public varDataType As String
Public varDatatypeSize As Integer
[Code] .....
I have sql server2000 encypted stored procedure. I can not modify them. Typicaly all the procedures manipulate row by row different tables using cursors etc. When the stored procedure is executed at the Query Analyser screen, I see error being thrown in between but the procedures continues till all the records have been processed. This behavior is acceptable to the client. I now need to automate the process using VB.net 2002 windows application. I call the procedure from vb.net but the program throws runtime error on the 1st occurance of a error in the stored procedure.
View 2 RepliesThe 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?
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.
For some reason my stored procedures are all executing twice! I have a static function that runs an SP given its name and the parameters and fills a datatable.
Public Shared Function RunSP(ByVal spName As String, ByRef spParams As Dictionary(Of String, String), ByRef pDataTable As DataTable) As Integer
Dim cmd As New SqlCommand
Dim lAdapter As SqlDataAdapter
[code]....
Is there something wrong with the code? I've checked with the debugger and the appropriate SPs are definitely only being called once, i.e. this function only runs once for a particular insertion function, but two things are inserted into the table.
I have a stored procedure that I need to execute from asp.net button , It takes more than 30 mins to execute.
So here I need to show a message like "In Process" while execution and disable couple of links..Once the execution is done I need to show "Last processed data and time" and enable the disabled links.
So in "In Process" stage we have to allow user to access other pages in the site.
I'm having out of range exception when executing the line
[Code]...
I have recently put together a new development machine and loaded Windows 7 64 bit and VS2010. I copied over all my projects (VB) from the old machine which was Windows 7 x86 and VS2008. After following the conversion wizard in VS2010 and installing a third-party component I had forgotten about, my solutions opened and executed fine on the new machine.
[Code]...
I have an issue with handling errors in procedure calls in VB6.
View 6 RepliesPrivate Sub CheckSearchState(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles chkVarible.CheckedChanged, chkMessage.CheckedChanged, chkOrgin.CheckedChanged, chkAdditionalInfo.CheckedChanged
' If TypeOf sender Is CheckBox Then
[Code]...
how to extract the control clicked on using this method?
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 RepliesI 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 RepliesI am currently building an ASPX webpage for internal use. Basically, there are two buttons on this page and I need each one to kick off a different stored procedure on our local SQLServer based on the needed task. these stored rocedures do quite a bit of work and take 3-5 minutes to finish running. In neither case do I need any kind of gridview or other output from these stored procedures, as they are simply crunching/cleaning data that will populate some tables that the user will then use to complete their task. There are also no inputs or parameters needed.
So i'm OK at ASPX and pretty good at SQL, but have no idea on the VB code behind page. This is what I have ben able to put together based on 3 days of googling. i think i am close but can't quite get across the line.
CODE:
I'm not sure if you need to see any of my ASPX or my SQL. both work fine on their own, but i am not able to get these buttons to work.
I have a general question regarding best practices for exception handling. I have a class library that uses structured error handling. The functions in the library generally perform some mathematical calculations and all return a boolean value indicating whether an exception occured or not (i.e. exception occured = true, no exception = false). The actual calculated result in the function is returned as a ByRef parameter.
Anyway the input variables for my calculations are all passed to the funtions as parameters. I perform some basic checks on these inputs (e.g check that an input is not negative etc) as part of the function code. The next stage is where im unsure of the best way to do things. Using the example i just mentioned, if an input parameter is negative, I can either throw an exception such as "ArgumentOutofRange", or i can simply show a messagebox with some info about what happened. Either way i do it the function will return true. At the moment i am throwing an exception, but on reading the "Best practices for exception handling" it is recommended you dont throw an exception for things that can be checked programatically because of "performance/overhead issues".
I'm a little confused by what they mean by this. What kind of overhead are they talking about? Slower program? More disk space required? More memory required? When my functions return true, the calling methods basically drop everything and stop calculations (exit sub), so im not sure that the overhead issues they are talking about are as important to me. It seems easier and neater to throw an exception and utilize some global error strings and pass some parameters rather than copy and paste messagebox.show() all the time, and modify the text to suit the situation. Another argument for me would be that both methods of exception handling utilize a messagebox, which stops code execution until the user does something. So i cant see the issue with the performance overhead.
for the program I am creating I want the computer to check if the configuration file has been created or not. I wrote this function to do that but I don't how to handle a file exception. Here's my code currently but obviously it returns an error if the configuration file doesn't already exist. So how do I add a check for an exception?
Public Function CheckIfRunBefore()
Dim ConfDirectory As String
ConfDirectory = ""
Dim StreamReader As New IO.StreamReader("C:\VRAI\Conf.txt")
[code]....
I am currently working on my Final Project and I need to incorporate some Exception Handling. I have created one in the following code but it isn't working. I don't have any "Errors" or "Warnings" but when I run the program it says the "BadNameException was unhandled." I thought I followed the steps correctly from my book, but I am stuck somewhere. [code]
View 6 RepliesI initially posted this in the wrong forum. I need help getting this to run properly. I'm trying to construct a fractions calculator. In order to complete it, I need to do it like this:Using Select Case statements, four Function procedures should be called based on the operation selected. Each Function procedure will calculate the correct operation and return the Decimal value to the calling procedure. The original procedure will print the result.
Now, the result should be calculated to the hundreths place and the input values should be validated by a Try-Catch Block.And of course, I've been having trouble with how to do this. I've attempted many times and this is what I have so far:
[Code]...
I have been using VB6.0 to create database-driven Apps. With VB6.0, I could Dimi recordsets to read/write data from/into database tables. I could use the read data to validate textbox controls on the Windows Forms. But I when I upgraded VB6.0 Apps to VS 2008, I had problems with PowerPacks not found, Exceptional Errors etc.Most of all the problems I have experienced are:
- Overload Resolution failed because no accessible 'item' accepts this number of arguments.
- Error Code -2146825023
- Exception Snapshot - {"Item cannot be found in the collection corresponding to the requested name or ordinal."}
- Interop Errors[code]
I have converted vb6 code to vb.net but in vb6 I used errorHandler in VB.NET we used "Tyr and catch" block
but In catch block resume next gives an error bcoz it is not valid for vb.net
[Code]...
i did this little bit of Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
[Code]...
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.
I am pretty new to VB and I am not sure why this is not working, basically I am trying to run a stored procedure from my web code. The sp runs just fine in SQL, I've tried it several times so I am sure that is not the problem. I don't want to return any results, I just want to see an "ok" statement if it runs and an error message if it doesn't. The code I am using for the lables (warnings and confirmation) is reused from earlier on the same page, the same goes for the validations (valUpload).
[Code]...
I am using SSMS 2008 and VB. I'm a novice VB developer. I am trying to display results of a simple stored proc on my ASPX page. But I get the error below. Here is my code behind for the ASPX page:
>MsgBox(GlobalFunctions.GlobalF.GetDevSQLServerStoredProcedure())
And my code from GlobalF namespace:
Public Shared Function GetDevSQLServerStoredProcedure()
Dim conn As SQLConnection
Dim DSPageData As New System.Data.DataSet[code]....
Where can I find information on creating or how can I create a button to execute a store procedure
View 6 Replies