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?
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]...
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] .....
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'
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?
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.
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] .....
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] .....
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
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.
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.)
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?
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'."}
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
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
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:
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.
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.
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.
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
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")
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?
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.
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