For Each Loop - Involving LINQ Query When Reading Form Controls

Dec 8, 2009

I have a form with a tab control, containing a small number of tab pages. I'm writing a sub procedure to clear the controls within a groupbox for the selected tab. A selected tab will only ever contain ONE groupbox and within a groupbox will be command buttons, labels, text boxes and possibly a combobox. The first block of code below firstly finds the groupbox within the selected tab. The next part loops around all control type and if of type texbox clears the text.

Now hears the head scratcher/confusion it error's with :-
Unable to cast object of type 'System.Windows.Forms.Button' to type 'System.Windows.Forms.GroupBox
Which I don't understand as I cant see where Im converting objects simply looping through all controls and then ONLY if type of control is textbox then clear text.

'Loop around all controls in form, simplified that all controls
'are within a SINGLE groupbox and clear contents or reset to default value
Dim groupbox = (From grpbx In tabAdmin.SelectedTab.Controls _
Select grpbx = DirectCast(grpbx, GroupBox) _
Where TypeOf grpbx Is GroupBox)
[Code] .....

View 1 Replies


ADVERTISEMENT

Loop Through LINQ To SQL Query?

Mar 12, 2012

Here's my query dim areas = From job In db.jobs Join area In db.areas

On area.JobID Equals job.JobID
Where job.JobID = id
Select area.Area, area.UnitID

I have two controls in my form

2 textboxes: tbArea1 and tbArea2
2 comboboxes: cbArea1Units and cbArea2Units

I've traditionally used a ForEach loop to cycle through LINQ to SQL results, but this instance doesn't seem to work. By design in the database, the result will always only return up to two possible areas, but no more then that. How can I populate the textboxes and set the SelectedValue of the comboboxes to something like this?

[Code]...

View 2 Replies

Asp.net - Loop Through Controls And Change LINQ Columns?

Jun 29, 2010

I have the following code:

