Querying XML With LINQ By Attribute?
Mar 2, 2012
Given the following XML file:
<users>
<user name="admin" password="foobar" roles="Admin,Guest" />
<user name="guest" password="foobar" roles="Guest" />
</users>
How do I find a specific node? In this case I want to find the node that has its name attribute to be "admin"
Dim authGroup As XElement = XElement.Parse(myXMLDoc.OuterXml)
Dim foundUser As IEnumerable(Of XElement) = From i In authGroup.Elements Where i.Attributes("name") = "admin" Select i
[Code].....
View 2 Replies
ADVERTISEMENT
Jan 24, 2010
I have been looking into dynamic querying of datasets and the use of copytodatatable() for a project. I have seen in alot of forums that the copytodatatable functionality is unusable as it was removed. have an example of a dynamic Linq query being loaded into a datatable.
View 1 Replies
Jun 29, 2010
How do I return a top 5 with rank number using linq?
Dim Top5 = From A In DAO.Cache.Select(Of VO.Empresa).Take(5) Select A.Nome
I would like this result:
Rank Name
1 "Example Name"
2 "Example Name"
3 "Example Name"
4 "Example Name"
5 "Example Name"
View 3 Replies
Mar 10, 2012
I am trying to query from search box using list of data and the linq I used is:data = (From k As BSPLib.ContactLib.Contact In data_org.Values Where k.stringdata Like "%" & Searchtxtbox.Text & "%" Select k.prime).ToListBut this is not working, I am getting no data at all. Data_org is a dictionary so I used the values; k.stringdata contains all the data that need to be searched. Searchtxtbox.text contains the user defined search item.I Tried with sqlmethods through linq, but sqlmethods does not exist for me, I tried with with Imported namespace yet the code is not showing sql methods, could you please provide a workable query or just tell me where I have gone wron
View 2 Replies
Sep 19, 2009
I am having a little problem with some homework. Here is the problem:Use the Invoice Class provided to create an array of Invoice Objects. Class Invoice includes four properties- a PartNumber (type integer), a PartDescription (type String), a Quantity of the item being purchased (type Integer), and a Price (type Decimal). Write a Console Application that performs the following queries on the array of Invoice objects and displays the results:
[Code]...
View 3 Replies
Jun 5, 2012
When I try to query an entity that has a varbinary field in it I am getting error:"The LINQ expression node type 'ArrayIndex' is not supported in LINQ to Entities."
Here is my query:
Dim query = From entity In db.Entity
Where entity.Id= Id
Select entity.VarBinaryField
[code]....
The error gets generated when I check that the query isNot nothing.
View 1 Replies
Sep 20, 2009
Use the Invoice Class provided to create an array of Invoice Objects. Class Invoice includes four properties- a PartNumber (type integer), a PartDescription (type String), a Quantity of the item being purchased (type Integer), and a Price (type Decimal). Write a Console Application that performs the following queries on the array of Invoice objects and displays the results:
a. Use LINQ to sort the Invoice Objects by PartNumber
b. Use LINQ to sort the Invoice objects by Price
c. Use LINQ to select the PartDescription and Quantity and sort the results by Quantity
d. Use LINQ to select from each Invoice the PartDescrition and the value of the Invoice (i.e. Quantity * Price). Name the calculated column InvoiceTotal. Order the results by InvoiceTotal.
e. Using the results of the LINQ query in Pard d, select the InvoiceTotals in the range of $200 to $500
I am pretty sure I have parts a, b, & c completed correctly. Or at least the provide the desired results. Part d I figured out how to multiply the 2 fields but can't create a new column for the result or figure out how to show the PartDescription with the multiplied result. Part c I think I can figure out when I get part d. I already coded what I think will work for part c.
Below are the 2 Objects the Invoice was given and not to be changed & the LINQ is the one I have been working on.
Module LINQ
Sub Main()
' array of invoices
Dim invoices As Invoice() = { _
New Invoice("83", "Electric Sander", "7", 59.98), _
[Code] .....
View 3 Replies
May 21, 2012
what im trying to do is, i have the following xml:
Postcode id="E20 2AP" from="test1" to="test2"/>
im tring to search for the postcode id and then get the from and to text from that id the code i have:
Public Shared Function GetFromDate(ByVal PostCode As String) As String
Dim LoadToAddresses = From ex In doc.Descendants.Elements("Postcode") Select New With {.accountName = ex.Attribute("id").Value, .datefrom = ex.Attribute("from").Value}
[code]....
this works but it returns:
{ datefrom = test }
i just want it to state "test"
View 1 Replies
Apr 8, 2011
I'm trying to use LINQ to XML to create an Excel spreadsheet. I created a template spreadsheet, exported it to XML, pasted the XML into my code and then began to edit it. When I try to create a set of XElements using LINQ, I get these errors:
The first squiggle under <Cell> says "attribute specifier is not a complete statement"
The second under ss says "'>' expected"
The third under Type says "'Type' is a type and cannot be used in an expression"
Ignore the error under "Lot 1..." I will be putting an expression hole there.
The squiggle under </Cell> says "Identifier expected".
View 1 Replies
Feb 25, 2010
If a node belongs to a namespace, it's children by default belong to the same namespace. So there's no need to provide an xmlns attribute on each child, which is good. However. If I create two nodes like this:
[Code]...
View 1 Replies
Nov 27, 2011
here any algorithms/pseudocode for reading/parsing 3-column csv data and determining unique objects/attributes/values?
example data:
john,height,1.75
george,age,21
[Code]....
i have already implemented a solution of my own but it's too slow and i can't find any relevant literature on the internet.
View 6 Replies
Nov 10, 2011
Possible Duplicate: Unrecognized attribute 'targetFramework'. Note that attribute names are case-sensitive
I am using window xp and iis 5.1 to run the application.
error is occurred Unrecognized attribute 'targetFramework'. Note that attribute names are case-sensitive.
[Code]...
View 2 Replies
Feb 2, 2012
I get an error when I try to build my project.'SSLAccessFiltercannot' be used as an attribute because it does not inherit from 'System.Attribute'. [code]
View 1 Replies
May 25, 2009
IErrorInfo.GetDescription failed with E_FAIL(0x80004005).I get this error when trying to send a query to a database. Its an access 2000 DB. Google suggests the error indicates that I am using a vb keyword as a field name or table name. I have checked with these here and can't see anything that matches.
View 6 Replies
Apr 12, 2010
I'm using VB.net for a project i'm building for a friend. He has access to data on all the schools in our country and also data on the local area Authorities which run these schools. I have a database with two related tables; 'TBLlocalauthority' and 'TBLschools'. Each localauthority can have several schools, but each school can only have one local authority.
[Code]...
View 8 Replies
Sep 10, 2010
Is there a particular class in .NET available that will allow a user to query IIS to see what websites are running on the local server? I would like to try to write a simple program that programmitically lets me know which websites are running in IIS along with some basic information about them. Can this be done in VB?
View 3 Replies
Jun 15, 2011
Whenever I have
Dim catID as integer
And I use this in a query like this:
cmd.CommandText = "select * from categories where parentid='" + catID + "'"
I get:
Conversion from string select * from categories where p to type Double is not valid.
Why is it so?The parentid datatype in sql is integer.
View 3 Replies
Aug 7, 2010
My form has a DateTimePicker and a DataGridView on it. I need to have it query a SQL Server DB and return the table to the DGV. The query is to search the Date_Joined field for date less than the date that the user input with the DTP. With the code below, my DGV is populated with all data and not the filtered data I need. I also have added a Go button for the purpose of execution instead of using the ValueChanged sub for the DTP.
Private Sub btnGo_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnGo.Click
Dim query As String
'dtpDateJoined is a DateTimePicker on the form
[code].....
View 6 Replies
Jun 11, 2011
Is it possible to re-use a DataTable in .net? Here's an example from code-behind:
[Code]...
View 3 Replies
May 28, 2009
I have some sql statement error while querying the DB and to display the result on a data grid view. Could someone check the codes below and let me know the problem with the codes.
Dim cm As New System.Data.OleDb.OleDbCommand
Dim rd As System.Data.OleDb.OleDbDataReader
Dim Conn As OleDbConnection
[code].....
View 1 Replies
Dec 24, 2009
I`d like to do a query to a SQL server database using the statements like "SELECT...FROM...." an so on. Then I`d like to save results of the query to an array or other variables. I`d like to handle the data of the query results "manually". I don`t want to use the datagridview and tableadapters and so on which are created when I drag a table from the datasources window to the form. is the ADO.NET and datasets the right tool at all? If yes, I believe these are the first steps needed:
- create a connection string
- create a connection and open it
- create a dataadabter
- create a dataset and populate it with the dataadabter
The first problem is the connection string. When I create a connection to a new data source in datasources window, a string is created and saved to some configuration file. Can I use it and how?
View 8 Replies
Mar 15, 2012
Basically for normal select queries from my database I have no problems as I would put the following and then bind it to a controller to display the iteam, however now I am trying to query sum of a field from the database, but I think it should be different as It's giving a Nullable value:
SELECT SUM(PointsRedeemed) AS tAward
FROM [Transaction]
WHERE (BusinessId = ?) AND (CardNo = ?)
[Code]....
View 3 Replies
Jan 17, 2011
the remaining code for my vb.net project? In my Project, I have a table name tblBatch that has a field name btchGravel. Since in my project, a field name gravel has more than 10 inputs from the 10 textboxes in my main form. I manage to save it in this manner:
'Save the textboxes in a single string, separated by comma
Dim GravelLine As String
GravelLine = txt1G.Text & "," & txt2G.Text & "," & txt3G.Text _
[code]......
View 2 Replies
Nov 25, 2010
I am trying to create a stock scanner which allows users to filter stocks based on multiple criteria that they select. Like the following example with 2 criteria:
Criteria 1 Filtered Result: StockA, StockB, StockC, StockD
Criteria 2 Filtered Result: Stock B, Stock C, StockE, StockF
SCANNER RESULT: Stock B, StockC (ideally this result would be displayed in a GridView)
[code]......
View 2 Replies
Oct 8, 2010
good afternoon people, i got a problem here on my program, i need to query from a different tables in database but it gives me error, here is my code
[Code]...
View 6 Replies
Mar 23, 2010
vb
Dim conn As New OleDb.OleDbConnection(ConnStr)
conn.Open()
[code].....
View 3 Replies
Oct 2, 2009
I have a DataTable filled with employee names and hours. I want to query that data to make a list of all the unique employees and the total hours for each, but I don't know how to do that. If I were to query the database directly I would do something like this
View 6 Replies
Oct 16, 2010
I'm using this function to return a value from multiple databases across three SQL instances (On the same server). I'm looping though a DataGridView that lists all the databases on one of the three SQL instances.Is there a faster way of doing this? It's quite slow using this method.
Function DatabaseStatus(ByVal SQLServer As String, ByVal Database As String)
Dim myConn As New SqlConnection("Server=" & SQLServer & ";User Id=USER;Password=PASSWORD;Database=" & Database & ";")
Dim Status As String = ""
[code]....
View 2 Replies
Jun 13, 2012
querying a remote Access database! We are currently using this because thus far we have failed at hooking up a sp_linkedserver. I feel like it's a terrible hack and want to be done with this whole network mapping business once and for all!
[Code]...
View 1 Replies
Mar 18, 2010
I am querying a date from my Access 2007 database in the format: MM/DD/YYYY It's then saved as a string
Depending on the month and day, it might be 1 or 2 characters. To set the DateTimePicker, it takes it as this format: DateTimePicker.Value = New DateTime(YYYY, MM, DD)
How can I switch around the characters in my string so that it can satisfy the format the DateTimePicker wants? I was thinking about some kind of reader that "consumes" characters until it reaches a delimiter ("/") and then does something with it. I remember doing that in JAVA but not in VB.NET
View 2 Replies
