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 ...
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 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...
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.
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...
Hi
I'd appreciate some help with following. I simply want to remove a node if it exists. Code to retrieve node is here. I find that the node is not being removed
Thanks in advance
I have employee table. i want to display second highest salary from the employee table
Employee Table
--------------------
EmpName Salary
ravi 4000
madhu 90...
