I've got a datacontext and created a binding source using LINQ to sql but cannot filter said bindingsource. The supportsfilter of the bindingsource is set to false ? why ? I can't find any info to say that I cannot filter a binding source based on a linq query.[code]
View 3 RepliesI'm trying to filter my access database and when I "search" by name, it works, but when I search by policy number it doesn't seem to work.
Here's my code:
If RadioButton3.Checked = True Then
Form3.Show()
Me.Close()
[CODE]...
I have an Access database and I want to view on a datagridview specific rows. For that I used the following :
CasesBindingSource.Filter =
"OfferDate Between #1/1/1997# And #12/31/1997#"
Cases is the table, OfferDate a field of the table wich is DateTime type.
When I use Between operator I get the following error :The expression contains unsupported operator 'Between'.
The table field [recordaddeddate] is a Date/Time field in my Access database. Usually this field contains a date + time value. For filtering on my datagridview I want to filter on the date portion only. However the following genterates a 'The expression contains an unidentified function call DateValue' error. How can I filter on just the date?
DateSelected = DateValue(Me.AddedDateDateTimePicker.Value)
Me.ConversationTblBindingSource.Filter = "DateValue([recordaddeddate]) = #" & DateSelected & "#"
HIDoes anyone have code for filtering numbers in a binding source?
View 4 RepliesI have a table (Projects) which is linked to projectVersions on projectID..projectVersions contains several columns on which I'd like to filter a returned project (and associated projectVersions) list. For example there is a "capacity" column and a "country" column. I am doing a filtered list of projects on one page and I'd like to include all projects where any one of the associated projectVersions has a capacity of 750ml and a country of "France" for example.It may be that a particular parameter is not set and so I pass a zero to indicate not to filter on that.I guess this needs some kind of subquery as when I try and do something like this: [code] it doesn't work as the "xxx" bit, being one-to-many, expects me to specify an item to get at the entities within and yet I want to query where ANY of the associated versions match one of the criteria.
View 1 RepliesHow can I filter multiple clauses in a binding source. I've tried
Form4.CustomersBindingSource.Filter = "[Last Name] = '" & TextBox1.Text & "'" & "[First Name] = '" & TextBox2.Text & "'"
What code I need to search a whole table (not just one column). I can already search a column but how do I search the whole table for a string .
source1.DataSource = ds.Tables(listboxselect)
Grid.DataSource = source1
source1.Filter = "id = " & searchtxt.Text
I have a Query to Display values in grid view, now i wanted impose certain condition in query to filter the values.I have FABDue(date column) and FABComp(date column)columns in a table.I need to check following two conditions in query
1.Records which does not contain FABdue date in FABDue column, then those records should not be listed in Grid view.
2.Rcords which are having FabComp(column) date then those records should not be listed in grid view
[Code]...
I have a list(of t) and I got a iqueryable(of a)
I want to filter out any item from the iqueryable(of a) where a.id = t.myotherid
I'm not really sure how to write this query[code]...
is there any way that i could link/bind multiple binding source to only one binding source navigator?
View 4 RepliesI have a LINQ query:[code]How can I pass "MyField" to the Sub and make the LINQ "Where" clause work?
View 2 RepliesCould not find this through Google or in SO questions.I have a checkbox listbox on my form. I want to filter my List by the list of selected Ids from that listbox that are checked, in SQL I would have done this like "Where TypeId In (1, 4, 5, 7)"... how do I do that in LINQ?
I feel like I am missing a really obvious answer, but cannot get it.
For argument sake... here is the what I have for sample data:
In Colors (List<of currentColors>)
ID, Name, TypeId
1, Red, 1
2, Blue, 1
3, Green, 2
4, Pink, 3
Selected Types 2 and 3 in CheckboxList: filteredColors
[Code]...
i try to convert this kind of sql query into linq in visual basic, but i get stuck on how to make a percent.. I also don't know how to use linqpad for creating this linq
SELECT CASE RIGHT(PICName, 3)
WHEN '(P)' THEN 'Problem'
WHEN '(R)' THEN 'Request'
[Code].....
I've got a form - CMCConsole It pops up a dialog form for adding a new case.If the matter number in a textbox on that dialog form matches an existing cases matter number I would like to find it in the binding source of the CMCConsole form
Private Function CheckMatter(ByVal MtrNum As String) As Boolean
Dim cfIndex As Integer = CMCConsole.caseBS.Find("MatterNumber", MtrNum)
Dim cfIndex2 As Integer = CMCConsole.casefileBS.Find("MatterNumber", MtrNum)
[code]....
But it appear the filter for the CASE we were just on that is set on the binding source is keeping the FIND from seeing other cases.
caseBS.Filter = "CaseId=" & e.Node.Tag.ToString
Do I have to clear the filter in order to find a matter number in some other case??
I have the following routine (that works) but which is messy to update owing to the hand-typed strings it uses:
Private Sub ListDefaults()
Dim conn As New SqlConnection( _
"server=bas047AUTODESKVAULT;Database=DWGDetails;Integrated Security=SSPI")
'Dim conn As New SqlConnection( _
[code]....
I have 2 Tables , OrderDetails and Requests In my LINQ to SQL dbml file. OrderDetailsID is a foreign key in Requests Table.
I want to write the query to get the sum of UnitCost from OrderDetails based on OrderId. And If there is a row in Requests Table for each OrderDetailsID, and the Requests.Last.RequestType="Refund" I want to reduce the total refund amount from the main sum otherwise If there is no row based on OrderDetailsID, add to sum.
Here is the way I implement that. I am looking to prevent using "For each".
iRefund = (From od1 In dc.OrderDetails _
Where od1.OrderID =1 _
Select od1.UnitCost).Sum
[Code]....
I have 2 Tables , OrderDetails and Requests In my LINQ to SQL dbml file.OrderDetailsID is a foreign key in Requests Table.I want to write the query to get the sum of UnitCost from OrderDetails based on OrderId.And If there is a row in Requests Table for each rderDetailsID, and the Requests.Last.RequestType="Refund" I want to reduce the total refund amount from the main sum otherwise If there is no row based on OrderDetailsID, add to sum
View 3 RepliesI have two module-level variables and Linq query. I want the results of the Let clause to change the global variables - is this possible?
For example:
Dim X As Integer = 0
Dim Y As Integer = 0
[code].....
I have the following LINQ-to-Entities query:[code]This will give me all the resident assignments for the current year/term. Then I have this LINQ-to-Entities query:[code]This will give me all the rooms. I want to iterate through the assignments and based on what room is assigned update the occupancy in reset_occupancy. I'm not 100% sure how to accomplish this. Here is my pseudo code of what I want to accomplish:[code]
View 1 RepliesI have the following LINQ-to-Entities query:
' Get all the residency assignments that match the term/year.
Dim assignments = From p In dbContext.Residents _
Where p.semester = term _
[code].....
binding navigators, datagrid view, binding source are all sql database parts.Will these parts still work if you havent got sql on you pc and your not using an database file (.log and .mfd) and your not coding to them, im using MS Jet/Oledb to code to Excel.What not to put on an Employee evaluation: This employee has hit rock bottom and shows signs of starting to dig.
View 2 RepliesI would like to bind a DataGridView to a different LINQ query every time (in order to reuse the same form/DGV for different queries), like this:
[Code]....
but the "Qry", and the number of comboboxes, and their field names would change every time.
I m trying to filter a sql db with many filter criteria which inert the user in textboxes .. i ve tryed this query
[Code]...
I 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.
Example-I have a person class
Public Class Person
Private _fname As String
Public Property Fname() As String
[Code]...
im doing something wrong in this statement
objDataAdapter.Fill(mydataset,
"Bookingen")
Dim dbbooking
[code].....
I'm trying to filter date and time
Dim
startTD As
Date = Dtp1.Value.Date
objbindingsource.Filter =
[code]....
am new to vb 2010 i havent touch VB since 2002 , am a lil confuse how to make things to work now.i have a local database "sql" with 2 tables.one holds the client info and the other the orders for the clients.i have a data grid view and am able to populate the grid with the correct information for the client. using [code]that brigs me all the orders for that client.now orders are also made by campaing.i have a textbox that the user will type the campaing to view just the orders for that campaing beloning to that clientand i get stuck,what i get is all the orders from that campaing and the 1st filter by client gets override.
View 6 RepliesI have a data table that looks like this:
USERNAME ICOUNT IAVERAGE DATE_LOGGED
LAGX01 1245 1245 05-07-2012
LAGX02 2211 1422 05-07-2012
LAGX03 1698 1112 05-07-2012
LAGX04 4598 1555 05-07-2012
LAGX05 2589 3245 05-07-2012
LAGX06 3321 1155 05-07-2012
LAGX07 3698 3458 05-07-2012
LAGX08 2589 4587 05-07-2012
LAGX09 1598 1142 05-07-2012
LAGX10 3156 1987 05-07-2012
LAGX11 5547 2011 05-07-2012
LAGX12 9456 3459 05-07-2012
Now, I want to execute a sql query that will display the top 5 based on average, so i did this:
SELECT DISTINCT USERNAME,IAVERAGE FROM myTable WHERE IAVERAGE > 0 AND DATE_LOGGED='05-07-2012' ORDER BY IAVERAGE LIMIT 0,5 and the result is:
USERNAME ICOUNT IAVERAGE DATE_LOGGED
LAGX03 1698 1112 05-07-2012
LAGX09 1598 1142 05-07-2012
LAGX06 3321 1155 05-07-2012
LAGX01 1245 1245 05-07-2012
LAGX02 2211 1422 05-07-2012
Now, I want to numberize my query result, so it will look like this:
RANK USERNAME ICOUNT IAVERAGE DATE_LOGGED
1 LAGX03 1698 1112 05-07-2012
2 LAGX09 1598 1142 05-07-2012
3 LAGX06 3321 1155 05-07-2012
4 LAGX01 1245 1245 05-07-2012
5 LAGX02 2211 1422 05-07-2012