I receive teh following error message;
Incorrect sytnax near the keyword 'where'
query = "INSERT INTO dbo.TblPracExclude (prac_no, prac_name, prac_status, prac_enabled) VALUES (" & _
DgvPracExcl.Rows(RowID).Cells(0).Value & ", '" & _
[Code]....
I am new to VB.NET. I'm trying to add a table to an ASPX page. But I get the above error with the following code. Can you tell what I am doing wrong? I want many table rows returned; one for each product, where first cell = product name, cell 2 = NumOpen, and cell 3 = 95%.[code]
View 2 RepliesCurrently using Microsoft SQL server 2008 in Visual Studio 2010
spot the mistake near the keyword 'INNER'
Dim selectSQL As String _
= "SELECT M.MID, M.MT, MS.SD, MS.TS" _
& "FROM M " _
[Code]....
I've got a GridView. My SelectCommand in the code works if I copy and paste it into SQL Server Management Studio. It executes fine.If I run the page and click Edit for any row I get the error:
"Incorrect syntax near the keyword 'IS'."
I've tried to see what's going on using SQL Server Profiler. Here's what the SelectCommand looks like and what SQL is receiving...
SelectCommand from supplies.ascx
SELECT some stuff FROM here WHERE (this IS NULL) and (that=1) ORDER BY this DESC
SQL Server Profiler reports
SELECT some stuff FROM here (this IS NULL) and (that=1) ORDER BY this DESC
I didn't put any code here because I'm not really sure what would be relevant and didn't want to load up the post with unnecessary lines of code.
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="fldSupReqID"
DataSourceID="SqlDataSource1"
EmptyDataText="There are no data records to display." AllowSorting="True"
[code]....
I am trying to create INSERT SQL using WHERE syntaxing in order to ensure no duplication with the SQLCMD.PARAMETER but the WHERE clause generate this error message:Incorrect syntax near the keyword 'Where'.
Here are the coding:
Dim strSql As String
strSql = "Insert into tblCustomers "
strSql &= "(CustomerID, ContactName,Address,City,PostalCode,Country)"
[code]....
I am trying to create a Datagrid at runtime. This I have done on other forms no problem yet on this I get a error:
"Incorrect syntax near the keyword 'FROM'." And the the following "In order to evaluate an indexed property, the property must be qualified and the arguments must be explicitly supplied by the user."
[Code]....
query = "UPDATE tblProjectPatients SET " & _
"Yes =" & CBool(DgvReturns.Rows(irow).Cells(2).Value)& ", " & _
"Where ProjectID= " & _
txtProjectID.Text & " and Prac_eid = " & _
txtpraceid.Text & " and prac_no = " & _
txtPracno.Text & " and Vision_PatID= '" & _
DgvReturns.Rows(irow).Cells(0).Value & "'"
Error Prompted - Incorrect syntax near the keyword 'Where'.
i just want to make a program with first form to enter the serial if correct just continue to form2 if incorrect just a popup say like "Serial Incorrect" how i can make it ?
View 2 RepliesProtected Sub Menu1_MenuItemClick(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.MenuEventArgs) Handles Menu1.MenuItemClick
End Sub
In VB.net, we have the Handles keyword, I'm wondering if C# has anything comparable. Or do you have to manually wire all the methods to each control's event (in ASP.NET especially)?
Possible Duplicate: WITH statement in Java? does anyone know if there is the With Keyword in Java?
View 4 Replieswhy use of namespace and use keyword and declaration of namespace
View 1 RepliesPossible Duplicate:Default value for generics k so while translating some code from c# to vb, i came across the default keyword, and I'm simply replacing it to nothing.
View 2 RepliesIn my current project everyone names variables and methods after what they are and what they do. This is good for quickly understanding the code, but with a lot of long varible names comes some headaches, such as when copying a dataset to an entity/object. So, while you understand the code, the readability still takes a blow.
veryLongVariableName.Id = datasetVeryLongVariableName.Id
veryLongVariablename.Something = datasetVeryLongVariableName.Something
etc.
Using VB.NET's With keyword can help.
With veryLongVariableName
.Id = datasetVeryLongVariableName.Id
.Something = datasetVeryLongVariableName.Something
End With
Now, my question, is there any way of using With, or something similar, but for several variables at the same time? Something like:
With veryLongVariableName As a, datasetVeryLongVariableName as b
a.Id = b.Id
a.Something = b.Something
End With
I'm all for descriptive naming conventions, but they do tend to clutter things. Especially in VB!
I m trying to create a software in vb.net for some genealogists to trace their ancestors History, the users will search for the document in 3 ways
1. reference number from a combo box.
2. By the title of the document.
3. by inserting a keyword from the documents abstract..
i have already loaded the picture. i hav put all in one note pad my reference no., on next line i put my abstract and on the third line i put my path where the document is located.in coding i put all in different array.... making the program read all one by one line wise.i want to make search thru the keyword... means wen user inserts a key word in the textbox the program read all my abstract and then in a drop down it should display the documents that match the keyword.
Its work well in windows 7 but when i run project in windows xp its says i must use New keyword but when i use New its gives error at regkey.GetValueNames and RegistryKey = Registry.LocalMachine and regBaseKey.OpenSubKey("SOFTWAREMyApp", FalseImports Microsoft.Win32[code]...
View 4 Repliesin C# you'd put a @ in front of a reserved keyword. Is there any equivalent in vb .net?
View 1 RepliesI have to serialize/deserialize a class into a JSON string/and return. The JSON Strinig must contain the "error" string (like: {error:"something strange occoured", id:23, result:"xxxxx"}), which specifies the occoured error.
How can i implement a class like:
[code]...
If i do this, the word 'error' is invalid.
I use the Call keyword when calling subs in VB/VBA. I know it's optional, but is it better to use it or leave it off? I've always thought it was more explicit, but maybe it's just noise. Also, I read this on another forum: Using the Call keyword is faster because it knows that it is not going to return any values, so it doesn't need to set up any stackspace to make room for the return value.
View 4 RepliesFirst off let me say that I am essentially new to VB.NET, i.e; still learning. Also, I hope that this is the right place to post this question. In a Project I have a Class module defined as:
Public Class Def
Public Id As String
Public Meaning As String
[Code]...
I used to have this one
Dt = MyMod.GetDataTable("SELECT TOP " & QuestionsPerCats(i) & " * From Questions WHERE CategoriesID ='" & Cats(i) & "' ORDER BY NEWID()")
but now i decided to use sqlparameters like
Dim cmd As New SqlCommand("SELECT TOP @QuestionsPerCats * From Questions WHERE CategoriesID = @CategoriesID ORDER BY NEWID()", conn)
Dim sqlParam As SqlParameter = Nothing
sqlParam = cmd.Parameters.Add("@QuestionsPerCats", SqlDbType.SmallInt)
[code]....
and returns the following error
Incorrect syntax near '@QuestionsPerCats'.
It was suggested that I use xmldocument.load to do a sql insert statement instead of BULK INSERT.However when I run the Sub I am getting this error: "Incorrect syntax near '<'. "Here is my code, I have no clue what is causing this error, or how to fix it.
Sub AO()
Dim Z As String = Microsoft.VisualBasic.Format(Today.AddDays(-1), "MMddyyyy")
Dim AO_Name As New String("\NetImportAO-M_" & (Z) & ".xml")
Console.WriteLine(AO_Name)
[code].....
I have to inherit some legacy code in company, which is written in Visual Basic.NET 7.0 (Visual Studio.NET 2002). I don't have much experiences in VB.NET, and this line of code gets me in trouble:
Public Class Global : Inherits System.Web.HttpApplication
Visual Studio gave this error: Error 31Keyword is not valid as an identifier.C:Documents and SettingsAdministratorDesktopPOManWebApplication1Global.asax.vb414C:...POMan
What is this keyword how can use it?If Page.IsPostBack = False Then
View 3 RepliesI generally use to organize codes below lines;
#Region "Comments.."
#End Region
But when I want to use it in the Function, it gives error ("..are not valid within..."). Are there any keyword to make this in the Function or there aren't? [Code]
I generally use to organize codes below lines;#Region "Comments.."#End RegionBut when I want to use it in the Function, it gives error ("..are not valid within...").
View 2 RepliesI'm still new in VB.net development environment, i've few of the question may need the advice from you guys to see whether i'm in the right track for the development as below condition:Basically my program wrote from this logics:
Condition:
2 log files available in C drive that is C:/BSKYB/Prod.txt
and C:/BSKYB_CWE/many of log files in .txt format
Program Flow:
Step 1: The program will read the last sentence Hexa number from the file "Prod.txt"
Step 2: Once the program detecting the keyword like example "abcde" it will go to another folder which is descript in C:/BSKYB_CWE to look at which text files contains the keyword "abcde"
Step 3: this step will capture the whole line the text info like example 1111 abcde
if in this case, once the abcde detected what is the command i should apply to capture the key word 1111 ?
This is the problem i have encounter right now, i doesn't know how is actually can apply the right method to read the whole text line once the key word is detected
Public Class Form1
' Const ConstBSKYB = "C:BSKYB_CWE.txt "
'Const ConstBSKYBP = "C:BSKYBProd.txt"[code].....
We have a keyword 'app.path' in VB6 What is the equivalent key word in VB.NET
View 1 RepliesIn C# you can do this to make your member variable immutable: public readonly int y = 5; What is the equivalent "readonly" keyword in VB.NET?
View 1 RepliesI am aware of the 'topmost' keyword in VB.NET for specifying a window to be brought to the front or top of the display windows showing. However, specifying 'xlApp.topmost' is resulting in a compile error in my VB 2010 Express project; most likely because my project doesn't include a reference that it needs for 'xlApp.topmost' to start working. What reference do I need to add?
View 2 RepliesMost of our development is done in vb.net (not my choice) and one frequently used code pattern uses an 'On Error GoTo' followed by a 'Resume Next' so that all database fields can be read with a DirectCast() and any DBNull values are just ignored.
The current code would be
On Error GoTo error_code
oObject.Name = DirectCast(oReader.Item("Name"), String)
[code].....