VB 2008
I want to convert a LINQ query to datatable.
I'm using this code:
Dim Var051a As IEnumerable
Dim tableVar051 as DataTable
Var051a = From ...
Dear experts,
I am having a problem with a fairly simple LINQ statement where the order by clause is not working. I have found out that this is because I am using "distinct" in the statemen...
i need linq query for highest salary and Second highest salary.
I'm trying to return all records that were entered on a specific date from an SQL database.
I need to strip out the time element of the datatime datatype field otherwise the date comparison w...
Hi Experts,
I am trying to use a group by expression but am not able to obtain what I want.
Below is what I am working with. Essentially I want to be able to select a variety of columns ...
Friends,
I have a Dictionary, and the Key is simply a ping sequence number, and the values are comprised of Host (string) and ResponseTime (integer) and they are simply inside a class (see ...
I have two tables, SQL and RUN_HISTORY. The table SQL contains SQL's that can be executed by a user. RUN_HISTORY contains a record for each user that runs an SQL to keep track of when it was ...
I have built a website in a classical manneer :
- Apache 2
- PHP 5
-MySQL 5
- powered by MAMP Pro
My app is NOT organized as a framework ! I just want to use Zend_Mail from the framewor...
My XML structure and code are listed below...
When I try to run the code, I get the dreaded "Object reference not set to an instance of an object." error. I'm pretty sure the XML is good, ...
Hello,
Working abit with Linq, and it really seems cool and i would really like to replace SQL actions with this, and generally use linq for processing data.
But im wondering if theres a...
I have not started using linq and not sure if this could be done any easier using linq. I have a dataset with a master and detail tables. (created with an sql stored procedure). In order to...
I have a form that has a parent child relationship between 2 tables. A grid shows the info of the child table. If I add a new master record a trigger in SQL creates a record(s) in the child ...
Friends,
I need help with Linq, to get multiple values out of a Hashtable for the Top 5 TotalRaceRankFactor_Entrant
You can see below how I declared the values in the class, attached to ...
Hi ,
how to union the return value with constant ?
my code comes the error says the union type incompitable.
I have to union them on linq becase this is used for a lookup control.
Sample XML and code below. I need to retrieve multiple sibling nodes using LINQ. It seems pretty straightforward, I know I'm missing a basic step, as my query only returns the first result.
How do I use linq to group a selection of DateTime by Year-Month ?
Let say I have 4000 rows with dates formatted like
2009-01-01 23:12:12
I know want them grouped (and printed) like
20...
Friends,
I am needing the Linq in VB.NET to get each item from an ArrayList in a sorted order.
I know I could use a sorted list, but I don't need any values with it. I simply just want ...
Hi
I have problem adding XElement to XML file. Every time VB add xmlns="" to the end of a row, which means when I bind it to a grid the row is missed.
Simple code is below for adding th...
Hello all,
I have a class coming back from Entity Framework for example Customers. What I want to do is only return two of the fields from the entire table coming back Customers from the f...
I need a linq query to return a DISTINCT List of DateTimes like this
private List<DateTime?> getList()
{
code.. return distinct...
Any idea how I can turn this query into a LINQ var query?
SELECT parent_row_id, child_row_id, ms.value_return AS stock_value,
mc.value_return AS class_value
FROM map_data p,
...
Friends,
I have the attached code snippet. It is LINQ qry that I use to get data from a Dictionary.
Now, I have a keyword that I pass in, and I want it to return any record with fields ...
I need assistance with being able to add a row to a datacontext and being able to save the value to the database.
I have attached sample coded and a couple of snagits of info.
I am trying to move a set of child entities to a different data context and am running into various problems.
When the coimpiler hits the foreach, an error spews out (EntitySet was modified...
I have an XML document that contains elements of type "item". Item contains an element of type "tags", which contains 0..* elements of type "tag", which has an attribute named "id". (see samp...
