VS 2008 ExecuteNonQuery Returns -1
Oct 15, 2009
Everything I read says calling an SQL Server stored procedure (SP) via ExecuteNonQuery .ExecuteNonQuery(cmd) should return the number of rows affected. When I run my code it successfully inserts a new record but it returns -1. The SP itself is coded to return (0) if successful else return (-99). It is these values that I want to test after execution. I have tried to add a return value parameter to the DBCommand but this causes an error on that parameter: Quote:
[Code]...
View 2 Replies
ADVERTISEMENT
Oct 12, 2009
I'm trying to execute a SQL command, but I just can't find out why this is not working. This is how I defined the "execute" function in my class named "clsSQL":
[Code]...
Probably, I just need another pair of eyes, 'cause I can't see what am I doing wrong Could this be related to the database and not to my code?
View 9 Replies
Apr 29, 2010
I keep getting a syntax error on the ExecuteNonQuery command. I am sure that the table names and column names are correct. Anyone see what I am doing wrong? Am I using any reserved words as column names or something?
Dim da5 As New OleDbDataAdapter("SELECT JobPlanNumber, SLPartNumber, Quantity, Order FROM tblSLMaterials WHERE JobPlanNumber = ?", cn)
Dim ds5 As New DataSet
[Code].....
View 2 Replies
Nov 26, 2010
I want connect to dbf file.
________________________________________________________
Imports System.Data
Imports System.Data.OleDb
Imports System.Data.Odbc
[code].....
The warning is: ExecuteNonQuery: Connection property has not been initialized.
View 4 Replies
Feb 3, 2009
(using vb.net) On our intranet site we have an app that loads customer or vendor information and then allows the users to edit info and add/update/delete contacts. I'm not sure what really changed to this program lately, but I keep getting this error:
Method not found: 'Int16 DBLayer.DBTools.ExecuteNonQuery(System.String, DB)'.
This occurs when i try editing any customer info and the vendor contacts, but the program works when I try editing the vendor info/addy. Here's the program code. There's a seperate program on our webserver that contains the classes used. Here's the main code that calls the classes:
TO ADD CONTACT
M2MInterface.M2M.Customers.AddContact(Session("CustVendID"), txtFName.Text.ToUpper.Trim, txtLName.Text.ToUpper.Trim, Tools.RemovePhoneNumberFormat(Phone), Tools.RemovePhoneNumberFormat(Fax), txtEMail.Text, txtNotes.Text, False)
TO UPDATE CONTACT
[code].....
View 5 Replies
Mar 18, 2011
i am trying to write a function which should return a 2D array , please advise what is wrong with.
vb.net
Public Function Cursor(ByVal SQL As String, Optional ByVal PARA1 As String = "", _
Optional ByVal PARA2 As String = "") As String(,)
Dim Cols, roWES, I, J As Integer
[code]....
View 3 Replies
Jan 30, 2010
Was wondering why the IsDate function always returns false.
dim myYear as string
myYear = trim(txtYear.text)
If isYear(myYear) = false then
[code].....
View 8 Replies
Feb 3, 2011
I am using Visual Basic 2008 and SQLServer 2005 on a Windows 7 64-bit PC. Within a class accessing a specific SQL table, I have a "Try Loop" where I add the results of a search (results returns 42 records) to a list. While within the Try Loop, I can access any instance of the SQL results with simple indexing. When I access the List after completing the Try Loop, I can see the proper count of occurrences, but when I view any occurrence of the list to my working dataspace, I only get the last occurrence, over and over again.
View 3 Replies
Dec 12, 2010
my app is calling a dll that returns SQL details to a bufferred string, here is what i did 6 Dim server As New String(" ", 256) when i use this in sql connection string i get this error: Format of the initialization string does not conform to specification starting at index 22.
View 10 Replies
Apr 22, 2011
implement MOD(%) function without using the MOD or %. Function should take in two integers and return one integer.
View 2 Replies
Jun 23, 2009
The idea is to expand on the existing, old, and lacking Inputbox, to allow for:1. A greater variety of types (Integers, doubles, List(Of String), etc.2. Data validation.For example, if the user wants the user to quickly enter an Integer, I want a custom Inputbox form to show up with a TextBox, which only allows Integer input. If he wants the user to choose from a List(Of String), I show a form with a Combobox instead, from which the user can then choose.
View 8 Replies
Jun 1, 2012
is string.empty = "" why the fallowing function returns 0
vb.net
Dim String1 As String = String.Empty
Dim StringEmpty As String = ""
MessageBox.Show(String.Compare(String1, StringEmpty, False))
View 3 Replies
Oct 16, 2010
I've just upgraded a project to .net 4.0, I'm getting an odd error using ExecuteNonQuery: Errors: {"Mixed mode assembly is built against version 'v2.0.50727' of the runtime and cannot be loaded in the 4.0 runtime without additional configuration infor
Dim xServer As Server = New Server(SQLServer)
Dim db As New Database(xServer, Database)
db = xServer.Databases(Database)
Dim xUser As New User(db, LoginName)
xUser.UserType = UserType.SqlLogin
[Code]...
View 3 Replies
Apr 15, 2012
I have a program where a user can update their Password by Entering their old password in a textbox, and entering their new password in a separate textbox.
An update query then updates the database with the new password.
CODE:
However, everytime the code gets to cmd.ExecuteNonQuery(), it throws up an error saying that there is a syntax error in the Update query. However, If I use this query in Microsoft Access, it works fine so the Update query itself is written correctly. What could be wrong?
Note: I am using an UPDATE query in another piece of code within the same Sub routine and it works there. Its something about this query.
Note Again: If I change the Update query to UPDATE Users SET EMAIL = '" & tbPassword.Text & "' WHERE userID = " & Row.Item(0)" it works. Something about Password that throws that error.
View 3 Replies
Sep 10, 2010
Partial Public Class _Default
Inherits System.Web.UI.Page
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles
[code]....
View 4 Replies
Nov 30, 2009
Dim cmd As New SqlCommand("insert into fiche values('" & Me.TextBox1.Text & "')", connex)[code]...
View 2 Replies
Jun 9, 2011
Is there any way that i can be able to get the ExecutenonQuery to Execute faster. Am using it to run mysql queries that have joins from diffrent tables. As I have come to notice, the user has to wait a while before the statement ExecutenonQuery can be completely executed.. is there any way that I can get it to execute faster?
View 2 Replies
Oct 8, 2009
I'm trying to execute a SQL command, but I just can't find out why this is not working.This is how I defined the "execute" function in my class named "clsSQL":
[Code]...
View 6 Replies
Feb 15, 2010
I'm trying to compare something the user sends to a listview(first column) to see if it can find a match using [code] and if it equals true the program requests a password if its false it returns the noturous "failed to login"
View 2 Replies
Oct 22, 2009
I have the following query:
SELECT Inventory.Inventory_Id, Inventory.Inventory_description, Inventory.Inventory_stock_count, nz((SELECT Sum(Order.item_qty) AS SumOfitem_qty
FROM [Order]
WHERE Order.From_date<=Date() AND (Order.To_date)>=Date()
AND Order.Item_ID='I' & Inventory.Inventory_Id),0) AS CurrentlyOut, [Inventory_stock_count]-Nz((SELECT Sum(Order.item_qty) AS SumOfitem_qty
[Code]...
View 11 Replies
Nov 19, 2011
can i do ( ExecuteNonQuery within the loop of a datareader ) in vb.net please help me with example
View 3 Replies
May 25, 2010
I have this generic routine that I wrote that takes a list of sql strings and executes them against the database. Is there any way I can make this work faster? Typically it'll see maybe 200 inserts or deletes or updates at a time. Sometimes there is a mixture of updates, inserts and deletes. Would it be a good idea to separate the queries by type (i.e. group inserts together, then updates and then deletes)?I am running this against an ms access database and using vb.net 2005.
Public Function ExecuteNonQuery(ByVal sql As List(Of String), ByVal dbConnection as String) As Integer
If sql Is Nothing OrElse sql.Count = 0 Then Return 0
[code].....
View 1 Replies
Aug 29, 2011
In order to check if specific user is db_owner, i excute the following query:
"select is_rolemember('db_owner', '" & p_userName & "')"
using the SqlCommand ExecuteNonQuery method.How do I get the query result?
Here is my code:
Dim com As SqlCommand = New SqlCommand(sql, m_connection)
com.ExecuteNonQuery()
[code].....
View 3 Replies
Mar 11, 2010
i want to delete data from database,but i can't. i think it's because the executeNonQuery is being converted to string..here is my code :
kongkon = New SqlCommand("DELETE FROM [User] where User_ID= ' " + lblssearch.Text + " ' OR [First Name] = ' " + lblssearch.Text + "' ", con)
ra = CStr(kongkon.ExecuteNonQuery) ---> i think this is the problem
[code].....
View 1 Replies
Jun 24, 2010
I have some code which gets child items for a menu via the GetChildren function which takes a list of menuData: Dim builtMenu As New List(Of MenuData)(_rawData.FindAll(Function(item) item.GroupingID = 0))
For Each menuData As MenuData In builtMenu
If menuData.Children IsNot Nothing Then
menuData.Children.AddRange(GetChildren(menuData))
End If
Next
If I check if menudata.children isnot nothing, it always is nothing because the GetChildren function is yet to run (providing the child items, which do exist). If I remove this check and just have this code:
Dim builtMenu As New List(Of MenuData)(_rawData.FindAll(Function(item) item.GroupingID = 0))
For Each menuData As MenuData In builtMenu
menuData.Children.AddRange(GetChildren(menuData))
Next
Then I am presented with a Object reference not set to an instance of an object error on menuData.Children.AddRange(GetChildren(menuData))
View 1 Replies
May 28, 2010
UPDATE: I've modified the code to drop the indexes before the inserting, but it makes not difference.I've been asked to resolve an issue with a .Net/SqlServerCe application. Specifically, after repeated inserts against the db, performance becomes increasingly degraded. In one instance at ~200 rows, in another at ~1000 rows. In the latter case the code being used looks like this:
Dim cm1 As System.Data.SqlServerCe.SqlCeCommand = cn1.CreateCommand
cm1.CommandText = "INSERT INTO Table1 Values(?,?,?,?,?,?,?,?,?,?,?,?,?)"
For j = 0 To ds.Tables(0).Rows.Count - 1 'this is 3110
[code]....
The specifics aren't super important (like what 'tbl' is, etc) but rather whether or not this code should be expected to handle this number of inserts, or if the crawl I'm witnessing is to be expected.
View 2 Replies
Mar 17, 2011
when i use TOAD to update a table all works just fine when using this query:
Update CSR.CSR_EAI_SOURCE ces
Set (STATUS_CODE, COMPLETE_DATE, DATA) =
(SELECT 'ERROR', '', REPLACE(REPLACE(c.Data, '...', ' '), ''','''')
[code]....
It stays on the ra = OracleCommand.ExecuteNonQuery() continuously until i get the error The CLR has been unable to transition from COM context 0x3327fa8 to COM context 0x3328118 for 60 seconds. The thread that owns the destination context/apartment is most likely either doing a non pumping wait or processing a very long running operation without pumping Windows messages. This situation generally has a negative performance impact and may even lead to the application becoming non responsive or memory usage accumulating continually over time. To avoid this problem, all single threaded apartment (STA) threads should use pumping wait primitives (such as CoWaitForMultipleHandles) and routinely pump messages during long running operations.What could i do in order to get this working within VB.net since it works just fine in TOAD when running that same query?
View 2 Replies
Dec 10, 2010
I add C# group too in this, because this is not VB problem but ExecuteNonQuery gives timeout. how to increase the time-out?Exact errormessage: ERROR [HYT00] [Microsoft][ODBC SQL Server Driver]Timeout expiredwe do have cms system and in that CMS I have created a IFRAME which calls this ASPX +VB code, which is in different physicall folder and it has managed Pipeline Classic. When I run this in Old application it works fine. But I copied the pages to the news server and created new application pool/website Call OldASPPAGES I get ODBC timeout on 'ExecuteNonQuery()' function below. Sometimes I works but 9 of the 10 cases I gettimeout. I checked the records and there are 247 records. But below you see there are 2 sql statements composed per Each loop. (update and insert)... 2 x 247 records = approx. 500 records.
But since the sql statement is concantenated so 1 call of ExecuteNonQuery, executue does do 500 SQL Statements.... I know this is GARBAGE, unacceptable.... But I inherited so for the moment I can't rewrite that.To the point:Below are the original statemenst: I have just added : conn.ConnectionTimeout = 240As you can see I've added 240 seconds, but I still get timeouts after approx. 30 secs... so this is not the right place.... question:- Why does this statement work in old ASP environment (without problem) and not in this environement in an IFRAME.
sql = sql & ", a30b_errorcode=" & data_30bis.errorCode
sql = sql & ", a30b_inputcompanyidvalid=" & Abs(CInt(data_30bis.inputCompanyIdValid))
sql = sql & ", a30b_inputnossvalid=" & Abs(CInt(data_30bis.inputNossValid))
[code].....
View 3 Replies
Jun 2, 2011
I am just inserting a record in sqlserver database using stored procedure. In this code Binddata() is the method where i have binbed the gridview with records. here is the code:
[Code]...
View 1 Replies
Apr 23, 2012
I'm trying to update a record in MS Access database with the code below. But it says 'Syntax error in UPDATE statement and highlights cmd.ExecuteNonQuery()'.
[Code]...
View 5 Replies