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,[code]...
View 3 RepliesI've added few stored procedures to my SQL Server 2005 database. Few of them were a procedures containing SELECT statements and one of them contains INSERT statement. While executing the procedures with select statements are as easy as displying tables, the procedure with INSERT statement is not so easy [for me].At first, i've tried to add the procedure to the dataset and execute it as others, by filling the table adapter. But... there is now way to access the tableadapter within the code... VB does not recognise it! Just like it wasn't there! It's not even listed on with the other tableadapters below my project. It's viible only in the dataset!After few minutes i've removed the procedure from the dataset and tried to add it as a query. Everything seemed to be ok... but... after naming a function, that would execute the query.... the function is visible nowhere. I can't execute it within the code.
View 3 RepliesI have a stored procedure that clears student accounts to showed that they have paid their bills. I am trying to create a form in vb.net that allows them to enter a parameter and then execute the stored procedure.
View 9 RepliesI have a form that requires me to execute several stored procedures one after the other. I'm wondering how to do that in vb.net. I realize that I could just have one stored procedure with all of my queries in it, but for clarities sake, I want to keep them seperate.
View 14 RepliesThis is a bit old-contents to be discussed but I need someone who can explain me how to create stored procedure in SQL Server for returning a value from procedure, example:[code]Then I need the name of its customer and the address instead.I need to make it as a stored procedure and show me how to execute it on VB.NET. Perhaps we assume that the name will be prompted to LABEL1.TEXT and the address will be prompted to LABEL2.TEXT. I've improved this SQL-Server Stored Procedure Using return but I have nothing to return after I execute it.[code]
View 1 RepliesI've created a simple parameterless stored procedure which I've pasted below. I've imported the stored procedure to my Entity Model and created a Function Import. The function in the model is never created and I am unable to execute this stored procedure using the ADO.NET Entity Framework. I've opened the .edmx file in XML view and have confirmed there are no errors regarding this stored procedure. What am I doing wrong? Is it really impossible to call such a simple stored procedure from the Entity Framework? I've set the return type for the import function to None seeing this stored procedure does not need to return any recordsets or values.
Stored Procedure:
ALTER PROC [dbo].[Inventory_Snapshot_Create]
AS
SET NOCOUNT ON
DECLARE @Inventory_Snapshot_ID int
[Code]...
How can I execute a stored procedure using sqldatasource and get the return value in vb.net.
View 2 RepliesIn vb.net is it possible to execute a sp for a dataset (datatable) ?
If no is there any alternative to do this as when I execute a sp from database it gives data saved in my db but if I am working on local dataset how to get updated data from same sp without saving to sql db first
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'm trying to execute a SQL stored procedure with a parameter that needs the SQL datetime format as:
Dim str_runproc As String
str_runproc = "exec UP_stopactivity @Activity='" & DGV_currentactivities.CurrentRow.Cells(0).Value & "' ,@Client='" & DGV_currentactivities.CurrentRow.Cells(2).Value & "',@starttime='" &
DGV_currentactivities.CurrentRow.Cells(3).Value & "'"
the DGV_currentactivities.CurrentRow.Cells(3).value is a datetime value that is put into a Datagridview via another stored procedure. When I run it in sql, it lists as a correct SQL datetime: 2011-04-27 05:54:51.003, in the datagridview it lists as: 27/04/2011 5:54:51
I have some VB code like
Dim data As DataTable = DataAccess.ExecuteDataSet("AuthenticateWebServiceClient" _
, New SqlParameter("@ClientID", ClientId) _
, New SqlParameter("@Password", Password) _[code]....
Except PrepareSPCommand isn't recognized by VS. Does anyone know the correct way to convert this function to C#.
In VB.NET, how do I do the following?
Execute a Stored Procedure
Read through the DataTable returned
I am trying to execute a stored procedure and place the data in a datagrid manually (without using the .net wizard). I am using vb.net and asp.net in visual studio.Here is my code but I can't figure out where I'm going wrong.
Imports System.Data.Sql,
Imports System.Data.SqlClient
Imports System.Diagnostics
Imports System
[code].....
How I can execute a stored procedure and the put the results into a webbrowser to display. I know html so I will format the stuff to look how I want it to.
View 6 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've a procedure like this:
[Code]...
How to make a procedure to be executed only once when an application is installed freshly.
I mean if my application is installed, i want to execute a procedure only one time at the first use of the application.
I'm using asmx web service to lock a folder on remote computer! When I run web service on local machine everything working fine, but when I run it on remote computer nothing happen, folder on remote computer stay unlock! I supose that I need to set security permission for this web service on remote computer, but i don't know where! So, what I need to enable executing this service on remote computer?
View 5 RepliesI'm evaluating the best approach to implement the following periodic task:
Get some users from SQL Server (2008) and then for each user enable licences in the Cloud (Office 365) using PowerShell.
My first thought was a console-based app in C# or VB.net but now that I realize that running a PS Script remotely using C# can be quite a challenge I'm starting to think in alternatives like perform all the stuff using PowerShell, I guess this is a better approach but I'd like to hear your thoughts on this.
I am trying to execute exe file on remote machine using wmi. Its basically work on 50%, but problem is interactive process it execute the app but i can't see any window or form but I can see app is running in the task manager. Does not need to be vwi, might different method, but I dont want to use psexec tool.
My function:
Public Function StartEXEonRemote(ByVal machine As String, ByVal file As String) As String
Dim wmi As ManagementClass
Dim wmi_in, wmi_out As ManagementBaseObject
Dim retValue As Integer
[Code] .....
im trying to execute exe file on remote machine using wmi. Its basically work on 50%, but problem is interactive process it execute the app but i can't see any window or form but i can see app is running in the task manager. I spend 3 days on this with no luck.Does not need to be vwi, might different method, but i dont want to use psexec tool.My function:
Public Function StartEXEonRemote(ByVal machine As String, ByVal file As String) As String
Dim wmi As ManagementClass
Dim wmi_in, wmi_out As ManagementBaseObject
[code].....
I have a working code snippet that I use to Execute processes on remote machines. This works great against my Windows 2008 machine but I get an access denied when executing against my Windows 2003. The access denied is thrown when connecting the scope in the code below. I believe I have give this user all kind of rights but some setting is missing. What settings are required? This is a local admin. Is there any special DCOM settings or?
Public Shared Function ConnectToScope(ByVal nc As NetworkCredentialClass, ByVal strHostName As String) As ManagementScope
Dim scope As ManagementScope = Nothing
Dim Path As String = CType(IIf(strHostName.ToUpper() = Environment.MachineName.ToUpper(), _
"ROOTCIMV2", "\" + strHostName + "ROOTCIMV2"), String)
[code]....
I was wondering if there is anyway you could go about executing what's stored in a variable....kinda like in an #Eval statement....
E.g.
dim i as integer
dim PlaceHolder as String
for i = 1 to 10
[Code].....
Suppose I have two buttons btnCheck and btnOK. I want to execute few lines code of btnCheck from btnOK. So that When I click on btnOK, btnOK's code as well as BtnCheck's Code should be executed one after the other. How can I do this in vb.net
[Code]...
I trying to figure out how to execute commands stored in string, let's say i have string called "command" and a textbox, so i want vb to run command that i typed in textbox, e.g. i type in textbox "label1.text = "bla bla"", and then type like "msgbox.show". Is that even possible?
View 12 RepliesI have the following code:
Code:
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
Main.payrollButton.Enabled = True
[Code]....
and I'm trying to execute several stored procedures and it doesnt seem that it is.
On my final form that this connects to, I'm trying to fill data that is summed by these stored procedures and I'm getting the error of :
'The SelectCommand property has not been initialized before calling 'Fill' ... which I'm told is because there is no data in my query.
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.