VS 2010 : Xpath Query On A XML Returns 0 Results?
Nov 13, 2011
I've converted an html to XML and now i want to get all the child nodes nested within a DIV element with a specific attribute (class="itemInfo").Because the html that the XML is based on changes from time to time i want to use a more "safe" relative root,
(something like : "//div[@class='itemInfo']").Problem is that i always get 0 nodes ...
Dim doc As New System.Xml.XmlDocument()
doc.Load("products.xml")
Dim root As System.Xml.XmlElement = doc.DocumentElement
[code]....
View 6 Replies
ADVERTISEMENT
Nov 13, 2011
I've converted an html to XML and now i want to get all the child nodes nested
within a DIV element with a specific attribute (class="itemInfo").
Because the html that the XML is based on changes from time to time i want to use a more "safe" relative root,[code...]
Problem is that i always get 0 nodes ...I'm sure that something is wrong with my Xpath syntax, just don't know what it is. Here is my code'[code...]
View 7 Replies
Apr 20, 2012
how can write code that can check if __InstanceCreation query has returned rows or not. I'm using this code to check for the creation of a file
Private Function CheckForFileCreation() As Boolean
Try
Dim query1 As New WqlEventQuery( _
[Code]....
so I need to know if the query returned > 0 rows, if it did then the function will return true, if the query returned 0 rows then the function should return false. Sorry I am a complete noob with WMI and WQL
View 2 Replies
Apr 6, 2010
I am trying to perform a query on an Access 2007 Database Using Visual Basic 2008. My database has a table tblStudents contains a field named Gender with Male/Female options. In VB 2008 I set up a form with a Combo box where the user can select either Male or Female to perform a query and navigate through the returned results. When i choose the 1st option in the Combo box the results are returned in the order. However when i choose the 2nd option in the combo box, i get the results in reverse order which i still could not find the reason why it does that. Here is my Code for the query and the Execute Query Button:
Private Sub DisplayGenderData(ByVal gender As String)
connUsers.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:StudentRecords.accdb;Jet OLEDB:Database Password=testing;"
' Open the connection.
[Code].....
View 4 Replies
Feb 9, 2012
I am trying to read the HKEY_USERS hive of a remote machine with this Class
Imports System.Management
Imports System.Management.Instrumentation
Public Enum RegHive As UInteger
[Code]....
The value of sSubKeyName is the user's SID + "" + Network (e.g. S-1-5-21-1606980848-2025429265-839522115-560021Network). Now under that key are various subkeys containing mapped drive letters. But it never returns anything.
Strangely, if I use the OpenRemoteBaseKey method it works BUT I don't want to use that because using WMI lets me specify alternate credentials and OpenRemoteBaseKey doesn't
View 1 Replies
Aug 19, 2010
Here is the code:
Function getData(ByVal id As String)
Dim reader As SqlClient.SqlDataReader
Dim statement As String
[code].....
View 1 Replies
Jun 2, 2011
I've got an xml file that looks like this:
<Records>
<Record>
<table>[code].....
What I need is to select all the ROW nodes, across all records, so I'm using something like this:
rowiterator = Me.XMLDocument.CreateNavigator.Evaluate("//table/Row")
which is working, but it returns a NodeIterator that only contains the first Row node in the first record!? As far as I can tell, that's the proper syntax for an xpath expression of "return all Row nodes with a parent table name anywhere in the document".
View 1 Replies
Apr 29, 2012
I'm trying to find a way where i can make it loop through the results of my capture group regex query.
For instance if i have this:
VB.NET
Dim matches = Regex.Matches("<h1><span>test</span></h1>", "(?<=<h1>(<span>)?)(?<data>.+)(?=(</span>)?</h1>)")For Each item In matches.OfType(Of Match)()Console.WriteLine(item.Value)Next
And i'm trying to get the contents of <data>, how do i do it without it printing out the junk before it and after it?
quantifier isn't working, its supposed to make the <span> tag optional in the query, but it isn't.
View 2 Replies
Sep 24, 2011
I wanted to know how to write a query in data grid control. So far I've seen alot of forums but they are related to either 2008 vb or vb 6. how to write a query in the datagrid control which will search for an id in the database of access and present it.
View 2 Replies
Oct 28, 2010
Why this api in VB.net does not return right results. in my pc the X,Y results are ndefined.
Code:
Imports System.Runtime.InteropServices
Module Module1
[code].....
View 3 Replies
Dec 9, 2011
I have an application that encrypts data which is written in VB. There is another application that uses the same data. Encryption code is the same but it returns different result in some cases. [Code]
View 2 Replies
May 29, 2009
We recently came across some sample code from a vendor for hashing a secret key for a web service call, their sample was in VB.NET which we converted to C#. This caused the hashing to produce different input. It turns out the way they were generating the key for the encryption was by converting a char array to a string and back to a byte array. This led me to the discovery that VB.NET and C#'s default encoder work differently with some characters.
C#:
Console.Write(Encoding.Default.GetBytes(new char[] { (char)149 })[0]);
VB:
Dim b As Char() = {Chr(149)}
Console.WriteLine(Encoding.Default.GetBytes(b)(0))
The C# output is 63, while VB is the correct byte value of 149.if you use any other value, like 145, etc, the output matches.Walking through the debugging, both VB and C# default encoder is SBCSCodePageEncoding.I have corrected the sample code by directly initializing a byte array, which it should have been in the first place, but I still want to know why the encoder, which should not be language specific, appears to be just that.
View 5 Replies
Mar 11, 2010
how to take a query that returns a single row of data and load that data into textbox controls.I know about ExecuteScalar but it is only good for a single column of data from the query.
View 2 Replies
May 31, 2012
I'm struggling to return user details from AD using LDAP, after i have authenticated that the user exists. I am using a simple auth method as follows:
Function AuthenticateUser(path As String, user As String, pass As String) As Boolean
Dim de As New DirectoryEntry(path, user, pass, AuthenticationTypes.Secure)
Try
Dim ds As DirectorySearcher = New DirectorySearcher(de)
Dim result As SearchResult = ds.FindOne()
[Code]...
the problem is that "distinguishedName" returns "DC=our-domain,DC=co,DC=uk" and "name" returns just "our-domain", not the name of the user that has just been auth'ed
Note: the displayName.text outputs are purely for debug purposes.I have tried various combos of requests but nothing seems to return USER details. ETA: to the security police: this is all within a https connection, I'm not sending passwords about in plain text!
View 1 Replies
Jul 27, 2010
I have a XML file on which when I run a Linq query returns nothing in the for loop.
View 2 Replies
Oct 24, 2011
I am using the OLEDB adapter (Oracle OLEDB) with Oracle 10.2.0.3.0. My code generates the SQL for the query, then when I execute it into an OLEDBDataReader, the HasRows is False. However, if I output the contents of the query string, copy, and paste into SQL+ (logged in as the same user from the same client machine), it returns 993 rows. What gives?? Here's a segment of my code:
[Code]...
View 2 Replies
May 3, 2012
I have a query that 'selects' object of a type:
Dim l as IList(Of Foo) = (From dataRow As DataRow In table.Select()
Where CStr(dataRow("Column1")) = "A"
Select New Foo(CStr(dataRow("Column1")), _
CStr(dataRow("Column2")))).ToList()
What's happening is that if i set a break-point to the constructor of Foo and step, the constructor is hit and the parameters are loaded with the arguments. However, l has empty Foo objects (the members in every object are Nothing). What could be happening here?
View 1 Replies
Aug 31, 2011
This is my first time using the Entity Framework and I'm getting some confusing results. I know a particular table contains 3 distinct rows when I run this SQL query:
SELECT * FROM mytable WHERE service_month = 201012
When I run this query against the framework however, I get 3 rows, but they are all copies of the first row (VB syntax).
Dim temp = _context.mytable.Where(Function(x) x.service_month = 201012)
Did I set up something incorrectly? This is how I'd do it with LINQ to SQL.
View 1 Replies
Jul 8, 2010
I'm trying to update an Access database by using an OLE connection, retrieving the information from textboxes where the user enters the new information.All the fields in my Access table are required fields, so I have validated that some info is entered in each one of the textboxes and that is the correct data type.But when I run the update query I get an error message saying something like values haven't been entered for some required parameters (my Visual Studio is the Spanish version, so I can't give the exact error message in English).The bit of code where the error occurs is inside the procedure called by my "Ok" button:
Dim campo1, campo2, campo3, campo4, campo5 As String
Dim campo6, campo7, campo8 As Double
Dim campo9, campo10 As Integer
[code]....
(I didn't post the whole code inside the procedure, but of course I'm creating the connection and everything)
The table has 10 fields, and the data is read from the textboxes and stored in variables (campo1, campo2, campo3, etc.), which I'm then using in the "set" query command.
"id" is the first field from the selected row in the datagrid, which I'm sending as a parameter to the procedure called by the "OK" button.The error message shows at runtime, so I'm guessing it's something in the query. Am I writing it correctly?
View 3 Replies
Mar 15, 2011
I have setup an OleDbConnection and my query works just fine but the problem I am facing is that I want the entire query not just a certain row or column. I also would like to place this entire query into a blank excel spread sheet.[code]
View 1 Replies
May 8, 2012
I have a select statement which was returning the required values but when I changed the OS date from English(US) to English(UK), it now returns null. I believe the problem is concerned with date since in the query am selecting values where the date from the database is the same as the date in a combobox but I don't know what else I can do. It almost looks like the dates in the combox and in the database are not the same and yet the date in the combobox is actually retrieved from the database and has been returning values fine until I changed the system date format.Here's my select command:
cmd4.CommandText = _
"SELECT sum(brought_qtty), recieved_qtty from brought_coffee, centre_weigh where brought_date=#" & _
dtComb.Text.Trim & "#" & _[code].......
View 1 Replies
Sep 29, 2011
So I'm writing a query as follows:
Dim assSummary = From a In db.Assignments
Join ur In db.UserRegions
On a.Origin.ID Equals ur.Region.ID
[code]....
In the controller I can return the data easily as follows:
For Each c In assSummary
MsgBox(c.Description & " " & c.AssCount)
Next
If I pass the object through to the view using Viewdata("assSummary") = assSummary, how do I display the data? Every method I've tried results in messages about 'VB$AnonymousType_7(Of Integer,String) and I don't know how to retrieve the data from the anonymous type.
View 1 Replies
Feb 3, 2009
If this is in the wrong section, I have a program that queries a database and puts the info in a specific format in a txt file. Now my problem comes w/ how to format the date.
Should I format the date in the SQL query OR is there a way to take the result from the query and format sometime before it is writen to the txt file? I'm not exactly sure how to do either. Would I need a subquery to get the desired date format?
[Code]...
View 5 Replies
Apr 22, 2009
I am using an access DB and wanted to create a query that returns user's in the db. First I need to check the db to see if it is empty. Then I need to check to see it my query returned any values. How do I go about doing this?
View 6 Replies
May 8, 2011
I'm a bit confused on how to grab query results. With VBA i would open a record set and have the results of the query written to that recordset. IN VB.net how can I grab the query result and throw each column into specfic arrays?[code]Now how would I force it to query my DB? I have a connection established already.After the query how can i play with the columnes and place them into arrays?
View 2 Replies
Sep 11, 2009
I have used linq quite abit but was just wondering how to append the results of two IEnumerable(of X) together into one IEnumerable(of X)
View 4 Replies
Aug 22, 2011
I had this query sp_msforeachdb 'select "?" AS db, * from [?].sys.tables' when I execute it in sql server, it return multiple results. How I can read all the results in my vb?
View 2 Replies
Oct 5, 2011
I have the following code in my program: Dim empenrollments = From enroll In db.EnrollmentSummary(eid)
Select New With {.Name = ename, enroll} Dim elist = empenrollments.ToList returns this error
In the following lines, I have to get each row in the returned results and add it to a DataTable, but it never gets there.
[Code]...
View 4 Replies
Feb 27, 2009
I am familiar with the VB6 ADO way of dealing with SQL queries and looping through the record set results.
However, what is the correct way to query a server, cycle through the results, and dispose of my query in VB.Net? All the ways I have been using seem to be unstable and crash randomly.
I have been using the following code:
Public Function GetSQLTable(ByVal strSQL As String) As DataTable
Dim table As New DataTable
Dim adapt As SqlDataAdapter
[Code].....
View 1 Replies
Apr 9, 2012
I am learning VB.NET and wanted to try and connect to a Oracle.DataAccess with this simple SQL Query but am stuck how to get my results.
Imports Oracle.DataAccess.Client
Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click[code].....
View 16 Replies