Updating A Stored Proc Programatically?
Oct 6, 2008Has 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 Replies
ADVERTISEMENT
Asp.net - Why Does Ms Sql Stored Proc Only Return An Integer
Nov 4, 2010I 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]...
Exec Stored Proc With Parameter
Jun 17, 2011I'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 RepliesUsing Stored Proc For Insert Command?
Mar 12, 2009first 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.
Stored Proc As Aspx Datagrid Source?
Dec 7, 2010Currently I have the following in default.aspx
View 6 RepliesVS 2008 Call SQL Stored Proc Asynchronously?
Jun 9, 2011I 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?
.net - View T-SQL Syntax Of A Stored Proc-based SqlCommand?
Mar 18, 2010retrieve 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.
ASPX File Output Differs From SQL Stored Proc
Apr 19, 2011<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
ASPX File Output Differs From SQL Stored Proc?
Apr 18, 2011I 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]...
C# - How To Work Continuously On Other Pages While Executing Stored Proc In Asp.net
Jul 28, 2010I 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.
C# - Reading A Stored Proc Not Working When Passing Values
Oct 7, 2009Why 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]......
Defining A Stored Proc For Use With Dataset Using Tableadapter Wizard
Oct 31, 2005things 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]
Sql Server - Converting Complex Sql Stored Proc Into Linq
Jan 24, 2011I'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]....
.NET Code To Call A Stored Proc And Store The Result In A String?
Oct 5, 2009What 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 RepliesSql - Passing Parameters To A Stored Proc Accepting In Parameter Of Type XML Type?
Jun 7, 2011I have a storedproc accepts parameters in XMLtype as
CREATE OR REPLACE PROCEDURE GetDetails(
p_para IN XMLTYPE,
[code].....
Updating 3 Tables In One Query Without Using Stored Procedure?
Jul 1, 2010i have 3 tables t1,t2,t3..if i update t1,t2 and t3 must also be updated.i have just been tried
UPDATE t1,t2,t3 SET t1.f1='sample',t2.f1='sample',t3.f1='sample' WHERE t1.f1='test' and t2.f1='test' and t1.f1='test'
using this,update fails if t2 and t3 could not find 'test' in their fields,if i use OR all records will be..i have also tried JOINS
Update tbl_maincat AS m LEFT JOIN tbl_maincat AS m2 ON m.cTitle = m2.cTitle,
tbl_main AS c LEFT JOIN tbl_main AS c2 ON c.MainCat = c2.Maincat,
tbl_subcat AS s LEFT JOIN tbl_subcat AS s2 ON s.csCat = s2.csCat
[code]....
Get Running Proc List > Dropdown Box
Apr 2, 2010im working on an app for work that just simplifies some tasks. what id like to do is place all running processes in a combo box so that when i click "kill process" it will kill the selected process.
Public Class Form1
Private Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
[Code]......
SQL Proc Executes But Nothing Is Inserted Into The Table?
Sep 22, 2010I have a vb.net app using plain old ado.net to run a s'proc on the database server. The proc simply inserts a record that contains binary data.When this executes, I can see the exec call on the proc being made from within sql profiler.ado.net claims everything worked, no errors. However, a record isn't inserted. There are no key collisions or anything like that.I copied the query I saw from profiler and ran it directly within management studio. When I run it there, the record is inserted.For whatever reason, sql server and ado.net were conspiring against me. The user account I was attempting to execute the s'proc under did not have execute rights for it. After I set those rights then it was proceeding as normal.Now, the problem I have is that there should have been some type of warning, error, exception, whatever that said "hey, you can't do this" instead of simply saying "Everything is good" But that's a question for Microsoft.
View 2 RepliesForce CREATE PROC When Table In The SQL Does Not Exist Yet
Jun 7, 2011I am converting a lot of projects from VB6 to VB.NET. Many of these projects use the DAO method CreateQueryDef, something ADO.NET does not. I know there is a way to replicate this method in ADOX using Catalogs, but I wanted to stay with pure ADO.NET. I have been using CREATE PROC to do this, but some of the query def's in the VB6 version mention tables/queries that are not created until later. For example,[code]The way the projects are, it is not possible to simply flip these two lines. I was wondering if there is a way to force CREATE PROC a AS SELECT FROM b even though b does not exist yet, or if there is a different option in ADO.NET to replicate the CreateQueryDef functionality.
View 1 RepliesDon't Have Permission To Use SELECT Command With Some Table Called 'proc'
Nov 7, 2008I'm getting ok connection to the database... but it's always telling me that I don't have permission to use the SELECT command with some table called 'proc'.
View 1 RepliesCreate 3 Folders (named As In,Proc,Error) In C:Ram Directory?
May 26, 2011I need to create 3 folders (named as In,Proc,Error) in C:Ram directory. First I need to check for folder existence in directory. If any of them not present need to create missing folder. If all missed need to create all 3. Could anyone suggest a simple looping code in VB.NET for this requirement .
View 1 RepliesVS 2008 : Proc.MainModule.FileName Has Repeated File Path
Dec 25, 2009in 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.
Design A Program That Can Encrypt And Decrypt Messages Stored In Simple Text Files Using A Private Key Stored In A Separate File?
Jun 13, 2011Need to design a program that can encrypt and decrypt messages stored in simple text files using a private key stored in a separate file. Software should also be able to allow the users to enter simple messages that either displays the encrypted or decrypted message. The encryption method should use a simple substitution method. It should be set out in the following format:
Example (the "@" is the separator):
@
The character The Code End of line
A @ 4gh EOL
B @ 84!9 EOL
Has to use the 256 ASCII character codes. The separator will be used to separate the character and its corresponding code.Here are the pseudocodes I have come up with:
� Read any private key file
separator = readline(file);
while not EOF(file) do
tempStr = readline(file);
[code].....
Updating Child Collection Of POCO (adding/updating/deleting) In Entity Framework 4.1?
Jan 25, 2012I have a webpage with a form that is used to edit some object. This object contains a Collection of other objects defined like this: Public Overridable Property Employees As List(Of Employee)
On a form I can delete an employee, add a new one or modify existing one. When I click save new values are sent to the server. On a server I check if the user exists. If exists then I modify its values, if it does not exist then I add it. All employees that exist on the server and were not sent are marked as deleted (State changed to EntityState.Deleted). I try to use the following code (dbCollection = database entities, newCollection = collection sent from the form):
[Code]...
This code does not work, because changing to EntityState.Deleted removes the object from collection, and for each loop breaks, since the collection is modified...I know that I can overcome this problem by using a for loop or adding objects to delete to some other list first, but I hope maybe there is a pattern that would make my code nicer.
C# - Download Pdf Programatically?
May 26, 2010How can I download a pdf and store to disk using vb.net or c#? The url (of the pdf) has some rediection going on before the final pdf is reached. I tried the below but the pdf seems corrupted when I attempt to open locally,
Dim PdfFile As FileStream = File.OpenWrite(saveTo)
Dim PdfStream As MemoryStream = GetFileStream(pdfURL)
PdfStream.WriteTo(PdfFile)
PdfStream.Flush()
[Code]...
Register A C# VB COM Dll Programatically
Mar 4, 2010I have a .NET dll which I use from a C++ program. Now I have to register the dll programmatically on a deployment computer. How do i do that (programmatically! not using regasm)? I remember, when I once called a VB6 dll from a C++ dll, I had to use DllRegisterServer and DllUnregisterServer. Is that still so with a .NET dll? It seems I have to somehow add the dllregisterserver function to the .NET dll.
View 3 RepliesC# - Convert XLS To XLSB Programatically?
Jun 22, 2011I have a customer that needs to convert XLS files to XLSB. Has anyone done this programatically, (with or without an add-on --- doesn't matter --- just need to be able to automate it)? I'm looking for a way to automate this.
As a side note, the customer is asking about this because they use Sharepoint, and it seems it has a way to analyze XLSB files quicker and easier than XLS??? I'm working to improve my Sharepoint knowledge, but in the meantime, I'm trying to find an answer to this XLSB issue.
How To Bind TextBox Programatically
Dec 26, 2011Me.StuDetComboBox.DataSource = StudentsDet.BindingSource
Me.StuDetComboBox.DisplayMember = "StuName"
ComboBox Bind Programatically Like Above Right ?
How To Change Key Bindings Programatically
Dec 11, 2010I'll try to make this simple, using VB.Net on Windows Vista:How do you change key bindings programatically?I'm thinking it has to do with the registry so if it does just give me the registry key names(i know how to change the registry already)If it helps, the reason I want to do this is to change the Windows media center button so that it opens my program rather than WMC.
View 3 RepliesHow To Programatically Open Combobox
Oct 25, 2011I have a window form and a ComboBox is placed on that form. I want to open combobox programatically on keypress event.
View 14 Replies