Wmi Query Returning VERY Slowly?
Apr 25, 2009I'm trying to query a remote machine and get the cpu percentage similar to task manager.. I have the following code:
Code:
im wmiK As New WMI
Private objMgmt As ManagementObject
[code].....
ADVERTISEMENT
SQL Query Returning Wrong Value
Mar 15, 2012I am messed up with the below query[code]...
but when i run the query in my project the reader in not reading correctly...even if values are present is returns false and if values are not there then it returns true.
.net - Linq Query Not Returning IEnumerable?
Jan 22, 2010I have the follow Linq query that is in a web application that was converted from .NET 1.1 to 3.5:
dim objListOfFilteredDataRows = from datarows as datarow in objDataSet.tables(0).rows _
where datarows("SomeColumn") = SomeValue
I have the exact same query in an application that was created using .NET 3.5 and the query returns an IEnumerable. However the query in the converted application is returning:
{Name = "WhereEnumerableIterator`1" FullName = "System.Linq.Enumerable+WhereEnumerableIterator`1[[System.Data.DataRow, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]"}
**Edit: When I highlight the expression, the intellisense says that it doesn't know the type of objListOfFilteredDataRows and assumes its a type of "Object". Why is the type not infered in the converted 1.1 application but is infered in the "native" 3.5?**
What am I missing here? How do I convert the "WhereEnumeratorIterator`1 to an IEnumerable?
Asp.net - LINQ-to-SQL Query Returning No Results?
Mar 5, 2011I have a query using LINQ-to-SQL. It queries an underlying database table Rooms. It uses Where conditions to narrow down the results, namely:
Gender.Current Occupancy < Max Occupancy Available Flag is Checked I know this should return results but it keeps returning an empty set.Code is below
[code]...
UPDATE: I've verified that the issue is with the statement where sh.is_available = 1, which doesn't make sense since this is a bit field.
Linq Query Returning Value From Another Class?
Apr 28, 2011Just a quick question about LINQ, I want to use a value from the returned dataset to lookup a value and return this. The line I am struggling with is .ViewingNotes = NewViewing(pt.ProspectId).GetViewings().Columns(7).ToString(). Is this possible?
With BusinessLayerObjectManager.Context
Return (From p As [Property] In .PropertySet
Join pt As Prospect In .Prospects On pt.Property.propertyID Equals p.propertyID
[code].....
LINQ To XML Query Returning No Results?
Jul 20, 2011I'm doing some XLINQ in VB for work. I basically need to pull some values from a small chunk of XML as listed here:
<?xml version="1.0" encoding="utf-8"?>
<Fields>
<typeQtyRadioButtonList>1</typeQtyRadioButtonList>
<cmbQtyCheck>Reject</cmbQtyCheck>
[code]....
... Leaving out the implementation of the For Each loop....So I have stuck a break point on the for each and the collection has no elements in it.
Query By Date Returning Error?
Jul 26, 2011I'm trying to run a query from a search form by date and I'm receiving the following error:[Teradata Database] Partial string matching requires character operands.The code for the search is:
ElseIf OptDate.Checked = True Then
sSQL &= "DATE_SUBMIT Like ('" & txtDateRec1.Text & "%')"
End If
SQL Data Query That Is Not Returning Any Records
Oct 28, 2010I am trying to debug my code, which involves a simple webservice that passes parameters to a data class, which calls a stored proc, and returns one row of record. I am not getting any error messages, but I am not getting any records back either.[code]
View 1 RepliesSQl Query On Form Returning Value Of 1/1/0001
Jun 11, 2011I am developing an application that based on when a user has last entered a payroll, my program tells them the next available Sunday that is available to them based on
1. The date that the last time payroll was entered
2. If payroll ran = "yes" or "no"
I have a sql query that returns the next Sunday back to me based on this criteria, but when I put it into my application, it returns 1/1/0001 to me.
Here is the query:
select MAX(payrolldate) AS [payrolldate],
dateadd(dd, ((datediff(dd, '17530107', MAX(payrolldate))/7)*7)+7, '17530107') AS [Sunday]
from payroll
[Code].....
SQL Query Returning Dates Of 1/1/0001
Oct 26, 2010I am building an application where a button click runs a sql query and shows a user the next available date that they can process from. The problem was that it needed to be the following Sunday and not the following day.
That code looked like this:
Public Class Form1
Dim ReturnValue As Object = Nothing
Private Sub Button1_Click_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
[Code]....
SQL Query Returning Dates Of 1/1/0001?
Oct 27, 2010I am building an application where a button click runs a sql query and shows a user the next available date that they can process from. The problem was that it needed to be the following Sunday and not the following day.That code looked like this:
Public Class Form1
Dim ReturnValue As Object = Nothing
Private Sub Button1_Click_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim connectionString As String
[code]....
DB/Reporting :: SQL Query Returning Dates Of 1/1/0001?
Oct 21, 2008I am building an application where a button click runs a sql query and shows a user the next available date that they can process from. The problem was that it needed to be the following Sunday and not the following day. That code looked like this:
Code:
Public Class Form1
Dim ReturnValue As Object = Nothing
[code]....
Code:"select payrolldate from payroll where(payrolldate <= getdate())and payrollran <> 'yes'")but when I add that query it just returns a value of 1/1/000 as the date.
Entity Framework Returning Different Data Then DB Query?
Jan 4, 2011I have a view on some data in my database it returns the data as I would expect, for example
Call Date To From Phone Number
20/1/2010 00:00 23:59 08923233223
20/1/2010 00:00 23:59 08923233245
However when I have added this to my Entity Model and query it I get duplicate(and unexpected) data appearing
Call Date To From Phone Number
20/1/2010 00:00 23:59 08923233223
20/1/2010 00:00 23:59 08923233223
I am simply binding a Entity Data Source to this Entity but I am left scratching my head as to why the data is being returned differently
EDIT: Interestingly this can't be the result of some strange under the hood join as the row counts match as expected. I have also put together a query myself to test with the same odd results.From o In App.Entities.v_PersonalRules Where o.companyid = CompanyID Select o. I am using Visual Studio 2010, .NET 4
EDIT: The front end code is fairly simple
<asp:EntityDataSource ID="EDS_Personal" runat="server" ConnectionString="name=Entities_NEW"
DefaultContainerName="Entities_NEW" EnableDelete="True" EnableInsert="False"
EnableUpdate="True" EntitySetName="v_PersonalRules" EntityTypeFilter="v_PersonalRules" >[code]....
Returning Query Results To Presentation Layer?
Mar 11, 2010Im currently working on an n-layer application that does alot of database work.90% of all database queries are updates, and inserts and I want to be able to view the results of my query in the presentation layer.I was thinking of creating a QueryResult class that has a few properties like QuerySuccessful (boolean), Message (string) - holds success or error message, and optional field to hold any additional data that may need to be passed back to the presentation layer.So I guess my question is, am I going about this the correct way by creating a QueryResult class, and passing that back up through the layers to my PL?
View 2 RepliesLinq To Xml Query Returning A List Of All Child Elements?
Mar 8, 2010I have got an xml document which looks something like this.
<Root>
<Info>
</Info>
<Info>
[Code]...
How can i write a linqToXML query so that it returns me an IEnumerable containing each child element, in this case all five child elements of , so that i could iterate over them. The order of child elements is not definite, neither is number of times the may appear.
SQL Possibly Not Returning Values For A Query In Visual Basic?
Jun 29, 2010In my code I enter a string in a text box and have the query check the server for the entry. If it exists it returns the string and the date into two separate variables. The database only has TrackingNumber and Date. Below is the code. As of right now i get "Invalid attempt to read when no data is present." at the "If (sdr("TrackingNumber") IsNot Nothing) Then" line.
Public Function CreateSqlParameter(ByVal name As String, ByVal dbType As DbType, ByVal direction As ParameterDirection, ByVal value As Object) As SqlParameter
Dim parameter As SqlParameter = New SqlParameter()
[Code]....
Asp.net - Returning In Oracle INSERT Is Not Returning Proper Value?
Mar 15, 2012I have an ASP.NET web application (VB.NET) using an Oracle database. On an insert, I need to get the identity of the inserted row back. I am trying to use RETURNING, but I keep getting a value of 1 returned.
Dim strInsert As String = "INSERT INTO L.TRANSACTIONS (LOCATION_KEY, TRANS_CREATOR, TRANS_EMAIL, TRANS_PHONE) VALUES (:location_key, :trans_creator, :trans_email, :trans_phone) RETURNING TRANS_ID INTO :ukey"
[Code].....
2008 Run More Slowly In Windows 7 64 Bit?
Dec 25, 2009I've create my program before in Windowx XP ir required 1:37 seconds to finish the Genetic Algorithm but after I moved to Windows 7 64 bit and trying to used the 64 bits compiled version it runs much more slowly, it could take 5 minutes more, I've tried to change to 32 bit compiled version it run more faster than 64 bits but still slower than Windows XP it takes about 2:01. Is there something I missed in the compiling for 64 bits, or maybe the VS 2008 still not compatible with Windows 7.
View 3 RepliesRichtextbox Scroll Down Slowly?
Dec 16, 2010what i want to do is have a richtextbox lets say this is the text
1
2
3
4
[Code].....
and i what i want to do is have a timer and have it scroll down line by line so each letter gets show and some letters go off the richtextbox cuz its small
.NET 3.5 Chart Control Loads Slowly?
Jul 1, 2010So in this program that I've made, I have 5 tabs. One of them uses this chart control for .NET ver 3.5 that I downloaded from the Microsoft website. The issue is, though, that when I start the program, everything is fine until I click on the tab with the 3 charts on it. The tab freezes a little bit, and it takes a few seconds to load the charts. After this initial hiccup everything is fine, but I've tested this on three computers now and it happens to all of them. Anyone know what I can do to make these charts load faster or smoother? This is quite a roadblock.because otherwise I'd be done I've been working on this project in VB.NET for the past 3 weeks and it's my first time using the language. So far every single one of my questions on here has been answered and all within a day or two
View 5 RepliesGetting Data Very Slowly And Sometimes Getting MemoryOutofRange Exception?
Dec 17, 2009I am working with serial port communications. I have very fast and continuous data on my serial port. I have a program to read data from serial port. I have comport.Datareceived event in my program to receive data. Now, the problem is there is data going every 100ms to comport. Will my comport.DataReceived event will receive also with that fast? Now,let's say there is data on comport and if I don't read it what happens to the data? The problem I'm facing is my dataReceived event is getting very slow after some time.If I stop sending data to my com, still my datareceiving program is receiving. That means it is not as fast as sending data.If I keep sending data from 4 to 5 days and coz my datareceived event is not that fast as sending, I am getting data very slowly and some times I am getting MemoryOutofRange Exception.
View 1 RepliesPossible To Fade Out A Picturebox Slowly After It Has Been Clicked?
Sep 12, 2011just wondering if its possible to fade out a picturebox slowly after it has been clicked?
View 4 RepliesWhy Does C# Execute Math.Sqrt() More Slowly Than .NET
Jun 11, 2010Background :While running benchmark tests this morning, my colleagues and I discovered some strange things concerning performance of C# code vs. VB.NET code.We started out comparing C# vs. Delphi Prism calculating prime numbers, and found that Prism was about 30% faster. I figured CodeGear optimized code more when generating IL (the exe was about twice as big as C#'s and had all sorts of different IL in it.)
I decided to write a test in VB.NET as well, assuming that Microsoft's compilers would end up writing essentially the same IL for each language. However, the result there was more shocking: the code ran more than three times slower on C# than VB with the same operation! The generated IL was different, but not extremely so, and I'm not good enough at reading it to understand the differences.
Benchmarks I've included the code for each below. On my machine, VB finds 348513 primes in about 6.36 seconds. C# finds the same number of primes in 21.76 seconds.
Computer Specs and Notes
Intel Core 2 Quad 6600 @ 2.4Ghz
Every machine I've tested on there is a noticeable difference in the benchmark results between C# and VB.NET.Both of the console applications were compiled in Release mode, but otherwise no project settings were changed from the defaults generated by Visual Studio 2008.
VB.NET code
Imports System.Diagnostics
Module Module1
Private temp As List(Of Int32)
Private sw As Stopwatch
[code]....
Why is C#'s execution of Math.Sqrt() slower than VB.NET?
[2008] Slowly Read A Txt File?
Jan 18, 2009i have a .txt file containing 27,607 words, 1 per line, and i need my program to slowly read through and put it into a textbox/label. It only needs to read in order, not randomly or anything. It needs 2 be slow enough that I can read every word being shown, and if possible it would be nice to be able to change the speed but it is not needed.
Public Class Form1
Dim FILE_NAME As String = "C:My DocumentsWordList.txt"
Dim objReader As New System.IO.StreamReader(FILE_NAME)
[code]....
This is what i tried and all this does is displays 2 words in the middle of the file, then form goes white for about 5 seconds and then the last word in the file shows up and the program remains white. When i try with a txtbox only the last word is displayed.
Asp.net - SSRS Reporting Loads Slowly The 1st Report
Apr 30, 2012I have a website(asp.net) which displays ssrs reports. Howevery everytime that I try to run the report from the website it takes about 2 min to load, but if I click on the report again , it will load up in seconds. I have tried to run a query that is used by the report and I get the results in second as well.
Is there any configuaration that I need to change or any tsql code that I need to add?
I have gone through to solutions provided here on stackoverflow but still had no luck.
Program Runs Slowly After About An Hour And A Half Or So
Jun 29, 2011I created a program that has 11 threads running simultaneously.Each thread runs a stopwatch and measures the amount of time that passes between the Start and Stop.There is no code between the start and stop, so most often, the result is 0 milliseconds.I noticed that INITIALLY, after a few minutes, the program would slow and the output to the RichTextBox would become disjointed.So, every two minutes, I have a timer execute and end the threads and restart them all.This seemed to help, however, after about an hour and a half, the program becomes more sluggish, evident in the stopwatches recording more instances over 0 milliseconds.Does this have to do with 'garbage collection' and is that even possible in VB .NET (I thought C only had that), or perhaps memory management?
View 1 RepliesSmall Window Comes Out Slowly From Windows Status Bar?
May 4, 2010I need to have a small window to appear slowly from the bottom of windows.is it a windows manipulation or it can be done in VB.net too.
View 10 RepliesSqlClient.SqlDataAdapter.Update() Performs Very Slowly?
Jun 29, 2011I am porting VB.Net 2 code (VS 2005) to VB.Net 4 (VS 2010). So far things have been going relatively smooth. However, in testing my new ported code, I came across a strange behavior. In VS 2005 (.Net 2), I have a DataTable filled with data. I then use a DataAdapter to send updates back to the SQL Server. When I perform the qlClient.SqlDataAdapter.Update() command, it execute in roughly 4 seconds. The same code,on the same table in VS 2010 (.Net 4) runs in 1 Minute 17 Seconds. This is completely unacceptable. However, I have no clue as to why it is happening. The .Update() method is an internal command, not one that I modified in any way. It does not error out, it's just painfully slow.
View 1 RepliesTabControl - Switching Between Tabs Runs Slowly
May 22, 2010Why is it that any project I make in VB.NET runs very slowly? Even if I simply add a TabControl, switching between tabs runs slowly, flashes the control white, etc. Is there a way to make it run smoother?
View 35 RepliesVS 2005 Fill DataAdapter To Dataset Is To Slowly?
Jul 21, 2009i try to use this yesterday it work fine..now, it will process too slow.. when fill the dataadapter into the dataset..here is the code it gives 20 menutes still no result.. "no error, no comment. it's like standby
Dim conn1 As MySqlConnection = New MySqlConnection("server=pc1;user id=user;Password=12345;persist security info=True;database=mytsmobile")
conn1.Open()
[code]....