With DbCommand I'm trying execute this SQL statement[code]...
But when I run each command from strCommand standalone then everything works fine.
I'm using VS 2010 Professional and SQL Server 2008 R2 Express.
What value will be returned from below execution with select, insert, update, delete?
Dim L_EXECUTED_NO1 As Integer = command.ExecuteNonQuery()
Dim L_EXECUTED_NO2 As Integer command.ExecuteReader()
Dim L_EXECUTED_NO2 As Integer = command.ExecuteScalar()
For example, I tried "Dim L_EXECUTED_NO1 As Integer = command.ExecuteNonQuery()" with Update SQL statement and that returned "-1". But it returned 1 for Delete SQL statement.
If Query_SQL("EXEC SP_ATT_CLOCK_INOUT_UPDATE '" & L_TODAY_DT & "', '" & L_EMP_ID & "', '" & L_START_TM & "', '" ) = True Then
MsgBox("Successfully saved!", MsgBoxStyle.Information)
End If
Function Query_SQL(ByVal SQL_Query) As Boolean
[Code] ......
Public Sub Procedure(ByVal procname As String, Optional ByRef param() As SqlParameter = Nothing)
'Execute Store Proc In Database
Dim cmd As SqlCommand
cmd = New SqlCommand(procname, conn)
cmd.CommandType = CommandType.StoredProcedure
[Code]....
I have came out with a simple DAL, when i pass in stored procedure and param, it throw me exception as the following
"ExecuteNonQuery requires the command to have a transaction when the connection assigned to the command is in a pending local transaction. The Transaction property of the command has not been initialized."
I'm passing in a sql command such as "EXEC StoredProc 0" into a a function called ExecMyCommand where StoredProc is a stored procedure taking a parameter of 1 or 0.It works fine with the following code.I had tried to judge success by looking at NumRowsAffected but soon realized that the -1 could represent a successful run even if -1 was the return value.So then I changed the code and return mLastRunOutcome = False if there is an error.So for testing I changed the name of the SP to like StoredProc2 in the database and ran the same command "EXEC StoredProc 0" and to my amazement, no errors were thrown in the code below..Of course ran the same command in Query Analyzer and it barked that there was no SP by that name.How do I know when a command ran successfully or not in code here? and Why didn't the ExecuteNonQuery throw an error when the command was not right??[code]
View 2 RepliesI 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].....
Imports MySql.Data.MySqlClient
Public Class Form1
Dim myTime As Date = TimeValue(Now)
Dim myDate As Date = DateValue(Now)
[CODE]..................
It'ss not running the cmd2.executenonquery. I've tried many different things such as opening a different connection and yet it still doesnt run that line of code, but it'll run the message box in the if then statement. So I assume it's something to do with the connection somewhere. I've also tried using try and catching the error. nothing. So the problem is that its just not running query2.
Can anyone tell me How do I solve this error.Error: NullReferenceException was Unhandled - "Object reference not set to an instance of an object."
Line: Dim reader As OleDbDataReader = dbCommand.ExecuteReader()
Database: MS Access
IDE: VB 2010 Express
[code].....
I am trying to add an order by case statement in the dbcommand.commandtext but i see that no rows are returned. I want to assign priorities for colors in the case statement. This would help me avoid create a new table to priorities and rewrite a lot of code to map the foreign key.[code]
View 2 RepliesIn WPF I'm trying to use commands to set all the content in multiple textboxes at once. The following code is able to get a command on the toggle button to execute for which ever textbox has scope but I can't seem to get the command to execute for both at the same time.
[code]...
Is what I am trying to do possible with commands? I would prefer not having to make direct references to each textbox in code behind inside a click_event or anything like.
In WPF I'm trying to use commands to set all the content in multiple textboxes at once. The following code is able to get a command on the toggle button to execute for which ever textbox has scope but I can't seem to get the command to execute for both at the same time.
[Code]...
I want to update data within multiple tables using sql command object. I have following codes which would not be updated the data.[code]...
View 4 RepliesI have several textboxes in a form, and have a button which inserts all the values in a Database and I have to clear the content of all the textboxes and focus to the first one right after pressing the button.Now I can easily do that using the Clear method of each of the textboxes but it takes 10-12 lines of code just for that. Can I do that in one go?
View 2 RepliesI'm using VB.Net to launch multiple command line window (same exe file) through Process.StartInfo. I would like to have those windows running at background without hanging main UI thread that launch them and at the same time able to get the output of those external window to show progress at progress bar.Here is a summary of what I'm trying to achieve but need further advise which way is feasible
- launch multiple exe command through Process.StartInfo
- don't want the external exe to hang my main UI thread
- need to get feedback from external exe to update progress bar which is placed at main UI thread
I've been searching for the answer for this all over, but I can't seem to find the solution. I have no idea how do this. A code that triggers an event after multiple command buttons are pressed in a certain order. For example: I press Command1, then Command2, then Command8, then Command5, then an event happens. It's kind of similar to entering a code to activate something.
View 4 RepliesI've found alot of examples for add/edit/delete a single table. In VB6 ADO you could load multiple tables into a recordset using the join command. Then manipulate or modify the data.
I've found how to retreive multiple tables like,
Da = New OleDb.OleDbDataAdapter("Select groups.groupid,groups.userid,lots.groupid,lots.lotid from groups inner join lots on groups.groupid=lots.groupid order by groups.groupid asc", DB) But the only way I have found to update is to use seperate Update commands for each table.
I need to open up a cmd prompt, then run a file called adb.exe which opens a shell to communicate with my android cell phone...
Heres what I need:
My Form1
Label1.Text = "adb.exe shell"
Label2.Text = "su"
Label3.Text = "mkdir /etc/folder"
[Code]....
Heres the problem... I can execute any normal dos command automaticly, but once i open the ssh prompt (adb.exe shell), i dont know how to keep putting commands in there...
The commands are stored in strings, and i need to take the commands from the strings, and type them into the command prompt like above.
I know how to use the default buttons item, but is there any way to achieve the style of multiline buttons (or maybe rather, "clickable text"?) like shown below?
The situation is that I have an interface for the user to select what kind of file he wishes to establish, and there has to be a brief description under the larger, main line of text.
I'm only planning to run this on Windows 7, so I don't need to worry about backwards compatibility with older versions of Windows
I created a Right-Click Menu option for files. When the user clicks the menu option it will copy all of the file paths to the clipboard.The following function I have will retrieve all of the filepaths to the clipboard. The problem lies in adding the filepaths to the listbox. If I turn single instance application off the result is multiple instance of the application for each filepath. Say for example I selected 2 files and clicked my right-click menu, I wind up with 2 instance of my exe with each file path added to the listbox, 1 in one listbox, the other file path in the second instance listbox.
Public Sub getthepath()
Try
Dim thefilepath As String
[code]....
Is there a way to loop through each file path from the clipboard and add them to the listbox through a loop?Several times I have tried different ideas I had that I thought would do it and I got odd results but never a good result.
First let me say that I am not sure whether or not this should go in this section or the API section, and if it needs to be moved I apologize. My issue is fairly straight forward, but for some reason I cannot get it to work.
I am trying to send a command to a command line and then submit the command. I have been trying without success to get this to work in v2008 Express and v2010 Express, Here is the code I am trying to us:
Private Declare Function FindWindow Lib "user32" Alias "FindWindowA" ( _
ByVal lpClassName As String, _
ByVal lpWindowName As String _
[Code].....
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]...
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.
Partial Public Class _Default
Inherits System.Web.UI.Page
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles
[code]....
Dim cmd As New SqlCommand("insert into fiche values('" & Me.TextBox1.Text & "')", connex)[code]...
View 2 RepliesIs 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 RepliesI'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]...
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]...
can i do ( ExecuteNonQuery within the loop of a datareader ) in vb.net please help me with example
View 3 RepliesI 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].....
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].....
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].....