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
ADVERTISEMENT
Jul 29, 2010
This is what I want to do as seen in C#(loop against a list and fill another list from its data using Linq)
[Code]...
View 1 Replies
Apr 12, 2010
The program I'm writing also creates that hammer_8_8.txt file which is a column of variables next to a column of their values. at the moment my program is really slow at writing the text file so I was wondering if there is a quicker way to do it than the way I have it?[code]...
View 1 Replies
Jun 29, 2009
I found some code online for a vb paint application and I modified it for my use, which is a signature application. It uses a tablet connected to the pc to write the signature on the screen and then save it as a bitmap for later retrieval.The only issue i am having right now is that if you write on the tablet too fast, the signature gets broken up alot, any way to quicken the paint process in the code so that I can get a smoother signature?
Here is my code:
Imports System
Imports System.Collections
Imports System.Data
Imports System.IO
Imports System.Xml.Serialization
[Code] .....
View 1 Replies
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
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
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
Nov 23, 2010
How to avoid for loop (Dictionary Array) using LINQ
View 1 Replies
Mar 11, 2010
I have the following code, that in my head should create a new row in a table:
Dim fin As Boolean
Dim db2 As New ChecklistModeldbmlDataContext
For Each a In bServers
If collection("fin" & a.ServerName) = "true, false" Or collection("fin" & a.ServerName) = "true,false" Then
[Code]...
It only ever adds one record in to the table and then errors with Cannot add an entity that already exists.
Now it should enter 4 rows into the table, but I can't work out why the above gives me that error.
I've also tried having the db2.SubmitChanges() outside of the for each and it just inserts the last row.
View 4 Replies
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
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
Oct 21, 2009
How can I convert an object of type System.Data.Linq.DataQuery to System.Linq.IQueryable?I'm working with Visual Basic/Silverlight, and the source code of my query is as follows:
Public Function Get_Cli_Pag() As IQueryable(Of V_Cliente_Pagare)
Dim Qry = From P In Me.Context.Pagares Join C In Me.Context.Codigos On C.Codigo
[code]....
View 1 Replies
Apr 9, 2010
I have three tables in SQL server which I would like to show and access on a form. Table 1 contains account data, address, contact details etc. Table two contains data attached to a Person, tel no , Mobile no, Email etc. Table three contains details on what awards the person holds, i.e. one person can hold several awards.
Therefore I have a one many relationship between the first two tables and a one many relationship between the second two tables. This is set up in SQL
The first two tables are shown on a form, table 1 via a set of text boxes, table 2 via a datagrid control.
I would like the functionality whereby I could select a row in the datagrid showing the persons name and find the Persons_ID number then use that as a filter to a second datagrid view so that only the selected persons awards show in the datagrid.
View 2 Replies
Apr 16, 2012
CODE:
That code works to read the entry data and to recognise the correct data, and the incorrect. However, even if entry is correct, the error msgbox will appear (x times of how many records there are in file), despite being navigated to the menu. Anyway that the Else isn't triggered when data is correct. Also for it to appear just one instead of (x times of how many records there are in file.)
View 2 Replies
Mar 14, 2011
Makes the following statement about the code below:
**"The computer evaluates the loop condition in the Do...Loop statment to determine whether the loop instructions should be processed. In this case, the inputsales <> String.Empty condition compares the contenst of the input sales variable to the String.Empty value. As you know the String.Empty value represents a zero length, or empty, string if the inputsales variable is empty, the loop condition evaluates to True and the computer process the loop instructions. *If on the other hand the inputsales variable is not empty, the loop condition evaluates to false and the computer skips over the loop instructions.
Based on the code I think it is the opposite: ...that while the inputsales value is not empty it should evaluate to true and process the loop and if it is empty it should evaluate to false and skip the loop?
See below.
Option Explicit On
Option Strict On
Imports System.Globalization
[CODE]...
View 2 Replies
Feb 13, 2009
i have a string (the letters will never be in the same order):
TFTADFDAAFDADADDAFFDTFFTDFTFTDTTAFDAFADTAAATFDTADAFFTFTDDFDAFFTAT
1) i know it is always going to 65 characters (no numbers)
2) it will only have the letters ADFT
i want to loop through each row of data and check if the data contains this.
System.Text.RegularExpressions.Regex.IsMatch()
View 5 Replies
Jul 14, 2011
I am trying to populate a dataset with data from a dynamic SQL dataset created by a code generator (PDSA). If I want the first row of data, or I use a specific "Where" clause to retrieve 1 row, I have no problem. But, when I loop through the dataset that has four entries, instead of getting the four entries, I get the first row 4 times.
Code Example:
Dim DS_C as New DS
Dim dr_A As DS_C.Tbl_ARow
Me.DS_C.Tbl_A.Clear()
[Code].....
I get:
System.InvalidCastException = {"Unable to cast object of type 'System.Data.DataRow' to type 'TblXLMajorPerilsRow'."}
View 1 Replies
Jul 10, 2009
I stucked by the xml problem, I want to read out the data and use the data to insert to database.
[Code]...
View 8 Replies
Jan 9, 2011
I use VB.NET 2010. So, I have to create a file, which has to follow a very old standard. I use a For Each / Next loop to get all my data. During this loop, I have to check the next entry before it is called. and if the next entry has some condition, it is not allowed to be called again....
Code Example:
For Each myData in Data
Dim nxt = Data.FindIndex(myData)
If Data(nxt+1).Depends = True Then
Data.RemoveAt(nxt+1)
End If
Next
View 1 Replies
Jun 2, 2011
an application i developed using vb 2008 express, to fill a web form with data from an access database, one after another when a button is clicked hasn't given me what i expected. the loop was suposed to stop after filling web form with the first data on clicking a button and continue to fill the webform with the next(2nd) data from the database on clicking the button again. Below is the code i wrote
Private
Sub STARTButton_Click(ByVal
sender As System.Object,
ByVal e
[Code]....
View 2 Replies
Dec 31, 2009
I got a weird problem here like I got a site that users can post comments on a friend profile page.Everytime a user post a comment my application sends e-mail to that page owner, you know to inform for a new posted comment on his/her profile page.The problem is I want to stop the application from sending email if that user has just recently posted a comment say like 5 hours ago/earlier.Here is the function I use that would try to check it:
[Code]...
View 2 Replies
Dec 6, 2010
I am trying to extract some data from a website using a LINQ statement, the XML is in the following form.
<parent>
<p>
<b>
Title
</b>
[code]....
I would like to get the As Of Date and Data (the data row is iterated several times). Also the table and as of date appear several times in the document (the table is active from a date).I can get the rows using the following LINQ but how do I get the As Of Date
Dim l_PricesTable = From rows In l_Xml.Descendants("tr") _
Where ((rows.Descendants("td") IsNot Nothing) AndAlso (rows.Descendants("td").Count >= 1)) _
Select Data = rows.Descendants("td")(0).Value,
AsOfDate = ???
I have no way of changing the XML as it is a 3rd party source. There is no XML element which contains just the as of date and also the table, they are all under the one parent node.
View 2 Replies
Jan 27, 2012
I have the following line of Dim clients = From client In db.clients Select client Where client.ClientID = id
In debugging, the clients object populates perfectly, but how can get get data from the clients object? Like if the clients object has a FirstName property, how can I set a textboxes text property to that property from the clients object?
I thought it'd be something like:
tbClientFirstName.Text = clients.FirstName But that doesn't work.
View 2 Replies
Aug 1, 2011
I need to update a datatable using LINQToSql. Option Strict is ON. Datatable name is Customer with fields customerID, customerName, SalesID. I need to update rows with SalesID = -1.
View 1 Replies
Apr 28, 2011
I have this XML:
<root>
<data name="lnkViewResultResource1.Text" xml:space="preserve">
<value>bekijk de resultaten</value>
</data>
[code]...
But, unfortunately, it is not working, it is not getting anything.
View 2 Replies
Nov 25, 2011
I am trying to loop through the rows of my gridview and retrieve the data key value of each row and then execute some code to run sql queries. How can I get the data key value of each row in variable? right now I am receiving an error message saying:
value of type system.web.ui.webcontrols.datakey cannot be converted to integer.
Here is my code:
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
For Each row As GridViewRow In GridView1.Rows
Dim therowindex As Integer = row.RowIndex
[code]....
View 2 Replies
Feb 3, 2010
I'm stuck in converting the rate in the datalist. My page contain one dropdownlist(currency converter), one datalist - inside contain the price of bags in labels. Now I uses the dropdownlist.selectedIndexchange
Protected Sub ddl_rate_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles ddl_rate.SelectedIndexChanged
Dim lbl_rate As Label = roomList.Items.Item(0).FindControl("lbl_rate")
[Code]....
View 1 Replies
May 19, 2012
Currently, I am looking for a solution to makes my data loop at the code behind? It is actually an announcement list that query from database which contains the title and contents.
cmdDa = New SqlDataAdapter("SELECT * FROM announcement ORDER BY announcement_PostDT DESC", conn)
ds = New DataSet()
cmdDa.Fill(ds, "announcement")[code]....
Should I put it into a panel, list view or anything and loop it?
View 1 Replies
Oct 15, 2010
I'm switching over from PHP to vb.net. And some of the concepts are a bit different. Mainly I struggle with concepts and keywords, so it hard to look stuff up. Currently I'm creating a dashboard and needs to run a lot of different sql queries. But I see where I should be able to minimize my code. But things that I have tired don't work. Example below of two chunks of code that I should be able to put in some type of loop and increment a value for my sqlstring and textbox output.
[Code]...
View 5 Replies
Feb 9, 2012
I'm trying to just iterate through this xml and grab all of its data and add it to my collection(_personOC). Right now it's not working. How can I do this without having to specify the id? All I did was make a dataset with a person table and saved it as a xml.
Public Property personOC As ObservableCollection(Of Person)
Get
Return _personOC
[Code]....
View 1 Replies
