Click here to Skip to main content
15,887,451 members
Home / Discussions / Visual Basic
   

Visual Basic

 
QuestionHow To Read Local Machine Time Pin
ktomecek18-Apr-08 7:17
professionalktomecek18-Apr-08 7:17 
AnswerRe: How To Read Local Machine Time Pin
Dave Kreskowiak18-Apr-08 8:08
mveDave Kreskowiak18-Apr-08 8:08 
GeneralRe: How To Read Local Machine Time Pin
Mycroft Holmes18-Apr-08 22:46
professionalMycroft Holmes18-Apr-08 22:46 
GeneralRe: How To Read Local Machine Time Pin
Dave Kreskowiak19-Apr-08 4:11
mveDave Kreskowiak19-Apr-08 4:11 
GeneralRe: How To Read Local Machine Time Pin
Mycroft Holmes19-Apr-08 13:52
professionalMycroft Holmes19-Apr-08 13:52 
AnswerRe: How To Read Local Machine Time Pin
Parwej Ahamad18-Apr-08 8:14
professionalParwej Ahamad18-Apr-08 8:14 
AnswerRe: How To Read Local Machine Time Pin
ktomecek19-Apr-08 15:47
professionalktomecek19-Apr-08 15:47 
Questionlooking for more efficient way to concatinate values in a datatable Pin
camatulli18-Apr-08 4:30
camatulli18-Apr-08 4:30 
i'm having an major performance issue with a concatination query i wrote against a datatable and was looking for a way to either speed up the query or a whole nother way of doing it which performs better...

at present my app spends 2 min processing this one loop, while i can do the two loops individually in about 5 seconds.

Here is the code:
<code>
For Each dr As DataRow In Main.DS_New.Tables(RightTable).Select(filter, "location,type desc")
Dim CATValues As String = Nothing
If dr.RowState &lt;&gt; DataRowState.Deleted And dr.RowState &lt;&gt; DataRowState.Detached Then
Select Case dr("name").ToString.ToLower
Case "value"
For Each DRsameLocation As DataRow In Main.DS_New.Tables(RightTable).Select(filter &amp; " AND PK&lt;&gt;" &amp; dr("PK") &amp; " AND Location='" &amp; dr("Location") &amp; "' AND type='" &amp; dr("type") &amp; "' AND Name='" &amp; dr("Name") &amp; "'")
CATValues += Chr(215) &amp; DRsameLocation("loc") &amp; Chr(214) &amp; DRsameLocation("value")
DRsameLocation.Delete()
Next
If CATValues = Nothing Then
dr("value") = dr("loc") &amp; Chr(214) &amp; dr("value")
Else
dr("value") = dr("loc") &amp; Chr(214) &amp; dr("value") &amp; CATValues
dr("loc") = "MV"
End If
End Select
End If
Next
</code>
GeneralRe: looking for more efficient way to concatinate values in a datatable Pin
Dave Kreskowiak18-Apr-08 8:05
mveDave Kreskowiak18-Apr-08 8:05 
GeneralRe: looking for more efficient way to concatinate values in a datatable Pin
camatulli18-Apr-08 8:11
camatulli18-Apr-08 8:11 
GeneralMail Merge Question Pin
jchigg200018-Apr-08 4:14
jchigg200018-Apr-08 4:14 
GeneralRe: Mail Merge Question Pin
jchigg200018-Apr-08 4:27
jchigg200018-Apr-08 4:27 
GeneralRe: Mail Merge Question Pin
camatulli18-Apr-08 4:34
camatulli18-Apr-08 4:34 
GeneralAdding Metadata Using Visual Basic 2008 Pin
Harold_Wishes18-Apr-08 3:35
Harold_Wishes18-Apr-08 3:35 
GeneralRe: Adding Metadata Using Visual Basic 2008 Pin
Dave Kreskowiak18-Apr-08 4:27
mveDave Kreskowiak18-Apr-08 4:27 
GeneralPrinting Text File In Dot Matrix Printer Pin
Member 366452518-Apr-08 2:08
Member 366452518-Apr-08 2:08 
GeneralRe: Printing Text File In Dot Matrix Printer Pin
Dave Kreskowiak18-Apr-08 4:23
mveDave Kreskowiak18-Apr-08 4:23 
Questioncapture Pin
swathi chandra18-Apr-08 1:21
swathi chandra18-Apr-08 1:21 
GeneralRe: capture Pin
Smithers-Jones18-Apr-08 1:40
Smithers-Jones18-Apr-08 1:40 
GeneralRe: capture Pin
manavharsh18-Apr-08 3:24
manavharsh18-Apr-08 3:24 
QuestionQuick question on config file Pin
AHeavey17-Apr-08 23:54
AHeavey17-Apr-08 23:54 
GeneralRe: Quick question on config file Pin
Christian Graus18-Apr-08 0:34
protectorChristian Graus18-Apr-08 0:34 
GeneralRe: Quick question on config file Pin
AHeavey18-Apr-08 0:36
AHeavey18-Apr-08 0:36 
GeneralHelp with Integrating MS Word in VB.NET Pin
Jats_4ru17-Apr-08 23:27
Jats_4ru17-Apr-08 23:27 
GeneralRe: Help with Integrating MS Word in VB.NET Pin
parth.p18-Apr-08 0:19
parth.p18-Apr-08 0:19 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.