I 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 RepliesIf 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 RepliesWhen 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]....
What 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 RepliesI used the same lines of codes to call a SQL server store procedure to export sql data to an XML file:
1. If I call the stored procedure from a window form application, it works and generates the file at the designated location.
2. If I call the stored procedure from a window service application with a setup project, and the install process run well, and I started the service, and checked the event log, it showed the service start successfully, BUT it FAILED to generate the file at the destination folder. I also run everything as administrator, but it still failed to generate the file. It made me wonder if a window service can call a stored procedure. Because, again, mine ran fine with the window form appl, but window service, I would like to have your sample codes. I have googled around for 3 days now, but could not find the answer. I use vs 2008, sql server 2008, and Windows 7
I will have a regular download box from Internet Explorer, and I want the progress bar, to show In my form, and if possible, show when download complete.Attributor 2.0
View 7 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.
I copied the code here and translate the code to vb [URL]it is working fine but there is one small problem but I cannot solve? Here is my code: SyncClientVB Another Source The scenario is... the progress is reported by an event (OnCopyingFile event)
Public Sub OnCopyingFile(ByVal sender As Object, ByVal e As CopyingFileEventArgs)
If pbFileTransfer.Value <> e.PercentCopied Then
If txtCurrentFile.Text <> e.FilePath Then
txtCurrentFile.Text = e.FilePath
[code]....
The problem is that it is ok when runned but when I click the form it starts to hang but in the console... it is still continuing.
dp.SyntaxHighlighter.ClipboardSwf = '/dp.SyntaxHighlighter/Scripts/clipboard.swf'
dp.SyntaxHighlighter.HighlightAll('6f5d1b01659646618ff3bdca29fb1b7f')
get the progress bar show the progress of the batchfile running in the background?
View 10 RepliesI have two forms, when the user selects a button, the second form opens and an external executable begins an automated process. The point of the second form, is to only show the current progress of the automated tasks and closes when those tasks are completed.How would I use a progress bar to show the current progress of an action on a different form without knowing how long it will take?
View 9 RepliesFor 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.
hat i am trying to accomplish is execute a dos command with the following
frmStatusBar.Show()
' Set start information.
Dim start_info As New ProcessStartInfo(sOutput)
[code].....
I am unable to crack this as the end user requested to show some kind of progress bar while running a long time method or an update statement. Kindly suggest me on this ASAP.
View 5 RepliesIn the app I'm currently making, I have two progress bars. One for current task being committed and the other is for overall progress.During runtime, I calculate how many tasks are being run and set that as the maximum. As each task completes, the progress bar is incremented by one.
I want the current task progress bar to show the progress of the current task. Some tasks can take a few minutes to complete so that progress bar works great. But, if the task is super quick, like editing registry keys, I see no progress at all.When I edit the registry, it basically goes like this:
'Edit Key
'x
'x
'x
ProgressBar1.PerformStep()[code].....
It completes so quickly that I never see the bar even move.I also have each task report its name into a label and it skips ahead so quickly that I only see the first task name and the last.Is there any way to make this do a better job at reporting the progress?
I came across a problem in my program it takes too long to calculate the values needed (about 10 sec) .But thats not the problem you don't know when the program is working or not, as it just locks up until its finshed and I view that as a problem.
I need to be able to show the progress of this .I looked at using background Workers but I get exception "Object reference not set to an instance" I believe this is because the background worker cannot write values or something ,As it works will a normal handler.
[code]...
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 want to display the Progress bar control in my vb.net application until my procedure runs at the backend.
View 2 RepliesI 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 deal with a lot of com class code. So, my code generally doesn't have a UI.I can't count on the calling code UI to handle the progress nor would they know the progress of my routines. I'm used to a language that allows you to call a progress window from any code. I've been banging my head up against a wall trying to find a way to create a simple Custom Control that I can simply call from my code that opens a modal window to report the progress.No matter what, I see a need for the backgroundworker in my code. But if the backgroundworker is declared in my code, I can't expose the doWork in the doworker sub.
View 1 RepliesI 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 RepliesI am trying to get some data relevant to a stored procedure (or funtion) back from a database using .Net. The first thing I need to be able to do, is get the stored proc from the database and turn it into string format.The information I need is: The return set of columns, tables used within the SP, Stored Procedures called from the SP. The only way of doing this at the moment that i can think of, is though parsing the text and looking for keyword matches.
View 3 RepliesI am a newbie to vb.net and sql server. My responsibility is to build a vb.net function that when a scanner scans an object, it would take the scanned string and call a stored procedure to get a row of data that match that scanned string and pass the data row to an application that would print out a label.below is my vb.net and sql server stored procedure script
1. Do I have to come up with a public class in order to store my row of data to pass it on to a different vb.net application that would take that data row and print out a label?
2. In my stored procedure, how would I return the founded data row to the vb.net function?
Module makeLabel
Public Class AMGCdata
Public fileName As String[code]...........