Search:
Type: Posts; User: Philly0494
Search:
Search took 0.12 seconds.
-
I have crafted this simple query to return the data I need:
SELECT * FROM EVENTS AS E1 INNER JOIN Events AS E2 ON E1.Source_Event = E2.Event_Id WHERE E1.PU_Id = 108 AND E1.TimeStamp > '1/1/2014'...
-
So Shaggy, all of my connection strings are identical, would it be okay to create one SQLConnection and modify the .getReader() function to use that SQLConnection each time and then close that...
-
Here is the function I am calling in a loop (just in case you are curious):
Private Function getProductionInfo(varId As String, codeId As String, code As String) As List(Of String)
Dim...
-
Just to add on, I am populating tables of data by calling functions in a loop and each iteration starts either 1 or 2 SqlConnections. I don't notice it slowing down but I am wondering if I port this...
-
Thank you very much, right now I am calling SqlConnection.ClearAllPools() before I attempt to make any connection to the database. It does not appear to slow down the program, is there any risk or...
-
I am writing a program that requires me to run a lot of different SQL queries so I create a new MySqlDataReader object for each query I run and when I am finished with it I call the .Close() method...
-
Thanks your method works great and it is really easy.
-
I am going to plop it into an Excel file using Gembox along with some other information. I will not be reading the data as text at any point in the future so if there is a way to save a picture of...
-
Thank you for replying. I think I resolved that issue by executing the code well after the page loads (which is fine for what I am doing) but I overlooked another problem with my method. I am left...
-
I am trying to collect information from the table below (which may change in size) that I have loaded in a WebBrowser control.
http://i.imgur.com/GRQotxL.jpg
I have tried the following code:
...
-
I was out of my office for the day so I wasn't able to try it at that time. When I change the joins to LEFT then I still do not get results.
-
Thats probably it, Reason_Level3 is often blank and sometimes Reason_Level2 is as well. so if I change the INNER to LEFT it should work?
-
That seems like it would work but when I try this query I get zero rows returned:
SELECT PU_Desc, Start_Time, T1.Event_Reason_Name,
T2.Event_Reason_Name,T3.Event_Reason_Name,Duration
FROM...
-
I have a SELECT query which works fine and it looks something like this:
"SELECT PU_Desc, Start_Time, Reason_Level1,Reason_Level2,Reason_Level3, etc etc
The problem is that the Reason_Level is...
-
Dim ts As TimeSpan = DateTime.Parse("4/7/2014") - DateTime.Parse("4/5/2014")
txtResult.Text = ts.Days.ToString()
-
Hey guys I have an update, it turns out that in VB.NET that escape character \n was not recognized and it assigned a data source name of "ustcaXXX\nabi".
I fixed this by changing the connection...
-
Have you tried modifying the TabIndex property of the controls on the form? The lowest TabIndex will be selected first. You can also call the CONTROLNAME.Focus() method to set focus to a control...
-
I am trying to pull data from a PivotTable in Excel but I would imagine the best way to do this would be to access the data source directly.
In Excel, it appears that the connection string is:
...
-
FF0E is hexadecimal but 7HTS is not a hexadecimal value
-
The DLL you are using is a .NET wrap the original devIL.dll, which is a COM dll I believe. You need to have devIL.dll in the folder as well because devIL.NET.dll references it, I believe.
-
I don't think so in this case. Red Gate is a respected company and a widely used tool. Any software written in .NET is very easy to "reflect", even more so than Java. This is so that the...
-
If the original application is, in fact, a .NET application I recommend you use .NET Reflector from Red Gate. It will actually fully decompile the program if you want it to.
-
System restores and Recycle Bin reserve space that they haven't used yet. In addition files that are beginning their download reserve enough space on the disk so that the download can be completed...
-
Perhaps try "Dim executepath As String = Application.StartupPath + "\" + getfiles.bat""
-
Stopping applications from running is different than blocking websites. You have a few options here.
You could create a covert application that closes all webBrowsers that open - using the code...
-
Yeah if you are viewing it from an email it may be reading it in html, in which case the carriage return will not render a new line.
-
If it's a client-sided block then an IP or SOCKS proxy will not have any effect against your defense.
You could always do things to detect the content of the page, just in case a HTTP proxy is...
-
Dim data As New List(Of String)
For x = 1 To ultragrid.activerow.cells.length-1
data.Add(ultragrid.activerow.cells(x).text)
Next
-
Just right-click the executable and choose Run As and then supply the credentials of a non-admin account.
-
Look at his first post again, if it returns Pet he would actually want the text to read "Dog" since that is what corresponds with the variable name Pet.
-
If you want to build to the Release folder you should be clicking Build->Build [project name]
If you want to check where it built to just take a look at the Output window it should show something...
-
Didn't you want the application to be invisible if it was executed via batch?
-
If My.Application.CommandLineArgs.Count > 0 AndAlso My.Application.CommandLineArgs(0) = "-batch" Then
btnStart.PerformClick()
End If
something along those lines on form load?
-
You could modify your definition of "batch mode" to resemble something like this:
start myApp.exe -hidden
and then you could quite easily detect when the command line argument "-hidden" was...
-
I'm pretty sure he is asking how to replicate the error on Windows XP.
Just run the .exe as a restricted user.
-
Set it to different values at various checkpoints or just do a simple Marquee to let them know that stuff is happening.
-
http://www.mathsisfun.com/definitions/whole-number.html
http://www.answers.com/topic/integer-1
Merrian Webster: "any of the set of nonnegative integer"
o.o
-
Keep in mind for question 1 a simple Integer will not suffice as a correct answer since it will allow for negative numbers (which are not whole numbers), therefore the correct declaration would be
...
-
Antivirus programs do this all the time, not to mention if he wants to install some sort of security system or monitoring software he may not want the user to be able to use the computer without it...
-
Well intuitively the for loop should most certainly outperform the LINQ approach
But in case that isn't enough for you:
http://ox.no/posts/linq-vs-loop-a-performance-test
The LINQ method...
|
Click Here to Expand Forum to Full Width
|