what is the exact meaning of the function:
cmd.ExecuteNonQuery()
Though i used it a lot of times while inserting,updating or deleting the entries of the database but my basic concept about this statement is not clear.......
I was just wondering what is the meaning of placing the '$' character after a function call
E.g.: Dim time as string = Format$(Now, "Long Time")
And what is funny is that it is of no use (as far as I can see).
whenever we go to code by double clicking on some control so we saw a body of two lines:
Private Sub Button11_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button11.Click
end sub
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]...
Here is my xsl:
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:template match="/">
<html>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"/>
[code]....
The problem is the class="pass_section" in the xsl. I need to set that value dynamically in the VB code (meaning put a run-time value in the xml to set it).
How to make my own "My" librayr. I want to make exact function like in .Net
My.Resources
System.Data
that everytime i enter period on the library another sub library will come up.
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] ......
what exactly is the type of the second argument of CType
CType(testobject, Control)
what exactly is Control? how can Control be used as though it is an expression?i nid to know this because i'm trying to build a function that takes the exact parameters of CType, let's call it CType2public function CType2 (byref object as Object, byval thetype as Type) as Object problem is when i do this: CType2(testobject, Control) they give me "Control is a type and cannot be used as an expression".
I need to calculate the age in Years,Months and Days for which i am using the following code, but it give inappropriate result
[Code]...
I have the following search code which works fine. However, I have an additional task to do, which is create a count function for the Record found or Record not found. Presently what it does is it searches and if a record is found it displays at the tooltip "Record Found" if not it says "Record Not found". However, sometimes you have 2 or more records. Therefore, the tooltip should say the exact amount of records found.. For example, 3 Records Found or even 5 Records Found. Also if only one record is found it says "Record Found" but if more it should display " 2 Records Found".
Private Sub btnPerformSearch_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnPerformSearch.Click
' Declare local variables...
Dim intPosition As Integer
' Determine the appropriate item selected and set the
' Sort property of the DataView object...
[Code] .....
Im trying to DELETE all records within a access table, this is my
[code]...
But it gives me the following error: ExecuteNonQuery: Connection property has not been initialized.
What is the meaning of having constructors (sub New) in a module, and why must they have no arguments?
View 4 RepliesIm doing a project something to do with getting the output using serial port.However, I still don't get the meaning of vbCr in my coding.
View 3 Repliesfor example. like a wikipidea or like apple is to eat or something..
View 7 RepliesI have Ln in my function that I write in excel but in vb it doesn't work
0.215*Ln(4.32/0.3)
it should return the value = 0.573
how can I write this function without using log function (I don't know logs functions)
get Intellisense in Visual Studio 2005 to display the meaning of individual enum values for a VB.NET project. This already happens for enums that are a part of the .NET library?
View 2 Repliesi want to know the meaning of false,false in the following code for odbc connectivity using vb6.0.
set db=opendatabase("dsn",false,false;"odbc;uid;pwd;dsn")
what is the meaning of the dollar sign after a method name in vb.net
like this:
Replace$("EG000000", "0", "")
What is the meaning of the square brackets around the name of a property in the definition ?
Example :
Public Property [Date] As String
i have a simple code just have a look End Class
[Code]...
When i add num1 and num2 as above, compiler gave error that -- Operator + is not defined for types "type" and "type".How to define the meaning of '+' or any other operator in such situations?
I have defined a Sub in vb.net, with 'Of' type parameter like this:
[Code]...
I want to just add number1 and number2, But as you can see error has occured where i want to sum number1 and number2 saying that '+' is not defined for type 'VarType'. how to add these variables in Such Methods.
I have a simple javascript I want to run in a contentpage (meaning inside a master). I test the javascript in a normal .aspx page like this:
HTML Code:
code:
And that works fine. Now, how do i transfer the java code to the content page? I just don't know where to put it, as I am already past the "Head" section of the page. From what i can read this should be right:
HTML Code:
code:
But that just returns an "error on page" message. I also tried putting the script in the head section of the masterpage. The error remains the same, and I do not want it there anyway. Anyone know where to place the script code?
Some of my students end up with a different icon in the Solution Explorer when they create applications. An example is the attached Exam.vb icon, which includes a little arrow into the normal Form icon (see pic) . I am guessing it means it is linked some how. When the application is zipped and submitted, an error is thrown when I unzip it to grade it which indicates that the file in not part of the project, and it references the absolute address on the original application.Any idea what caused this and how can I instruct the students to avoid it in the future?
View 5 RepliesWhat is the most similar thing in vb.net to a pointer, meaning like C poinetrs? I have a TreeView within a class. I need to expose some specific nodes (or leaves) that can be modified by external objects.
View 5 Replieswhat is the meaning of the Ampersand after Boolean in "Result as Boolean"? Also I have seen a question mark after Boolean in some 'Dim' statements. What does that mean?
View 3 RepliesThis webservice is almost converted form VB to C#, except I get this error shown below on the DataRow arow object when I use it in the foreach statement below to populate the Results Class with a DataSet Object...
Error: A local variable named 'arow' cannot be declared in this scope because it would give a different meaning to 'arrow', which is already used in a 'parent or current' scope to denote something else
using System;
using System.Web;
using System.Collections;
[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 Replies