Dim i As Integer
For i = 1 To 20
Dim captionTextBox As TextBox = DirectCast(Me.FindControl("news_Image" +

[Code].....

Where the comment is in the code above, I need to insert the value of the textbox (text) into Linq columns. For example: articleToUpdate.news_Image1Caption, news_Image2Caption, but I need to change the number after news_ to the value of i in the for loop.

View 1 Replies

LINQ Query With Multiple OrderBy Statements Added In Loop

May 11, 2012

I have a method in a webservice that has parameter with which users can decide how they want to order their results. This is a List(Of String) with the names of the fields in the order they want to sort them. I know I can normally order on multiple columns by doing the following

Dim test = Bars.OrderBy(Function(x) x.Foo) _
.ThenBy(Function(x) x.Bar) _
.ThenBy(Function(x) x.Test)

However in this case this won't work since I can't chain the ThenBy function because I'm adding the sorting orders in a loop. To use ThenBy I need an IOrderedQueryable collection. This is how I would want it to work

Dim sortColumns = {"Foo", "Bar", "Test"}
Dim query = From b in Bars
For each column in sortColumns
Select Case column
Case "Foo"
query = query.Orderby(Function(x) x.Foo)
[Code] .....

View 1 Replies

Asp.net - Select Distinct Rows From A Datatable With Criteria Involving Multiple Columns Using LINQ

Mar 9, 2012

I have a datatable as shown in the figure. Let me explain my required based on this image. I have 7 rows of data. The rows 1 and 2 contains columns till UnitSqcNo same. I want only row 3 among the two. In general I want select all the rows with distinct model, unittype, unit and rest with greater CompId. ie the table should look like

View 1 Replies

Passing A LINQ Query From A Form To Another?

Feb 1, 2010

I have a Form1 with a query, and I want to display the results in a DataGridView in Form2, like this:

Form1:

VB
Dim Db As New DataClasses1DataContext
Dim Qry = From country In Db.Countries
Select country

[Code]....

View 25 Replies

LINQ Query Is Enumerated - Turn On Some Kind Of Flag That Alerts Me Each Time A LINQ Query Is Enumerated?

Sep 22, 2009

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.

View 3 Replies

TabIndex Property - Loop Through Windows Form Controls Array

Oct 14, 2009

Any hunk of code that loops trough the windows form controls array, and based on top/left to bottom/right, resets the TabIndex property? I've mashed a huge form together and expect my user community to want to move things around, and I don't want to have to fool around with this over and over again.

View 6 Replies

.net - ActiveRecord Linq/NHibernate Linq Not Building Query Completely?

Jul 14, 2011

given 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

View 1 Replies

Performance Gain In LINQ Query Vs LINQ Stored Procedure?

Aug 6, 2009

if there is that much of a performance gain in running a LINQ stored procedure versus a LINQ query?

View 1 Replies

Asp.net - Complex Linq Query - Add A .Where() Or .Any() Predicate To Reduce Query Complexity (in VB)?

Sep 14, 2010

I 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]....

View 2 Replies

LINQ Query Using The Dynamic LINQ Library?

Mar 31, 2011

Forgive my ignorance on this.I have this LINQ Query:Dim ngBikersDataContext As New CarBikeWalkDataContext

bikersList = (From c In ngBikersDataContext.Reg_Bikers _
Order By c.L_Name _
Select New Bikers() With { _
.BikerID = c.BikerID, _
.F_Name = c.F_Name, _

[Code]...

with the error "Overload resolution failed because no accesible 'Select' accepts this number of arguments."
Over the "NEW" I get an error " ')'expected."

View 1 Replies

Setting A 'default' Value To Controls (textbox) (loop Controls)?

Nov 11, 2009

I have aspx form with several textboxes.They are populated with values from a table via retrieval of a dataview.If the row count for the dataview is 0, then I'd like to reset the values in all textboxes. How can I loop through all the textboxes and set a default value?I've tried the following, but no sucess.

For Each ctrl As Control In Page.Form.Controls
If TypeOf ctrl Is WebControls.TextBox Then
CType(ctrl, WebControls.TextBox).Text = ""
End If
Next

My first For Loop was using Page.Controls but it returned only 1 count.The textboxes are inside a tabpanel (ajax), so do I have to locate the tabpage and then find all it's controls (for each tabpage)?

View 1 Replies

Results From Query - Populate Textbox Controls With Query Result?

Mar 11, 2010

how 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

VS 2008 Loop Through Controls Doesn't Get All Controls?

Jan 21, 2011

I am rather irritated at this. I have no clue why looping through controls on a form and in groupboxes leaves out 75% of the controls.

Here's the code I have:

Dim settings As String = ""
Dim gbControl As Control
Dim gbbox As Control

[Code]....

I want to have setting save all settings to an ini file, and not have to reprogram the saving routine when I add a group box or control. At random times, any number of controls can be disabled, checkboxes can be checked and unchecked, radiobuttons can be checked and unchecked. Regardless of the state of the control, I want the control to show up in the loop. But they don't. Only controls that are enabled and only checkboxes that are checked, every other control state is ignored. That's crap, and is definitely not what is needed by any programmer of any type. We're capable of determining if a control is enabled, hidden, checked, visible, and otherwise.

How do I get the controls to be included in the loop regardless of their state?

View 8 Replies

"System.ArgumentException: An Item With The Same Key Has Already Been Added." When Trying To Order An In-memory LINQ Query By A LINQ Association?

Jan 27, 2011

We are doing a query against an in-memory collection of LINQ data objects. The wrinkle is that we are ordering by a column in a related table whose records have not necessarily been loaded yet (deferred loading:)

Dim oPkgProducts = _
From b In oBillPkg.BillProducts _
Where b.Successful.GetValueOrDefault(Common.X_INDETERMINATE) = _

[code]....

View 1 Replies

LINQ To SQL - Add In Row_Number To A LINQ To SQL Query?

Aug 31, 2011

How do I add ROW_NUMBER to a LINQ query or Entity? How can I convert this solution to VB.NET?

[Code]...

I'm having trouble porting that last line. I have been unable to locate a VB.NET example. I'm actually not looking for any paging functionality like the example provides, just good old-fashioned Row_Number(Order By X) row index.

View 1 Replies

VS 2008 Linq Possible To Use Query In Another Query?

Apr 16, 2011

I was wandering is it possible to use a query within another query below is the code I am trying to use.

Public Function GetInventByComp(ByVal CompID As String) Using DC As New DataClassDataContext
'need to get company id's based off names? thats bad should be name from Id need to rethink this
Dim invent = (From C In DC.Inventors_Companies _
Where C.CompID = CompID _
Select C.InventorID).ToString

[Code]...

I was trying to us multiple values in a string like "1, 3, 5" but I can't seem to get that working either so I am trying to use just a single value now. Can anyone help me? "Yes I am new to this"

View 5 Replies

Reading From XML File Using LiNQ?

Feb 21, 2010

Im starting a project that needs to read data from some sort of table, the best way i can think of storing this data was xml as its not a large amount. The xml file i have is.

<House>
<Rooms>
<Room>Dining/Living Room</Room>

[Code].....

All i want to do is query the xml with the Room name and return the Temp and Air values. I have read that there are many ways to read xml files and tbh its confused me a bit, but the LINQ method seems to be easier than the others but still having issues. Is it possible to give me some guidance of a snippet of code that will work the the above xml to populate a simple textbox upon clicking a button.

View 5 Replies

How To Loop Through LINQ Results

May 17, 2010

I've got some code to try and loop through LINQ results, but it doesn't seem to be working.

HERE'S THE CODE

Public Sub ProcessRequest(ByVal context As System.Web.HttpContext) Implements System.Web.IHttpHandler.ProcessRequest
''# the page contenttype is plain text'

[Code]....

View 1 Replies

Loop Reading Only The First Line?

Aug 23, 2010

My name is Steven Jeffers and I just started studying arrays and I am using StreamReader to read textfile but when i run the debug on the program to see if the patient ID array is correct it only produces the first id which is 230.

Public Class frmPatientCholesterol
Public Shared _intSizeOfArray As Integer = 15
Public Shared _strPatientsName(_intSizeOfArray) As String

[Code].....

View 3 Replies

LINQ: Writing And Reading XML Settings?

Mar 8, 2012

i am having trouble reading my XML settings. I Create new entries like this

Private Sub Create()
Dim doc As New XDocument
If File.Exists("Settings.xml") Then
doc = XDocument.Load("Settings.xml")

[code]....

The XML file will have multiple <Network> Entrys. I cant figure out how to loop the file and get every <Server> entry. But then if i opened a form and gave the variable one of the server entries how could i get that <Network> based on the server entries child parameters.

View 10 Replies

.net - Should Use LINQ For This Query

Sep 4, 2009

I've been reading a fair bit about the performance of using LINQ rather than using a for each loop and from what I understand using a LINQ query would be a little bit slower but generally worth it for convenience and expressiveness. However I am a bit confused about how much slower it is if you were to use the results of the query in a for loop.

Let's say that I have a set called 'Locations' and a set of objects called 'Items'. Each 'item' can only belong to one 'location'. I want to link items that are under the same location to each other. If I were to do this using a normal 'For Each' loop it would be something like this:

For Each it as Item in Items
If it.Location.equals(Me.Location)
Me.LinkedItems.Add(it)
End If
Next

However if i was to use LINQ it would instead be this:

For Each it as Item in Items.Where(Function(i) i.Location.equals(Me.Location))
Me.LinkedItems.Add(it)
Next

is the second (LINQ) option going to loop once through the entire 'Items' set to complete the query, then loop through the results to add them to the list, resulting in essentially two loops, or will it do the one loop like the first (For Each) option?

View 2 Replies

Can Do A LINQ Query Of A LINQ Query?

Mar 24, 2012

Is it possible to do the following? [code] Basically I have one Load_Gridview function that is called on all postbacks, and rather than creating a bunch of different cases.I want the filters to stack.My actual code has more filters set up (4 or 5 of the).It all compiles ok but when I run and try to execute with active checked, or a department selected I get the following error. [code]

View 4 Replies

Linq Query In .net?

May 5, 2009

I have below XML file

<?
xml version="1.0" encoding="utf-8" ?><
PageFlow>
<
attributegroup name="Search"><
attributes>

[Code]...

View 2 Replies

Put A Sum() In Linq Query?

Apr 18, 2012

I am looking to sum the "Status" field.

Dim _detailRecords As New DataTable
_detailRecords.Columns.Add("y")
_detailRecords.Columns.Add("z")

[Code]....

I'm also wanting to keep this as an IEnumerable of DataRow because I will be creating a datatable from it with

Dim yyyyy As DataTable = query8.CopyToDataTable

View 1 Replies

Query With Linq To Xm?

Aug 13, 2010

I am Fairly new to Linq and I am trying to write a simple query to return the error messages within my xml file.

<?xml version="1.0" encoding="utf-8"?>
<Error xmlns="urn:xxxxx">
The following errors were detected:

[code].....

View 1 Replies

Quicker Way To Loop Through LINQ Data

Oct 22, 2010

I am writing code that pulls data from database tables and writes them to an XML file (to be picked up by another process). There are bout 60,000 records, and each record can have multiple entites, i.e. a member can have several contacts, each contact can have several phone numbers, etc. The entire process takes several hours, and I've narrowed down the slowness to the actual pull of the data (not writing the XML, or any data processing after it's pulled, etc.). I've tried the code two different ways, with similar results. First I leveraged LINQ queries and created all the elements in one statement:[code]That produced almost no change in amount of time the process took. I then tried stripping out all the elements and reduced the code down to just the database pulls, and it was similarly slow.Is there a faster/better way to pull all this normalized data from the database so I can get it to the XML file as quickly as possible?

View 3 Replies

Reading A Text File And Using A For Loop

Sep 16, 2010

I'm trying to create a program to read a file and create a table. Public Class Form1

[Code]....

View 8 Replies

Why The Sql Query Is Different On That Linq Query When Run On C# And On .net

Aug 26, 2009

if I run this under c#

from p in Addresses where p.Address2 == null select p.AddressID

it generate this query

SELECT [t0].[AddressID]
FROM [dbo].[Address] AS [t0]
WHERE [t0].[Address2] IS NULL

if I run this under vb.net

from p in Addresses where p.Address2 = nothing select p.AddressID

it generate this query

SELECT [t0].[AddressID]
FROM [dbo].[Address] AS [t0]
WHERE [t0].[Address2] = ''

p.Address2 is a varchar field that accept null value

why vb.net is "wrong" ?

View 1 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved