Equivalent To C# Var Keyword - Retrieve The Result Of A LINQ Query?
Mar 19, 2010Is there a VB.NET equivalent to the C# var keyword? I would like to use it to retrieve the result of a LINQ query.
View 4 Replies
ADVERTISEMENT
LINQ Equivalent For SQL Between Keyword?
Feb 12, 2010Is there a LINQ To SQL equivalent to the SQL between keyword?[code]...
View 2 RepliesC# Equivalent Of VB LINQ Query?
Jul 20, 2011I have the following query in VB, but I do not know how to translate it to C# synatax
Dim q = From c In db.Customers
Group Join o In db.Orders On c.CustomerID Equals o.CustomerID Into orders = Group
Select New With {c.ContactName, .OrderCount = orders.Count()}
Linq Equivalent On Sql Query ?
Jun 12, 2012Find the Linq equvalent on the below sql query:
select sum(weight) from (
select weight from pers p
join list l on l.persindex= p.persindex
group by p.persindex,weight) a
Linq To SQL Equivalent Of Query
Mar 5, 2012This is the query that I'm trying to reproduce:
[Code]...
How To Use The Vb Equivalent Of ++ For An Index Property In A Linq Query Projecting A New Type
May 3, 2011I'd normally do this in C# but since I've got to get this code in this particular assembly which is a vb.net one, I'm stuck.
Here's my linq query:
Dim i As Integer = 0
Dim oldAndCurrentIntersectionOnNames = From currentApplicant In currentApplicants _
Group Join oldApplicant In oldApplicants _
[CODE]...
You'll see the .Index = i+=1
This was my attempt to do what I'd quite happily do in C# (i.e. Index = i++) in VB. Unfortunately the VB compiler doesn't like that. how I'd do this in VB.
.net - Saving The Result Of A Linq Query To An XML File?
Nov 16, 2010Here is the original xml file
<?xml version="1.0" encoding="utf-8"?>
<configuration>
<setup>
<cap>33</cap>
</setup>
[Code]...
Join LINQ Query Result And Arraylist In VB
Dec 5, 2009I have a set off LINQ queries filtering original datatable (loaded from Excel file) according to user selections in Comboboxes. Then the result is joined with Arraylist to further filter the set. Arraylist is a simple string list from 1 to 5. [Code]
View 3 RepliesShow SQL Query Result In Textbox Using LINQ 2 SQL?
Nov 15, 2011I have a question regarding LINQ 2 SQL and data integration with textbox:I have one textbox and button on my form, one stored procedure and LINQ 2 SQL class file in my project,I want that when I hit button, my store procedure run the SQL query and show me the result in textbox.I am using VB 2008 and Visual Basic for programing.
View 2 RepliesAssign Result (from LINQ To XML Query) To List(Of String)?
Jul 6, 2011Is it wrong? Please suggest me correct way.
Public Function ReadXML() As List(Of String)
Dim list As New List(Of String)
Dim xmlDoc As XDocument = XDocument.Load("C:\MappingFile.xml")
[code].....
VS 2010 Bind Linq Query Result To Datagridview
May 9, 2012I want to create a LINQ to entities query getting data(join) out of two tables and bind the result as datasource to a datagridview.
Unfortunately I seem to stumble upon a syntax issue.
Table 1 : dcpricing.tblpricing
Table 2 : dcpropertydetail.tblpropertydetail
Grid: grdpricing
[Code].....
Create A LINQ Query Statement That Retrieve Intersecting Data From 3 Datatables
Nov 26, 2010I am trying to create a LINQ query statement that retrieve intersecting data from 3 datatables (dt, dt1, dt2). My first attempt to do so with the following LINQ query statement was successful: [code] However in my design, I would need the LINQ query statement to be dynamically generated, because I want a user to be able to retrieve intersecting data entries from VARIABLE number of datatables. In this case, the first option is not as good as the "INTERSECT" query operator, with which I can just easily connect each SQL query statement with a "INTERSECT" operator. The problem is that my second attempt using the "intersect" operator fails, and after many trials and errors I still can't get it to work. [code]
View 5 RepliesEquivalent Keyword For App.path
Apr 11, 2010We have a keyword 'app.path' in VB6 What is the equivalent key word in VB.NET
View 1 RepliesEquivalent Of The C# Readonly Keyword?
Mar 3, 2009In 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 RepliesEquivalent Of 'Unchecked' Keyword Expression
Apr 8, 2010I have converted the following C# code to VB.NET.But I am unable to find the equivalent of C# "Unchecked" keyword in VB.NET.Below is the C# Code and following the C# Code is converted VB Code.After conversion and building the VB Code I am getting the error :"Constant expression not representable in type 'UInteger'." [code]
View 11 RepliesWhat Is [Android] Java's Equivalent Of Static Keyword
Jan 25, 2012Is there a Java equivalent - specifically on Android - for VB.NET's Static keyword? For those not familiar with VB.NET, take the following code snippet...
Sub MyFunc()
Static myvar As Integer = 0
myvar += 1
[code].....
VS 2008 : Highlight Keyword In String Result In RED?
Jul 27, 2010I have a keyword search in my program that searches a SQL database table and displays all records that match that keyword in a datagridview. As some of the results can be quiet big i would like to highlight the word in the result that matches the keyword in RED. How can i do this?
Dim count As Integer
Dim word() As String
For count = 0 To DataGridView1.Rows.Count - 2
[code]....
LINQ Query Is Enumerated - Turn On Some Kind Of Flag That Alerts Me Each Time A LINQ Query Is Enumerated?
Sep 22, 2009I know that LINQ queries are deferred and only executed when the query is enumerated, but I'm having trouble figuring out exactly when that happens.Certainly in a For Each loop, the query would be enumerated.What's the rule of thumb to follow? I don't want to accidentally enumerate over my query twice if it's a huge result.
For example, does System.Linq.Enumerable.First enumerate over the whole query? I ask for performance reasons. I want to pass a LINQ result set to an ASP.NET MVC view, and I also want to pass the First element separately. Enumerating over the results twice would be painful.It would be great to turn on some kind of flag that alerts me each time a LINQ query is enumerated. That way I could catch scenarios when I accidentally enumerate twice.
Linq - .NET/ASP.NET With And New Keyword Muddle
Jun 27, 2009how New works with the With keyword in this example from the MVC framework.
routes.MapRoute("Default",
"{controller}/{action}/{id}",
New With {.controller = "Home", .action = "Index", .id = ""})
Results From Query - Populate Textbox Controls With Query Result?
Mar 11, 2010how 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.NET Equivalent To This C# Linq Class?
Sep 25, 2009I'm trying to convert something from C# to VB.NET and I'm having trouble finding an equivlent in VB.NET to C#'s yield keyword. I realize 'yield' is not a convertable keyword to VB.NET, so can someone please show me how I would implement this code in VB.NET. I got all of it converted over except for the implemented GetEnumerator() function. It is simply a class that implements CollectionBase and IEnumerable (to make it LINQ worthy):
[Serializable()]
public partial class Customers : CollectionBase, System.Collections.Generic.IEnumerable<BusinessLayer.Customer>
{
[code]....
What's The LINQ Equivalent To SUM(CASE WHEN X=Y THEN 1 ELSE 0 END)
Sep 18, 2009Not sure if this is just a bad habit, or a valid way of doing things, but for large complex report queries spanning bunches of tables, I often get my aggregate stats by summing a Case statement.For example:
SELECT Contact.Name,
SUM(CASE WHEN Order.Type = 'Special' THEN 1 ELSE 0 END) AS SpecialOrders,
SUM(CASE WHEN Order.Type = 'Magic' THEN 1 ELSE 0 END) AS MagicOrders,
[code].....
.net - ActiveRecord Linq/NHibernate Linq Not Building Query Completely?
Jul 14, 2011given this function:
Public Function Search(ByVal StartIndex As Integer, _
ByVal MaxResults As Integer, _
ByVal AccountNumber As String, _
ByVal LastName As String, _
[Code]....
instead of what I expected:
Select count(*) from remitline where lastname = "smith"
What am I doing wrong building up the where clause? I'm using Castle ActiveRecord 2.1
Performance Gain In LINQ Query Vs LINQ Stored Procedure?
Aug 6, 2009if there is that much of a performance gain in running a LINQ stored procedure versus a LINQ query?
View 1 RepliesTranslate Obscure LINQ - SQL Equivalent?
Sep 22, 2010Some long-gone developer left the following LINQ query behind with no documentation and I'm struggling to understand what it does (and therefore if it's doing it right), either by breaking it into pieces or providing the SQL equivalent?
CODE:
I am struggling in particular with the Group Join and Into TargetMatches = Group pieces:
CODE:
Asp.net - Complex Linq Query - Add A .Where() Or .Any() Predicate To Reduce Query Complexity (in VB)?
Sep 14, 2010I have to join two main tables, and I need to filter the results by elements in an ASP.NET web form. These filters are created on the fly so I have to use a lot of where extensions to filter the query. I want to execute the query with as optimized SQL as possible.
I am first doing a simple join between TW_Sites and TW_Investigators. Then there are two sub-tables that are involved. TW_InvestigatorToArea and TW_InvestigatorToDisease. While most of the where clauses are working fine, I have found a performance issue that won't be an issue right now, but will be an issue as the table gets bigger.
The arrays DiseaseCategories and DiseaseAreas would be the results of a CheckBoxList result.
Protected Sub LoadResults()
'Get Dictionary of Filters
Dim FilterDictionary As OrderedDictionary = Session.Item("InvestigatorFilterDictionary")
' Initialize LinqToSql
[code]....
Equivalent Of The C# "is" Keyword?
Jul 2, 2010I need to check if a given object implements an interface. In C# I would simply say:
if (x is IFoo) { }
Is using a TryCast() and then checking for Nothing the best way?
How To Retrieve The Result In VB From HTML/Javascript External Scripts
Jun 17, 2009What I would like to do is to find a way to get the results from a HTML/Javascript script in a string, using VB 2010.To make it clean on a practical case, I would like to get, in my VB application, the results provided by the run of the following external script:The resulting string should be something like this :
"document.write('<'+'style type='text/css'>#TCGPHiLoContainer {width: 300px;font-family: Arial;}#TCGPHiLoTable {width: 300px;margin-bottom: 3px;}.TCGPHiLoHeader {font-size: 8pt;text-align: center;}.TCGPHiLoHigh {background-color: #D9FCD1;color: Black;font-weight:
[code].....
IDE :: Unable To Display The Result When I Retrieve Data From Database?
Dec 8, 2009The main problem is I couldn't display the result when I retrieve data from database.
1. On Picture 1 above, for the Dg_Details, I set the Columns in two type, textbox and checkbox. But, for the datagridview1, I didn't set anything.So, when I bind data from database to Dg_Details and datagridview1, the datagridview1 display the data from database, but the Dg_Details doesn't display the data. Below is the code I written in my form :
Try
objCommand = Me.MyConnection_F.open.CreateCommand
objCommand.CommandText = "select Reg_Num, Reg, Golf, Course_1, Course_2, Course_3, Course_4, Course_5 from Invoice_Reg where Receipt_No = '00001'"[code].....
I think that's happen because the Dg_Details already set and it blocked the result data from database.
Retrieve The Result In VB From HTML/Javascript External Scripts?
Apr 17, 2011What I would like to do is to find a way to get the results from a HTML/Javascript script in a string, using VB 2010.To make it clean on a practical case, I would like to get, in my VB application, the results provided by the run of the following external script:
<script src="http://partner.tcgplayer.com/syn/synhighlow.ashx?pk=MAGCINFO&pi=fnmp-124"></script>
The resulting string should be something like this :
[code].....