I need to call a stored proc from a .NET web page which takes around 15 min to process. We do not want user not to be able to browse the website in the meanwhile. Is calling it asynchronously the way to go or are there any other recommended ways?
make an asynchronous stored proc call?
What I need to do, is to call a SQL stored procedure from VB.NET, and then store the returned query value in a string.
View 13 Repliesim making a transport agent for exchange and am getting hung up on how to call a method asyncronously. Im doing this based on an msdn article but like usual they didnt provide the part of the code i need to figure out.the article is in C# but i converted it to vb in my project. [URL]I know I need to setup a delegate for the method and then invoke that delegate, but im not 100% on how to implement this.
Imports Microsoft.Exchange.Data.Transport.Routing
Imports Microsoft.Exchange.Data.Transport
Namespace TestTransportAgent
[code]....
I am using vs2008 making an asp.net.vb app. The following stored procedure resolutely insists on returning an integer. I on the other hand was hoping for, and expecting, a single name to be returned. Can anyone help amend the sp or describe what I need to do to get the result I desire.
ALTER PROCEDURE [dbo].[getusername]
(
@email varchar ,
@retvalue nvarchar (10)output
[code]...
I'm having troble getting my code to recognize the parameter for my Stored Procedure.This code below show how I select my files (commented out all other files to make sure one works first)It selects my files through the OpenFileDialog box, it loads the name & location of the csv file into memory and then I want to run a SP to import the csv into my database. I have set the SP up ok as it works through SSMS. [code]
View 8 RepliesHas anyone updated a proc in code, outside of SSMS? It's easy enough to change the stuff after the ALTER statement, but what I can't figure out how to change the comments before it.
View 17 Repliesfirst of, here's what i'm using.
Visual Basic 2005 Express Edition
Oracle Database 10g Express Edition
i created a procedure stored in the oracle database create_user and accepts a few parameters...
procedure create_user
( p_user_num out tbl_users.user_num%type
,p_username in tbl_users.username%type
[Code].....
so i run the form, click the AddNew button in the BindingNavigator, enter the data in the textboxes and then click Save. i receive no error but the values of the textboxes are not being passed to my stored procedure. it is creating records but all columns are null.
i checked this by using an SQL Editor to query the table back-end.
Currently I have the following in default.aspx
View 6 Repliesretrieve the actual T-SQL that is to be executed by a SqlCommand object (with a CommandType of StoredProcedure) before it executes...My scenario involves optionally saving DB operations to a file or MSMQ before the command is actually executed. My assumption is that if you create a SqlCommand like the following:
Using oCommand As New SqlCommand("sp_Foo")
oCommand.CommandType = CommandType.StoredProcedure
oCommand.Parameters.Add(New SqlParameter("@Param1", "value1"))
oCommand.ExecuteNonQuery()
End Using
It winds up executing some T-SQL like:
EXEC sp_Foo @Param1 = 'value1'
Is that assumption correct? If so, is it possible to retrieve that actual T-SQL somehow? My goal here is to get the parsing, validation, etc. benefits of using the SqlCommand class since I'm going to be using it anyway.
<div class="body">
I am developing an ASPX file that returns results from a SQL stored proc into a data adapter, which is then displayed in a GridView. But the problem is that the numbers do not match between the SQL stored proc and Gridview. They are close, but are off just slightly: 3 thousandths. So the SQL Stored proc gives me 0.199, but in Gridview this same value = .203. And it doesn't appear to be a rounding issue either. Also, I looked at the Gridview properties, but I didn't see anything that would be causing this. All of the values for this one column are off by the same margin.
What troubleshooting steps can u recommend? I am using VB in a VS 2008 Shell for SSRS, SSIS. Here is my code from the main ASPX file:
<%@ Page Language="VB" Debug="true" Src="../Global.vb"%>
<%@ Import Namespace="ChartDirector" %>
<%@ Import Namespace="System.Data" %>
[CODE]..................
And portions of the global.vb file:
Namespace GlobalFunctions
Public Class GlobalF
[CODE]................
I would like to debug this, but this is the shell and so I don't seem to have the debug options. I can set breakpoints, but all of the Debug functionality is greyed out. This may be because I can only create SSAS/SSIS/SSRS projects
I am developing an ASPX file that returns results from a SQL stored proc into a data adapter, which is then displayed in a GridView. But the problem is that the numbers do not match between the SQL stored proc and Gridview. They are close, but are off just slightly: 3 thousandths. So the SQL Stored proc gives me 0.199, but in Gridview this same value = .203. And it doesn't appear to be a rounding issue either. Also, I looked at the Gridview properties, but I didn't see anything that would be causing this. All of the values for this one column are off by the same margin.
What troubleshooting steps can u recommend? I am using VB in a VS 2008 Shell for SSRS, SSIS. Here is my code from the main ASPX file:
[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.
Why is this not working for me? What is wrong with my code below? I am trying to read a stored proc and applying values to labels. Getting error that say "Incorrect syntax near CareerInner".........
Private Sub LoadData()
' Define data objects
Dim conn As SqlConnection
[Code]......
things look good till I reach the Bind Commands to Existing Stored procedures page of the wizard and I select my target spproc (rpt_IPR_...) then I hit the finish button and see the message: invalid object name '#TmpResults' now the dataset seems to setup correctly but was wondering why we are getting this message and should I be concerned. The same proc in Access had no issues. [Code]
Because we where not seeing info on the spproc parms we began to suspect that the query made by the IDE to get metadata was failing and that indeed is the case. (we also switch to non-production database to reproduce the issue)after some great SQL debugging from Kevin Currier here at Mindsolve the problem seems to be the SET FMTONLY OFF; SET FMTONLY ON; that the framework is using to get metadata info for the [Code]
I'm using Linq to Sql and have a stored proc that won't generate a class. The stored proc draws data from multiple tables into a flat file resultset. The amount of data returned must be as small as possible, the number of round trips to the Sql Server need to be limited, and the amount of server-side processing must be limited as this is for an ASP.NET MVC project. So, I'm trying to write a Linq to Sql Query however am struggling to both replicate and limit the data returned. Here's the stored proc that I'm trying to convert:
[Code]....
I have working code to read an RSS feed that uses:
Dim doc As New XmlDocument
doc.Load("http://...")
Dim channel As XmlElement = doc("rss")("channel")
Dim items As XmlNodeList = channel.GetElementsByTagName("item")
Unfortunately the doc.Load call causes the rest of the program to become unresponsive until it finishes.What's the best way to perform the load asynchronously and have a callback function to process the data?Edit: Here's the code I've tried using WebClient - the Load method is still lagging:
Private Sub checkResults()
'request rss feed
Dim w As New System.Net.WebClient
[code]....
The rssReadCallback method is executed fairly quickly after calling checkResults, but then the UI freezes during the Load method.
I have a flash video player embedded in a page which has javascript calls for it's controls, specifically calling playStarted() when the play button is pressed. I want to capture this event asynchronously to record when people are actually playing the video versus visiting the page, but I'm not really sure how to do this.
I was thinking the "hack" of a way would be to create a javascript function called playStarted() that would post the video ID to a separate ASP.NET page that would then record it to SQL (where I store my data on page visits and where I want to store my data on video plays.)
But ideally there is a better way to do this where I can register the javascript to the script manager so it can trigger a public sub asynchronously when it's called
I have a function in a module that returns a datatable.I need to call that function asynchronously and get the results in the Main thread (Main Form) in vb.net.
View 2 RepliesI know that it's possible to Call a stored procedure from a Windows Application made in VS 2008. But, is it also possible to Create one? If so, isn't it possible for someone to create a SP that will delete all the data in a DB,when executed? Is there a real danger that someone could use an application that communicates with a DB to create such a procedure?
View 7 RepliesI have a storedproc accepts parameters in XMLtype as
CREATE OR REPLACE PROCEDURE GetDetails(
p_para IN XMLTYPE,
[code].....
I connected to the Informix server using RazorSQL, created a stored procedure and tested it, getting the expected answer, so the procedure exists in the database in some form.
I then run the following code:
If ConnectToInformix() Then
Dim cmd As New IfxCommand("dc_routeHasOutstandingQuantity", conn)
cmd.CommandType = CommandType.StoredProcedure
[Code]....
This error does not occur when calling the stored procedure from a live SQL connection.
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?
I 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]...........
in my program, i use that code for getting the file path of a process, once it gets the path, it is put into a list view which has details like the task manager. the code works fine the first time, but with a little bug that is, when it reaches the vhost of my program. For some reason, it just copies the file path of my program even though the process has changed. After the code has gone through, i want it to refresh the list so as doing the same as when loaded...so I let it refresh and once again it copies the path of the vhost, but this time it has basically taken over every process' location. So in turn, I only get returned my programs location, for something like the task managers location, where it would be like "C:Windowssystem32skmgr.exe"
Here's the
VB
Private Sub frmmain_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Dim Process As New Process()
Dim Count As Integer = 0
[code]....
The refresh code is frmmain_Load(Nothing, Nothing) just to make things easy for me right now, while i get that part of the program going. To me it seems to be working fine, but why it does that what it does, im not sure. as you can see, the process changes. and Ive even checked it through run time, and each and every time, the process.processname changes.
I am trying to call a stored procedure from a SQLExpress2005 data base on a Windows 2003 Domain Controller. I keep having errors when I run my code in debug mode.
Stored procedure name = InsertUsersFromAD
Server name where SQL resides = MIS631
Database Name = AdminGUI
[Code]...
I've tried making the Data Source = \MIS631SQLEXPRESS also, which didn't seem to work. I am trying to finish up a school project and this is the only thing not working.
way to create and initialize SqlParameters in VB.NET? Using 3 lines per variable seems quite excessive. Unfortunately the constructors for this class are rather ridiculous, so I'm thinking of just writing my own sub for initializing each parameter. This is how I've been doing it.
Dim ID As New SqlParameter("@ID", SqlDbType.Int)
ID.Value = val
query.Parameters.Add(ID)
[Code]....
My application has a variable VAR_1 that is boolean, this name is also stored in database.
Now I need to set VAR_1 value in my app by reading database and asign x value,
How do I call VAL_1 from a string?, this is:
Dim VAL_1 as boolean
Dim str as string = myTable.Rows(0).item("x") <--- Here's the name "VAL_1"
But I just can't find how to call VAL_1 by converting "VAL_1" to variable
I have an Excel workbook which I created a sub-routine to insert data from the selected worksheets to a Sql database with the Sql stored procedure. I tested the sp using the Sql Management Studio and it works fine. However when I tried to call that store procedure and it failed. [Code]
View 1 RepliesExcel call to Sql Stored Procedure
View 2 RepliesHow to call a stored procedure from sqlplus?
I have a procedure like ::
Create or replace procedure testproc(parameter1 in varachar2,parameter2 out varchar2)
begin
[Code]....
