Linq Combining 2 Queries?
Oct 11, 2010
Let's say I have 3 tables: carts, baskets and eggs where a basket can contain many eggs and where carts contain many baskets. Each basket has a foreign key that maps to a cart and each egg has a foreign key that maps to a basket.I need to return a table that contains these 3 columns:Cart Name | Count of Baskets in Cart | Count of Eggs in Cart.Each table is an EF and I'm using linq with VB.So far, I have 2 queries: one that returns the columns Cart Name and Count of Basket and another one that returns Cart Name and Count of Eggs. How can I combine these two result tables so that I get the results in one table?
Dim query1 = (From cart In myEntities.Carts
Where cart.UserID = TheUserID
Join baskets In myEntities.Baskets On baskets.CartID Equals cart.CartID
[code]...
View 2 Replies
ADVERTISEMENT
Jan 6, 2010
I am writing a message system on my server, the xml is something like this
<xml>
<entry>
<sender>[code]....
my problem now i guess is 2 fold, i wish to combine the first 3 queries into a single query and place in a list or a collection or is there a way to do this with a single query that will give me my desired result?
View 1 Replies
Mar 9, 2009
I am trying to fill a temporary table with one column( a code) with the unique results of three queries of their respective table adapters.I can't figure out how to do it from here.The database is Access 2007 and I have activated the appropriate dataset on the form from which this code executes. The table adapters are part of that dataset.I could try to use the recordset approach, but that means making another connection to the same database.Is that a preferable approach?My purpose in doing this is to build a VB process like the one that works in a VBA Module of this Accessdatabase, partly to help me learn VB2008 and partly to overcome the necessity to keep updating queries used by the module.Code below
[Code].....
View 4 Replies
Apr 27, 2012
I've seen several posts on the subject, but none seem to answer this particular dilemma. I have two datatables that I obtained by querying two separate servers.[code]
View 7 Replies
Aug 24, 2011
I have a basic grid of Linq2Sql entities (frmList). I have a separate form for editing (frmEdit). frmEdit has its own DataContext (as that appears to be the recommended way). How can I tell when my detail form has saved changes?
I don't see a built-in method. I am considering raising an event on the detail form when I save the datacontex, but not sure how I consume this event on frmList, and I have a feeling these events are already created for me somewhere?
View 1 Replies
Mar 13, 2012
I have a function used to filter a list of options to return only those that are lot traced, and, when applicable, also only show items matching a specified pattern:
Private Shared Function FilterResultsLot(ByVal source As IQueryable(Of Item), _
ByVal itemCode As String) As IQueryable(Of Item)
If HasFilter(itemCode, True) Then
[Code].....
View 1 Replies
Mar 17, 2009
I have 2 tables that are related. Each app can relate to many apps. ie, office can be related to word, excel.[code]I would like to do the following query. I use vb.net but c# is ok.Query is to return all the apps that are not related to (1), so the result should be (4, quake) .
View 3 Replies
Apr 5, 2011
I know there are similar questions on stackoverflow - and I looked through them and think my issue is somewhat similar, but haven't been able to find a solution by looking at any of these other questions/answers.I'm getting the error when attempting to execute the following code:
Private Sub btnReserve_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnReserve.Click
' Check that the room is still available.
Dim dbCheckOccupants As New pbu_housingEntities
Dim hall As String = CStr(Session("hall"))
[code]....
It is catching an error on this line:
Dim myID As String = GetID.First.id.ToString
As far as I can tell I'm not using multiple contexts?
View 2 Replies
Apr 7, 2009
I decided to iterate through the Data.DataTable and trimmed the values there.Utilizing SirDemon's post, I have updated the code a little bit:
[code]...
I know that on the DisplayMember line the .First.Item() part is wrong, I just wanted to show what row I am trying to designate as the DisplayMember.
View 3 Replies
Feb 17, 2011
I use the following code to fill the Table1 dictionary with the information found within the LINQ query.
Dim DB As New DatabaseDataContext
Dim Table1 As New Dictionary(Of String, Integer)
Dim Table2 As New Dictionary(Of String, Integer)
[code].....
View 3 Replies
Jul 6, 2010
I will start a new project, use the queries and dealing with databases using LINQ or SQl ,Which is better to start ???
View 4 Replies
Jun 5, 2008
I've recently ported my website from 2005 to 2008, and I'm using LINQ Queries to implement a search. The issue is that none of the fields are mandatory, so I've had to implement a dynamic LINQ Query (sic?). Here's the relevant code -
Public Function searchQuery(ByVal titleType As String, ByVal titleName As String, _
ByVal configMgr As String, ByVal lifecycle As String, _
ByVal CIType As String, ByVal recordsPerPage As String) As IEnumerable(Of
[code].....
View 2 Replies
Oct 22, 2009
This is really a continuation from my earlier post. I've never worked with this datatype/collection (system.collection.generic.Ienumerable) before so I'm struggling to declare the query globally so I can reference the results within other sub routines/functions. I also am struggling to convert it to other types.how I can convert the collection of xml elements/system.collection.generic.Ienumerable into an xmltextreader (I know I will have to change the query below as it select the value of the node and not the node itself) I imagine by converting the query result to system.IO.stream My first port of call was MSDN but I find the material very difficult to understand for this particular subject.
[Code]...
View 3 Replies
Apr 19, 2011
Can this be rewritten any better using LINQ? I'm a C#er trying to think in VB.NET for this current project. It's in an ASP.NET Web Forms .vb codebehind:
Public ReadOnly Property AllowedCategoryIds As Integer()
Get
Dim ids = New List(Of Integer)
[Code]....
View 1 Replies
Aug 18, 2010
i have to combine 2 wav files in my project.
View 1 Replies
Apr 28, 2012
I'm a long time VB.NET developer and has recently switched to C#. I found out that some of the built-in VB.NET functions (which predates .NET back to 6.0 and BASIC itself) such as the String.Left, or Right, or advanced functions like saving to the registry (SaveSettings and GetSettings) are noticeably absent. What I did was create a new project in the same solution with VB.NET as its language and recreate basically all the functions I need that are available in VB.NET. And then I just call that to the C# code I'm writing.Since compiling the code in .NET pretty much boils down to the same CIL, it shouldn't matter performance-wise what language I wrote the code in or whether I mix C# with VB.
View 4 Replies
Sep 5, 2009
I'm trying to write 2 extension methods to handle Enum types.One to use the description attribute to give some better explanation to the enum options and a second method to list the enum options and their description to use in a selectlist or some kind of collection.You can read my code up to now here:
<Extension()> _
Public Function ToDescriptionString(ByVal en As System.Enum) As String
Dim type As Type = en.GetType
Dim entries() As String = en.ToString().Split(","c)
[code]....
So my problem is both extension methods don't work that well together. The methods that converts the enum options to an ienumerable can't use the extension method to get the description.
View 1 Replies
Jan 31, 2012
I'm working with a third-party library interfacing to an old database system. There's a method - CallProg that calls a "stored procedure" (for lack of a better translation - any Pick users in the crowd?). However, instead of doing something like this:
Public Sub CallProg(ProgName, ParamArray ProgArgs() As String)
...
End Sub
[code].....
View 2 Replies
Nov 11, 2009
I have 3 textbox's and 1 dropdownlist and I am trying to combine all that data into one string. Here is what I tried but is not working:
Private Sub FullAddressTextBox_TextChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles FullAddressTextBox.TextChanged
FullAddressTextBox.Text = AddressTextBox.Text & " , " & CityTextBox.Text & " , " & StateDropdown.text " , " & ZipCodeTextBox.Text
End Sub
My goal is to combine these simultaneously as whoever is filling in the data or after I hit my submit button, if so it has to occur as the first event.
I think my problem has to do with .text after the statedropdown, Is it suppose to be .tostring?
View 6 Replies
Dec 22, 2009
Try5Times will try a function for 5 times.that function can have any number of argument and return a boolean.
If the function return false, try again.
If the function return true, stop.
How to make such function and delegate? Is there a general delegate?
View 3 Replies
Mar 18, 2011
im just playing around making a silly web browsing application for no reason but to look for the right code and see it i guess
well anyway is there a way for me to make a 'for' statement that does an action to a string of objects with same name but different number like:
For fame As Integer = 1 To 10
If PageLoc = fame Then
WebBrowser(fame).Navigate(TextBoxAddress.Text)
End If
Next
View 8 Replies
Jan 5, 2011
I have two (actually many) .png images in my application. Both have transparent areas here and there.I want, in my application, to take both images, combine them, and display the result in a picture box. Later I want to save the result through a button.So far I managed to find the two images and combine them, but it seems the transparency thing won't work. I mean, if you put one image over another, only the top image is visible as the result because, apparently, the image's background is a plain white box. Which is not. Here is a bit of my code:
Dim Result As New Bitmap(96, 128)
Dim g As Graphics = Graphics.FromImage(Result)
Dim Name As String[code]....
resourcesPath is the path to my resources folder. Bases is a folder in it. And Name is the image's name.
View 2 Replies
Jun 21, 2010
How to combine these two conditions in one section
Private Sub DataGridView1_CellValidating(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewCellValidatingEventArgs) Handles DataGridView1.CellValidating
'condition 1
' check given value is numeric or charactr type
If e.ColumnIndex = 3 Then
If Not IsNumeric(e.FormattedValue) Then
DataGridView1.Rows(e.RowIndex).ErrorText = " must be a numeric value"
[Code] .....
'condition 2
' check given value is greater than 0 or not
If e.ColumnIndex = 3 Then
If (e.FormattedValue.ToString = "0") Then
[Code] .....
View 2 Replies
Jul 3, 2009
I'm trying to combine two arrays. Simply append 1 array to another. I have two string arrays. Lets just say array1 and array2.would the following be correct?
array1.Copy(array1, array2, UBound(array1)) I guess I'm slightly confused about the parameters. When I try to use the above code I get green squigglies with the following error.Access of shared member, constant member, enum member or nested type through an instance; qualifying expression will not be evaluated.
View 2 Replies
Mar 7, 2011
[Code]...
this is my code right now i want to make it so that it will keep adding the total. meaning if i get an answer then get another answer i want both of them to add up and show.how can i change it so that it will do tat??
View 4 Replies
Mar 1, 2011
Take a look at this VB.NET code:
list = GeoController.RegionByCountry(country, language)
Region.allByLanguage(key) = list
In C#, I could write this in one line:
[code].....
View 3 Replies
Feb 5, 2011
Is it ok to use some classes and modules inside a single VB file ?
At present, I used to create them in separate files by choosing Project menu --> Add Class/Module
I was thinking about combing them into one file. Is there any merit or demerit on this approach ?
View 6 Replies
Dec 16, 2009
I am working in vb express 2008.I want to combine two tables to show all the columns of two tables in one table. I tried following query:
"Select de.Description, SUM(de.Quantity) AS Quantity, SUM(de.Amount) AS Amount " & _
"FROM DailyExpenses de " & _
"WHERE de.EDate Between @START and @END " & _
[code]....
And i want to combine two tables to display the following result into a Listview through a SQL query:
Description Quantity AmountDescription Quantity Amount
Mineral Water 12 26 Coca Cola 2 25
Rice 3 215 Sprite 3 15
Beaf 4 150 Beaf 4 50
View 6 Replies
Apr 19, 2008
I originally developed a simple application software [VB.Net + MS Access] (Lets call this project A) but now I want to include more functionality in it. I have an encryption/ decryption software utility (Lets call this project B ) and a Text to speech generation utility(Lets call this project C) . That is, I want to add Projects B and C to project A. [Such that clicking on the main form of project A calls a form from project B or C as desired].In solution explorer, I right clicked--Add Existing Project--and added both the above mentioned projects 1 by 1. (Added B and C to the solution explorer with the already present A).As the application software's (Project A's) main form is the main form of my project, I want to have a menu option on the main form (Of Project A) so that a user could click on one of the menu options and the main form of my other projects ( Project B or Project C or Encrypt/Decrypt or Voice Generation) should open by him doing so. To this effect, I tried the following:
1. I dragged the form simply from one of the projects (From B or C ) into the folder of my Application Software (Project A).This generated a lot of Build errors and the Voice Generation utility (Prj. C) would not work like this.
2. Tried to reference a dll, however the authors of Projects B and C did not include a dll in their projects.
3. Now I came to know that to call a form residing in another project folder or even another folder within the same project, you have to give a path for the form. HOW DO WE DO THIS?
As you can understand, I cannot copy the entire code of the 3 projects here....I will try attaching my project here though..Here it is: http: rapidshare.co...MY_Prj.zip.html[Dear Administrator: The downloading option on the webpage does not allow files bigger than I mb, thts why I used an external link]As I said, in the application, Project A is TMS.NET ; Project B is EncryptFile and Project is C.I encountered a problem while adding project C [spoken word], so the project contains only projects B and A. I will try to attach project C seperately.That is, TMS contains proj A+B and Speech contains C.
View 4 Replies
Aug 1, 2011
I have a set of objects that I'm returning via a Linq to SQL query. I'd like to modify the query so that I return a set of objects that are combined only when one of the fields match. The relevant columns of my Products DB table are CategoryID and Quantity. I'd like to combine the fields so that if the CategoryID is identical, the Quantity fields are summed up. However, I don't just want the sum - I need an object that has all the common fields (assume all other fields are identical for the query) so it appears as only one object of type Product. Is this possible? (I'm using VB.net - but open to solutions that include database views, partial classes, etc)
View 1 Replies
